Relational Database Design, Tools and Techniques

Dated: 15-11-2019

Description


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


Topics

Inquiry Register

1. An overview of DBMS technology

  • How data is accessed, organized and stored
  • The database development process

2.   DBMS and related user tools

  • Query and application development tools
  • CASE tools for database analysis and design

3.  How a Relational DBMS Works

4.  Relational technology fundamentals

  • Tables, attributes and relationships
  • Primary and foreign keys
  • Relational integrity constraints
  • Manipulating data: selection, projection, join, union, intersection, difference
5. Components of a relational DBMS
  • An integrated, active data dictionary
  • The query optimizer

6. Designing Relational Databases
7. A step-by-step approach and techniques

  • Developing the logical data model
  • Mapping the data model to the relational model
  • Specifying integrity constraints
  • Defining the data in the data dictionary

8.  Entity-relationship modeling

  • 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

9.   Normalizing data to design tables

  • Avoiding update anomalies
  • Identifying functional dependencies
  • Applying rules for normalization

10.  Working with a CASE tool

  • Generating the SQL to build the database
  • Reverse engineering to capture the design of an existing database
11. Physical database design
  • Assigning tables to disk files for performance and maintenance
  • Fragmenting large tables
  • Planned denormalization vs. accidental denormalization
  • Indexing for performance and integrity 

12.   Building and Querying a Relational Database

13.   Fundamentals of SQL

  • A dynamic and evolving language
  • ANSI and ISO standards

14.   Creating a relational database

  • Defining the database and its objects: tables, keys, views and indexes
  • Declaring integrity constraints

15.   Accessing the database with SQL

  • Querying the database to retrieve desired information
  • Updating data while maintaining database integrity

16.   Constructing and using views

  • Defining views for simplicity and security
  • Customizing windows into the database
  • Querying and updating through views

17.   The Future of Database Design

 18.   Enforcing business rules for data integrity

  •  Defining declarative constraints
  •  Server-side programming in a procedural language

19.   Trends

  • Modelling in analysis and design
  • Focusing on business rules
  • Creating an intelligent server

Duration: 21 Hours | Cost: £20/Hr