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

Get more out of your Software
Improve your Skills
Prepare for Certification
Save time every time and reduce frustration.

Our online training material lets you:
TEST your skills
LIST the areas where you need additional training
Take lessons that TEACH SKILLS to improve these areas
Tests your skills again

NO HIDDEN CHARGES.
NO SETUP or SHIPPING CHARGES.
NO ads or banners in the training material.
No selling of your personal information, no email lists.
Just 100% Quality Training at one low price.

Repeat the courses as often as you need, you have 12 months of unlimited access and can view your scores anytime so you can easily track your progress.

Our training is tested and guaranteed to provide RESULTS and save you TIME.

All courseware is online 24 hours a day.
Our courseware is optimized so content delivery is fast even with a 28.8 modem connection.
If you can get on the Internet you can access the training, ANYWHERE, ANYTIME.