RDBMS Concepts

Training Provided by Teach Me IT The RDBMS Concepts WBT is an end user course that provides an overview of the architecture, functions, and benefits of a database management system and discusses various database models. The course describes the data structure of a relational database model in detail. It extensively covers the normalization process and compares SQL with other popular relational databases. After completing this course, the student will be able to:

Describe a database management system and trace its historical development
Identify the advantages of the database approach over the file-based data storage system
Describe the architecture of a DBMS
List the functions of the database system components
List the features of distributed and object-oriented databases
Describe different types of logical-based data models
List the features of the entity-relationship modeling technique
Identify the features of hierarchical and network record-based models
Describe a relational record-based model in terms of its data structure
List the operators that work on relations
List the features of the first, second, and third normal forms
Describe the Boyce-Codd Normal Form (BCNF) and the need for denormalization
List the features of SQL as the relational database language
Compare different RDBMSs

RDBMS Concepts

Course Name RDBMS Concepts Audience End users who want an overview of a database management system and who need to know the components and data structure of a relational database. Course Requirements You need Microsoft Internet Explorer 5.0 or above OR Netscape Navigator/Communicator 4.78 or above. Plug-in Requirements  ØMacromedia Shockwave plug-in for Windows for IE/NN  ØMacromedia Flash plug-in for Windows for IE/NN Note: Macromedia Flash plug-in comes built in with IE 5.5 and above and NN 6.x. To download the plug-ins, click on the relevant icon below. Pre-requisites Users should be familiar with basic database concepts. Course Duration 4.1 hours Course Objectives The RDBMS Concepts WBT is an end user course that provides an overview of the architecture, functions, and benefits of a database management system and discusses various database models. The course describes the data structure of a relational database model in detail. It extensively covers the normalization process and compares SQL with other popular relational databases. After completing this course, the student will be able to: Describe a database management system and trace its historical development Identify the advantages of the database approach over the file-based data storage system Describe the architecture of a DBMS List the functions of the database system components List the features of distributed and object-oriented databases Describe different types of logical-based data models List the features of the entity-relationship modeling technique Identify the features of hierarchical and network record-based models Describe a relational record-based model in terms of its data structure List the operators that work on relations List the features of the first, second, and third normal forms Describe the Boyce-Codd Normal Form (BCNF) and the need for denormalization List the features of SQL as the relational database language Compare different RDBMSs Course Outline Fundamentals of Database Systems Introduction to Database Systems Architecture of a Database System Quiz Types of Data Models Distributed and Object-oriented Databases Object-based Logical Models Record-based Logical Models Quiz Relational Database Management System Features of the Relational Model Normalization and Denormalization SQL and other RDBMSs Quiz

About The Training Provider: Teach Me IT