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
Computer Vision: The FundamentalsUniversity of California, Berkeley via Coursera Programming Languages
University of Virginia via Udacity Learn to Program: Crafting Quality Code
University of Toronto via Coursera Computational Photography
Georgia Institute of Technology via Coursera Algorithms: Design and Analysis, Part 2
Stanford University via Coursera