RDBMS
Relational Database Management Systems (RDBMS)
A brief summary of the topics covered in this course is as below. This is 60 hours course, it is suggested to complete this course in 1 month.
An introduction to Database
- Introduction Database
- RDBMS
- SQL Database
- No-SQL Databases
Basics of SQL
- Data Retrieval with SQL
- Compound Functions and Relational Operators
- Pattern Matching with Wildcards
- Basics of Sorting
- Session Summary
- Order by Clause
Advanced SQL
- Aggregate Functions
- Group by Clause
- Having Clause
- Nested Queries
- Inner Join
- Multi Join
- Outer Join
- Summary
Database design
- Defining Data Warehouse
- Structure of Data Warehouse
- OLAP vs. OLTP
- Star Schema
- How to Use a Star Schema – A Demonstration
- Data Warehouse Schema- Industry Example
Updating Table
- Introduction
- Adding and Deleting Columns
- Changing Column Name and Data Type
- Creating Table from existing table
- Changing Constraints (Primary key)
- Changing Constraints (Foreign key)
- String Manipulation
- Date Manipulation
Window Functions
- Introduction
- Introduction to Windowing Functions
- Frames
- Named Windows
- Window Functions’ Restrictions
User Defined Functions and Stored Procedures
- Introduction
- Introduction to User defined Functions
- User defined functions (Application)
- Introduction to Stored Procedures
- Stored Procedures (Application)
Query Optimisation
- Introduction
- Optimisation in Select Clause
- Optimisation in Where Clause
- Optimisation in Group by and Order by
- Optimisation in Joins
- Optimisation in Window Function