Relational Database

ExitCertified - Canada
Ottawa, Toronto, Vancouver, Calgary, Edmonton, Winnipeg, Canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' After an overview of relational concepts that are important for designing relational databases, learn about the different views of the data of the application domain and the steps included in this comprehensive relational database design methodology. These steps include:

Analyzing a problem statement for an application domain
Establishing an Entity Resolution (ER) model to visualize and structure the business object types of the application domain as entity types
Illustrating the relationships between the business object types as relationship types
Modeling the constraints for the entity types and relationship types imposed by the business rules
Using the business information and the process inventories to produce a data inventory
Establishing tuple types for entity types and relationship types of an ER model
Transforming the tuple types for the application domain to the tables of the target database management system
Defining implementation techniques for the various types of integrity
Recommending the necessary indexes from a database design perspective
Transitioning from the storage view to the logical view by creating logical data structures



...''

Phone:1.866.328.EXIT (3948)

School Address:

Ottawa, Ontario
ExitCertified Head Office
85 Albert Street, Suite 1200
Ottawa, Ontario, Canada
K1P 6A4

Toronto, Ontario
40 Eglinton Ave E., Suite 305
Toronto, Ontario, Canada
M4P 3A2

Montréal, Quebec
Sun Life Building
1155 Metcalfe Street, Suite 2120
Montréal, Québec, Canada
H3B 2V6

Québec City, Quebec
Holiday Inn Select
Centre-Ville
395, de la Couronne
Québec City, Québec, Canada
G1K 7X4

Vancouver, British Columbia
700 West Pender Street
Suite 610, Pender Place I
Vancouver, British Columbia, Canada
V6C 1G8

Calgary, Alberta
Suite 204
2333 - 18th Avenue NE
Calgary, Alberta, Canada
T2E 8T6

Edmonton, Alberta
10060 Jasper Ave.
Suite 810, Scotia Place
Edmonton, Alberta, Canada
T5J 3R8

Winnipeg, Manitoba
723 Portage Ave.
Winnipeg, Manitoba, Canada
R3G 0M8


Jobs & Resumes: Ottawa, Toronto, Vancouver, Calgary, Edmonton, Winnipeg
Houses & Roommates: Ottawa, Toronto, Vancouver, Calgary, Edmonton, Winnipeg

CICS Fundamentals
CICS TS for z/OS Problem Analysis
CICS Application Programming
CICS DB2 Interface for System Programmers
CICS Web Support Programming Workshop
CICS Transaction Server for z/OS Basic Tailoring
Data Warehouse
DB2 Federated Database Performance, Tuning, and Advanced Topics Workshop
WebSphere Information Integrator Federated Workshop
QMF/SQL for End Users
DB2 UDB Data Warehouse Edition Components with Cube Views
QMF on z/OS Workshop
Queue Replication
DataStage Essentials for Mainframe
Hands on Technical Training for DS4000
AuditStage Essentials
DB2 UDB Advanced Programming
DB2 Fundamentals
DB2 SQL Workshop

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: This website holds more than 300,000 training course records worldwide, with hundreds of new postings daily. All services in this website are free!