Who Should Attend

Managers, system analysts, programmers, and end users responsible for implementing and using systems based on relational database technology will benefit from this course. The course provides a conceptual framework to begin to productively use many of the RDBMS's currently on the market. Managers who are responsible for selecting and implementing new technology will benefit from the overview this course offers.

Prerequisites

Previous exposure to database management systems is helpful.

What you will learn

This course will focus on two important areas for developing systems using relational database technology: data modeling and structured query language (SQL). You will be introduced to data modeling techniques, designing for data integrity, structured query language (SQL), performance tuning techniques, and transaction processing. After completing this course, participants will be able to complete the following tasks:

• Develop Entity-Relationship Diagrams
• Develop normalized relational database schemas
• Perform database queries using SQL
• Use indexing to improve query performance
• Implement concurrency control mechanisms
• Effectively implement transaction control

Course Outline

1. Overview of Relational Database Technology
• Introduction to Database Technology
• The Structure of a Relational Database
• The Evolution of the Relational Model
• Prospects for Growth
2. Data Modeling Techniques
• The Database Design Task
• Data Dictionaries/Master Data Store
• Entity-Relationship Diagrams
• Data Integrity Considerations
• Logical vs. Physical Design
3. Structured Query Language
• Overview of SQL
• Relational Primitives (Select, Insert, Update and Delete)
• Cursor Management
4. Indexing Techniques
• Deciding when to index
• Key Fields
• Analysis of Performance
5. Concurrency Control
• Why is concurrency control needed?
• Record Level Locking
• Table Level Locking
6. Transaction Control
• Applications which require transaction control
• Implementation
7. Future Developments
• On-Line Transaction Processing (OLTP)
• Multi-Threaded Database Engines
• Client/Server Model

Hands-on Workshops

• Data Modeling
• Developing a Database Schema
• Understanding SQL Syntax
• Using the Singleton Select
• Using Select Statements with Sub-Queries
• Using Select Statements with Cursors
• Building Multi-user Applications/Concurrency Control
• Using Update, Delete, Insert Primitives
• Performance Tuning

Course Duration

Two (2) days

Course Schedule

Go to Epcom Course Schedule

Course Materials

• Comprehensive course workbook/summary
• Course certificate of completion