RDBMS – SQL Course – Step by Step Guide to learn SQL

Course Curriculum

Chapter 1: Welcome to the Course

Lecture 1: Introduction to RDBMS

Chapter 2: Installation

Lecture 1: Virtual Box Installation

Lecture 2: Ubuntu Installation

Lecture 3: MySQL Installation

Chapter 3: Introduction

Lecture 1: Data vs Information

Lecture 2: Why do we need Data?

Lecture 3: Different ways of Storing Data

Lecture 4: Systems to store Data

Chapter 4: RDBMS

Lecture 1: History of RDBMS

Lecture 2: What is RDBMS?

Lecture 3: What is Database?

Lecture 4: What is Database Components?

Lecture 5: Database Components – Hands – On

Lecture 6: What is Datatypes?

Lecture 7: Datatypes – Hands – On

Lecture 8: What is Database Object?

Lecture 9: Database Object – Index

Lecture 10: Database Object – Sequence

Lecture 11: Database Object – View

Lecture 12: Database Object – Views Hands On

Lecture 13: Database Design

Lecture 14: ER Diagram Part1

Lecture 15: ER Diagram with Component Part 2

Lecture 16: ER Diagram Part 3

Lecture 17: Keys Introduction

Lecture 18: SuperKey

Lecture 19: Candidate Key

Lecture 20: PrimaryKey

Lecture 21: Unique-Surrogate-Alternate-Composite Keys

Lecture 22: Foreign Key

Lecture 23: Data Integrity Introductions

Lecture 24: Domain Integrity Check Constraints Theory

Lecture 25: Check Constraint Hands-On

Lecture 26: Default Constraint

Lecture 27: Not Null Constraint

Lecture 28: Unique Constraint

Lecture 29: Entity Integrity Constraint

Lecture 30: Entity Integrity Constraint Hands-On

Lecture 31: Referential Integrity

Lecture 32: Referential Integrity Hands-On

Lecture 33: Introduction – Normalization

Lecture 34: Need for Normalization with Example

Lecture 35: Dependencies

Lecture 36: Normalization – First Normal Form

Lecture 37: Second Normal Form

Lecture 38: Third Normal Form

Lecture 39: BCNF Normal Form

Lecture 40: Transactions

Lecture 41: Transactions – ACID Properties

Lecture 42: Atomicity

Lecture 43: Consistency

Lecture 44: Isolation

Lecture 45: Durability

Chapter 5: SQL

Lecture 1: Introduction to SQL

Lecture 2: Types of SQL Commands

Lecture 3: Create and Alter Theory and Hands-On

Lecture 4: Rename Theory and Hands-On

Lecture 5: Drop and Truncate Theory and Hands-On

Lecture 6: Comment Theory and Hands-On

Lecture 7: DML Commands Theory

Lecture 8: DML Commands Hands-On

Lecture 9: Ways of Inserting Data into Tables Theory

Lecture 10: Ways of Inserting Data into Tables Hands-On

Lecture 11: DCL Commands Theory

Lecture 12: DCL Commands Hands-On

Lecture 13: TCL Commands Theory

Lecture 14: TCL Commands Hands-On

Lecture 15: DQL Commands Theory

Lecture 16: DQL Commands Hands-On

Lecture 17: SQL Statements

Lecture 18: Alias Theory and Hands-On

Lecture 19: Distinct Theory and Hands-On

Lecture 20: What are Operators?

Lecture 21: Arithmetic Operators Theory

Lecture 22: Arithmetic Operators Hands-On

Lecture 23: Comparison Operators

Lecture 24: Logical Operators – And & Between

Lecture 25: Logical Operators – In & Not In

Lecture 26: Logical Operators – Like & OR

Lecture 27: Logical Operators – Exists & Not Exists

Lecture 28: Aggregate Functions Theory

Lecture 29: Aggregate Functions Hands-On

Lecture 30: SQL Clauses

Lecture 31: Where Clause Theory

Lecture 32: Where Clause Hands-On

Lecture 33: Order By Clause Introduction

Lecture 34: Order By Clause – Ascending Order Theory and Hands-On

Lecture 35: Order By Clause – Descending Order Theory and Hands-On

Lecture 36: Order By Clause – Ascending & Descending Order Theory and Hands-On

Lecture 37: Order By Clause – Ascending with Null Values Theory and Hands-On

Lecture 38: Order By Clause – Descending with Null Values Theory and Hands-On

Lecture 39: Group By Clause Theory

Lecture 40: Group By Clause Hands-On Part-1

Lecture 41: Group By Clause Hands-On Part-2

Lecture 42: Having Clause Theory