Week 1: Course Introduction; Introduction to Databases and DBMSs
Week 2: Relational Data Model and the CREATE TABLE Statement
Week 3: Basic Query Formulation with SQL; Extended Query Formulation with SQL
Week 4: Notation for Entity Relationship Diagrams; ERD Rules and Problem Solving
Week 5: Developing Business Data Models; Data Modeling Problems and Completion of an ERD
Week 6: Schema Conversion
Week 7: Normalization Concepts and Practice
Database Management Essentials is course 1 of 5 in the Data Warehousing for Business Intelligence Specialization.
Evaluate business needs; design a data warehouse; and integrate, and visualize data using dashboards and visual analytics. This Specialization covers data architecture skills that are increasingly critical across a broad range of technology fields. You’ll learn the basics of structured data modeling, gain practical SQL coding experience, and develop an in-depth understanding of data warehouse design and data manipulation. You’ll have the opportunity to work with large data sets in a data warehouse environment to create dashboards and Visual Analytics. You will use of MicroStrategy, a leading BI tool, OLAP (online analytical processing) and Visual Insights capabilities to create dashboards and Visual Analytics. In the final Capstone Project, you’ll apply your skills to build a small, basic data warehouse, populate it with data, and create dashboards and other visualizations to analyze and communicate the data to a broad audience.