Title here
Summary here
PostgreSQL
Airflow: Syllabus
Learn how to design, deploy, and optimize data pipelines with Apache Airflow, covering 90% hands-on implementation using real-world datasets.
September 7, 2023 in Data Engineering, Workflow Automation3 minutes
DBT: Syllabus
Learn how to implement scalable data transformation pipelines with DBT, ensuring data quality, consistency, and efficiency in modern data workflows.
September 7, 2023 in Data Engineering, Data Quality3 minutes
Grafana: Syllabus
Learn how to create powerful, real-time monitoring solutions and data-driven dashboards using Grafana, with practical implementation for PostgreSQL, Trino, and other data sources.
September 7, 2023 in Monitoring, Data Analysis3 minutes
GX: Syllabus
Learn how to implement scalable data validation pipelines with Great Expectations, ensuring data quality, consistency, and compliance in production workflows.
September 7, 2023 in Data Quality, Testing3 minutes
PostgreSQL: Syllabus
Learn how to efficiently manage and optimize PostgreSQL databases, covering 90% of essential skills for real-world applications.
September 7, 2023 in Database Management, PostgreSQL3 minutes
PSQL: Syllabus
Learn how to efficiently interact with PostgreSQL using psql, focusing on database administration, SQL scripting, and performance optimization.
September 7, 2023 in Database Administration, PostgreSQL3 minutes
PostgeSQL: Introduction
Learn about PostgreSQL, its architecture, installation, and how to execute basic SQL commands with hands-on exercises.
September 7, 2023 in Databases4 minutes
PostgreSQL: Data Types and Table Management
Master PostgreSQL data types, constraints, and table management like a pro. Includes hands-on exercises to solidify your skills.
March 21, 2024 in Database3 minutes
PostgreSQL: Querying and Data Manipulation
Learn how to write powerful queries, optimize data retrieval, and manipulate data efficiently in PostgreSQL. Includes hands-on exercises.
February 21, 2025 in Database3 minutes
PostgreSQL: Transactions and Concurrency Control
Master the art of managing transactions and handling concurrency in PostgreSQL. Learn about ACID properties, transaction management, isolation levels, deadlocks, and more.
September 7, 2023 in Database Management4 minutes