Nov 28th 2016

Database Management Essentials (Coursera)

Taught by:

Database Management Essentials provides the foundation you need for a career in database development, data warehousing, or business intelligence, as well as for the entire Data Warehousing for Business Intelligence specialization. In this course, you will create relational databases, write SQL statements to extract information to satisfy business reporting requests, create entity relationship diagrams (ERDs) to design databases, and analyze table designs for excessive redundancy. As you develop these skills, you will use either Oracle or MySQL to execute SQL statements and a database diagramming tool such as the ER Assistant to create ERDs. We’ve designed this course to ensure a common foundation for specialization learners. Everyone taking the course can jump right in with writing SQL statements in Oracle or MySQL.


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.