EncartaLabs

Relational Database Design, Tools and Techniques

( Duration: 4 Days )

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

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

Relational technology fundamentals

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

Components of a relational DBMS

  • An integrated, active data dictionary
  • The query optimizer
5

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
6

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
7

Normalizing data to design tables

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

Working with a CASE tool

  • Generating the SQL to build the database
  • Reverse engineering to capture the design of an existing database
9

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
10

Fundamentals of SQL

  • A dynamic and evolving language
  • ANSI and ISO standards
11

Creating a relational database

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

Accessing the database with SQL

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

Constructing and using views

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

Enforcing business rules for data integrity

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

Trends

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

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top