Database Engineer/DBA – (PostgreSQL, IBM-DB2, MariaDB,NoSQL)

Course Curriculum

Chapter 1: PostgreSQL Setup

Lecture 1: Introduction

Lecture 2: What is PostgreSQL

Lecture 3: Minimum Installation Requirements

Lecture 4: Installing PostgreSQL on Windows

Lecture 5: Installing PostgreSQL on MacOS

Lecture 6: Installing PgAdmin Tool on MacOS

Lecture 7: Installing PostgreSQL on Linux

Lecture 8: Installing PgAdmin Tool on Linux

Lecture 9: Connecting to PostgreSQL Database Server

Lecture 10: Load Sample Database

Lecture 11: Loading Sample Database -Option 2

Lecture 12: Database Concepts

Lecture 13: Data Types

Chapter 2: PostgreSQL Database Objects

Lecture 1: Server Service

Lecture 2: Database

Lecture 3: Table

Lecture 4: Schema

Lecture 5: Tablespace

Lecture 6: Views

Lecture 7: Functions

Lecture 8: Cast and Operators

Lecture 9: Sequences

Lecture 10: Extensions

Chapter 3: PostgreSQL CRUD Operations

Lecture 1: What is CRUD

Lecture 2: What is SQL

Lecture 3: Create Database using pgadmin

Lecture 4: Create Table using pgadmin

Lecture 5: Create Table using SQL Statement

Lecture 6: Retrieve data with SELECT statement

Lecture 7: Using Subqueries

Lecture 8: Modify data using UPDATE Statement

Lecture 9: Remove data using DELETE Statement

Lecture 10: Add data using INSERT INTO Statement

Lecture 11: PostgreSQL Unique Constraint

Lecture 12: Filtering data with WHERE clause

Lecture 13: Retrieve all data from a table

Lecture 14: Retrieve data from a specific column

Lecture 15: Remove duplicate records

Lecture 16: Sorting data

Lecture 17: Grouping Data using GROUP BY Clause

Lecture 18: Using HAVING Clause

Lecture 19: Truncating Tables

Lecture 20: Stored Procedures

Chapter 4: PostgreSQL Operators

Lecture 1: Comparison Operators

Lecture 2: BETWEEN Operator

Lecture 3: NOT BETWEEN Operator

Lecture 4: LIKE OPERATOR

Lecture 5: NOT Operator

Lecture 6: OR Operator

Lecture 7: AND Operator

Lecture 8: Combining AND | OR Operator

Lecture 9: LIMIT Operator

Lecture 10: IN Operator

Lecture 11: UNION Operator

Lecture 12: UNION ALL Operator

Lecture 13: INTERSECT Operator

Lecture 14: EXCEPT Operator

Chapter 5: PostgreSQL Database Table Join

Lecture 1: Introduction to Table Joins

Lecture 2: INNER JOIN

Lecture 3: LEFT Join

Lecture 4: FULL OUTER Join

Lecture 5: CROSS Join

Lecture 6: NATURAL Join

Chapter 6: PostgreSQL Aggregate Functions

Lecture 1: Introduction to Aggregate Functions

Lecture 2: AVG Aggregate function

Lecture 3: COUNT Aggregate function

Lecture 4: MAX Aggregate function

Lecture 5: MIN Aggregate function

Chapter 7: PostgreSQL Analytic Functions

Lecture 1: SUM Aggregate function

Lecture 2: Introduction to Analytic Functions

Lecture 3: Creating sample tables

Lecture 4: Using AVG as window function

Lecture 5: ROW Number Functions

Lecture 6: RANK Functions

Lecture 7: DENSE RANK Functions

Lecture 8: First Value Function

Lecture 9: LAST Function

Lecture 10: LAG Function

Lecture 11: LEAD Function

Chapter 8: PostgreSQL Views

Lecture 1: Introduction to Views

Lecture 2: Benefits of views

Lecture 3: Creating views

Lecture 4: Modifying and removing views

Lecture 5: Updatable Views

Lecture 6: Creating Updatable Views

Lecture 7: Materialized Views

Lecture 8: Creating Materialized Views

Chapter 9: PostgreSQL Triggers

Lecture 1: Introduction to Triggers

Lecture 2: Creating your first trigger-part 1

Lecture 3: Creating your first trigger-part 2

Lecture 4: Creating your first trigger-part 3