/CourseBundles(60489)/4292485-Thinknyx_PostgreSQL.png)
PostgreSQL for the Absolute Beginners - Hands-On
Master SQL Basics Using PostgreSQL – Hands-On Learning for Absolute Beginners
$10.00 $25.00 60% OFF
Course Overview
Unlock the power of databases with our hands-on course in PostgreSQL! Whether you’re new to programming or looking to enhance your data skills, this course will guide you through everything you need - from installing PostgreSQL on Windows and Linux, to mastering essential data operations, advanced queries, and performance tuning. You’ll learn how to create and manage tables, use powerful SQL functions and operators, optimize with indexing, work with complex data types like JSON and arrays, and safeguard your data with transactions and backups. Finish off with a guided capstone project where you connect PostgreSQL with Python for real-world experience. No prior database experience required.
What is in this course:
This course offers a focused, in-depth study of SQL and PostgreSQL, covering installation and configuration on Windows and Linux, schema design, and advanced data manipulation. Participants will master CRUD operations, complex queries using DISTINCT, LIMIT, GROUP BY, JOINs, and subqueries, as well as indexing, transaction management, concurrency control, and handling JSON and array data types. The course also includes database backup and restoration techniques. A capstone project integrating PostgreSQL with Python reinforces practical application and enterprise-level database skills.
Course Structure:
-
Lectures
-
Live Demonstrations
-
Assessments
Course Contents:
-
Understanding Database
-
Postgres Architecture
-
Installing Postgres
-
Working with Database and Tables
-
Datatypes in Postgres
-
DDL Commands
-
CURD Operations
-
Advance Querying Techniques (DISTINCT, LIMIT)
-
Grouping Data
-
Joins and Subqueries
-
Comparison, Logical and Arithmetic Operators
-
Functions in Postgres
-
Sequence and Views in Postgres
-
Functions and Triggers
-
Indexing and Performance Optimization
-
Working with JSONJ and Arrays
-
Transactions and Concurrency
-
Database Backup and Restore
-
Capstone Project
This course is designed with a strong focus on practical learning. Learners are encouraged to follow along and build their own chatbot projects as they progress through the course.
Course Curriculum
PostgreSQL for the Absolute Beginners - Hands-On
1 Exercises • 93 Learning Materials
Course Introduction
Introduction
GitHub Repository Link
Course Material - PostgreSQL for the Absolute Beginners - Hands-On
Introduction to SQL & PostgreSQL
Section Introduction
Understanding Databases & Database Systems
Database Models & Relational Concepts
What is SQL?
Importance of SQL for developers
Database Terminologies
Getting Started with PostgreSQL
PostgreSQL vs. Other Databases (MySQL, Oracle, SQL Server)
PostgreSQL Architecture
Summary
Installing PostgreSQL on Windows & Linux
Section Introduction
Using official installers (Windows)
Setting up psql command-line tool(Windows)
Installing via package managers (Linux)
Setting up psql command-line tool (Linux)
Summary
Working with Databases & Tables
Section Introduction
Types of SQL Commands
Creating and connecting to a PostgreSQL database
Data types in PostgreSQL (INTEGER, TEXT, DATE, JSONB, etc.)
What is a schema & why it is needed?
Creating tables with CREATE TABLE command
Create Table using Column Constraints
Understanding SERIAL and identity columns
DDL Commands (DROP, ALTER, RENAME)
Table Constraints in Postgres
Summary
CRUD Operations
Section Introduction
Inserting Data
Retrieving Data( Data Query Language)
Updating Data
Deleting Data
Summary
Advanced Querying Techniques
Section Introduction
DISTINCT for unique values
Aggregate Functions
LIMIT Clause
Grouping Data
Filtering grouped Data
Difference between Where and Having clause
Summary
Joins and Subqueries
Section Introduction
Understanding Relationships in PostgreSQL
Inner Join & Outer Join
Full Join & Self Join
Cross Join
SubQueries
Common Table Expressions (CTEs)
Summary
Operators & Functions
Section Introduction
Comparison, Logical & Arithmetic Operators
String Functions & Operators
LIKE, BETWEEN, IN, NOT IN, EXISTS (Operators)
SQL set Operators
Summary
Advanced SQL Concepts in PostgreSQL
Section Introduction
Sequence
Views
Type Conversion
Stored procedures
Functions & Triggers
Summary
Indexing and Performance Optimization
Section Introduction
Why Indexing Matters
Creating and Using Indexes
Unique and Composite Indexes
Indexing JSONB and Text Columns
Indexing - Best Practices and Pitfalls
Summary
Working with JSON & Arrays
Section Introduction
Storing JSON Data (JSON vs. JSONB)
Querying JSON Data
Working with Arrays in PostgreSQL
Summary
Transactions and Concurrency Control
Section Introduction
Understanding Transactions
Savepoints and Nested Transactions
Concurrency and Isolation Levels
Handling Deadlocks and Locking
Summary
Database Backup & Restore
Section Introduction
Backup Methods in PostgreSQL
Restoring Databases
Summary
Integrating PostgreSQL with Python
Section Introduction
Connecting PostgreSQL with Python
Demonstration on Querying PostgreSQL using Python
Summary
Capstone Project
Test your knowledge - PostgreSQL for the Absolute Beginners - Hands-On
Quiz - PostgreSQL for the Absolute Beginners - Hands-On
Course Conclusion
Course Conclusion
Course Instructors
/4164177-Thinknyx_Technologies.png)
Thinknyx Technologies
31 Courses • 17 Students
Thinknyx® Technologies is a trusted name in the IT industry, backed by a team of seasoned professionals with extensive expertise across a broad spectrum of technologies. Our core competencies span Software Development, IT Infrastructure Management, Cloud Solutions, Automation, Container Management, Web & App Development, Cybersecurity, and Professional Services. As a recognized and reputable brand, Thinknyx® Technologies delivers end-to-end IT consulting services, including specialized training in both Information Technology and essential Soft Skills. We also provide comprehensive Talent Acquisition and Recruitment solutions, supporting organizations of all sizes around the globe.
Partner with Thinknyx® Technologies to empower your workforce, drive innovation, and stay ahead in the digital age.
/4201500-madhuri_pic.jpeg)
Madhuri Jha
1 Courses • 31 Students
Madhuri is a Senior DevOps Specialist and AWS Educator with deep expertise across development, automation, and cloud technologies. She began her career in web development using Java and .NET, later embracing Python as her core programming language. Her journey led her into cloud computing with AWS, containerization using Docker and Kubernetes, infrastructure automation with Ansible, and Linux administration.
Madhuri also brings strong development skills in PHP and the Laravel framework. As an AWS Educator, she’s passionate about sharing practical, hands-on knowledge with learners, helping bridge the gap between development and operations through real-world DevOps practices.
Related Courses
Unlock your potential with professional DevOps and Cloud Courses
Affordable Price
Unlock your potential with affordable upskilling! Our unbeatable course prices are your chance to level up without breaking the bank.
Flexible Access
Acquire flexible access to our resources with recorded lectures, post-module activities, and walk-through labs for comprehensive learning.
Certificate of Completion
Receive a certificate of completion to showcase your new skills. Add it to your resume or LinkedIn profile to stand out.
Hands-On Experience
Get hands-on experience with real-world scenarios and challenges, giving you practical skills for immediate application.
Expert Instructors
Learn from industry experts with years of experience in pentesting, passionate about sharing their knowledge.
Flexible Learning
Whether you're a beginner or experienced professional, our courses are designed to meet you where you are.
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy & Refund Policy