Blog Archives

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)

20461MOD: Querying Microsoft SQL Server 2014 (On-Demand Training)

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. 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® … Continue reading 20461MOD: Querying Microsoft SQL Server 2014 (On-Demand Training)

20761 MOD: Querying Data with Transact-SQL (On-Demand)

The main purpose of this course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals. The course will very likely … Continue reading 20761 MOD: Querying Data with Transact-SQL (On-Demand)

10985 MOD: Introduction to SQL Databases (On-Demand)

This on-demand video course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs. Audience: The primary audience for this course is people who are moving into a database … Continue reading 10985 MOD: Introduction to SQL Databases (On-Demand)