数据库管理精要

Part of a 5-course series, the Data Warehousing for Business Intelligence Specialization

科罗拉多大学系统

分享

数据库管理精要
  • 分类: 计算机
  • 平台: Coursera
  • 语言: 英语

About this Course

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.

数据库管理精要 is course 1 of 5 in the Data Warehousing for Business Intelligence Specialization.

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.

授课教师

Michael Mannino
Associate Professor
Business School, University of Colorado Denver

Jahangir Karimi
Professor
Information Systems

Syllabus

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

声明:MOOC中国收录之课程均源自下列机构,版权均归他们所有。本站仅作报道并尊重其著作权益,感谢他们对MOOC事业做出的贡献!(排名不分先后)
  • Coursera
  • edX
  • OpenLearning
  • FutureLearn
  • iversity
  • Udacity
  • NovoEd
  • Canvas
  • Open2Study
  • Google
  • ewant
  • FUN
  • IOC-Athlete-MOOC
  • World-Science-U
  • Codecademy
  • CourseSites
  • opencourseworld
  • ShareCourse
  • gacco
  • MiriadaX
  • JANUX
  • openhpi
  • Stanford-Open-Edx
  • 网易云课堂
  • 中国大学MOOC
  • 学堂在线
  • 顶你学堂
  • 华文慕课
  • 好大学在线CnMooc

Copyright © 2008-2015 MOOC.CN 慕课改变你,你改变世界