
Database & Advanced SQL
Course Outlines:
Database Introduction
- Database
- Relational Database
- Database Management Systems (DBMSs)
- Relational Database Management Systems (RDBMSs)
- Database Keys
- Table Relationships
- Integrity Constraints
- Database System
- Lifecycle of Database Design
Relational Database Important Concepts
- SQL
- Data Type
- Index
- View
- Stored Procedure
- Trigger
Advanced SQL
- Select Statement
- SQL Functions
- Aggregating Data Using Group Functions
- SQL Joins
- SQL Subquery
- CTE (Common Table Expression)
- Create Objects in MS SQL SEVER
- Change Table Contents
Business Intelligence Technology
- Business Intelligence (BI)
- Data Warehouse
- OLTP vs. OLAP
- Data Warehouse Architecture
- ETL (Extract, Transform and Load)
- CDC & SCD