This course teaches how to work with Integration Services packages in the context of a data warehouse development project to perform extract, transform, and load operations.

SQL Server’s data engine traditionally stores relational data but it can also be used to store data in non-relational schemas. You’ll learn about one example -- Entity, Attribute, Value (EAV).

This course details recent additions to the standard SQL language and includes topics such as Analytic Functions and Extensions to GROUP BY, to name a few.

The use of triggers is a fundamental concept in SQL Server as they provide a powerful way to automatically run complex business logic. This course will teach you to use nested triggers and to improve the performance of your SQL Server code.

Prepare confidently for advanced system design interviews by mastering real-world systems in under 5 hours.

Unlock the future of time series analytics with SQL Server. This course will teach you advanced time series forecasting techniques.

Utilizing SQL Server transactions is a fundamental piece of understanding how SQL queries maintain consistency and integrity in a database. This course will build upon your existing skills of interacting with SQL Server transactions.

Master MongoDB aggregation techniques to perform complex queries across documents. Learn how to use aggregation pipelines for data transformation, analysis, and reporting within MongoDB for efficient data retrieval.

Organizations want to develop a data warehouse solution that can meet the needs of the massive amount of data. This course will teach you how to make the most of AWS Redshift for the storage and retrieval of vast amounts of data.

Learn the basics of Apache Airflow for workflow management, focusing on scheduling, monitoring, and orchestrating data pipelines.

An introductory course for getting familiar with Spark and learning the basics of manipulating data using Spark.

This course provides a practical understanding of current enterprise architectural framework. It covers basic concepts found in TOGAF®: Architecture Development Method (ADM), techniques, architecture content, tools, and capabilities.