Master SQL Development

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.

• 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.
• Course 8: SQL Server Database Triggers
• Learn how to use SQL Server database triggers to automate routine tasks and facilitate a more consistent, reliable, and predictable system.