What will i learn?
- Ability to install, configure, and manage PostgreSQL databases
- Proficiency in writing advanced SQL queries using CTEs and Window Functions
- Hands-on experience with JSON/NoSQL features and data relationships
- Skills to optimize performance, manage users, and perform backups/migrations
- Confidence to integrate PostgreSQL with Python or Java in real-world applications
Curriculum for this course
60 Lessons
00:00:00 Hours
Duration
4 Lessons
00:00:00 Hours
- Course Duration: 6 Months 00:00:00
- Mode: Available in Offline & Online 00:00:00
- Level: Beginner to Intermediate 00:00:00
- Get 40% OFF by enrolling in the online training mode! 00:00:00
Module 1: Introduction to PostgreSQL & Setup
5 Lessons
00:00:00 Hours
- Overview of PostgreSQL and its features 00:00:00
- Understanding open-source relational databases 00:00:00
- Installing PostgreSQL on Windows/Linux 00:00:00
- Introduction to pgAdmin & command-line interface 00:00:00
- Creating your first database 00:00:00
Module 2: Database Design & Data Types
5 Lessons
00:00:00 Hours
- Understanding tables, rows, and columns 00:00:00
- PostgreSQL data types: TEXT, INTEGER, BOOLEAN, DATE, etc. 00:00:00
- Creating tables with proper constraints (PRIMARY KEY, UNIQUE, NOT NULL) 00:00:00
- Schema creation and organization 00:00:00
- ER Diagrams and basic data modeling 00:00:00
Module 3: SQL Basics
4 Lessons
00:00:00 Hours
- SELECT, INSERT, UPDATE, DELETE commands 00:00:00
- Filtering data using WHERE, ORDER BY, LIMIT 00:00:00
- Aliases, expressions, and built-in functions 00:00:00
- Sorting, aggregating, and grouping data 00:00:00
Module 4: Relationships & Joins
4 Lessons
00:00:00 Hours
- One-to-One, One-to-Many, Many-to-Many relationships 00:00:00
- Foreign Keys and Referential Integrity 00:00:00
- INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN 00:00:00
- Using JOINs to combine and retrieve data from multiple tables 00:00:00
Module 5: Advanced SQL Techniques
5 Lessons
00:00:00 Hours
- Subqueries and nested queries 00:00:00
- Common Table Expressions (CTE) 00:00:00
- Window Functions: RANK(), DENSE_RANK(), ROW_NUMBER(), etc. 00:00:00
- Working with views and materialized views 00:00:00
- Using CASE and COALESCE statements 00:00:00
Module 6: JSON and NoSQL Features in PostgreSQL
4 Lessons
00:00:00 Hours
- Working with JSON and JSONB data types 00:00:00
- Inserting and querying JSON data 00:00:00
- JSON functions and operators 00:00:00
- Using PostgreSQL as a hybrid relational–NoSQL database 00:00:00
Module 7: User Management & Security
4 Lessons
00:00:00 Hours
- Creating users and assigning roles 00:00:00
- Granting and revoking privileges 00:00:00
- Schema-level and table-level permissions 00:00:00
- Security best practices 00:00:00
Module 8: Performance Tuning & Optimization
5 Lessons
00:00:00 Hours
- Indexing: B-tree, Hash, GIN, and GiST 00:00:00
- Query planning and execution 00:00:00
- Using EXPLAIN and ANALYZE 00:00:00
- VACUUM, ANALYZE, and AUTOVACUUM 00:00:00
- Identifying and resolving slow queries 00:00:00
Module 9: Backup, Restore & Migration
5 Lessons
00:00:00 Hours
- Logical backups with pg_dump and pg_restore 00:00:00
- Full database backup and restore 00:00:00
- Using psql for database migration 00:00:00
- Basic replication and WAL concepts 00:00:00
- Migration from other databases to PostgreSQL 00:00:00
Module 10: Capstone Project – Real-Time Database Application
15 Lessons
00:00:00 Hours
- ???? Project Title: Student Management System using PostgreSQL 00:00:00
- Project Objectives: 00:00:00
- Design and create a relational database schema for managing students, courses, enrollment, and results 00:00:00
- Apply constraints and relationships effectively 00:00:00
- Write SQL queries to generate reports, summaries, and analytics 00:00:00
- Use JSON data for storing flexible metadata (e.g., student preferences) 00:00:00
- Implement user roles with specific permissions 00:00:00
- Perform backup and simulate a restore 00:00:00
- Optimize queries using EXPLAIN and indexes 00:00:00
- Deliverables: 00:00:00
- ER Diagram 00:00:00
- SQL scripts (DDL + DML) 00:00:00
- JSON integration script 00:00:00
- Backup and restore guide 00:00:00
- Project documentation 00:00:00
Requirements
- Laptop or PC with internet access for practice and assignments
- Basic knowledge of computers and internet usage
- Familiarity with basic SQL concepts (optional but helpful)
- 12th pass or graduate in any stream (IT background preferred)
+ View more
Description
PostgreSQL Database Training by Udeck Services is designed to equip learners with the skills to build, manage, and optimize powerful database systems. Over the course of 1.5 months, this hands-on program covers everything from PostgreSQL setup and configuration to advanced SQL techniques like Common Table Expressions (CTE) and Window Functions.
You'll explore essential topics including data types, schema design, relational modeling, user permissions, and JSON/NoSQL integration. The course also introduces performance tuning, backup strategies, and practical integration with Python and Java, making it ideal for backend developers and data professionals.
Whether you're a student or a working professional, this training empowers you to create scalable, production-grade database systems. A certificate is provided upon successful completion.
+ View more
Other related courses
About the instructor
- 0 Reviews
- 3 Students
- 36 Courses
Student feedback
Reviews
Write a public review