1 Introduction to DataBases

2 Introduction to SQL

3 Getting started with MySQL

4 Connecting to MySQL through Jupyter Notebook

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 Inner SELECT

28 Inline SELECT

29 Aggregate Functions

30 Grouping on Aggregate Functions

31 HAVING clause

32 Constraint Keys on Tables - Primary and Unique Key

33 Quiz Question - SQL Create simple table

34 Quiz Question - SQL Create table

35 Constraint Keys on Tables - Foreign Key

36 Prepare data for Questions

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

38 Quiz Question - SQL Select - Employees Joined in Oct

39 Quiz Question - SQL Select - Monthwise employees induction

40 Quiz Question - SQL Select - Department City Wise Employees

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

42 Quiz Question - SQL Select - Similar Employees

43 Quiz Question - SQL Select - Report

44 ALTER Command

45 Quiz Question - SQL Alter

46 Indexes

47 Quiz Question - SQL Create Index

48 Transactions in MySQL

49 Quiz Question - Facts Check

50 Temporary Tables

51 ACID Properties in DBMS

52 Transaction Isolation Levels

53 Quiz Question - Facts Check

54 Quiz Question - Facts Check

55 Installing MySQL on your machine

56 Managing MySQL Database

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

58 Default transaction isolation level

59 OS process of MySQL

60 SQL Tutorial - A user can shutdown the MySQL Server

61 Getting database information