Duration: 3 days
Remote Attendance: Click here for more information.
Course Description: This relational database design class develops relational database design skills and techniques. Practical methodologies such as E-R diagrams and normalization forms are emphasized. Attention is placed on designing for data integrity and efficiency at the same time. During hands on lab sessions students are required to design multiple database models from business requirements and specifications. Through hands on experience using SQL programming code to create, populate and manage relational tables, students will experience the necessity of proper design methods and gain an in depth understanding of the link between design, creation, and utilization. The impact of alternative designs on maintainability and database performance is emphasized.
Course Prerequisites: General computer knowledge. Familiarity with relational database concepts is helpful but not required.
| Developing Relational Databases
||Building a Logical Data
|Transforming to Physical Design
||Constructing the Database Using DDL
|Manipulating Table Data Using SQL's Data Manipulation Language (DML)
||Writing Basic SQL Queries
|Manipulating Query Results
||Advanced Query Techniques
In the ten years I've been an IT professional and taken 1-3 courses per year in that time, I found this instructor to be the best educator bar none. He is extremely articulate and is impeccably skilled in hearing the real need behind the question. He is energetic, enthusiastic and fun. Humor is used effectively in his presentations...Because of this training experience, I prefer HOTT courses to other courses such as Global Knowledge, etc.
— T.L., W.L. Gore and Associates
Fantastic instructor obviously well-versed and has a lot of real-world experience. Was able to help me apply the course material to needs at my job. Excellent instructor, excellent class.
— J.N., Mary T. Inc
The instructor is wonderful! She conveyed the material clearly and with the right amount of detail. Plus she held my attention throughout the class.
— B.D., Westvaco
Individual training passes: save up to 43%! For complete discount options » click here «
|# Courses||Total Cost||Cost Per Course||% Savings|