Lecture 25: SQL (part 1)| EMRS KVS NVS Computer Science Tier2 скачать в хорошем качестве

Lecture 25: SQL (part 1)| EMRS KVS NVS Computer Science Tier2

EMRS KVS NVS Series PlayList Link :    • EMRS KVS NVS Series   I will cover here the Complete Syllabus of EMRS KVS NVS Computer Science TGT PGT 2025 Tier -2 Exam. Special Focus on Descriptive Answer writing through Practice Session in between Lectures. Lecture 25: SQL (part 1) Structured Query Language: introduction, Data Definition Language and Data Manipulation Language, data type (char(n), varchar(n), int, float, date),constraints (not null, unique, primary key), create database, use database, show databases, drop database, show tables, create table, describe table, alter table (add and remove an attribute, add and remove primary key), drop table, insert, delete, select, operators (mathematical, relational and logical), aliasing, distinct clause, where clause, in, between, order by, meaning of null, is null, is not null, like,update command, delete command, group by, having clause, joins: Cartesian product on two tables, equi-join, Union and natural join Telegram Channel: https://t.me/csdidi_Annu Follow telegram channel for lecture PDFs, other doubts and Descrptive answer writing practice.