Master SQL Development

Overview

As the standard language for most relational database management systems, SQL is a highly sought-after skill in data development. This learning path instructs you on how to be a SQL power user.

Identify advanced methods in data management.
Master how to optimally leverage SQL.
Practice accessing data with new processes.

Syllabus

Courses under this program:
Course 1: Advanced SQL: Logical Query Processing, Part 1
-Gain a deep understanding of how the database processes SQL queries, improve your programming skills, and learn to effortlessly read, write, and troubleshoot SQL queries.

Course 2: Advanced SQL: Logical Query Processing, Part 2
-Take your SQL skills to the next level. Continue learning about aspects of logical query processing: from subqueries to ordered set functions, and from lateral joins to cursors.

Course 3: Advanced SQL for Data Scientists
-Learn advanced techniques for analyzing large data sets with SQL. Find out how to build sophisticated data models, optimize queries, extend SQL with user-defined functions, and more.

Course 4: Advanced SQL for Query Tuning and Performance Optimization
-Learn how to analyze query execution plans and use data modeling strategies to boost query performance.

Course 5: Advanced SQL for Application Development
-Build scalable and resilient databases to support any application. Learn how to write optimized SQL, use indexes, partition data, and use established design patterns.

Courses

0 reviews
2-3 hours
View details

Build scalable and resilient databases to support any application. Learn how to write optimized SQL, use indexes, partition data, and use established design patterns.
0 reviews
1-2 hours
View details

Learn how to analyze query execution plans and use data modeling strategies to boost query performance.
0 reviews
2-3 hours
View details

Take your SQL skills to the next level. Continue learning about aspects of logical query processing: from subqueries to ordered set functions, and from lateral joins to cursors.
0 reviews
2-3 hours
View details

Learn advanced techniques for analyzing large data sets with SQL. Find out how to build sophisticated data models, optimize queries, extend SQL with user-defined functions, and more.
0 reviews
1-2 hours
View details

Gain a deep understanding of how the database processes SQL queries, improve your programming skills, and learn to effortlessly read, write, and troubleshoot SQL queries.