Database Analysis  «Prev  Next»

Lesson 1

Relational Database Analysis

Welcome to Relational Database Design Fundamentals: Data Analysis. This course introduces you to techniques of data analysis involved in designing databases and how to apply them effectively.
This is the second in a two-part series devoted to the fundamentals of database design. This course will enable you to design an efficient database by creating relational constructs, normalizing tables, creating joins and views, optimizing the database's physical design, and avoiding common database design mistakes.
Taken in conjunction with Relational Database Design in this series, this course will prepare you to make solid contributions as a member of a database design team. Along the way, you will work on a course project that will give you a chance to put your new skills to use in the context of actual business scenarios.

Course goals

After completing the course, you will be able to:
  1. Create relational constructs
  2. Normalize tables to first, second, and third normal forms
  3. Create joins and views
  4. Optimize a database's physical design
  5. Identify and avoid common design mistakes

In this course, you will learn and practice database design skills with the aid of several kinds of
  1. SlideShows,
  2. MouseOver applets.
You can measure your progress by completing the quizzes and exercises included throughout the course.
You will also create a course project that involves designing and optimizing a database to track orders that Stories on CD, a fictional company that sells books on CD, places with its distributors. You will complete the project incrementally via a series of exercises that provide opportunities to apply what you have learned to a real-world situation.


numpy.corrcoef(x, y=None, rowvar=True, bias=<no value>, ddof=<no value>)[source]
Return Pearson product-moment correlation coefficients.
The relationship between the correlation coefficient matrix, R, and the covariance matrix, C, is

The series

Relational Data Analysis is the second of two courses in the Relational Database Design Fundamentals series.
In the next lesson, the prerequisites for the course will be discussed.