| Name | Description |
| SQL Server for Developers |
Whether you`re new to SQL or a more experienced developer, this course is a great start and an eye-opener on how much you`re missing out on in SQL. You will cover, how to create complex inner and outer joins, summary queries, and subqueries. What the different data types are and how to handle the common problems you run into with various types of data. How to use built-in functions or write your own to handle everyday challenges. You will also see the basics of database design and implementation using the Management Studio. |
| Querying with T-SQL in SQL Server |
The content is aimed at providing an introduction to T-SQL from a non-developer perspective. |
| SQL Server Reporting Services |
In this course, you will learn how to use SQL Server Reporting Services, explore its architecture and gain an understanding of the components of SSRS . You will explore creation of ad hoc reports with Report Builder, using Data tools and Tablix reports. The reports will cover using expressions and functions, interactivity and dynamic reporting as well as enhancement of reports with data visualisation tools. This course is a solid introduction to getting the most from the well-established and effective SSRS toolset. |
| Administering a SQL Database |
The 55316A five-day instructor-led course will provide training in how to administer and maintain SQL Server and Azure SQL databases. IT professionals who work in environments where databases play a key role in their job will find this material useful. By using demonstrations and hands-on lab exercises, students will learn to carry out these important tasks. The material updates and replaces course 20764AC previously published under the same title. |
| SQL Server Integration Services |
SQL Server Integration Services is the non-certified version of 20767CC Implementing a SQL Data Warehouse. This five-day instructor-led course is intended for IT professionals who need to learn how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages, and to use SSIS to extract, transform, and load data to and from SQL Server. This course is similar to the retired Course 20767-C: Implementing a SQL Data Warehouse but focuses more on building packages, rather than the entire data warehouse design and implementation. |
| Administering a SQL Database Infrastructure |
This five-day instructor-led course - replacing the retired MOC 20764 - provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases. |