Since it's a long video, I am adding the timestamp to each of the sections covered in this video so you can skip and watch only the sections, you are interested in. A BIG THANK YOU to each and everyone one of you for appreciating this video!!! Timestamps: 00:00 Intro 01:42 What is SQL 03:14 Different types of SQL Commands 03:36 What is Data Definition Language (DDL) 04:46 What is Data Type in SQL 06:11 What are Constraints in SQL 08:33 What is Data Manipulation Language (DML) 09:40 Practice SQL Commands (DDL, DML) 21:10 What is Data Query Language (DQL) 23:13 Practice simple SQL Queries 25:18 Operators in SQL (Comparison Operators, Arithmetic Operators, Logical Operators) 34:48 Case Statement in SQL 36:15 Different ways to write queries in SQL 42:30 UNION and UNION ALL Operators in SQL 47:18 GROUP BY Statement in SQL 56:10 Sub Queries in SQL 58:55 Aggregate Functions in SQL (AVG, MIN, MAX, COUNT, SUM) 01:01:56 SQL Joins (Inner Join, Left Join, Right Join, Full Outer Join)
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.
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.
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
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.
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.
Beautiful! You've really helped my learning path on Data Analysis. Thank you. Moreover,if the video can be enlarged that will help more as they're very tiny.
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.
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.
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!!
This video is the most useful video among other videos on UA-cam for SQL. Great way of presenting things. Please make more such important videos on SQL and databases.
This video is the most useful video among other videos on UA-cam for SQL. Great way of presenting things. Please make more such important videos on SQL and databases. please share the tables link with Answers for Practice with the help of your content
Video though long, you've made it very interesting. Explaining very eloquently without jargons & gobbledygook. Great job... Your efforts have translated into easy understanding. Keep going👍Thank you
Amazing video in 1 hour you will understand all the basics concepts of SQL. Otherwise rest of the videos are 3 to 4 hours long. Thank you so much for the amazing and informative content
Loved it 👍🏻👌🏻 Best SQL video for beginners and for people who want to strengthen their base in SQL. Good Job👏🏻👏🏻 Waiting for more videos explaining SQL in depth🤞🏻
🎯 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
Excellent! You are doing a great job dude. Hats off to your dedication and expertise. Wish our schools and colleges could atleast deliver 1% of what you are doing.
Incredible and Insight full content across al three SQl stages (beginner, Intermediate and advanced). I am a data analytics consultant with 4 years of experience in SQL and this was much helpfull during my interview prep. Just a small suggestion it would be nice if you include a session on wild cards in sql. Thanks again!
Great stuff!!!!!! I know you have other videos which shows more detailed explanations and logic on the different JOINS. HOWEVER, in showing your JOINS examples in this video best to show the original tables (along with the table original columns) somewhere else in the screen off to the side so it's better to follow along, actually we can see table and columns names of the tables, and try to visualize it. And makes it better to follow along and actually try to replicate the exercises as well.
Amazing explanation. Probably thhe best SQL teacher on yt. Just a question. Why on 11:25 after the CONSTRAINT is there PK_STF , FK_STAFF_SCHL AND FK_STAFF_ADDR. I understand what they stand for but why are written like that? Thanks. Amazing content again!
You have put so much effort into this video. Can you also make videos on BI, Tableau, and other data visualization tools? The videos are so elaborate and easy to understand. Well done!
Ma'am for BI check Pavan lalwani vedio . He has covered E2E .... for power query/ DAX in BI CHECK - Curbal Vedios .. I don't prefer TABLEAU as it's 4 -14 days trial version ..i tried tableau public version software .. loading data is dead slow ..
It is the best video and very useful. Learnt sql. “Ask, and it will be given to you; seek, and you will find; knock, and it will be opened to you. Matthew7:7. "the fear of the lord is the beginning of wisdom." Proverbs 9:10
Actually... This contains most of the informative consolidated contents that more than the top ranked above videos.. Dono why didn't get much views.. Anyways great work dude 📌💯... I guess indexing is the only missed thing.. I guess
Thank you Siva 🙏🏼 Really greatful that you consider this video with such high regard.. Glad you found this useful 🙂 And yes indexing is something I may cover in a future video..
Your kind of teaching is good for people who are coming from computer background and are intermediate not for beginners. I expected step by step tutorial , for example how to create tables , inserts . step,
Sir, your teaching is very great but when I wrote the very first command into my pg admin it is showing relation 'school' doesn't exist. what seems to be the problem here.
Since it's a long video, I am adding the timestamp to each of the sections covered in this video so you can skip and watch only the sections, you are interested in. A BIG THANK YOU to each and everyone one of you for appreciating this video!!!
Timestamps:
00:00 Intro
01:42 What is SQL
03:14 Different types of SQL Commands
03:36 What is Data Definition Language (DDL)
04:46 What is Data Type in SQL
06:11 What are Constraints in SQL
08:33 What is Data Manipulation Language (DML)
09:40 Practice SQL Commands (DDL, DML)
21:10 What is Data Query Language (DQL)
23:13 Practice simple SQL Queries
25:18 Operators in SQL (Comparison Operators, Arithmetic Operators, Logical Operators)
34:48 Case Statement in SQL
36:15 Different ways to write queries in SQL
42:30 UNION and UNION ALL Operators in SQL
47:18 GROUP BY Statement in SQL
56:10 Sub Queries in SQL
58:55 Aggregate Functions in SQL (AVG, MIN, MAX, COUNT, SUM)
01:01:56 SQL Joins (Inner Join, Left Join, Right Join, Full Outer Join)
Ha you missed an as before c3 in query 1 and query2 at 22:17 minute
Nice explanation and your voice
Tried to contact you, regarding sql classes
@techTFQ @36:21 in case statement what is order by 2 desc; what is 2 here ??
Sir can you pls change the theme of application. My request
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.
I don't understand why this video has so small number of views and likes... The video is very informative, thank you very much!
Thank you so much!
Glad that you found it useful...
Share it with your friends and people who u think it might be helpful....and don't forget to tell then to like and share😉😉
Thanks a lot Reeves for your kind words 🙏🏼☺️
Thank you Veena 🙏🏼🙏🏼☺️
Exactly the video is to the point and made with perfection
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.
Hands down one of the best SQL tutorials I've seen on the Internet! Perfectly planned and executed!
Chat GPT is replacing Database Professionals
@@jamesorior chatGPT site is down bro! Go & get some coffee......
Incredible content! You explain SQL very well. Never thought I’d learn SQL in an hour and 10 minutes. Thank you!
Thank you Aaron
I am glad this helped
Bro, i have to admit you are the best SQL teacher of the UA-cam even better than my offline faculty. Thank You very much man.
hi bro
where are you from
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
best brief sql vid in youtube till now
Thank you very much ☺️
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.
Thank you very much Sheeba..
So glad you liked it and found it useful.. ☺️
@@techTFQ, How can I have the source data such as CSV files to follow with you, the SQL course? Thank you very much in advance,
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.
Thank you so much buddy.
very glad you liked it
can you please share that SQL scripts I will download it.
# 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
Beautiful! You've really helped my learning path on Data Analysis. Thank you. Moreover,if the video can be enlarged that will help more as they're very tiny.
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.
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.
Very happy to read this :)
thank you
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!!
This is very comprehensive.... yet simplified topic.... Thank you... Sir...
This video is the most useful video among other videos on UA-cam for SQL. Great way of presenting things. Please make more such important videos on SQL and databases.
Thank you and will do 🙏🏼
One of the best tutorials in SQL on UA-cam. Thanks a lot for your contribution ❤
You have put things in an easy way and more practical. Great way of explanation, I thoroughly enjoyed the session.
Bro you can teach💯💯
Best teacher I’ve seen so far
Details 💯
Thank you Ael for the kind appreciation 🙏🏼
Glad you liked it..
You are the GOAT of explanation my friend thank you!
This video is the most useful video among other videos on UA-cam for SQL. Great way of presenting things. Please make more such important videos on SQL and databases.
please share the tables link with Answers for Practice with the help of your content
Great job on this video. I'm learning a TON. Maybe 2 tons. Thanks, Thoufiq!
WOW ...Started to learn SQL ...You are a Good Teacher Brother...Thanks a Ton....
Thank you so much Shaik :)
Happy to know you benefit from this video :)
Video though long, you've made it very interesting. Explaining very eloquently without jargons & gobbledygook. Great job... Your efforts have translated into easy understanding. Keep going👍Thank you
Thank you very much...
Amazing video in 1 hour you will understand all the basics concepts of SQL. Otherwise rest of the videos are 3 to 4 hours long. Thank you so much for the amazing and informative content
It's not a video, it's a package of all the relevant details, appreciate it mate, preparing for the interview with this video.
Awesome bro.. good luck and thank you 🙏🏼
@@techTFQ Thanks, Cracked interview, next round is due tomorrow
Awesome bro.. good luck for tomorrow 👍
Top notch content. Brilliant visual presentation. ENJOY!
Loved it 👍🏻👌🏻 Best SQL video for beginners and for people who want to strengthen their base in SQL. Good Job👏🏻👏🏻
Waiting for more videos explaining SQL in depth🤞🏻
Thank you Shahil ☺️
One of the best SQL Fundamental video I have seen!! You have really co ordinated every thing you can cover!! Well Done Mate!
Hats off to you.A real SME in true sense . Thank you for the superb explanation .
Well curated, Definitely people will understand all the concepts without any doubt as you explained with examples in this video ❤
Best SQL tutorial for beginners. Thank you so much
Glad you think so bro!
🎯 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
This video helped me land a job.
Excellent! You are doing a great job dude. Hats off to your dedication and expertise. Wish our schools and colleges could atleast deliver 1% of what you are doing.
This guide was extremely informative, clear, and well organized; thank you for this video! Wish you were a professor at my college!
your video for SQL is simply BEST.
Thanks sir for dng videos,keep uploading more videos it will help us to learn more knowledge
Great course for SQL beginner. Much appreciated!
Glad you liked it
Incredible and Insight full content across al three SQl stages (beginner, Intermediate and advanced).
I am a data analytics consultant with 4 years of experience in SQL and this was much helpfull during my interview prep.
Just a small suggestion it would be nice if you include a session on wild cards in sql.
Thanks again!
Welcome. Noted
@@techTFQ unable to restore given .sql files for practice
I learn join query using SQL in depth because of you thank you .it was amazing 👍 keep upload many videos like that
Thank you and will do
Your lesson is awesome.
I envisage to transition into IT field with focus on DATA Analysis.So your video is help
Very nice in depth structured courses for particular commands. Thank you!
Your welcome buddy
Yeah it really a good innovation to learn lot of member about SQL
Thank you so much for this awesome tutorial, and also BIG thanks for sharing all scripts.
Thank you !!!
Glad you liked it
Great video for quick prep, used time well to present most important SQL concepts
Congratulations on achieving 200K subscribers!!
Thanks man.. I just saw this after your comment .. thanks again ❤️
@@techTFQ 😍😍
You have put things in an easy way and more practical. Great way of explanation, I thoroughly enjoyed the session. 💯👌🏻
Thank you Rakesh 🙏
Glad you liked it..
I'm much more interested in learning SQL from basic so I hope your videos will be helpful for me
Great stuff!!!!!! I know you have other videos which shows more detailed explanations and logic on the different JOINS. HOWEVER, in showing your JOINS examples in this video best to show the original tables (along with the table original columns) somewhere else in the screen off to the side so it's better to follow along, actually we can see table and columns names of the tables, and try to visualize it. And makes it better to follow along and actually try to replicate the exercises as well.
The best tutorial i have ever seen. Keep it up
Glad it helped
Thanks Taufiq! This Video is very thorough and helpful.
really background music gives me so concentration. tnx a lot techTFQ. keep doing like this way
Glad you liked it bro
Sir, you are a legend. The way you explain is mind blowing. Hats off to you !! Keep up the good work.
May God bless you for providing this content for free! 🙏
U r legend sir. U understood in very easy way..GBU thanks alot and made more videos ahead.
Instant subscribe. Your explanations are something else.
Thank you Ivan 🙏🏼
Very informative and easy to follow the concepts are explained very well.
Please make a vedio on complexes and queries...
amazing explanation of each topic....best video on sql i have ever found ..pls upload more videos on sql
Thank you :)
Will do..
Amazing explanation. Probably thhe best SQL teacher on yt. Just a question. Why on 11:25 after the CONSTRAINT is there PK_STF , FK_STAFF_SCHL AND FK_STAFF_ADDR. I understand what they stand for but why are written like that? Thanks. Amazing content again!
Thank u for the informative video, its really useful and most underrated video on UA-cam!
way of explanation truly appreciate no words. I have seen lots of videos but your way is different
Very happy to follow ur each and every video of urs and clean explanation, thank you soo much 🥰
Very informative and super explanation....tq very much for video plz do full SQL course......
Thank you Vamsi 🙏🏼
And will do complete sql tutorial too
Best channel for SQL, great content bro... Keep posting, looking forward ❤
It is very useful for beginners, thank you so much
Your welcome buddy
you have explanation skills very good.....thanks for making such kind of videos....
😇😇😇😇
Thank You Sir........Stay Awesome Stay Positive
Thank you buddy
Thank you soo much for too easy understanding of SQL Queries.
Your explanation is really amazing, Taufeeq!
Thank you 🙏🏼
Great course for the beginners. Much appreciated! Thank you so much.
Thank you so much for this tutorial !!! Best tutorial..!
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.
thank you for effort and useful information shared, extremely helpful
Very well explained buddy, truly appreciate it!
Understandable work
Thanks so much for your simplicity 🎉
Superb. I appreciate your hard work for making this video with superior quality in both visual and voice. Keep doing more videos like this.
You have put so much effort into this video. Can you also make videos on BI, Tableau, and other data visualization tools? The videos are so elaborate and easy to understand. Well done!
Ma'am for BI check Pavan lalwani vedio . He has covered E2E .... for power query/ DAX in BI CHECK - Curbal Vedios ..
I don't prefer TABLEAU as it's 4 -14 days trial version ..i tried tableau public version software .. loading data is dead slow ..
@@sidindian1982 Bro...can you suggest any channel for real time project?
This was very helpful. Thank you👌🏽👍🏽👏🏽
Thanks. I am an experienced java developer . Useful for interviews
Awesome content! Best place to learn SQL if you have a very minimum understanding of sql and joints
First of all tq for posting this video
This video is most informative content n also more useful to mine
Thank you 🙏🏼
It is the best video and very useful. Learnt sql. “Ask, and it will be given to you; seek, and you will find; knock, and it will be opened to you. Matthew7:7.
"the fear of the lord is the beginning of wisdom."
Proverbs 9:10
Thank you 🙏🏼
Glad this helped ..
Actually... This contains most of the informative consolidated contents that more than the top ranked above videos.. Dono why didn't get much views.. Anyways great work dude 📌💯... I guess indexing is the only missed thing.. I guess
Thank you Siva 🙏🏼
Really greatful that you consider this video with such high regard..
Glad you found this useful 🙂
And yes indexing is something I may cover in a future video..
Best video I seen ever for learning sql
Thank you
sir, really nice tutorial i'm enjoing it, sit can you tell how you are executing a specific section of code by hilighting it
Your kind of teaching is good for people who are coming from computer background and are intermediate not for beginners. I expected step by step tutorial , for example how to create tables , inserts . step,
Genuinely , best video, thank you sir, helpful in many ways
Thanks a lot 🙏🏼
So glad this helped 😊
Thank you ❤️ brother 😊, thank you so much ❤️😘
This video is very helpful for me
Glad you liked it buddy
Sir, your teaching is very great but when I wrote the very first command into my pg admin it is showing relation 'school' doesn't exist. what seems to be the problem here.
thank you so much for your videos.
, good quality explanations
best video out there for learning sql
Good video, learning SQL at the moment, thanks
great explanation and very helpful. keep it up!
Thanks a lot 🙏🏼
Glad it helped ☺️☺️
Excellent teaching sir
Thank you so much
Very neat explation
Makes the subject very simple
Thank you Laxmi
Excellent session to learn in practical way...Thank u very much...iam expecting more sessions ....Thanks in advance
Thank you so much 🙏🏼
Glad you liked it ☺️☺️
Very informative and useful video... thanks for sharing it with us😊😊👏
Thank you so much..
Glad it was helpful 🙂
Marvelous! This is a great work, and very useful.. thanks!