SQL for Data Analytics - Learn SQL in 4 Hours

Описание:

Learn SQL in 4 hours with this comprehensive course covering basics, advanced topics, and a project. The course is divided into three chapters: Chapter 1 covers SQL fundamentals such as data types, comparisons, joins, and aggregation; Chapter 2 dives into PostgreSQL setup, data manipulation, date functions, CASE expressions, subqueries, CTEs, and UNION operators; Chapter 3 guides you through a real‑world project, including repository creation and queries to identify top‑paying jobs, skills, and in‑demand skills. Follow the timestamps below for each section. 0:00:00 - Welcome 0:03:43 - What is SQL 0:10:44 - Intro to Course 0:16:51 - The Basics 0:33:59 - Comparisons 0:41:18 - Practice Problem 1 0:45:23 - Wildcards 0:48:49 - Alias: AS 0:51:06 - Practice Problem 2 0:54:01 - Operations 0:59:37 - Aggregation 1:06:28 - Practice Problem 3 1:08:45 - NULL Values 1:10:07 - JOINS 1:20:15 - Order of Execution 1:22:35 - Practice Problem 5 1:26:18 - Setup PostgreSQL 1:32:48 - IDE Install: VS Code 1:44:08 - Data Types 1:47:35 - Manipulate Tables 2:00:00 - Database Load 2:10:02 - Date Functions 2:20:26 - Problem Problem 6 2:25:02 - CASE Expression 2:30:24 - SubQueries and CTEs 2:42:21 - Practice Problem 7 2:50:11 - UNION Operators 2:54:28 - Practice Problem 8 2:58:11 - About the Project 3:02:17 - Create the Repository 3:14:50 - Query 1 - Top Paying Jobs 3:20:42 - Query 2 - Top Paying Job's Skills 3:28:10 - Query 3 - In-Demand Skills 3:34:14 - Query 4 - Top Paying Skills 3:41:37 - Query 5 - Most Optimal Skills 3:53:14 - Share on GitHub 4:05:16 - Share on LinkedIn