Database Management Essentials course from Coursera by University of Colorado
This repository contains all coursework from the Database Management Essentials course of the Data Warehousing for Business Intelligence specialization offered by The University of Colorado on coursera.org.
Motivation for taking this course is to gain more experience using SQL and working with DBMSs in order to develop skills used in the Data Science and ML/AI Engineering Industry.
All SQL code is written in MySQL, using goormIDE.
ica_diagrams contains reference diagrams for the database used in modules 3, 4, and 5. The database is named ica and is short-hand for the Intercollegiate Athletic Database. It contains information necessary to schedule and offer events through the Intercollegiate Athletic Department.
Assignments of Coursera Course "Database Management Essentials".
Week 1: Introduction to Databases and DBMSs; Nothing to commit
Week 2: Relational Data Model and the CREATE TABLE Statement;
Week 3: Basic Query Formulation with SQL and Extended Query Formulation with SQL;
Week 4: Notation for Entity Relationship Diagrams and ERD Rules and Problem Solving;
Week 5: Developing Business Data Models and Data Modeling Problems and Completion of an ERD;
Week 6: Schema Conversion;
Week 7: Normalization Concepts and Practice.