Welcome to the Databases with PostgreSQL tutorial series repository!
This repository contains all the resources, scripts, and examples from the tutorial series aimed at helping you master PostgreSQL from foundational database concepts to advanced features.
- Step-by-step SQL scripts for creating, managing, and optimizing databases.
- Comprehensive notes on PostgreSQL features like schemas, data types, indexing, performance optimization, and security.
- Introduction to Databases and Why PostgreSQL Stands Out
- Managing Users in PostgreSQL
- Managing Schemas in PostgreSQL
- PostgreSQL Data Types
- Creating and Managing Tables in PostgreSQL
- Resetting a Sequence in PostgreSQL to Prevent Insert Failures
- SQL Basics with PostgreSQL
- Filtering Data in SQL using WHERE, ORDER BY, and GROUP BY
- Understanding WHERE and HAVING Clauses in SQL
- Aggregate Functions in SQL
- Using CASE Statements in SQL
- INNER JOIN in SQL
- LEFT JOIN in SQL
- RIGHT JOIN in SQL
- FULL JOIN in SQL
- Understanding Stored Procedures in PostgreSQL
- Understanding Functions in PostgreSQL
- Understanding Cursors in PostgreSQL
- Working with Views in PostgreSQL
- Understanding Materialized Views in PostgreSQL
- PostgreSQL Performance Optimization - Cleaning Dead Tuples & Reindexing
- Window Functions in SQL
- Subqueries in SQL
- What is an Index in a Database?
- Why PostgreSQL Uses Sequential Scan Even If Index Exists
- Why PostgreSQL Uses Sequential Scan Even If Index Exists
- PostgreSQL Index Scan vs Index-Only Scan
- Bitmap Index Scan in PostgreSQL
- Linux tutorial series for software developers
- Java Tutorial Series
- Object-Oriented Programming (OOP) in Java
- Real-World Projects with OOP Concepts
- Dev Portal Subscribe for the latest Database tutorials.
- LinkedIn Profile Connect with me for more programming insights.
Happy coding! If you found these resources helpful, please give this repo a star ⭐ and share it with others who are learning database.