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.
Courses
-
1
Top Five Things to Know in Advanced SQL1h 35mTop Five Things to Know in Advanced SQL
By: Kendall Ruber
Learn advanced SQL concepts and practice them with hands-on exercises.
-
2
Advanced SQL: Logical Query Processing, Part 11h 38mAdvanced SQL: Logical Query Processing, Part 1
By: Ami Levin
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.
-
3
Advanced SQL: Logical Query Processing, Part 22h 2mAdvanced SQL: Logical Query Processing, Part 2
By: Ami Levin
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.
-
4
Advanced SQL – Window Functions1h 56mAdvanced SQL – Window Functions
By: Ami Levin
Learn how aggregate, rank, offset, and distribution window functions work‚ how to implement them efficiently, and how to solve the toughest SQL challenges elegantly.
-
5
Advanced SQL for Query Tuning and Performance Optimization2h 9mAdvanced SQL for Query Tuning and Performance Optimization
By: Dan Sullivan
Learn how to analyze query execution plans and use data modeling strategies to boost query performance.
-
6
Advanced SQL for Application Development2h 7mAdvanced SQL for Application Development
By: Dan Sullivan
Build scalable and resilient databases to support any application. Learn how to write optimized SQL, use indexes, partition data, and use established design patterns.
-
7
Advanced SQL for Data Scientists2h 30mAdvanced SQL for Data Scientists
By: Dan Sullivan
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.
-
8
Level Up: Advanced SQL37mLevel Up: Advanced SQL
By: Jess Pomfret
Take your SQL skills to the next level in this interactive, advanced coding course.
Instructors
Kendall Ruber
Data Scientist @ Yum! Brands | LinkedIn Learning [in]structor | Machine Learning | Statistics | NLP | Speaker
Ami Levin
Are your relational databases ultra fast, reliable, consistent, scalable, and easily modified to support new features? Would you like them to be? Ask me how! Message-less connection requests will be politely ignored.
Dan Sullivan
Data Architect, Data Engineer, Cloud Architect
Jess Pomfret
Database Platform Engineer, Microsoft MVP