|
Provided by: Serebra Learning Corporation Database Technologies Part 1: Relational Database FundamentalsRDBMS |
 |
The first of a two-part series this course will introduce the learner to the fundamentals of relational databases and relational database design including an in-depth look at data modeling and data design. This course will also cover the evolution of data access and the role that databases and associated enabling technologies play in today's corporate environments. Students should leave this course with a solid foundation in the 'what' and 'why' of relational databases plus an introduction to the 'how' of data modeling and design.
|
|
||||||||||||||
Audience
Associate database administrators technical support consultants and associate programmer/analysts are some of the types of people who would benefit from this course. This course is intended for people who are relatively new to the world of corporate IT and databases. They will most likely either be new to the workforce or have recently been assigned new duties that require them to learn basic SQL and relational database skills. Students should have at least limited exposure to databases and a basic familiarity with programming concepts.
Objective
- Identify database concepts database models and logical modeling.
- Identify entities relationships and the physical design of relational databases.
- Identify relational data structure principles normalization and index structures.
- Identify database design extended relational databases implementation technologies and database maintenance.
Topics Include
Unit 1: Relational Concepts
- Identify the implicit properties of a database.
- Match the database example with the industry in which it is used.
- Identify the characteristics of the database approach to file processing.
- Identify the characteristics of the hierarchical database model.
- Identify the characteristics of the network database model.
- Match the relational database model element with its definition.
- Match the database modeling method with its function.
- Identify the steps of the top-down approach to logical modeling.
- Sequence the steps of the bottom-up approach to logical modeling.
Unit 2: Entities and Data Relationships
- Identify the properties associated with entity relation.
- Label the entity relation documentation symbol with its meaning.
- Match the data relationship type with its example.
- Match the data relationship with the symbol used to document a relationship.
Unit 3: Relational Data Structure
- Identify the characteristics of a relation.
- Match each structure-related term with its definition.
- Match each value-related term with its definition.
- Match the key to its function.
- Identify the different index structures.
- Match each type of integrity constraint with its definition.
- Identify the reasons for performing normalization techniques.
- Match each normal form with its definition.
- Identify the features of a hash structure.
- Identify the features of a B-tree structure.
- Identify the instances where indexing occurs during query optimization.
Unit 4: System Implementation
- Select the phases of the database design process.
- Match the physical design type with its function.
- Identify the benefits of the Universal Server approach.
- Identify the benefits of using Middleware.
- Identify the benefits of the object-oriented approach to designing extended relational databases.
- Match the database software application with its vendor.
- Identify the features of an RDBMS.
- Match the database tools with their functions.
- Identify the types of database security mechanisms.
- Identify the advantages of using a distributed database.
- Identify the features of multi-tier architecture.
- Identify the advantages of remote data management.
- Match the database recovery technique with its function.
Duration
8
Minimum Requirements
The CDROM version of this course requires:
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
- At least a double speed CDROM drive.
- An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM and 14MB available hard disk space or file server space.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
Media
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
