Search
Cancel
Sign In

Master SQL Development

Go to class
Write Review

Free Online Course: Master SQL Development provided by LinkedIn Learning is a comprehensive online course, which lasts for 14 hours worth of material. 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 Adam Wilbert, Ami Levin, Ami Levin, Dan Sullivan, Dan Sullivan, Dan Sullivan, Ami Levin and Adam Wilbert.

via LinkedIn Learning
14 hours worth of material
Self Paced
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.
    • 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.

← Prev Next →
0, based on 0 Course votes at GetYourEducation

Start your review of Master SQL Development

Add review ->
Related courses by Level

ANIMATIONs

Beginner
Provider: Swayam
Language: English

Adobe Lightroom Classic Fundamentals

Beginner
Provider: CreativeLive
Language: English

Build, Train, and Deploy ML Pipelines using BERT

Beginner
Provider: Coursera
Language: English

English for Research Publication Purposes

Beginner
Provider: Coursera
Language: English

English for Research Publication Purposes

Beginner
Provider: Coursera
Language: English

Introduction to Bohemian Watercolor Techniques

Beginner
Provider: Skillshare
Language: English
Browse by subject
Browse by provider
Browse by university
Browse by institution
College Rankings