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
Social Network AnalysisUniversity of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX