RDBMS Fundamentals: Database Principles

Synopsis
RDBMS Fundamentals: Database Principles provides an introduction to relational database management systems. The course covers basic types of databases, data integrity, the relational model, entity relationship modeling, ormalization, and performance measurement.

Audience
This course is for programmers and database administrators who want to learn more about relational database principles.

Time
4 hours

Product Code: RDBC01

After completing RDBMS Fundamentals: Database Principles, the user should be able to:

Describe databases and database management systems

Explain relational database management systems

Design simple database models using Entity-Relationship Modeling

Normalize a database

Measure the performance of a database

Estimate the storage needs of a database

Explain the reasons for and pitfalls of denormalizing a database

Understanding Databases

Defining a database

Storing data

Describing different types of databases

Understanding a DBMS

Maintaining and enforcing data integrity

Understanding transactions

Communicating with a database

Relational Database Management Systems

Evolution of databases

Using the relational model

Describing different types of databases

Using Codd's Twelve Rules

Entity-Relationship Models (ERDs)

Modeling entity relationships

Mapping ERDs to the relational model

Understanding Normalization

Knowing when to normalize

Going through a normalization example

Using normal forms above the Third Normal Form

Planning and Management

Defining application types

Using quantitative estimates

Using transaction analysis

Using sizing analysis

Denormalizing a database

This course is distributed with:

Exercises that allow users to practice simple database design

A file containing the text of the exercises

A relational database management system glossary