课程概况
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 or Visual Paradigm 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
Specialization Introduction
Course Introduction
Course objectives
Topics and assignments
Database management software requirements
Database characteristics
Organizational roles
DBMS overview and database definition feature
Non-procedural access
Transaction processing overview
Data warehouse processing overview
DBMS technology evolution
Review
Quiz: Module02 Quiz
Week 2 Relational Data Model and the CREATE TABLE Statement
Basics of relational databases
Integrity rules
Basic SQL CREATE TABLE statement
Integrity constraint syntax
Assignment 1 Notes
Practice Problems and Assignment
Assignment: Module 3 Assignment
Week 3 Basic Query Formulation with SQL
Extended Query Formulation with SQL
SQL Overview
SELECT statement introduction
Join Operator
Using join operations in SQL SELECT statements
GROUP BY clause
Practice Problems and Assignment
Query formulation guidelines
Multiple table problems
Problems involving join and grouping operations
SQL set operators
SQL modification statements
Practice Problems and Assignment
Assignment: Module 4 Assignment
Assignment: Module 5 Assignment
Week 4 Notation for Entity Relationship Diagrams
ERD Rules and Problem Solving
Database development goals
Basic ERD notation
Relationship variations I
Relationship variations II
Practice Problems and Assignment
Basic diagram rules
Extended diagram rules
ERD problems I
ERD problems II
ER Assistant Demonstration
Practice Problems and Assignment
Assignment: Module 6 Assignment
Assignment: Module 7 Assignment
Week 5 Developing Business Data Models
Data Modeling Problems and Completion of an ERD
Conceptual data modeling goals and challenges
Analyzing narrative problems
Design transformations I
Design transformations II
Practice Problems and Assignment
Data modeling problems I
Data modeling problems II
Finalizing an ERD
Practice Problems and Assignment
Assignment: Module 8 Assignment
Assignment: Module 9 Assignment
Week 6 Schema Conversion
Goals and steps of logical database design
Conversion rules
Conversion problems
Practice Problems and Assignment
Assignment: Module 10 Assignment
Week 7 Normalization Concepts and Practice
Modification anomalies
Functional dependencies
Normal forms
Practical concerns
Normalization problems
Course Conclusion
Practice Problems and Assignment
Assignment: Module 11 Assignment
