In this project you will learn how the relational model works and how to retrieve data based on basic SQL constructs.
In this project you will learn how to to retrieve necessary data using set operations and simple JOINs.
In this project you will learn how to retrieve necessary data using various types of JOINs.
In this project you will learn how to modify data using the Data Manipulation Language (DML).
In this project you will learn how to utilize virtual views and physical snapshots of data.
In this project, you will practice implementing a simple SQL-based solution to the Traveling Salesman Problem.
This project will cover the process of creating database indexes, including when to implement them.
In this project you will learn how to integrate a new business feature into the data model.
In this project you will learn how to use specific OLAP constructs to extract insights from data.
In this project you will dive into transaction isolation levels and their significance in database management.
In this project you will learn how to create and utilize functions and stored procedures in databases.
In this project you will learn what data warehouses (DWH) are and gain hands-on experience building an extract, transform, load (ETL) pipeline.