7. What is Data Query Language (DQL) in SQL? Introduction to the SELECT Command in MySQL.

  Рет қаралды 22,830

Everything Computerized

Everything Computerized

Күн бұрын

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

Пікірлер: 30
@priyaanand6228
@priyaanand6228 3 жыл бұрын
Informative n helpful video👍ty CA
@EverythingComputerized
@EverythingComputerized 3 жыл бұрын
@mehwishuiux
@mehwishuiux 3 жыл бұрын
You are the besssssssssssssssssssssssssssssssssssssssssssssssssst bro ✌️🤧
@EverythingComputerized
@EverythingComputerized 3 жыл бұрын
Thaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaannnnnkkkkkkkuuuuuuuuuuuuuuuuuuuu🤯
@dewashishdeshmukh
@dewashishdeshmukh 3 жыл бұрын
Amazing
@EverythingComputerized
@EverythingComputerized 3 жыл бұрын
Thank you!
@ashokkumarak7128
@ashokkumarak7128 2 жыл бұрын
Super❤️
@EverythingComputerized
@EverythingComputerized 2 жыл бұрын
😊🙈❤
@ravitejagunapati5644
@ravitejagunapati5644 3 жыл бұрын
Super bro 🙏🙏🙏
@EverythingComputerized
@EverythingComputerized 3 жыл бұрын
😊❤
@chikkuckn8585
@chikkuckn8585 2 жыл бұрын
clear cut explaination bro sup
@EverythingComputerized
@EverythingComputerized 2 жыл бұрын
🙂❤❤
@kavinthapa9076
@kavinthapa9076 2 жыл бұрын
Thanks ❤
@EverythingComputerized
@EverythingComputerized 2 жыл бұрын
😊
@bhushnamkumar743
@bhushnamkumar743 3 жыл бұрын
Hi, I want a full MySQL video from you,can you make it please
@EverythingComputerized
@EverythingComputerized 3 жыл бұрын
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.
@chaithanyaks470
@chaithanyaks470 4 ай бұрын
can u show order by command?
@tusharpatil1053
@tusharpatil1053 3 жыл бұрын
there are 3 more commands in DQL 1]projection 2]selection ]joins please eleborate this also
@EverythingComputerized
@EverythingComputerized 3 жыл бұрын
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.😊
@tusharpatil1053
@tusharpatil1053 3 жыл бұрын
thanks for the reply 😊🙏
@EverythingComputerized
@EverythingComputerized 3 жыл бұрын
🙂🙂🙂
@-BhanuprakashGangineedi
@-BhanuprakashGangineedi Жыл бұрын
​@@EverythingComputerized
@abdheshkumar249
@abdheshkumar249 3 жыл бұрын
What is cobe of arranging data in ascending order ? Plz tell
@EverythingComputerized
@EverythingComputerized 3 жыл бұрын
Havent yet uploaded the vdo.. Request you to please Wait for it to be uploaded🙂
@abdheshkumar249
@abdheshkumar249 3 жыл бұрын
@@EverythingComputerized plz write cobe becz today is my test And one other is arranged data in alphabetical order Plz write cobe plz
@abdheshkumar249
@abdheshkumar249 3 жыл бұрын
Questions
@abdheshkumar249
@abdheshkumar249 3 жыл бұрын
We only use column we row also plz anwer this question
@EverythingComputerized
@EverythingComputerized 3 жыл бұрын
Your question isn't clear. You can use hindi also in my channel.
@abdheshkumar249
@abdheshkumar249 3 жыл бұрын
Creating a table and populating it with number of tuples plz write command language
@EverythingComputerized
@EverythingComputerized 3 жыл бұрын
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🙂
you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)
24:25
NetworkChuck
Рет қаралды 1,5 МЛН
World’s Largest Jello Pool
01:00
Mark Rober
Рет қаралды 116 МЛН
Mom's Unique Approach to Teaching Kids Hygiene #shorts
00:16
Fabiosa Stories
Рет қаралды 40 МЛН
Как бесплатно замутить iphone 15 pro max
00:59
ЖЕЛЕЗНЫЙ КОРОЛЬ
Рет қаралды 8 МЛН
Solving one of PostgreSQL's biggest weaknesses.
17:12
Dreams of Code
Рет қаралды 187 М.
Learn SQL Basics in Just 15 Minutes!
16:57
Kenji Explains
Рет қаралды 135 М.
Learn SQL In 60 Minutes
56:24
Web Dev Simplified
Рет қаралды 2,1 МЛН
World’s Largest Jello Pool
01:00
Mark Rober
Рет қаралды 116 МЛН