SkillManthan Logo - Best IT Training Institute in Lucknow
Loading your future skills...
+91-6392-361-443,+91-9120-341-047
theskillmanthan@gmail.com
Our Placements Scholarship Test Training Brochure Company Profile
Register Now Scholarship Test
Best Summer & Industrial Training in Lucknow | Affordable IT Internships
Verify Certificate Register Now
Download Courses - SkillManthan Technologies Pvt Ltd
PostgreSQL Course Banner

PostgreSQL / Advanced Database Management

Learn PostgreSQL from basics to advanced — build powerful, scalable, and high-performance database systems used in enterprise and modern applications.

Course Description

This course covers PostgreSQL in-depth including advanced SQL queries, indexing, performance tuning, JSON data handling, and real-world database design used in production-grade systems.

Detailed Course Syllabus

L.N. Contents Hours
1
  1. Introduction to PostgreSQL
  2. DBMS vs RDBMS
  3. Installing PostgreSQL
  4. pgAdmin Overview
 2
2
  1. SQL Basics
    • Data Types
    • CREATE, ALTER, DROP
    • Primary & Foreign Keys
 2
3
  1. Data Manipulation
    • INSERT
    • UPDATE
    • DELETE
    • SELECT Queries
 2
4
  1. Filtering & Sorting
    • WHERE Clause
    • ORDER BY
    • LIMIT / OFFSET
 2
5
  1. Joins
    • INNER JOIN
    • LEFT JOIN
    • RIGHT JOIN
    • FULL JOIN
 2
6
  1. Aggregate Functions
    • COUNT, SUM, AVG
    • GROUP BY
    • HAVING
 2
7
  1. Indexes & Performance
    • B-Tree Index
    • GIN / GiST Index
    • Query Optimization
 2
8
  1. Advanced Features
    • JSON & JSONB
    • Window Functions
    • CTE (WITH Clause)
 2
9
  1. Functions & Triggers
    • User Defined Functions
    • Triggers
    • PL/pgSQL Basics
 2
10
  1. Backup & Restore
    • pg_dump
    • pg_restore
    • Cloud Backup
 2
11
  1. Security & Roles
  2. Final Project
  3. Interview Preparation
 2