SQL Complete Course in 4 Hours | SQL in One Shot using MySQL #sql
SQL Full Course for Begineers | SQL Complete Tutorial | SQL Complete Course in Hindi SQL - Complete Course in 4 Hours | SQL in One Shot using MySQL 🔍What You'll Learn? In this 4 hour SQL tutorial, you'll excel SQL in one shot using MySQL. No pre-requisites. Download SQL Worbench from here - https://dev.mysql.com/downloads/insta... Enroll For Live Doubt Solving Session - https://drive.google.com/file/d/1cOEQ... Google Form Link - https://forms.gle/PVhtucpA4HtVdyqeA Complete PDF Notes for Revision and Practice - https://drive.google.com/file/d/1VCM-... SQL basic Queries here - https://drive.google.com/drive/folder... 🔗 Stay Connected 📌 Linkedin : / rohit-honde-50a100185 📌 Telegram for instant updates: https://t.me/dataengineer_rohit 📌 Instagram - / dataengineer_rohit ⌚ Timestamps 00:00 – Introduction 02:15 – Steps to Enroll for Live Doubt Solving 03:58 – What is a Database? 07:50 – Types of Databases 15:30 – CRUD Operations 16:40 – SQL Workbench Installation 19:53 – Creating a Database 21:55 – Creating Tables 24:30 – Data Types and Constraints 30:40 – SELECT Query 32:40 – Rename, Alter, and Move Columns 40:00 – Insert Rows 46:00 – Insert Multiple Rows 50:20 – WHERE Condition & SQL Operators (Greater Than, Less Than, Greater Than or Equal To, Equal To, Less Than or Equal To) 55:35 – NULL, BETWEEN, IN, AND, OR, LIKE, LIMIT, ORDER BY 01:13:20 – UPDATE 01:20:56 – DELETE 01:26:15 – Unique Constraint 01:32:08 – NOT NULL, DEFAULT, CHECK Constraint 01:43:35 – Primary Key & Auto Increment 01:49:14 – SQL Functions – Aggregate (COUNT, SUM, MIN, MAX, GROUP BY) 01:57:46 – DateDiff, Length, Concatenate, Round, Floor, Ceil 02:04:12 – Commit & Rollback 02:10:36 – Primary Key, Unique Key, Foreign Key 02:38:00 – Joins (INNER, LEFT, RIGHT) 02:48:10 – UNION & UNION ALL 02:52:50 – Self Join 02:58:58 – Views 03:04:05 – Index & Multi-Column Index 03:10:58 – Subqueries 03:16:05 – Group By (Detailed) 03:18:20 – HAVING 03:21:32 – Stored Procedures with Delimiters 03:29:00 – Triggers 03:34:04 – Logical Operators, TRUNCATE, Wildcards, LIMIT & OFFSET, CHANGE & MODIFY 03:44:50 – Other Videos & Outro 👍 Support the Channel If you find this tutorial helpful, don’t forget to: ✔ Like ✔ Comment ✔ Share ✔ Subscribe #sql
