Complete SQL & MySQL in One Video in Hindi 2023🙏

------------- TimeLine For you reference -----------------

00:00 Introduction
00:44 What is Database?
01:30 What is collection of Data?
02:09 Where and How to store Data?
02:54 Explanation of Database using real life example
04:10 What is Database Management System?
04:53 Advantages of DBMS
05:55 Working of DBMS
07:04 Difference between SQL and NoSQL
11:10 What is SQL and MySQL?
13:30 How to use MySQL?
16:45 How to find Username and Password on PhpMyAdmin?
18:36 What will we learn?
19:35 How to check Databases using CMD and PhpMyAdmin?
21:14 How to create Database using CMD and PhpMyAdmin?
23:25 How to delete Database using CMD and PhpMyAdmin?
25:02 How to check current Database?
26:28 MySQL Data types
26:44 Why we need MySQL data types?
29:23 Different categories of MySQL data types
29:50 Int data type
30:40 Varchar data type
31:53 Date data type
32:28 How to create Table using CMD and PhpMyAdmin?
35:24 How to show Tables using CMD and PhpMyAdmin?
38:30 How to delete Tables using CMD and PhpMyAdmin?
39:17 How to insert data into Table?
43:03 How to show data of Table?
43:29 First : Small Challenge
45:11 Solution of challenge
45:55 NULL vs Not NULL in MySQL
52:22 What is Default value in MySQL?
55:22 ALTER TABLE statement for adding new column
57:22 ALTER TABLE statement for deleting column
58:34 What is PRIMARY KEY in Table?
1:03:19 What is AUTO_INCREMENT in Table?
1:06:31 CRUD operation
1:07:02 First, Create one table for CRUD operation
1:08:20 Second, Insert data in it for CRUD operation
1:09:19 Read operation : SELECT , WHERE clause
1:10:54 Update operation : UPDATE statement
1:14:05 Delete operation : DELETE statement
1:16:21 Second : Simple Task
1:16:40 SELECT DISTINCT statement in MySQL
1:18:53 ORDER BY keyword in MySQL
1:21:17 LIMIT keyword in MySQL
1:22:05 LIKE operator in MySQL
1:24:26 Aggregate Functions : COUNT(),MAX(),MIN(),SUM(),AVG() in MySQL
1:27:50 What is Logical operators?
1:28:04 Logical operator : NOT EQUAL
1:29:17 Logical operator : Greater or Less than
1:30:16 Third : Simple Task
1:30:32 Logical operator : Between...and
1:31:26 Logical operators
1:33:24 Logical operator : NOT Between...and
1:33:42 Logical operator : IN
1:35:27 String functions : CONCAT()
1:37:47 String functions : REVERSE()
1:38:24 Simple Trick to make palindrome string
1:39:22 String functions : CHAR_LENGHT(),UPPER(),LOWER()
1:39:53 Date Time data types in MySQL
1:42:33 Predefined functions of Date Time data types
1:43:48 Foreign Key Constraint in MySQL
1:45:26 Implementation of Foreign Key Constraint
1:49:00 How to show relation between Tables using Foreign key?
1:52:17 What is SQL JOIN?
1:53:26 Different types of SQL JOINs
1:53:35 What is INNER JOIN in MySQL?
1:57:38 What is LEFT JOIN in MySQL?
1:59:56 What is RIGHT JOIN in MySQL?
2:00:42 Outro

ALL THE ABOVE MENTION IS FULLY EXPLAINED WITH EXAMPLES.

What is a Database in MySQL in Hindi?
A database is a separate application that stores a collection of data. Each database has one or more distinct APIs for creating, accessing, managing, searching and replicating the data it holds.

Nowadays, we use relational database management systems (RDBMS) to store and manage the huge volume of data. This is called relational database because all the data is stored into different tables and relations are established using primary keys or other keys known as Foreign Keys.

A Relational Database Management System (RDBMS) is a software that −

Enables you to implement a database with tables, columns and indexes.

Guarantees the Referential Integrity between rows of various tables.

Updates the indexes automatically.

Interprets an SQL query and combines information from various tables.

MySQL Database
MySQL is a fast, easy-to-use RDBMS being used for many small and big businesses. MySQL is developed, marketed and supported by MySQL AB, which is a Swedish company. MySQL is becoming so popular because of many good reasons −

MySQL is released under an open-source license. So you have nothing to pay to use it.

[ThapaTechnical]

****Updated FEB 2022**** In this video, I covered Complete SQL & MySQL Topics In Hindi and also Added TimeLine Features too 👍📌..



GUYS, PLEASE SHARE WITH ALL YOUR FRIENDS AS MUCH AS YOU CAN ♥♥

[adarshraj]

