A collection of tutorials and quickstarts meant to teach you to use SQL Server and Azure SQL Database.

SQL Server triggers are special stored procedures that are executed automatically in response to the database object, database, and server events. This section covers the advanced SQL …

This intensive course covers advanced topics, techniques, and best practices to optimize performance, enhance security, implement high availability solutions, and leverage advanced …

Advanced SQL courses can help you learn complex queries, data manipulation, performance tuning, and database design. Compare course options to find what fits your goals. Enroll for free.

Are you a junior analyst who wants to level up to advanced SQL so you can take the next step in your career? Or maybe you're a data scientist who knows enough SQL to get by, but want to …

This is a set of three courses featuring fully interactive tasks. Learn advanced T SQL concepts like recursion, GROUP BY extensions, and window functions.

Aug 6, 2024 · Master advanced SQL Server skills in this hands-on, interactive course. Practice your new programming skills in a final project based on a real-world database.

Oct 9, 2023 · First, you’ll learn how to navigate hierarchical data using recursive common table expressions (CTEs). Second, you’ll explore how to rotate tabular data while aggregating …

Develop an in-depth understanding of the concepts and functions of an advanced SQL server with this free online course. In this course, we will be taking your basic database skills up a notch …

Learn how to use advanced Transact-SQL features to fetch and transform data in your databases.