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