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)
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.
🎯 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
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.
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
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..
Thank you for your videos; you are one of the best teachers on RUclips so far. However, it would be even more helpful if you could guide us through the process of creating a table for beginners instead of directly presenting the table and its explanation. thank you for your help.
Very nice video for SQL beginners. My major confusion is when we use " join... on ..." mthod to join the tables and we need to write the "where" clause on multiple join tables like "t1 join t2 on.. where" and again "join t3 on... where". This yields very different result. where do we exactly write all the "Where" clause at the end of all the joins or on the respective joins itself.
Where clause should be after all the joins.. You don’t put where in between the joins.. I have created separate video series covering joins where I have explained all the process.. perhaps you can watch that
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.
I copied all the code to PgAdmin but I get ERROR: relation "school" does not exist if I try to execute it. There are no tables. I was looking if there is word 'CREATE' anywhere in the code but there is none. I guess I need Create to create any tables? I am stuck here as I wanna put in the work and not just listen to the video. Please help!
Hi , Also please make a Vedio on only operators/commands in sql , like 'Any' , 'All' etc and whatever the topics you left out from the above Vedio. Thank you so much for your support
Honestly speaking, I did not find this video very informative. I was here to learn basic SQL but he went explaining the concept way too fast and not detail oriented.
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.
in basics, sir u directly started joins, group by and big queries without explaining what r they actually and also subqueries which are complicated I feel for beginners.......
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.
This video is the most useful video among other videos on RUclips 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
This video is the most useful video among other videos on RUclips for SQL. Great way of presenting things. Please make more such important videos on SQL and databases.
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
Fo which commands we need to write ".... table table_name...." and for which commands we just need to directly write table_name without the table in prefix. Pls explain once.
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.
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.
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!!
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.
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🤞🏻
I have learnt oracle sql previously and currently practicing sql in oracle sql developer. So to start career with data analyst whether I need to switch to any other DBMS like postgresql, mysql, MS sql server?
This video is not for beginners and for beginners. I mean you had already brushed up basic of SQL few months back. Now you want to remember them as quickly as possible. Then This video is for you. 🙃
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.
Hi , Can you suggest where to practice these sql queries ,I am not able use lighthall.As we know ,just watching these powerful concepts may not store in brain. Could you advice
As for practice sql queries, I am thinking of a way to help since many request for it .. Let me see if I can come up with a list of really good queries
Employee_Id Employee_Name rating supervisor_employee_id designation 1 Dr.Max 9 3 doctor 2 Dr.James 8 4 doctor 3 Peter 6 None supervisor 4 Simon 9 None supervisor Write a query to find the doctors having more ratings than their supervisors ?
Hi, below query should work: select a.* from (select * from employee where designation = 'doctor') a join (select * from employee where designation = 'supervisor') b on a.supervisor_employee_id = b.Employee_Id and a.rating > b.rating;
Sir please upload vidio cursor and plsql program how to all sql concept use in programing like cursor function procedure exception and when to use in programing
When I heard you mentioned about 'Malaysia' when updating the address table, I am glad someone knows about Malaysia 🤣🤣 Btw your teaching in SQL is great 👍👍 Showing what happen when different queries is executed 👍👍
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.
1 represents the 1st column in select list. So either you can mention column name in order by or just mention the position of that column in the SELECT list
Firstly, thanks for such a great video but I have a doubt at 46:20 - how can there be duplicates between the results of 2 queries if the first query is returning the "teaching staff" and the second query is returning the "non-teaching staff". What are the criteria based on which we call 2-row duplicates?
can you teach us lesson on 1. trigger 2. index 3. stored procedure 4. pivot 5. view 6. curser suggestion = your videos quality and animation are easily understanding. It has also been engrossed with knowledge and information that is important. you add subtitle on video because pace of your communication is little bit high. if it is possible. I am from INDIA so that I am supposed to give a suggestion on that particular subject and another one is when will python tutorials be commencing ?
Hi Suraj, Thanks for the suggestion 🙏🏼 I’ll consider this and try to make videos on all these topics in the near future.. Regarding the pace of my video, I’ll try to get little slower.. And regarding python, I have already posted python tutorial series for beginners covering all basic concepts and also have posted some advanced python tutorial as well. Please check out my channel
Hi- Thank you. Question: in the first join example my logic tell me "From CLASSES and not From SUBJECTS", Did you write it on purpose or because it doesn't make any changes in the result!
Hi, I have good knowledge on below SQL queries..... SELECT; ORDER BY; SELECT DISTINCT; LIMIT; COUNT; WHERE; LIKE; AGGREGATION FUNCTIONS; GROUP BY; HAVING; EXTRACT; TO CHAR; CASE; JOINS; UNION; CREATE ; DROP; INSERT; ALTER; UPDATE ; VIEWS; OVER; PARTITION; can any one suggest which Microsoft Certification in SQL I can do.... Thnx.
Could you please guide me how to get OAuth2 token and call REST API through SQL. The scenario is every 10 mins I have to call the API automatically create a new record in my application. Please let me know best way to achieve this . Thanks in advance
Maybe a video to assist in loading data set into SSMS, the scripts are not working , for example: when you insert the Student values into the table, SSMS is not recognizing "TO DATE ('2014-01-13', 'YYY-MM-DD')) . The content is great, just would to follow along with writing queries.
I'm not fully understanding the "OR" keyword @31:28. AGE >50 OR GENDER = 'F' -- Why did it retrieve ages that are less than 50? It was true to sticking with the 'F' as it didn't pull an 'M'. In my mind this should have fetched everything except where the records are male who are under 50. But no males were retrieved and there are ages that are under 50 that were retrieved.
I executed the scripts in mysql server and its showing lot of errors. It is showing error in students table, To_date function not working in mysql etc. If anybody has tried this, please reply
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
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......
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,
🎯 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
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.
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...
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 is very comprehensive.... yet simplified topic.... Thank you... Sir...
Well curated, Definitely people will understand all the concepts without any doubt as you explained with examples in this video ❤
One of the best SQL Fundamental video I have seen!! You have really co ordinated every thing you can cover!! Well Done Mate!
HELLO, TO_Date function is not working in my case, it is showing an error TO_DATE FUNCTION DOESNT EXIST. Kindly help
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
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..
Thank you for your videos; you are one of the best teachers on RUclips so far. However, it would be even more helpful if you could guide us through the process of creating a table for beginners instead of directly presenting the table and its explanation. thank you for your help.
Top notch content. Brilliant visual presentation. ENJOY!
Very nice video for SQL beginners. My major confusion is when we use " join... on ..." mthod to join the tables and we need to write the "where" clause on multiple join tables like "t1 join t2 on.. where" and again "join t3 on... where". This yields very different result. where do we exactly write all the "Where" clause at the end of all the joins or on the respective joins itself.
Where clause should be after all the joins..
You don’t put where in between the joins..
I have created separate video series covering joins where I have explained all the process.. perhaps you can watch that
# 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.
I copied all the code to PgAdmin but I get ERROR: relation "school" does not exist if I try to execute it. There are no tables. I was looking if there is word 'CREATE' anywhere in the code but there is none. I guess I need Create to create any tables? I am stuck here as I wanna put in the work and not just listen to the video. Please help!
Hi ,
Also please make a Vedio on only operators/commands in sql , like 'Any' , 'All' etc and whatever the topics you left out from the above Vedio.
Thank you so much for your support
Your welcome bro and will cover all sql topics in a tutorial series which I plan to make soon
@@techTFQ also please include cast and convert functions in your Vedio
Honestly speaking, I did not find this video very informative. I was here to learn basic SQL but he went explaining the concept way too fast and not detail oriented.
Bro, i have to admit you are the best SQL teacher of the RUclips even better than my offline faculty. Thank You very much man.
hi bro
where are you from
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.
in basics, sir u directly started joins, group by and big queries without explaining what r they actually and also subqueries which are complicated I feel for beginners.......
Your explanation is really amazing, Taufeeq!
Thank you 🙏🏼
U r legend sir. U understood in very easy way..GBU thanks alot and made more videos ahead.
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.
I have one doubt it is iam inserting values into students table it error like ,error code: 1241. operand should contain 1 column
Bro you can teach💯💯
Best teacher I’ve seen so far
Details 💯
Thank you Ael for the kind appreciation 🙏🏼
Glad you liked it..
Very informative and easy to follow the concepts are explained very well.
Thank you soo much for too easy understanding of SQL Queries.
Thank You So Much..................✅
You are welcome :)
Thank you sir this video helps me a lot.
This video is the most useful video among other videos on RUclips 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
This video is the most useful video among other videos on RUclips for SQL. Great way of presenting things. Please make more such important videos on SQL and databases.
Thank you and will do 🙏🏼
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
The best tutorial i have ever seen. Keep it up
Glad it helped
Fo which commands we need to write ".... table table_name...." and for which commands we just need to directly write table_name without the table in prefix. Pls explain once.
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.
you have explanation skills very good.....thanks for making such kind of videos....
😇😇😇😇
I WANT FULL COURSE OF SQL BASIC TO ADVANCE.
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.
Congratulations on achieving 200K subscribers!!
Thanks man.. I just saw this after your comment .. thanks again ❤️
@@techTFQ 😍😍
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!!
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
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 ☺️
I have learnt oracle sql previously and currently practicing sql in oracle sql developer. So to start career with data analyst whether I need to switch to any other DBMS like postgresql, mysql, MS sql server?
Does not matter .. SQL is 90% same across all RDBMS so what u learnt in SQL, you will be able to apply them in all other rdbms
@@techTFQ thank you so much for your prompt response.
This video is not for beginners and for beginners. I mean you had already brushed up basic of SQL few months back. Now you want to remember them as quickly as possible. Then This video is for you. 🙃
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.
Sir class 11 aur 12 ke lia bhi content banaya karo....channel grow karega aur hum baccho Ko apse parhne ki opportunity.
Thank you Vineet for liking my contents..
As for college subjects, not planning as of now bro
You are the GOAT of explanation my friend thank you!
Why it showing error this like
Hi , Can you suggest where to practice these sql queries ,I am not able use lighthall.As we know ,just watching these powerful concepts may not store in brain. Could you advice
As for practice sql queries, I am thinking of a way to help since many request for it ..
Let me see if I can come up with a list of really good queries
@@techTFQ thank
Excellent outstanding tutorial
Thank you Brother for your Explanation
The teaching level like master but could you please increase quality of video
Hopefully it’s improved in the recent videos
Thank you so much for this tutorial !!! Best tutorial..!
Employee_Id Employee_Name rating supervisor_employee_id designation
1 Dr.Max 9 3 doctor
2 Dr.James 8 4 doctor
3 Peter 6 None supervisor
4 Simon 9 None supervisor
Write a query to find the doctors having more ratings than their supervisors ?
Hi, below query should work:
select a.*
from (select * from employee
where designation = 'doctor') a
join (select * from employee
where designation = 'supervisor') b
on a.supervisor_employee_id = b.Employee_Id and a.rating > b.rating;
Hello sir, can I get your mail id ?
Sure, you can reach me at techtfq@gmail.com
Pls upload video groupby and having clauses
Things are explained to the point , in an understandable way ... nice :)
Thank you so much!
Glad you liked it :)
sir, really nice tutorial i'm enjoing it, sit can you tell how you are executing a specific section of code by hilighting it
Need clarification regarding order by 2 desc and order by 1,2. What I understand by this is we can give column order/number instead of column name?
It means the column position in your select clause..
When we say order by 2.. sorting happens based on the 2nd column in select clause..
good job bro amazing explanation superb
Very informative and useful video... thanks for sharing it with us😊😊👏
Thank you so much..
Glad it was helpful 🙂
Sir please upload vidio cursor and plsql program how to all sql concept use in programing like cursor function procedure exception and when to use in programing
Awesome video and clear explanation!! Thank you so much for the video.
Your welcome :)
Glad this helped..
best brief sql vid in youtube till now
Thank you very much ☺️
cult cut clear explanation dude'
When I heard you mentioned about 'Malaysia' when updating the address table, I am glad someone knows about Malaysia 🤣🤣 Btw your teaching in SQL is great 👍👍 Showing what happen when different queries is executed 👍👍
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.
Wow, best sql video by far.
Thank you so much 🙏🏼
Glad you found this helpful ☺️
Please make a vedio on complexes and queries...
This video has to appear on top whenever a person types sql tutorial
Thank you buddy
Sir can you please explain what is the meaning of order by 1 order by 2 and order by 1,2
1 represents the 1st column in select list. So either you can mention column name in order by or just mention the position of that column in the SELECT list
@@techTFQ thnkuu sir.. also awesome content please keep creating 😊👏
Glad you liked it
You have put things in an easy way and more practical. Great way of explanation, I thoroughly enjoyed the session.
Marvelous! This is a great work, and very useful.. thanks!
can u pls add the like of my slq software link for downloading the mysql
Are you looking for help in downloading and installing MySQL database?
@@techTFQ yes
Firstly, thanks for such a great video but I have a doubt at 46:20 - how can there be duplicates between the results of 2 queries if the first query is returning the "teaching staff" and the second query is returning the "non-teaching staff". What are the criteria based on which we call 2-row duplicates?
can you provide plz sql file which you used in the video for practice
Already provided. Check description
@@techTFQ sir i am new in a field
Could you please tell me how to export this file in my sql ?🙏🙏
Sir....do we need to create different tables for foreign keys constraints.
can you teach us lesson on
1. trigger
2. index
3. stored procedure
4. pivot
5. view
6. curser
suggestion = your videos quality and animation are easily understanding. It has also been engrossed with knowledge and information that is important. you add subtitle on video because pace of your communication is little bit high. if it is possible. I am from INDIA so that
I am supposed to give a suggestion on that particular subject and another one is
when will python tutorials be commencing ?
Hi Suraj,
Thanks for the suggestion 🙏🏼
I’ll consider this and try to make videos on all these topics in the near future..
Regarding the pace of my video, I’ll try to get little slower..
And regarding python, I have already posted python tutorial series for beginners covering all basic concepts and also have posted some advanced python tutorial as well. Please check out my channel
Hi- Thank you. Question: in the first join example my logic tell me "From CLASSES and not From SUBJECTS", Did you write it on purpose or because it doesn't make any changes in the result!
Sir please upload SQL concept of ANY & ALL
Hi,
I have good knowledge on below SQL queries.....
SELECT; ORDER BY; SELECT DISTINCT; LIMIT; COUNT; WHERE; LIKE; AGGREGATION FUNCTIONS; GROUP BY; HAVING; EXTRACT; TO CHAR; CASE; JOINS; UNION; CREATE ; DROP; INSERT; ALTER; UPDATE ; VIEWS; OVER; PARTITION;
can any one suggest which Microsoft Certification in SQL I can do....
Thnx.
Could you please guide me how to get OAuth2 token and call REST API through SQL.
The scenario is every 10 mins I have to call the API automatically create a new record in my application.
Please let me know best way to achieve this .
Thanks in advance
Maybe a video to assist in loading data set into SSMS, the scripts are not working , for example: when you insert the Student values into the table, SSMS is not recognizing "TO DATE ('2014-01-13', 'YYY-MM-DD')) . The content is great, just would to follow along with writing queries.
Thanks sir for dng videos,keep uploading more videos it will help us to learn more knowledge
Great job on this video. I'm learning a TON. Maybe 2 tons. Thanks, Thoufiq!
best video thank you very much💯💯
Your welcome 🙏🏼
Glad you liked it
Can you show how to connect Azure Data Studio using MacBook, please, thank you. I'm getting a few errors creating a connection.
Bro thanks for this video.. thanks for this kinda explanation.
Could you please say the keyword for date in mysql if possible
Visual basic.... But there is no chances or scopes in future life
Sorry I don’t understand what you meant
@@techTFQ I studied in my plus two computer class but I didn't get any profit in my life
My second Question: Where is duplicate which will be eliminated after using UNION? Record is either Teaching or non teaching. What am i missing here?
One of the best tutorials in SQL on RUclips. Thanks a lot for your contribution ❤
I'm true fan of your channel❤❤❤
Please make a video on solving complex SQL queries... Please I humbly request you
Y should you uploaded this video's in yt bro waste of time I can't able to see what you explained
That data structures are small very small
This video helped me land a job.
I'm not fully understanding the "OR" keyword @31:28. AGE >50 OR GENDER = 'F' -- Why did it retrieve ages that are less than 50? It was true to sticking with the 'F' as it didn't pull an 'M'. In my mind this should have fetched everything except where the records are male who are under 50. But no males were retrieved and there are ages that are under 50 that were retrieved.
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..
Hi. May I know where we can find the data set to practice for the above explained select queries(Practice simple SQL Queries)
I executed the scripts in mysql server and its showing lot of errors. It is showing error in students table, To_date function not working in mysql etc. If anybody has tried this, please reply