1 Introduction to SQL

2 Getting started with MySQL

3 Assessment Question - Login to MySQL Database

4 Assessment Question - Connecting to MySQL

5 Introduction to Database Systems

6 Can Data be ported to another database?

7 What is SQL?

8 MySQL Database Terminology

9 Unique keys vs Primary keys

10 Examples of RDBMS

11 MySQL from Developers' Perspective

12 MySQL Data Types

13 MySQL Data Types ... continued

14 MySQL Data Types ... continued

15 Creating and Dropping a table

16 Inserting data into a table

17 Assessment Question - SQL Insert

18 Selecting data from a table

19 Filtering - WHERE clause

20 Updating data in a table

21 Deleting data from a table

22 Sorting the query results

23 Joins - Selecting from multiple tables

24 Self-Joins

25 Outer Joins

26 Subquery

27 Inline SELECT

28 Aggregate Functions

29 Grouping on Aggregate Functions

30 HAVING clause

31 Constraint Keys on Tables - Primary and Unique Key

32 Quiz Question - SQL Create simple table

33 Quiz Question - SQL Create table

34 Constraint Keys on Tables - Foreign Key

35 Prepare data for Questions

36 Quiz Question - SQL Select - Employees having "k" in name

37 Quiz Question - SQL Select - Employees Joined in Oct

38 Quiz Question - SQL Select - Monthwise employees induction

39 Quiz Question - SQL Select - Department City Wise Employees

40 Quiz Question - SQL Select - Employees Department for a salary strata

41 Quiz Question - SQL Select - Similar Employees

42 Quiz Question - SQL Select - Report

43 ALTER Command

44 Quiz Question - SQL Alter

45 Indexes

46 Quiz Question - SQL Create Index

47 Temporary Tables

48 Transactions in MySQL

49 Quiz Question - Facts Check

50 Database Export

51 Database Import

52 Quiz Question - Facts Check

53 Quiz Question - Facts Check

54 Quiz Question - Facts Check

55 Quiz Question - Facts Check

56 Quiz Question - Facts Check

57 ACID Properties in DBMS

58 Transaction Isolation Levels

59 Quiz Question - Facts Check

60 Quiz Question - Facts Check

61 Installing MySQL on your machine

62 Managing MySQL Database

63 SQL - Database Engine can be changed permanently ...

64 Default transaction isolation level

65 OS process of MySQL

66 SQL Tutorial - A user can shutdown the MySQL Server

67 Creating and dropping database

68 Getting database information