Instructor - Akarsh Vyas
Master SQL for Data Analytics in One Video!
This is the only SQL tutorial you need to become job-ready for Data Analytics, Data Science, and Business Intelligence roles.

In this full SQL course, we’ll go from absolute beginner to real-world advanced concepts with hands-on examples using a powerful products database.

Notes and code - https://github.com/AkarshVyas/SQL-Video-Content

What You’ll Learn:
SQL Basics – SELECT, WHERE, GROUP BY, ORDER BY
Filtering, Aggregations, and Advanced Clauses
Real-world SQL Projects & Test Scenarios
One-to-One, One-to-Many, and Many-to-Many Relationships
Views for Reporting & Optimization
Stored Procedures (PL/pgSQL) for Automation
Perfect for PostgreSQL, MySQL, and Interview Preparation


00:00:00 - 00:00:32 - intro
00:00:32 - 00:12:58 - SQL Basics
00:12:58 - 00:17:27 - Windows Installation
00:17:27 - 00:25:09 - MAC Installation
00:25:09 - 00:31:18 - Important things in PgAdmin
00:31:18 - 00:56:38 - Basic CRUD operations
00:56:38 - 01:16:27 - Data Types in SQL
01:16:27 - 01:29:54 - Constraints in SQL
01:29:54 - 01:46:00 - Exercise 1 / Test 1
01:46:00 - 01:54:13 - Some Problems
01:54:13 - 02:11:20 - Clauses in SQL
02:11:20 - 02:26:11 - Operators in SQL
02:26:11 - 02:32:02 - Aggregation Function
02:32:02 - 02:45:03 - Exercise 2 / Test 2
02:45:03 - 03:00:41 - String Functions
03:00:41 - 03:22:56 - Alter with Examples
03:22:56 - 03:42:24 - Case in SQL
03:42:24 - 03:48:11 - Relationships
03:48:11 - 03:59:37 - One to One Relationship
03:59:37 - 04:06:36 - One to Many relationship
04:06:36 - 04:19:33 - Joins
04:19:33 - 04:46:25 - Exercise 3 / Test 3
04:46:25 - 04:59:12 - Many to many Relationship
04:59:12 - 05:02:00 - Important Message
05:02:00 - 05:09:46 - Views is SQL
05:09:46 - 05:18:10 - Procedures
05:18:10 - 05:18:52 - Outro


Enjoy Love you all ❤️
#SQL #DataAnalytics #DataScience #SQLTutorial #LearnSQL #PostgreSQL #BI #PowerBI #SQLCourse #AnalyticsCareer #AkarshVyas