Microsoft SQL Server
Query, tune and secure SQL Server — advanced T-SQL, query optimization, columnstore indexes, hierarchies and security.
Beginner
2 coursesIntermediate
3 coursesQuerying Data with SQL Server
SQL (Structured Query Language) is the programming language used to communicate with relational databases. It has been around for over 50 years and remains omnipresent in all areas relate...
Understanding Query Optimization in SQL Server
This module lays the theoretical foundations for optimizing SQL Server queries. It answers the fundamental question: when should you start optimizing your T-SQL queries?
Working with Hierarchies in SQL Server
This course, Working with Hierarchies in SQL Server, is led by Pinal Dave, SQL Server expert at sqlauthority.com. Understanding the hierarchyid data type in SQL Server is essential for ma...
Advanced
3 coursesAdvanced Querying Techniques in SQL Server
This training explores several advanced querying techniques in Transact-SQL (T-SQL), the SQL dialect used by Microsoft SQL Server. It is aimed at developers and database administrators wh...
Optimizing Query Performance with Columnstore Indexes
This course introduces and explores in depth Columnstore Indexes in SQL Server — one of the most powerful features for improving the performance of analytical queries on large volumes of...
Securing SQL Server Applications
This course is aimed at developers and DBAs who work with SQL Server and want to improve the security posture of their databases. Data is an organization's most valuable asset, and SQL Se...
Interested in Microsoft SQL Server?
Contact us to book a course or get a custom training plan for your team.