- 4-day instructor-led training course
After-course computing sandbox included
- Learning Tree end-of-course exam included
- After-course instructor coaching benefit
Relational Database Design Training: Tools and Techniques
Course 382
- Duration: 4 days
- Labs: Yes
- Language: English
-
23 NASBA CPE Credits (live, in-class training only)
- Level: Foundation
This Relational Database Design training course delivers the groundwork for building and working with relational databases — including Oracle, SQL Server, and MySQL — and enables you to develop and use relational databases in your environment. You will learn to design your database to model your business requirements, normalize and denormalize data to optimize performance, and automatically generate database documentation using CASE tools. You will also learn how to simplify code and improve performance by avoiding common database design errors.
Relational Database Design Training Delivery Methods
In-Person
Online
Relational Database Design Training Information
In this training, you will learn how to do the following:
- Extract core business data requirements from source documents.
- Design both conceptual and logical data models using requirements.
- Recognize and accurately model complex data relationships.
- Apply data normalization methods to refine data models.
- Physically deploy a relational schema from a logical model complete with tables, indexes, keys, and constraints.
Prerequisites
Before taking this course, you should already have basic knowledge and experience using a relational database and SQL.
Relational Database Design Training Outline
- How data is accessed, organized, and stored
- Relational and NoSQL database comparisons
- Roles involved in database design, development, and administration
- The database development process
Relational technology fundamentals
- Terminology and definitions
- Tables, attributes, and relationships
- Primary and foreign keys
- Manipulating data: selection, projection, join, union, intersection, difference
Components of a relational DBMS
- An integrated, active data dictionary
- Databases, accounts, and schemas
A step-by-step approach and techniques
- Extracting core business information from requirements
- Generating conceptual data entities
- Transforming a conceptual model into a logical one
- Building a physical database from a logical model
- Building database documentation
Conceptual modeling
- Capturing core entities
- Identifying entity attributes
- Creating unique identifiers
- Graphically representing a conceptual model
Logical modeling
- Apply data types to entity attributes
- Describing relationships: one-to-one, one-to-many, many-to-many
- Building recursive relationships
- Understanding different modeling notations
- Avoiding update anomalies
- Identifying functional dependencies
- Applying rules for normalization
- Normalizing multi-valued attributes
Physical database design
- Implementing keys from unique identifiers
- Building foreign keys from relationships
- Enforcing business rules with check constraints
Working with design software
- Generating the DDL to build the database
- Reverse engineering to capture the design of an existing database
Applying best practices to database design
- Natural versus surrogate keys
- Exploring lookup table deployment options
- Examine vertical and horizontal data partitioning strategies
- Using record timestamps
Need Help Finding The Right Training Solution?
Our training advisors are here for you.
Relational Database Design Training FAQs
The database environments this course focuses on are relational databases, including Oracle, SQL Server, and MySQL.
This course is intended for database developers, database designers, and database administrators who need to acquire the skills to design a relational database from written requirements by using best practice techniques and methods to go from concepts to deployable code.
Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs wherever you want, including online training.