Common Table Expressions Courses and Certifications

SQL Server: Transact-SQL Common Table Expressions

400 ratings at Pluralsight

Learn how to create and use common table expressions (CTEs) correctly, for developers and DBAs from SQL Server 2005 onward

• Pluralsight
• 1 hour 21 minutes
• On-Demand
• Free Trial Available

70-461 Session 6: Querying Microsoft SQL Server (T-SQL code)

1768 ratings at Udemy

Using SQL, correlated subqueries, CTEs, Pivots, UDFs and Sequences. SQL Server 2012 to 2022, including SQL Server 2019

• Udemy
• 7 hours
• On-Demand
• Paid Course

University of Wisconsin–Madison

SQL Fundamentals

Learn the fundamentals of SQL and database management.

• edX
• 8 weeks, 12-15 hours a week
• On-Demand
• Free Online Course (Audit)

Meta

Advanced MySQL Topics

208 ratings at Coursera

Elevate your MySQL skills with advanced functions, optimization techniques, and data analytics tools for enhanced database engineering and career growth.

• Coursera
• 18 hours 39 minutes
• On-Demand
• Free Online Course (Audit)

Intermediate SQL for Data Scientists

1697 ratings at LinkedIn Learning

Dive into one of the most important data science tools: SQL. Learn how to use joins and subqueries, statistical functions, window functions, and much more.

• LinkedIn Learning
• 2 hours 39 minutes
• On-Demand
• Free Trial Available

Level Up: Advanced SQL

593 ratings at LinkedIn Learning

Take your SQL skills to the next level in this interactive, advanced coding course.

• LinkedIn Learning
• 37 minutes
• On-Demand
• Free Trial Available

Advanced SQL for Data Science: Time Series

314 ratings at LinkedIn Learning

Learn how to model time series data and apply advanced analysis techniques using SQL.

• LinkedIn Learning
• 1 hour 20 minutes
• On-Demand
• Free Trial Available

Top Five Things to Know in Advanced SQL

186 ratings at LinkedIn Learning

Learn advanced SQL concepts and practice them with hands-on exercises.

• LinkedIn Learning
• 1 hour 35 minutes
• On-Demand
• Free Trial Available

First Look: MySQL 8 for Developers

87 ratings at LinkedIn Learning

Learn how to use MySQL to build databases and power data-driven applications.

• LinkedIn Learning
• 1 hour 56 minutes
• On-Demand
• Free Trial Available

Querying Data with SQL Server

36 ratings at Pluralsight

In this course, you’ll learn essential skills that are needed to become proficient in querying data using T-SQL including logical query execution, creating single table queries to filter and aggregate data, and combining data from multiple tables.

• Pluralsight
• 1 hour 57 minutes
• On-Demand
• Free Trial Available

Advanced SQL for Professional Developers

33 ratings at egghead.io

Enhance SQL proficiency with advanced techniques for efficient querying, data manipulation, and performance optimization in PostgreSQL, covering transactions, JSON handling, and more.

• egghead.io
• 54 minutes
• On-Demand
• Paid Course

Analyzing Business Data in SQL

13 ratings at DataCamp

Learn to write SQL queries to calculate key metrics that businesses use to measure performance.

• DataCamp
• 4 hours
• On-Demand
• Free Trial Available

Combining and Filtering Data with MariaDB

11 ratings at Pluralsight

In this course, you'll explore and learn how you can combine and filter multiple areas of the relational database to build an efficient result for end users.

• Pluralsight
• 2-3 hours
• On-Demand
• Free Trial Available

Getting Started with Hierarchical Data in SQL Server

10 ratings at Pluralsight

Explore the world of hierarchical data in SQL Server! This course will teach you how to understand, manage, and query hierarchical structures effectively, using common table expressions and recursive queries for real-world applications.

• Pluralsight
• 32 minutes
• On-Demand
• Free Trial Available

Devoxx

Awesome SQL – Tips and Tricks for Application Developers

Discover advanced SQL techniques for modern application development, including window functions, CTEs, JSON handling, and efficient pagination methods to enhance query performance and functionality.

• YouTube
• 46 minutes
• On-Demand
• Conference Talk