What Will You Learn?
Learn how to execute core SQL commands to define, select, manipulate, control access, aggregate, and join data and data tables. Understand when and how to use subqueries, several window functions, and partitions to complete complex tasks. Clean data, optimize SQL queries and write select advanced JOINs to enhance analysis performance.About This Course
Provider: Udacity
Format: Online
Duration: 7 hours to complete [Approx]
Target Audience: Beginners
Learning Objectives: Clean data, optimize SQL queries and write select advanced JOINs to enhance analysis performance.
Course Prerequisites: None
Assessment and Certification: NA
Instructor: Derek Steer
Key Topics: Basic SQL, SQL Joins, SQL Aggregations, SQL Subqueries & Temporary Tables, SQL Data Cleaning, SQL Window Functions, SQL Advanced JOINs & Performance Tuning
0 Comments