00:00 Introduction
00:44 What is Database?
01:30 What is collection of Data?
02:09 Where and How to store Data?
02:54 Explanation of Database using real life example
04:10 What is Database Management System?
04:53 Advantages of DBMS
05:55 Working of DBMS
07:04 Difference between SQL and NoSQL
11:10 What is SQL and MySQL?
13:30 How to use MySQL?
16:45 How to find Username and Password on PhpMyAdmin?
18:36 What will we learn?
19:35 How to check Databases using CMD and PhpMyAdmin?
21:14 How to create Database using CMD and PhpMyAdmin?
23:25 How to delete Database using CMD and PhpMyAdmin?
25:02 How to check current Database?
26:28 MySQL Data types
26:44 Why we need MySQL data types?
29:23 Different categories of MySQL data types
29:50 Int data type
30:40 Varchar data type
31:53 Date data type
32:28 How to create Table using CMD and PhpMyAdmin?
35:24 How to show Tables using CMD and PhpMyAdmin?
38:30 How to delete Tables using CMD and PhpMyAdmin?
39:17 How to insert data into Table?
43:03 How to show data of Table?
43:29 First : Small Challenge
45:11 Solution of challenge
45:55 NULL vs Not NULL in MySQL
52:22 What is Default value in MySQL?
55:22 ALTER TABLE statement for adding new column
57:22 ALTER TABLE statement for deleting column
58:34 What is PRIMARY KEY in Table?
1:03:19 What is AUTO_INCREMENT in Table?
1:06:31 CRUD operation
1:07:02 First, Create one table for CRUD operation
1:08:20 Second, Insert data in it for CRUD operation
1:09:19 Read operation : SELECT, WHERE clause
1:10:54 Update operation : UPDATE statement
1:14:05 Delete operation : DELETE statement
1:16:21 Second : Simple Task
1:16:40 SELECT DISTINCT statement in MySQL
1:18:53 ORDER BY keyword in MySQL
1:21:17 LIMIT keyword in MySQL
1:22:05 LIKE operator in MySQL
1:24:26 Aggregate Functions : COUNT(), MAX(), MIN(), SUM(), AVG() in MySQL
1:27:50 What is Logical operators?
1:28:04 Logical operator : NOT EQUAL
1:29:17 Logical operator : Greater or Less than
1:30:16 Third : Simple Task
1:30:32 Logical operator : Between...and
1:31:26 Logical operators
1:33:24 Logical operator : NOT Between...and
1:33:42 Logical operator : IN
1:35:27 String functions : CONCAT()
1:37:47 String functions : REVERSE()
1:38:24 Simple Trick to make palindrome string
1:39:22 String functions : CHAR_LENGHT(), UPPER(), LOWER()
1:39:53 Date Time data types in MySQL
1:42:33 Predefined functions of Date Time data types
1:43:48 Foreign Key Constraint in MySQL
1:45:26 Implementation of Foreign Key Constraint
1:49:00 How to show relation between Tables using Foreign key?
1:52:17 What is SQL JOIN?
1:53:26 Different types of SQL JOINs
1:53:35 What is INNER JOIN in MySQL?
1:57:38 What is LEFT JOIN in MySQL?
1:59:56 What is RIGHT JOIN in MySQL?
2:00:42 Outro

[soniyapol]

1st long video which i m able to complete till end😂 its because of u thank u

[kirtisharma]

Wow just wow! Thank you first of all taking the time and hard work to create the SQL training video. I did not learn like this much in detail in school than with your full 2 hr video. I will definitely check out other videos to learn from you further. Thank you 🙏🏽💐👌❤️

[shriyapandey]

This lecture is informative and worth the trip, you explained smoothly. It developed my interest in SQL, thank you so much.

[amanlodhi]

Nobody, literally nobody-
Thapa bro after every minute:
Boom guys...😂

[sarfraznawaz]

Extremely helpful and quality content you have man, especially for someone like me who's desperately trying to switch his career to web development and doesn't have much time left to do so.
Keep up the good work and greetings from across the border.

[manasdas]

"delete from students;"It deletes all the record without deleting the table.

[Alex-mliv]

Thank you very much....i have joined IT company as a fresher and being a non IT guy this video is definitely gonna help me

[akhandpratapsingh]

Thanks for putting lots of effort into every topic. Thank you very much 👍🏼

[rockagain]

Really A good videos about dbms and sql .
Many confusion was in my mind but when i saw your video its totally solved thanks for making such a video.

[adorablecat]

1:41=collection of data best friends, shopping list, contact, facebook use accout +2:47 =database : mind, pen, phone, computer+4:14 =database management system example: pen is database management sys
6:08 =multiple database can create +6:40 =#+7:09 +7:27 =sql vs no sql +8:24 = no sql jason format +8:48 = sql vertically scalable +10:17 =#

11:22 =sql is a standard language which we use to talk to our database

[SheGotFavour]

Today i was wondering what is sql and dbms, and this evening i got u...
Thank u so mch yar....ur video was enough to understand what sql is...
May God Bless uh and increase ur subscribers to 1M . 😘

[shalinipanigrahy]

you helped a students a lot
hope u will get whatever u want
Thank you for your

[ayush_singh_]

I have studies Mysql during my school days and let me tell you this video is great help in recapping the whole Mysql and for revising it . Thanks for making this available.

[arpanprakash]

bhai 3 din me video complete hua notes or practice ke sath...THANKS FOR YOUR EFFORTS....PLEASE MAKE A VIDEO ON JAVASCRIPT

[manishkumar-gkit]

Sir delete statement is used to delete the record in table rather than deleting table itself truncate statement is also same

[rohitrout]

I wonder from where you gather so precise and prefect understanding about any topic. Because no one is there who clarify things so beautifully just like you❣️❣️🎗️keep it up..

[RKY]

Good Going, Thanks for Making This Video for student

[prasadgurav]

Thanks Thapa !!! for such a lovely video , I was scared earlier about database but after completion of this video i can say i know database and i know how to write query. This video help me a lot Thanks once again. you made video for 2 hrs but i seated whole day and i did practice side by side . Grate Work !!! I surely recommend this video.