Advance Your MS SQL Server Skills

Learn Microsoft SQL Server from the ground up with this comprehensive learning path that takes you from foundational database concepts to advanced enterprise implementations. This practical, hands-on curriculum combines theory with real-world scenarios, empowering you to design, manage, and optimize enterprise-scale SQL Server environments while implementing modern data solutions.

Develop using Transact-SQL programming.
Design and implement data solutions for actionable insights.
Modernize database deployment and management strategies.

Syllabus

Courses under this program:
Course 1: Introduction to Transact-SQL
-Get an introduction to Transact-SQL (T-SQL), a Microsoft-specific extension of SQL.

Course 2: Microsoft SQL Server 2022 Essential Training
-Get an introduction to creating relational databases with SQL Server and the graphical interface, SQL Server Management Studio.

Course 3: Querying Microsoft SQL Server 2022
-Learn how to retrieve information stored in a Microsoft SQL Server database using the Transact-SQL (T-SQL) language and the latest features of SQL Server 2022.

Course 4: Automating SQL Server with dbatools
-Discover practical strategies for using dbatools to manage and automate your SQL Server estate.

Course 5: Implementing a Data Warehouse with SQL Server 2022
-Learn how to create a long-term data storage solution using local SQL Server instances and cloud-based Azure Dedicated SQL Pools.

Course 6: SQL Server 2022 Administration
-Explore the skills and tools required to manage SQL Server 2022, the latest release of the relational database management system developed by Microsoft.

Course 7: SQL Server Containerization: Modern Deployment Strategies for Data-Driven Organizations
-Get a comprehensive overview of the skills required to deploy SQL Server on non-Windows platforms such as Linux, Docker, and Kubernetes.

Course 8: SQL Server Integration Services
-Learn how to extract, transform, and load data (and create ETL packages) with SQL Server Integration Services, one of the core add-on components to SQL Server.

Course 9: SQL Server: Reporting Services
-SQL Server Reporting Services makes it easy to create professional looking reports from up-to-date information.