Database Design

Welcome to the course on Database Design and Operational Business Intelligence. This course is strategically crafted to empower you with the skills needed to design a robust database and efficiently manage intricate datasets. Throughout this course, you will acquire the expertise to develop well-formatted databases that are seamlessly designed [...]

This course provides you with the opportunity to learn about relational database design. You will be provided an in-depth understanding of the design principles and methodologies involved in creating well-structured, normalized, and efficient relational databases to manage data for small, medium, and large-scale [...]

Have you ever wanted to build a database but don't know where to start? This course will provide you a step-by-step guidance. We are going to start from a raw idea to an implementable relational database. Getting on the path, practicing the real-life mini cases, you will be confident [...]

Are you ready to dive into the world of data engineering? You’ll need a solid understanding of how data is stored, processed, and accessed. You’ll need to identify the different types of database that are appropriate for the kind of data you are working with and what processing the data requires.

In this course you will learn more about the historical design of databases and the use of SQL in the PostgreSQL environment. Using SQL techniques and common commands (INSERT INTO, WHERE, ORDER BY, ON DELETE CASCADE, etc) will enable you to create tables, column types and define the schema [...]

Welcome to the course on Power BI Integration with AWS and Snowflake. Design and build data models on Snowflake using Snowflake Architecture's unique schema . Manage the hosting of datasets on AWS and connect them with Power BI to stream data and use it to visualize data.

Welcome to the course on Data Connection and Functionalities in Power BI. This course is strategically crafted to empower you with the skills needed to construct a robust database and efficiently manage intricate datasets using MS SQL Server. Throughout this course, you will acquire the expertise to develop well-formatted [...]