7. What is Data Query Language (DQL) in SQL? Introduction to the SELECT Command in MySQL.
HTML-код
- Опубликовано: 10 июл 2024
- Welcome to Everything Computerized. I'm CA and in this video, I'm gonna explain the Data Query Language (DQL) in detail. This is the seventh video in the SQL tutorial series, and here you'll learn about the DQL, SELECT command, its syntax and various other concepts with practical implementation.
So watch this video till end, and please like this video and share to your friends and help them too. Thanks for all your support, and Yeah! We are near to 1K family! So jam on that red subscribe button, and break the records!
My InstaID: @everything_computerized
Important Links:-
1. Link to the table: everythingcomputerized-ca.blo...
2. Link to the SQL playlist: • How to install MySQL t...
3. Install MySQL on PC: • How to install MySQL t...
4. How to use MySQL: • How to use the MySQL C...
5. Intro to SQL: • 1. Basic concept of SQ...
6. DDL: • 2. What is Data Defini...
7. DML: • 4. What is Data Manipu...
8. DCL: • 5. What is Data Contro...
9. TCL: • 6. What is Transactio...
Timestamps:
00:00-00:35 | Introduction
00:36-00:53 | Intro to DQL
00:54-01:07 | Commands in DQL
01:08-01:31 | Definition of DQL
01:32-01:53 | Intro to SELECT command
01:54-02:18 | Syntax 1 of SELECT Command
02:19-02:43 | Practical Implementation of syntax 1
02:44-03:08 | Syntax 2 of SELECT Command
03:09-08:25 | Practical Implementation of syntax 2
08:26-08:47 | Brief intro to Clauses
08:48-10:19 | The WHERE Clause
10:20-15:22 | Practical implementation of WHERE Clause
15:23-15:53 | Conclusion
My Github account: github.com/Chiku1022/
#dql #sql #select #mysql
Informative n helpful video👍ty CA
❤
Amazing
Thank you!
Super bro 🙏🙏🙏
😊❤
Super❤️
😊🙈❤
clear cut explaination bro sup
🙂❤❤
Thanks ❤
😊
You are the besssssssssssssssssssssssssssssssssssssssssssssssssst bro ✌️🤧
Thaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaannnnnkkkkkkkuuuuuuuuuuuuuuuuuuuu🤯
there are 3 more commands in DQL 1]projection 2]selection ]joins please eleborate this also
DQL just consists of SELECT.. and as far as the points you suggested, they are different topics. I've started this series for School students, so I'll keep it simple and I'll not include complex things that aren't in syllabus.
Projection, Selection and Join are operations that can be done on a table. I'll briefly explain these topics in a seperate vdo.
BTW, I'll make sure I include external notes for complex topics too.😊
thanks for the reply 😊🙏
🙂🙂🙂
@@EverythingComputerized
can u show order by command?
Hi, I want a full MySQL video from you,can you make it please
Sure.. I'm planning on it and when I'll get time, I'll try to upload them one by one.. till then, I request you to please be with us.
What is cobe of arranging data in ascending order ? Plz tell
Havent yet uploaded the vdo..
Request you to please Wait for it to be uploaded🙂
@@EverythingComputerized plz write cobe becz today is my test
And one other is arranged data in alphabetical order
Plz write cobe plz
Questions
We only use column we row also plz anwer this question
Your question isn't clear.
You can use hindi also in my channel.
Creating a table and populating it with number of tuples plz write command language
You mean inserting data into it?..
If yes, watch DML section..
Please watch the playlist in sequence, you'll get everything..
Also, things are mentioned in Thumbnail, title and description.. have a look at it, you'll not have to ask anything after that🙂