บทเรียนวิศวกรรมข้อมูล | อ่าน เรียนรู้ และพัฒนาทักษะ

Learn to manage dotfiles for a consistent configuration across systems and for an improved workflow. Ensure compatibility with Unix-based systems.

Learn how third normal form (3NF) can help you organize your databases more efficiently by removing redundancy and minimizing dependency issues. See how decomposing tables can simplify data management.

Learn how to set up PostgreSQL on macOS using Homebrew, a convenient package manager. Follow step-by-step instructions to install, configure, and start PostgreSQL services.

This tutorial walks you through Microsoft Fabric, showing you how to set up, connect data, build pipelines, and collaborate—all in one practical guide!

Learn how to update multiple columns in SQL using a single query for improved efficiency. Explore practical advanced techniques and examples, including single row updates and multiple row updates.

Learn how to use a Python API to connect systems and give your projects real-time data. Discover how to retrieve, send, and process data, and make your applications dynamic and responsive.

Ready to start with dbt and take data modeling to the next level? This hands-on tutorial dives into essential techniques and project patterns to help you build intuitive, high-quality data warehouses with dbt.

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 .