IMPORTANT QUESTIONS OF MYSQL | MYSQL COMMANDS | CBSE CLASS 12 | COMPUTER SCIENCE

In this video, you will understand the type of Questions that can be asked in your board exams.

Revised Syllabus
https://www.youtube.com/watch?v=4MSy61D485E
Channel Link
https://www.youtube.com/channel/UC2vH9rqGh-fJELF8acGfBdw

MYSQL
Database Concepts: Introduction to database concepts and its need. Relational data model: Concept of domain, relation, tuple, attribute, degree, cardinality, key, primary key, candidate key, alternate key and foreign key.
https://www.youtube.com/watch?v=adw0ELL-HS0
Introduction of MYSQL, Features, MYSQL v/s SQL, DDL and DML Commands

https://www.youtube.com/watch?v=maKHoWMz4IA
Download and Install MYSQL Server (Complete Step – by – Step Guide)
https://www.youtube.com/watch?v=XJNLw3W7xew
MYSQL Commands
Create Database, Use Database, Show Databases, Show Tables, Create Table, char v/s varchar , data types in MYSQL (PART-1)
https://www.youtube.com/watch?v=orGavb9E9uw
Desc Command, Insert Into and Select Command (PART-2)
https://www.youtube.com/watch?v=pRwjSFzIAdE
WHERE Clause, Relational Operators, Logical Operators, Putting Text in Query, Scalar Expressions (PART – 3)
https://www.youtube.com/watch?v=gb1S-cWTeRE
DISTINCT BETWEEN NOT BETWEEN IS NULL IS NOT NULL LIKE NOT LIKE (PART-4)
https://www.youtube.com/watch?v=tmAchsH3tGU
ALTER , UPDATE , DELETE , DROP Commands (PART-5)
https://www.youtube.com/watch?v=g6u4vhoAwWk
Aggregate Functions (PART-6)
https://www.youtube.com/watch?v=aHi1duh2dTk
Order By , Group By , Having Clause (PART-7)
https://www.youtube.com/watch?v=-fUiv_CRMUA
Joins in MYSQL (Equi Join Natural Join) (Part – 8)
https://www.youtube.com/watch?v=vdLlpE7YrhA

Playlist Links:

Python Revision Tour
https://www.youtube.com/playlist?list=PL5Raijva2y4Rj6b_o7qEJr7ROubAYOP21

Functions in Python
https://www.youtube.com/playlist?list=PL5Raijva2y4QCsp_YXMcx_l94VU19fvsj

random module
https://www.youtube.com/playlist?list=PL5Raijva2y4T70gfikFKcqy-WdAA9M50E

Mathematical and String Functions
https://www.youtube.com/playlist?list=PL5Raijva2y4RyD5qC-AS2MDY35mhqlcwI

Using Python Libraries:
https://www.youtube.com/playlist?list=PL5Raijva2y4RR26kVHlzPC7-m9wxebk4-

Data Structures: Stack and Queue
https://www.youtube.com/playlist?list=PL5Raijva2y4Qhp87VuVA-ueQRgJTWhHCF

File Handling:
https://www.youtube.com/playlist?list=PL5Raijva2y4SoxE5BDz6tNkJivlSPYvDJ

Recursion
https://www.youtube.com/playlist?list=PL5Raijva2y4TyDofN9SXG3h2T4ug5N8oN

Idea of Algorithmic Efficiency
https://www.youtube.com/playlist?list=PL5Raijva2y4TEdYWXySP3HOUcHFqWqc3

Interface Python with MYSQL:
https://www.youtube.com/playlist?list=PL5Raijva2y4QBzhQw5OWIn9Dopl_M_NEE

MYSQL
https://www.youtube.com/playlist?list=PL5Raijva2y4S2sDeMIMu1kAVjwjgWyvyK

Programming Corner:
https://www.youtube.com/playlist?list=PL5Raijva2y4QSKwbV-yfkh1OzwajpJd2j