Visão Geral

Curso Relational Database Design, Tools and Techniques. Os bancos de dados relacionais geralmente impulsionam aplicativos críticos para a empresa e habilitados para a Web; portanto, criar um design de banco de dados que capture com precisão os requisitos do usuário é vital para o sucesso. Este Curso Relational Database Design, Tools and Techniques, fornece uma base para projetar, construir e trabalhar com bancos de dados relacionais, permitindo que você desenvolva e use bancos de dados relacionais de maneira eficaz em seu ambiente.

Objetivo

Ao participar do Curso Relational Database Design, Tools and Techniques, os participantes aprenderão a:

• Projete, construa e use um banco de dados relacional usando métodos comprovados
• Garanta que os projetos de banco de dados modelem com precisão os requisitos de negócios
• Normalize e desnormalize dados para otimizar o desempenho
• Trabalhar com restrições de integridade
• Gere automaticamente documentação de banco de dados usando ferramentas CASE
• Simplifique o código e melhore o desempenho evitando erros comuns

Materiais

Conteúdo Programatico

An overview of DBMS technology

1. How data is accessed, organized and stored
2. The database development process

DBMS and related user tools

1. Query and application development tools
2. CASE tools for database analysis and design

Relational technology fundamentals

1. Tables, attributes and relationships
2. Primary and foreign keys
3. Relational integrity constraints
4. Manipulating data: selection, projection, join, union, intersection, difference

Components of a relational DBMS

1. An integrated, active data dictionary
2. The query optimizer

A step-by-step approach and techniques

1. Developing the logical data model
2. Mapping the data model to the relational model
3. Specifying integrity constraints
4. Defining the data in the data dictionary

Entity-relationship modeling

1. Capturing entities, attributes and identifiers
2. Describing relationships: one-to-one, one-to-many, many-to-many
3. Optional and mandatory relationships
4. Resolving many-to-many relationships for implementation

Normalizing data to design tables

1. Avoiding update anomalies
2. Identifying functional dependencies
3. Applying rules for normalization

Working with a CASE tool

1. Generating the SQL to build the database
2. Reverse engineering to capture the design of an existing database

Physical database design

1. Assigning tables to disk files for performance and maintenance
2. Fragmenting large tables
3. Planned denormalization vs. accidental denormalization
4. Indexing for performance and integrity

Fundamentals of SQL

1. A dynamic and evolving language
2. ANSI and ISO standards

Creating a relational database

1. Defining the database and its objects: tables, keys, views and indexes
2. Declaring integrity constraints

Accessing the database with SQL

1. Querying the database to retrieve desired information
2. Updating data while maintaining database integrity

Constructing and using views

1. Defining views for simplicity and security
2. Customizing windows into the database
3. Querying and updating through views

Enforcing business rules for data integrity

1. Defining declarative constraints
2. Server-side programming in a procedural language

Trends

1. Modeling in analysis and design
2. Focusing on business rules
3. Creating an intelligent server