SQL Part 5| IN | Not IN | Between | Not Between | Like | Not Like | Python | Tutorial | CBSE 2020-2

A new session with new syllabus is here.
This is fifth part of SQL
More valuable content is on the way....
In this video we are covering the below syllabus by CBSE for 2020-21 students

Visit Playlist for more....

CBSE Class 11th I.P Syllabus 2020

Database Concepts: Introduction to database concepts and its need, Database Management System. Relational data model: Concept of domain, tuple, relation, Advantages of using Structured Query Language, Introduction to MySQL, Data Types, candidate key, primary key, alternate key, foreign key., Data Definition Language, Data Query Language and Data Manipulation Language,
SQL Commands: Create Database, CREATE TABLE, DROP TABLE, ALTER TABLE, SELECT, FROM, WHERE, INSERT, UPDATE, DELETE

CBSE Class12th C.S Syllabus 2020
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; Structured Query Language: General Concepts: Advantages of using SQL, Data Definition Language and Data Manipulation Language; Data Types: number / decimal, character / varchar / varchar2, date;
SQL commands: CREATE TABLE, DROP TABLE, ALTER TABLE, UPDATE ....SET...., INSERT, DELETE; SELECT, DISTINCT, FROM, WHERE, IN, BETWEEN, LIKE, NULL / ISNULL, ORDER BY,GROUP BY, HAVING;
SQL functions: SUM ( ), AVG ( ), COUNT ( ), MAX ( ) and MIN ( );
Joins: equi-join and natural join

Mail me [email protected]
Follow me on fb @pythonspark

Part 1 Link- https://youtu.be/L38BPPUYCyQ
Part 2 Link- https://youtu.be/cRBfMqe6h5M
Part 3 Link- https://youtu.be/6KKiayPJW7s
Part 4 Link- https://youtu.be/IOLCD0KlggI
Changes in C.S Syllabus 2020-21- https://youtu.be/JWi5iHfPDAE
Changes in I.P. Syllabus 2020-21- https://youtu.be/ReRLaqSPw9w