SQL Server Training

If you're just getting started writing reports or creating websites using SQL Server, this is the right SQL course for you. You will learn the fundamentals of SQL queries shared by all major databases as well as some of the ways SQL Server's variant of SQL differs from other databases. For a deeper dive into Transact-SQL, consider our 3-day MOC 20761 - Querying Data with Transact-SQL.

Choose this SQL Server class if you are a new database professional and need to learn fundamental database concepts including database types, database languages, and database designs.

Choose this SQL Server course if you administer and maintain SQL Server databases and are responsible for optimal performance of SQL Server instances.

Choose this SQL Server training if you are a business intelligence professional or a technically proficient business user who must learn to manage Business Intelligence (BI) operations to provide business users with the ability to analyze data and share their findings.

Are you a database professional who needs to learn to create Business Intelligence reports? If so, this is the right course for you. Your certified SQL Server trainer will teach you how to analyze data and create desktop and mobile reports using SQL Server Reporting Services.

Choose this SQL Server course if you have experience with an earlier version of SQL Server and need to upgrade your skills to SQL Server 2017.

If you are or are becoming a Database Administrator, Database Developer or BI professional using SQL Server, then you need to to know Transact-SQL, which is used by all SQL Server-related disciplines. This SQL course provides a deeper dive into Transact-SQL than our two-day Introduction to SQL using SQL Server course.

Choose this SQL Server course if you are new to SQL Server and need to learn to design and develop a SQL Server database. Your certified SQL Server trainer will teach you to create a database designed to be efficient and ensure data integrity.

Choose this SQL Server course if you need to learn to administer and maintain SQL Server databases. Your certified SQL Server trainer will teach you how to authenticate users and assign them roles and permissions, protect data with encryption and auditing, develop recovery models and backup strategies, automate database management, and much more.

Choose this SQL Server course if you administer and maintain SQL Server databases and need to learn to provision SQL Server databases, either on premise or in SQL Azure.

Choose this SQL Server course if you are a database professional who needs to learn to create Business Intelligence solutions including Data Warehouse implementation, ETL, and data cleansing.

Choose this SQL Server course if you are a database professional who needs to learn to implement multidimensional databases and/or create tabular semantic data models for analysis using SQL Server Analysis Services.

Choose this SSRS course if you are a business analyst or data consumer and need to be able to create reports on a SQL Server Reporting Services server. If you also need to distribute those reports in different formats to other team members, you should consider our SQL Server Reporting Services 2016 for Report Writers course instead.

Choose this SSRS course if you need to learn to use SQL Server Reporting Services to create, publish, and manage reports, and make those reports available to users to view in a web browser, on a mobile device, or as an email. You will learn to use Report Designer, Report Builder, and Report Manager to create and distribute reports.

Need to learn to create analysis and reporting solutions with SQL Server? This SQL Server course is for Business Intelligence Developers who have to implement analytical data models and reports, manage report delivery, create business performance dashboards, and support data mining and predictive analysis.