Lesson 8 of 11 • 6 upvotes • 12:59mins
The DDL statements ( CREATE, ALTER, TRUNCATE, DROP, DESC, RENAME) and DML statements (INSERT, DELETE, UPDATE, SELECT) are explained with an example. The video contains the self assessment questions to assess yourself on the topic you learned.
11 lessons • 1h 53m
Overview
1:19mins
SQL Data Types and Create Command
9:24mins
Insert, Select and Delete Query
8:52mins
NoSQL and MongoDB
8:50mins
Understanding Database and Table
8:02mins
Primary Key, Foreign Key and Unique Key
7:53mins
SQL SELECT statement
13:51mins
SQL statements
12:59mins
Aggregate functions and GROUP BY clause
13:51mins
Constraints
14:06mins
Question paper discussion - Database & SQL (SECTION C) - 2017
14:39mins