Database Management System & SQL

Module - 1: Databases

1. Evolution of DBMS

2. Types of Keys

3. ER Diagram

4. Database Normalization, Functional Dependency & Decomposition

5. First and Second Normal Forms

6. Third Normal Form

7. Indexing in Database

8. B and B+ Tree

9. ACID Properties

10. Recoverable Cascadeless and Strict Schedule

11. View and Conflict Serializability

12. Two Phase Locking

13. Timestamp Based Protocol

Module - 2: Introduction to SQL

1. Introduction to MySQL and NoSQL

2. DDL v/s DML v/s DCL v/s TCL

3. Datatypes in SQL

Module - 3: Basics of SQL

1. Basic SQL statements (SELECT, DELETE and UPDATE)

2. How to convert data into tables

3. COMMIT and ROLLBACK statements

Module - 4 Filtering Data using SQL

1. Filter Data using the WHERE and ORDER BY Clause

2. Using of Filtering Operators – IN, NOT IN, IS NULL, BETWEEN

3. Regular Expression for Filtering

Module - 5 Functions in Database

1. Basics of Function

2. Boolean Expressions and Concatenation

3. String Function

4. Grouping Function

Module - 6 Displaying Data from Multiple tables

1. Introduction to Joins and its types

2. Using UNION, UNION ALL and EXPERT Clause

3. Views, Sequences and Indexes in SQL

Module - 7 Grouping Data and Computing Aggregates

1. Introduction to Grouping

2. Using GROUP BY & HAVING

Module - 8 Subqueries and Nested queries in SQL

1. Single-Row, Multiple-Row Subqueries

2. Subqueries with ANY and ALL Operators

3. Conditional Expressions using CASE Clause

4. Correlated Subqueries