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/installer/

Enroll For Live Doubt Solving Session - https://drive.google.com/file/d/1cOEQL4Y8zi8fk85pxJqxkmgvb3El7rrc/view?usp=sharing

Google Form Link - https://forms.gle/PVhtucpA4HtVdyqeA

Complete PDF Notes for Revision and Practice - https://drive.google.com/file/d/1VCM-QAJnld4uCm3GPGUbfd1HOQvT7vEk/view?usp=drivesdk

SQL basic Queries here - https://drive.google.com/drive/folders/1zvL_TgLeYpmvq80f97-vnpwAKo73TqPg?usp=sharing

🔗 Stay Connected
📌 Linkedin : https://www.linkedin.com/in/rohit-honde-50a100185
📌 Telegram for instant updates: https://t.me/dataengineer_rohit
📌 Instagram - https://www.instagram.com/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

Видео SQL Complete Course in 4 Hours | SQL in One Shot using MySQL #sql канала Rohit Honde