Master SQL Development

Go to class
Write Review

Free Online Course: Master SQL Development provided by LinkedIn Learning is a comprehensive online course. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. Master SQL Development is taught by Ami Levin and Dan Sullivan.

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.