Relational Database Design Concepts
Click here for information regarding remote access training.
Students Will Learn:
- Design normalized table structures for relational databases
- Create databases and tables
- Using primary and foreign keys
- building a logical data model
- Implementing the data model with DDL
- Creating, modifying and dropping database objects
- Writing SQL Queries
- Using inner and outer joins
- Manipulating query results
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.
Relational Database Design Concepts Course Overview:
| 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
"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."