In this course, you’ll master the skills needed to write Transact-SQL SELECT statements accessing one or more tables. You’ll also learn the various techniques for combining data, filtering the results and how to control and format the statement output. You’ll gain a foundation understanding of a SQL Server database and use the tools available to … Continue reading SQL101v2: Introduction to Transact-SQL
Blog Archives
SQL250: Transact-SQL for Developers
In this course, you’ll establish a solid foundational understanding of database concepts and terminology. Then you’ll master the use of various Microsoft tools to submit queries to quickly and efficiently get the results you want. We teach students how to write a query the same way that SQL Server processes a SQL statement – following … Continue reading SQL250: Transact-SQL for Developers
SQL101v2: Introduction to Transact-SQL
In this course, you’ll master the skills needed to write Transact-SQL SELECT statements accessing one or more tables. You’ll also learn the various techniques for combining data, filtering the results and how to control and format the statement output. You’ll gain a foundation understanding of a SQL Server database and use the tools available to … Continue reading SQL101v2: Introduction to Transact-SQL
SQL250: Transact-SQL for Developers
In this course, you’ll establish a solid foundational understanding of database concepts and terminology. Then you’ll master the use of various Microsoft tools to submit queries to quickly and efficiently get the results you want. We teach students how to write a query the same way that SQL Server processes a SQL statement – following … Continue reading SQL250: Transact-SQL for Developers
DP-3001: Migrate SQL Server Workloads to Azure SQL
The course is designed as a blended learning experience that combines instructor-led training with online materials on the Microsoft Learn platform (https://docs.microsoft.com/learn). Students are encouraged to use the content on Learn as reference materials to reinforce what they learn in class and to explore topics in more depth.
SQL101v2: Introduction to Transact SQL
In this course, you’ll master the skills needed to write Transact-SQL SELECT statements accessing one or more tables. You’ll also learn the various techniques for combining data, filtering the results and how to control and format the statement output. You’ll gain a foundation understanding of a SQL Server database and use the tools available to … Continue reading SQL101v2: Introduction to Transact SQL
DP-080T00: Querying Data with Microsoft Transact-SQL
This course will teach the basics of Microsoft’s dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.
SQL419: Advanced T-SQL Querying, Programming and Tuning for SQL Server 2012 – 2019
Developed in-house by SolidQ, the Advanced T-SQL course focuses on writing and tuning queries and programming with T-SQL in SQL Server 2012 – 2019 and in Azure SQL Database. In this course you will learn the details and capabilities of T-SQL in the following areas: Logical Query Processing; Query Tuning (Internals and Index Tuning, including … Continue reading SQL419: Advanced T-SQL Querying, Programming and Tuning for SQL Server 2012 – 2019
SQL417: Advanced T-SQL Querying, Programming and Tuning for SQL Server 2012 – 2017
This advanced T-SQL course focuses on writing and tuning queries and programming with T-SQL in SQL Server 2012, 2014, 2016, 2017 and in Azure SQL Database. In this course you will learn the details and capabilities of T-SQL in the following areas: Logical Query Processing; Query Tuning (Internals and Index Tuning, including Columnstore Indexes, Query … Continue reading SQL417: Advanced T-SQL Querying, Programming and Tuning for SQL Server 2012 – 2017
20461: Querying Microsoft SQL Server 2014 (See Course SQL250)
This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. The main purpose of the course is to prepare people for the exam “70-461: Writing Queries Using Microsoft® SQL Server® 2014 Transact-SQL.” This exam will be the underlying exam for all SQL Server-related disciplines; namely, Database Administration, … Continue reading 20461: Querying Microsoft SQL Server 2014 (See Course SQL250)