Data Engineering Tutorials | Read, Learn, & Grow Your Skills

Discover how WHERE filters row-level data in SQL queries, while HAVING filters grouped data after aggregation, and master their distinct uses in SQL querying.

Understand the SQL order of execution and how its different from the order of writing. Write accurate and optimized queries for improved performance and avoid common mistakes in query design.

Learn how to install Jenkins on Windows, set up and run Jenkins agents and pipelines, and build MLOps projects with Jenkins pipelines from model training to model serving.

Python dlt is a great choice for data engineers who want to move data fast and confidently. It integrates with almost any source and destination and lets you write your ELT/ETL pipelines quickly. This tutorial shows you how to control every step of the pipeline and work with local files, cloud, databases, and REST APIs.

A transitive dependency occurs when one attribute in a database indirectly relies on another through a third attribute, causing redundancy. Keep reading to learn how to identify and eliminate transitive dependencies in database design .

Discover GitHub Codespaces, the development environment that allows you to write, run, and deploy your code anywhere.

This tutorial teaches you how to create, manage, and use Amazon SQS queues for building scalable distributed applications on AWS, with practical examples using both the console and the CLI.

DuckDB is a powerful analytical engine that lives on your laptop. You can use it to speed up data reading and processing and reduce your pipeline runtimes from minutes to seconds. Follow this hands-on guide to learn how.

Learn how UPDATE with JOIN in SQL simplifies cross-table updates in SQL Server. Understand how INNER JOIN and LEFT JOIN differ for specific use cases, and explore alternatives using subqueries or the MERGE statement.

Learn three methods to migrate data from Amazon DynamoDB to Redshift, with step-by-step instructions, the pros and cons of each method, and best practices for data integrity and performance optimization.

Learn how to set up AWS Glue, create a crawler, catalog your data, and run jobs to convert CSV files into Parquet format, optimizing your ETL processes.

A database schema provides a comprehensive blueprint for the organization of data, detailing how tables, fields, and relationships are structured. Read to learn about the schema types, such as star, snowflake, and relational schemas.