Master SQL Development
Offered By: LinkedIn Learning
Course Description
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.
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
-
Build scalable and resilient databases to support any application. Learn how to write optimized SQL, use indexes, partition data, and use established design patterns.
-
Learn how to analyze query execution plans and use data modeling strategies to boost query performance.
-
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.
-
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.
-
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.
Taught by
Ami Levin and Dan Sullivan
Related Courses
Données et services numériques, dans le nuage et ailleursCertificat informatique et internet via France Université Numerique Introduction to Digital Curation
University College London via Independent Excel Avanzado
Miríadax SAP Business Warehouse powered by SAP HANA
SAP Learning Programming Mobile Applications for Android Handheld Systems: Part 2
University of Maryland, College Park via Coursera