Relational DB Analysis Course introduction

Relational DB Analysis Course introduction

Module introduction

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'll 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:

Create relational constructs
Normalize tables to first, second, and third normal forms
Create joins and views
Optimize a database's physical design
Identify and avoid common design mistakes

In this course, you'll learn and practice database design skills with the aid of several kinds of

Simulations,
SlideShows,
MouseOvers,

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 w;ll complete the project incrementally via a series of exercises that provide opportunities to apply what you have learned to a real-world situation.

The series
Data Analysis is the second of two courses in the Relational Database Design Fundamentals series.

Relational DB Analysis Course introduction

ERD and Normalization

In the next lesson, the elements required for the course will be discussed.


		Relational DB Analysis Course introduction Module introduction
		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'll 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: Create relational constructs Normalize tables to first, second, and third normal forms Create joins and views Optimize a database's physical design Identify and avoid common design mistakes
		In this course, you'll learn and practice database design skills with the aid of several kinds of Simulations, SlideShows, MouseOvers, 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 w;ll complete the project incrementally via a series of exercises that provide opportunities to apply what you have learned to a real-world situation.
		The series Data Analysis is the second of two courses in the Relational Database Design Fundamentals series. Relational DB Analysis Course introduction ERD and Normalization
		In the next lesson, the elements required for the course will be discussed.