Courses

NameDescription
DP-300T00 - Administering Microsoft Azure SQL Solutions This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.
Introduction to SQL Learning the SQL language is one of the key tasks required for the use of a relational database. SQL proficiency is essential for business users, database developers, database administrators and any other database professional. This course introduces the basics of the SQL language Participants become acquainted with the differences in the working environment between a traditional on-premises database installation and the database services of cloud-computing platforms. This course incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one course.
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.
SQL Scripting This one day course provides an introduction to SQL (Structured Query Language) for non IT developers. It is aimed at anyone who needs to know how to extract finance and non-finance data from databases within their organisation. SQL is a fundamental tool used to interrogate databases and is a core component of data analytics.

The course goes through the language that queries these databases, looking at its syntax and structure in order to return the relavent data. The last few topics are short examples of the use of SQL in modern Data Analysis, which would form a bridge to further learning with Power BI etc.

The course will be hands-on with scripts being executed on a SQL Server database, but the skills learned can be applied to any SQL based database.

Cloud Database querying using Excel and SQL This is a hands-on introduction to querying cloud-based databases using Excel and explores the simplest way to get data from the cloud with SQL. Effective use of SQL and examples of its use in modern Data Analysis will be covered and visualisation of the data to ascertain key business insights will be demonstrated, allowing participants to implement new skills in their roles.