SQL for Data Analytics - Learn SQL in 4 Hours

SQL for Data Analytics - Learn SQL in 4 Hours04:08:40

Download information and video details for SQL for Data Analytics - Learn SQL in 4 Hours

Uploader:

Luke Barousse

Published at:

3/11/2024

Views:

767.5K

Description:

Welcome to the SQL for Data Analytics course, a free 4‑hour program that covers everything from basic SQL concepts to advanced PostgreSQL techniques. The lesson starts with a welcome at 0:00:00, then explains what SQL is at 0:03:43, introduces the course at 0:10:44, and dives into the basics at 0:16:51. It continues with comparisons at 0:33:59, practice problems at 0:41:18 and 0:51:06, wildcards at 0:45:23, alias usage at 0:48:49, operations at 0:54:01, aggregation at 0:59:37, NULL values at 1:08:45, joins at 1:10:07, and order of execution at 1:20:15. The advanced section begins at 1:26:18 with PostgreSQL setup, followed by IDE installation at 1:32:48, data types at 1:44:08, table manipulation at 1:47:35, database loading at 2:00:00, date functions at 2:10:02, CASE expressions at 2:25:02, subqueries and CTEs at 2:30:24, UNION operators at 2:50:11, and additional practice problems. The project portion starts at 2:58:11 with an overview, repository creation at 3:02:17, and queries on top paying jobs and skills from 3:14:50 to 3:53:14, concluding with sharing on GitHub and LinkedIn at 4:05:16.