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