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.
Follow-up SQL 2012 Courses: Microsoft SQL Server 2012 Administration, SQL Server 2012 Reporting Services, SQL Server 2012 Business Intelligence Application Development (SSRS, SSIS, SSAS), SQL Server 2012 Business Intelligence: Integration Services and Analysis Services
Follow-up SQL 2014 Courses: Microsoft SQL Server 2014 Administration, SQL Server 2014 Reporting Services, SQL Server 2014 Business Intelligence Application Development (SSRS, SSIS, SSAS), SQL Server 2014 Business Intelligence: Integration Services and Analysis Services
Follow-up SQL 2016 Courses: SQL Server 2016 Reporting Services, SQL Server 2016 Business Intelligence Application Development (SSRS, SSIS, SSAS), SQL Server 2016 Business Intelligence: Integration Services and Analysis Services
| 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|