Who Should Attend

Managers, engineers, system analysts, programmers, and database administrators who will be developing and maintaining relational database systems. It provides a conceptual framework to allow participants to approach issues such as: data modeling and schema design, utilizing CASE tools in the design process, normalization, performance tuning, and building multi-user systems.

Prerequisites

Introduction to Data Modeling & SQL course (ES0520) or equivalent knowledge.

What you will learn

This course provides a design methodology that allows participants to create a conceptual, logical and physical data model. It also provides the conceptual framework to allow you to begin to incorporate CASE tools into your design methodology. Data modeling techniques using Extended Entity Relationship Analysis and designing using CASE tools are the focus of the hands-on workshops. After completing this course, participants will be able to complete the following tasks:

• Develop a Conceptual Data Model using EER Diagrams
• Build a normalized relational database schema
• Perform complex queries using SQL
• Build multi-user applications
• Build applications using transaction processing
• Select a RDBMS package for your application

Course Outline

1. Data Modeling - Design Approach
• Developing a conceptual data model
• Transforming the conceptual model to a relational model
• Data integrity considerations
• Developing relational schemas
• Defining the data dictionary
2. Extended Entity-Relationship Analysis
• Describing the model (entities and attributes)
• Relationships (one-to-one, one-to-many, many-to-many)
• Designing views
• Normalization
3. Physical Data Design
• Logical vs. physical design
• Physical disk structure
• Access methods
• Indexing for performance and integrity
• Indexing, B-trees and Hashing
• Data clustering
4. Structured Query Language
• Overview of SQL
• Complex queries (outer join, subqueries and multiple table joins)
• Cursor Management
5. Application Development
• CASE tools
• Developing functional specifications
• Rapid-prototyping
• 4GL's and application generators
• 3GL programming interface
• Maintaining the integrity of data
• Concurrency control issues
• Performance tuning
6. Evaluating RDBMS Packages
• Application requirements
• Benchmarks
• Report writers
• Interfaces to other software
7. UNIX-based RDBMS Packages
• ORACLE
• INGRES
• INFORMIX
• UNIFY

Hands-on Workshops

• Developing an EER Model
• Developing a relational database schema
• Performing complex queries using SQL
• Building multi-user applications/ concurrency and transaction control
• Performance Tuning

Course Duration

Three (3) days

Course Schedule

Go to Epcom Course Schedule

Course Materials

• Comprehensive course workbook/summary
• Course certificate of completion