#Module 9 : SQL

Section 9 is divided into sub sections

👉 9.1 Introduction to Databases

👉 9.2 Why SQL?

👉 9.3 Execution of an SQL statement.

👉 9.4 IMDB dataset

👉 9.5 Installing MySQL

👉 9.6 Load IMDB data.

👉 9.7 USE, DESCRIBE, SHOW TABLES

👉 9.8 SELECT

👉 9.9 LIMIT, OFFSET

👉 9.10 ORDER BY

👉 9.11 DISTINCT

👉 9.12 WHERE, Comparison operators, NULL

👉 9.13 Logical Operators

👉 9.14 Aggregate Functions: COUNT, MIN, MAX, AVG, SUM

👉 9.15 GROUP BY

👉 9.16 HAVING

👉 9.17 Order of keywords.

👉 9.18 Join and Natural Join

👉 9.19 Inner, Left, Right and Outer joins.

👉 9.20 Sub Queries/Nested Queries/Inner Queries

👉 9.21 DML:INSERT

👉 9.22 DML:UPDATE , DELETE

👉 9.23 DDL:CREATE TABLE

👉 9.24 DDL:ALTER: ADD, MODIFY, DROP

👉 9.25 DDL:DROP TABLE, TRUNCATE, DELETE

👉 9.26 Data Control Language: GRANT, REVOKE

👉 9.27 Learning resources

👉 9.28 Assignment-22: SQL Assignment on IMDB data

9.1 Introduction to Databases

9.2 Why SQL?

9.3 Execution of an SQL statement

9.4 IMBD dataset

9.5 Installing MySQL

9.6 Load IMBD data

9.7 USE, DESCRIBE, SHOW TABLES

9.8 SELECT

9.9 LIMIT, OFFSET

9.10 ORDER BY

9.11 DISTINCT

9.12 WHERE, COMPARISON OPERATORS, NULL

9.13 Logical Operators

9.14 Aggregate Functions: COUNT, MIN, MWX, AVG, SUM

9.15 GROUP BY

9.16 HAVING

9.17 ORDER OF KEYWORDS

9.18 Join and Natural Join

9.19 Inner, Left, Right and Outer joins