About this Course
In this course, you’ll learn how to create, load and transform data in relational and non-relational databases. You’ll examine the similarities and differences between several relational and non-relational databases by developing on-site and cloud-hosted Microsoft SQL Server, Analysis Server, MongoDB and Databricks databases.
WHAT YOU’LL LEARN
- How to create and use on-premise SQL Server, Analysis Server (Tabular) and MongoDB databases
- How to create and use cloud SQL Server, MongoDB, and Databricks databases
- How to design dimensional data models (relational databases)
- Non-relational data modeling (tabular, document and data lake databases)
- How to perform simple data extractions, transformations and loading processes