Name: Master SQL Development
Price: -1 USD

Master SQL Development

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

Course 1: MTA Database Fundamentals (98-364) Cert Prep: 3 Storage

Prep for MTA Exam 98-364 and get a baseline understanding of the core concepts of database storage: normalization, key fields, and indexing.

Course 2: 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 3: 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 4: Advanced SQL for Data Science: Time Series

Learn how to model time series data and apply advanced analysis techniques using SQL.

Course 5: 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 6: 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 7: Advanced SQL – Window Functions

Learn how aggregate, rank, offset, and distribution window functions work‚ how to implement them efficiently, and how to solve the toughest SQL challenges elegantly.