SQL

Intro

Introduction Database

Database Users & Database Advantages

Types of Architecture

ER Diagrams

Relational Database Model

Various Types of Database

Bank ER-diagram

Bank ER-diagram

Er diagram to relational schema

Er diagram to relational schema1

SQL Practice Question

2. SQL Data Definition

3. Basic structure of SQL queries-Constraints

3. Set Operations

3.1 Join

3.2 Views

3.3 Transaction Management in DBMS (2)

3.3 Transaction Management in DBMS

3.3 Transactions_ch17

3.4 SQL Data types and Schemas-extended

3.5 SQL_Authorization

4.1 Functions and Procedures

4.2 SQL Triggers

4.3 Recursive Queries

15. SQL_4_Beginners_AdvancedAggregateFunctions

18. SQL_4_Beginners_NoSQL

19. SQL_4_Beginners_PLSQL

Mid Sem

End Sem