This Relational Database Design training course is designed to deliver the groundwork for building and working with relational databases — including Oracle, SQL Server, and MySQL — and enabling 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.
Oracle’s free SQL*Developer Data Modeler is used to design and generate a database
PostgreSQL RDBMS along with the SQL Workbench/J IDE are used for database demonstrations and samples
Concepts apply to any relational database environment
Relational Database Design Training: Tools and Techniques Delivery Methods
After-course instructor coaching benefit
4thdacad end-of-course exam included
After-course computing sandbox included
Relational Database Design Training: Tools and Techniques Course Benefits
Extract core business data requirements from source documentsDesign both conceptual and logical data models using requirementsRecognize and accurately model complex data relationshipsApply data normalization methods to refine data modelsPhysically deploy a relational schema from a logical model complete with tables, indexes, keys, and constraints
Relational Database Design Course Outline
An Overview of DBMS Technology
How data is accessed, organized, and stored
Relational and NoSQL database comparisons
Roles involved in database design, development, and administration
The database development process
How a Relational DBMS Works
Designing Data Models
Normalization Techniques
Building a Relational Database
العربية