Скачать с ютуб SQL - Complete Course in 3 Hours | SQL One Shot using MySQL в хорошем качестве

SQL - Complete Course in 3 Hours | SQL One Shot using MySQL

You can join the NEW Web Development batch using the below link. 🔥Delta 3.0(Full Stack Web Development) : https://www.apnacollege.in/course/del... Early bird offer for first 5000 students only! International Student (payment link) - https://buy.stripe.com/7sI00cdru0tg10... --------------------------------------------------- 📌 Details about the Delta 3.0 Batch : - Start Date : 7th November, 2023 - Alternate day lectures (at 8PM) - Duration - 4.5 months - Each Class duration : 1.5 hour-2hour (alternate days) - Access to the course is for 2 years - Complete Frontend Development with HTML, CSS, Javascript & ReactJs - Complete Backend Development (NodeJs, ExpressJs) - Complete Database -( SQL & MongoDB) - Complete MERN Stack (MongoDB, Express, React, Node) - Real Life and Industry Grade Projects - Live Mentorship Sessions - 500+Topic Videos - Certificate will be given on Completion. Link for SQL Notes : https://drive.google.com/drive/folder... SQL Timestamps: Start - 00:00 Introduction to SQL - 01:43 01:48 What is database? 03:45 Types of databases 08:03 Installation of MySQL 13:03 Database Structure 14:21 What is table? 16:29 Creating our first database 22:41 Creating our first table 29:49 SQL Datatypes 37:11 Types of SQL Commands 40:09 Database related queries 43:43 Table related queries 46:11 SELECT Command 47:22 INSERT Command 51:19 Practice Questions 56:25 Keys 01:01:26 Constraints 01:13:04 SELECT Command in Detail 01:15:10 Where Clause 01:21:19 Operators 01:25:21 Limit Clause 01:26:48 Order By Clause 01:29:12 Aggregate Functions 01:32:33 Group By Clause 01:37:51 Practice Questions 01:43:35 Having Clause 01:47:18 General Order of Commands 01:50:31 UPDATE Command 01:56:40 DELETE Command 01:58:41 Revisiting Foreign Keys 02:06:35 Cascading Foreign Keys 02:12:30 ALTER Command 02:15:06 CHANGE and MODIFY Commands 02:20:33 TRUNCATE Command 02:24:00 JOINS in SQL 02:51:23 UNION in SQL 02:53:54 SQL Sub Queries 03:11:26 MySQL Views