Welcome, to MySQL Tutorial in One Video in Hindi 2023. Also, SQL in One Video in Hindi. We will cover Complete MySQL Tutorial In Hindi 2021. So, What you will learn from my video 🙂 ✅ Latest NoSQL and MongoDB in One Video: https://youtu.be/hv7Y-Ct9sE4 ✅

————- 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.