@Dheerane
🎯 Key points for quick navigation: 00:00 📚 SQL Overview - SQL is a widely used programming language for managing relational databases. - It allows interaction with databases for reading, writing, modifying, and analyzing data. - SQL is essential for various roles including developers, analysts, engineers, and scientists. 03:18 🏗️ SQL DDL Commands - Data Definition Language (DDL) commands in SQL include CREATE, ALTER, DROP, and TRUNCATE. - These commands are used to define and manage database structures like tables and views. - DDL commands ensure database objects are created, modified, or deleted as required. 08:21 🛠️ SQL DML Commands - Data Manipulation Language (DML) commands in SQL include INSERT, UPDATE, and DELETE. These commands are used to manipulate data within database tables. - DML commands facilitate adding, modifying, or removing data entries. 13:00 📊 SQL Constraints - Constraints like CHECK, NOT NULL, UNIQUE, PRIMARY KEY, and FOREIGN KEY ensure data integrity. - They impose rules on data columns to maintain consistency and accuracy. - Constraints prevent invalid data insertion and enforce relational integrity. 21:16 📑 SQL SELECT Queries - SELECT queries retrieve data from one or more tables based on specified conditions. - These queries form the core of SQL for fetching, analyzing, and reporting data. - SQL SELECT statements are flexible and can include complex joins and filtering conditions. 22:40 📚 Introduction to SQL basics and practice queries - Introduction to writing SQL select queries covering operators, group by statements, SQL joins, subqueries, and aggregate functions. - Overview of database tables designed to simulate a school database environment. 24:31 📊 Basic SQL select queries and operators - Explanation of the SQL `SELECT` statement using `SELECT * FROM students` to fetch all records. - Detailed overview of SQL operators: equal to, not equal to, less than or equal to, greater than or equal to, and their practical uses in filtering data. 27:05 🔄 Sorting and filtering data in SQL - Demonstration of the `ORDER BY` clause for sorting query results. - Practical application of the `BETWEEN` operator for filtering salary ranges. - Explanation of the `IN` and `NOT IN` clauses for filtering data based on multiple conditions. 30:21 🧩 Logical operators and conditional queries in SQL - Detailed use of `AND` and `OR` operators in SQL queries for combining multiple conditions. - Examples of how `AND` requires all conditions to be true, while `OR` retrieves results if any condition is true. 35:05 🎯 Conditional logic with CASE statements in SQL - Utilization of the `CASE` statement to create conditional logic in SQL queries. - Example of using `CASE` to categorize salaries into high, average, and low categories based on predefined conditions. 36:28 🌐 SQL joins: INNER JOIN and WHERE clause - Explanation of SQL joins using `INNER JOIN` and the `WHERE` clause for filtering data across multiple tables. - Comparison of JOIN syntax using aliases for better readability and debugging in complex queries. 44:14 📊 Union and Union All in SQL - Understanding the usage of `UNION` and `UNION ALL` operators in SQL. - `UNION` combines results and removes duplicates, while `UNION ALL` combines results without removing duplicates. - Ensure columns and their data types match when using `UNION`. 47:20 📊 Group By in SQL Queries - Explanation of the `GROUP BY` statement in SQL to aggregate data. - Use `GROUP BY` to group data based on specific column values. - Essential for performing aggregate functions like `COUNT`, `SUM`, `AVG` on grouped data. 52:08 📊 Using Group By with Having Clause - How to filter grouped data using the `HAVING` clause in SQL. - `HAVING` clause is used with `GROUP BY` to apply conditions to aggregated data. - Example: Filtering classes with more than 100 students using `GROUP BY` and `HAVING`. 54:12 📊 Subqueries in SQL - Introduction to subqueries and their role in SQL queries. - Subqueries are queries nested inside another query. - Useful for complex filtering and retrieving specific data subsets. 58:49 📊 Aggregate Functions in SQL - Understanding aggregate functions (`AVG`, `SUM`, `MIN`, `MAX`) in SQL. - Aggregate functions perform calculations on a set of values and return a single value. - Practical examples include calculating average salary or total salary in a dataset. 01:02:08 📊 Inner Join and Outer Join in SQL - Explanation of `INNER JOIN` and `OUTER JOIN` in SQL. - `INNER JOIN` retrieves records that have matching values in both tables. - Types of `OUTER JOIN`: `LEFT`, `RIGHT`, and `FULL`, for retrieving unmatched records from one or both tables. 01:06:21 📊 Understanding Left Outer Join - Understanding left join in SQL, - Left join fetches all records from the left table and matching records from the right table. - Non-matching records from the left table are also included with NULL values for the right table columns. 01:07:54 🔄 Exploring Right Outer Join - Exploring right join in SQL, - Right join retrieves all records from the right table and matching records from the left table. - Non-matching records from the right table appear with NULL values for the left table columns. 01:09:17 🌐 Applying Full Outer Join - Applying full outer join in SQL, - Full outer join combines results of both left and right outer joins. - It retrieves all matching records, along with non-matching records from both left and right tables. Made with HARPA AI
@sonamkumar059
For the past 3 days, I have been trying to learn the basics of SQL from different channels. This video is, so far, the best in explanation. I love the fact that you make SQL sound so simple and easy to understand. I would definitely recommend you to other people who want to go into the data analytics business. Thank you so much.
@realninja357
This video is absolutely brilliant. 1 hour to learn what I've been struggling with for months! This was vital in understanding the bigger picture. I am so grateful.
@tombsmaker
# Timestamps 3:40 DDL 3:59, 4:19 create 4:02 alter 4:08 drop 4:12 truncate 9:48 datatype 5:16 varchar 5:29 Int 5:36 date 5:45 float 5:54 boolean 6:06 sample data type 6:12 constraints 6:34 check constraints 6:54 not null constraints 7:01 unique constraint 7:21 primary key 7:43 foreign key 8:10 drop 8:17 alter 8:34 DML 8:43 insert 9:03 update 9:22 delete 9:42 DDL & DML operations practical 9:44 create table 9:52 datatype 9:56 varchar 10:17 not null 10:24 check constraint 10:39 primary key 10:42 foreign key 11:02 select address, school, staff 11:33 insert 12:00 check constraint insertion error 12:30 primary key constraint error 13:00 not null constraint error 13:27 foreign key constraint error 14:34 Drop table 14:56 After command (datatype, rename table, rename column, 16:58 add constraints alter 17:36 DML 17:48 2 different insert syntax style 18:30 multiple records insertion 18:58 update 20:18 delete 21:10 DAL 21:13 Select 24:40 fetch all records 25:10 fetch particular columns 25:50 where =!-comparison 26:33 <= 26:55 order by asc 27:42 order by desc 27:57 between 28:32 in (in vs =) 29:07 not in 29:30 like starts with S 30:00 ends with C 30:21 and 31:18 or 32:31 addition 32:52 column name, alias 33:24 oracle, mysql arithmetic 34:13 distinct 34:25 limit 34:50 case/ if else 36:16 2 ways to write queries join, 37:47 join 39:15 no direct relation join, concatenating 2 columns, 42:35 fetch with multiple conditions, union 46:56 Union all 47:24 Group by 48:00 check total records 51:10 conditions on count 52:00 having 56:12 subquery 59:16 avg 1:00:20 Sum 1:01:30 min 1:01:46 max 1:02:15 inner join 1:03:37 match record? 1:05:14 inner join 1:05:54 outer join 1:06:04 left outer join 1:06:13 right outer join 1:06:20 full outer join 1:06:32 left join 1:08:04 right join 1:09:05 full outer join
@aleskerovw
I don't understand why this video has so small number of views and likes... The video is very informative, thank you very much!
@hemantgoyal6651
Hands down one of the best SQL tutorials I've seen on the Internet! Perfectly planned and executed!
@gerrielegue1095
Today I took basic SQL lessons. A very good and clear explanation. Thank you for setting up the lessons professionally. I am already looking forward to the next lessons. I wish you and your family a healthy 2023
@aaronschwartzman2926
Incredible content! You explain SQL very well. Never thought I’d learn SQL in an hour and 10 minutes. Thank you!
@ushalandesahoo1794
Recently I switched from BA to DA role and your SQL videos are very useful. I have watched many videos but your way of explanation is easy to understand.
@payalthakur1997
Thanks, I am giving interviews ri8 now and its so helpful to clear all doubt in less time. I love the fact that you make SQL sound so simple and easy to understand. I would definitely recommend you to other people who want to go into the data analytics business. Thank you so much.
@pritamsarkar3371
best brief sql vid in youtube till now
@sheebaparveen3630
Absolutely amazing video. Have watched so many videos on SQL but never such video like this where the required concepts are brilliantly explained without any dragging and just to the point. Perfect video for people who want to learn SQL in just little time. Great job. Loved this. Looking forward for more such videos.
@tekndesign5721
You are a legend man! This is one of the best SQL tutorials out there. And the provided downloadable SQL Scripts just made it the best ever! The plain english language reference in front of each SQL queries, just gave me a goosebumps. A massive thank you, just what I've been looking for as SQL beginner.
@Euphoria-k6r
I came here by shakra shamim reference by her post on linkedin and i am literally enjoying it. First kudos to shakra obviously and next to you toufiq.
@kush_chandhok
Here, as an Economics Graduate, non computers background but enjoying learning SQL
@Michael_Tseye
Bro you can teach💯💯 Best teacher I’ve seen so far Details 💯
@terihandrick2333
Wow I am glad I found your channel. You have an excellent teaching ability! Clear and concise and you have presented content I have not seen elsewhere laying the groundwork for SQL. Great job!!
@vshal3880
Bro, i have to admit you are the best SQL teacher of the YouTube even better than my offline faculty. Thank You very much man.
@BenDieselBasicAutomotive
This is very comprehensive.... yet simplified topic.... Thank you... Sir...
@techTFQ