PostgreSQL

2014★★★★★(4.8)• 31 students enrolled• 15k views

Instructor

Professor Mohammed Safder Ali

Course language

English

COURSE DETAILS

Dive deep into PostgreSQL Database — one of the world's most powerful enterprise-grade RDBMS. Covers installation, PL/SQL, performance tuning, security, and real-world DBA skills.

WHAT YOU'LL LEARN

✓PostgreSQL Database Architecture and core concepts.

✓PL/SQL programming fundamentals.

✓DDL and DML operations in PostgreSQL.

✓Advanced querying with PostgreSQL-specific functions.

✓Database security, users, and privileges.

REQUIREMENTS

Skills in understanding elementary-level English.

COURSE CONTENT

∨Chapter 1 - Course Introduction

1 lecture

Live SQL Training

∨Chapter 2 - Introduction to Software Applications

9 lectures

Application Software Software Development Life Cycle Database Components Database Platforms GUI tools for SQL Development Tansy Cloud Business Application Assignment: Analyzing Salesforce Business Application Assignment: Analyzing Instagram Social Application Assignment: Analyzing Snapchat Mobile Application

∨Chapter 3 - Database Tables, Columns and Rows

5 lectures

Database Table ROWs and COLUMNs SQL Assignment: List Tables and Columns - Banking Management System Assignment: List Tables and Columns - Hospital Management System

∨Chapter 4 - Setup Sample Database

2 lectures

PostgreSQL Query Editor Database Hosting

∨Chapter 5 - DDL (Data Definition Language)

12 lectures

CREATE TABLE ALTER TABLE DROP TABLE Data Types JSON Data Type NUll vs NOT NULL CHECK Constraint DEFAULT Constraint UNIQUE Constraint AUTO INCREMENT DDL ASSIGNMENT1 - Banking Application System DDL ASSIGNMENT2 - Hospital Management System

∨Chapter 6 - DML (Data Manipulation Language)

8 lectures

INSERT SELECT INTO UPDATE UPSERT DELETE TRUNCATE DML ASSIGNMENT1 - Banking Application System DML ASSIGNMENT2 - Hospital Management System

∨Chapter 7 - DQL (Data Query Language)

44 lectures

SELECT * WHERE Clause LIMIT OFFSET DISTINCT ORDER BY BETWEEN Operator CONCAT IN Operator NOT IN Operator IS NULL Operator IS NOT NULL Operator 'AND' and 'OR' Operators '>' and '<' Operator (greater than, less than) '< >' or '!=' Operator (not equal) '=' (equal to) Operator LIKE Operator NOT LIKE Operator EXISTS, ANY and ALL Clause SQL Aliases GROUP BY HAVING Clause COUNT, SUM, AVG, MIN, MAX Functions CASE statement INNER JOIN LEFT JOIN RIGHT JOIN UNION and UNION ALL PIVOT Sub Queries GROUP RANK JSON SELECT Arithmetic Operators Comparison Operators Logical Operators STRING functions DATE functions NUMERIC functions SQL Execution Order CAST COALESCE DQL ASSIGNMENT1 - Banking Management System DQL ASSIGNMENT2 - Hospital Management System DQL ASSIGNMENT3 - SQL Logic for Dashboard Reporting in a Banking Management System DQL Assignment 4 - PostgreSQL Logic for Dashboard Reporting in a Hospital Management System

∨Chapter 8 - RDBMS Concepts

15 lectures

What is RDBMS Primary Key Foreign Key Cardinality Normalization Second Normal Form Third Normal Form Business key, Natural key and Candidate Key Surrogate Key Database Index Index Types Structured VS Unstructured ERD (Data Model) SQL Data Model Assignment - Banking Application System SQL ERD Data Model Assignment - Hospital Management System

∨Chapter 9 - Advanced Topics

6 lectures

Database View PostgreSQL Stored Procedure DB Function DB Trigger Common Table Extensions (CTE) SQL Window Functions

∨Chapter 10 - Projects

2 lectures

Final Capstone Project 1: Banking System in PostgreSQL Final Capstone Project 2: Hospital Management System in PostgreSQL

∨Chapter 11 - SQL Certifications

1 lecture

SQL certifications

STUDENT REVIEWS

No Review Found