relational database design, tools and techniques

Relational databases often drive company-critical and web-enabled applications; therefore, creating a database design that accurately captures user requirements is vital for success. The Relational Database Design, Tools and Techniques course provides a foundation for designing, building and working with relational databases, enabling participants to effectively develop and use relational databases in their environment.

By attending Relational Database Design, Tools and Techniques workshop, Participants will learn to:

  • Design, build and use a relational database using proven methods
  • Ensure database designs accurately model business requirements
  • Normalize and denormalize data to optimize performance
  • Work with integrity constraints
  • Automatically generate database documentation using CASE tools
  • Simplify code and improve performance by avoiding common errors

COURSE AGENDA

  • Defining views for simplicity and security
  • Customizing windows into the database
  • Querying and updating through views
  • Defining declarative constraints
  • Server-side programming in a procedural language
  • Querying the database to retrieve desired information
  • Updating data while maintaining database integrity
  • Defining the database and its objects: tables, keys, views and indexes
  • Declaring integrity constraints
  • A dynamic and evolving language
  • ANSI and ISO standards
  • Generating the SQL to build the database
  • Reverse engineering to capture the design of an existing database
  • Assigning tables to disk files for performance and maintenance
  • Fragmenting large tables
  • Planned denormalization vs. accidental denormalization
  • Indexing for performance and integrity
  • Avoiding update anomalies
  • Identifying functional dependencies
  • Applying rules for normalization
  • Capturing entities, attributes and identifiers
  • Describing relationships: one-to-one, one-to-many, many-to-many
  • Optional and mandatory relationships
  • Resolving many-to-many relationships for implementation
  • Developing the logical data model
  • Mapping the data model to the relational model
  • Specifying integrity constraints
  • Defining the data in the data dictionary
  • How data is accessed, organized and stored
  • The database development process
  • Query and application development tools
  • CASE tools for database analysis and design
  • Tables, attributes and relationships
  • Primary and foreign keys
  • Relational integrity constraints
  • Manipulating data: selection, projection, join, union, intersection, difference
  • An integrated, active data dictionary
  • The query optimizer
  • Modeling in analysis and design
  • Focusing on business rules
  • Creating an intelligent server