Relational Databases

Learning Tree International
London,Edinburgh, United Kingdom

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

Course Description:

'' you will learn how to

Work in a relational database environment confidently
Develop a data model to describe an application’s data
Design a relational database using data modelling and normalisation
Access data in a relational database using SQL (Structured Query Language)
Transform the relational database system into an intelligent server
Address the most important performance and quality issue first: database design


Introduction
AN OVERVIEW OF DBMS TECHNOLOGY

Key concepts and terminology
How data is accessed, organised and stored
The importance of business rules
Uses of databases: production and decision-support
The database development process
THREE-LEVEL INFORMATION ARCHITECTURE

External schema: a user’s view of data
Conceptual schema: logical data model
Internal schema: physical data structures
DB SERVER/USER TOOLKIT ARCHITECTURE

Query languages
Report writers
Query and application development tools
Data-modelling CASE tools
How a Relational DBMS Works
RELATIONAL TECHNOLOGY FUNDAMENTALS

The structure of a relational database
Tables, attributes and relationships
Primary and foreign keys
Relational integrity constraints
Semantic integrity, existence constraints
Manipulating data: selection, projection, join, union, intersection, difference
COMPONENTS OF A RELATIONAL DBMS

An integrated, active data dictionary
The query optimiser
An engine that supports transactions, concurrency and recovery
Front-end tools for easy user access
Designing Relational Databases
A STEP-BY-STEP APPROACH & TECHNIQUES

Developing the logical data model
Mapping the data model to the relational model
Specifying integrity constraints
Developing the conceptual schema
Defining the data in the data dictionary
ENTITY-RELATIONSHIP MODELLING

Capturing entities, attributes & identifiers
Describing relationships: one-to-one, one-to-many, many-to-many
Optional and mandatory relationships
Guidelines for a well-formed E-R diagram
Resolving many-to-many relationships for implementation in an RDB
USING A CASE TOOL

Database design and documentation
Generating the SQL to build the database
Reverse engineering to capture the design of an existing database
NORMALISING DATA TO DESIGN TABLES

Why/why not normalise
Avoiding update anomalies
Identifying functional dependencies
Applying rules for normalisation
PHYSICAL DATABASE DESIGN

Grouping and assigning tables to disk files for performance and maintenance
Fragmenting large tables
Planned denormalisation versus accidental denormalisation
Indexing for performance and integrity
Accessing a Relational Database
SQL

A dynamic and evolving language
ANSI and ISO standards
CREATING A RELATIONAL DATABASE

Defining the database and its objects: tables, keys, views and indexes
Declarative integrity constraints
Altering structures and constraints
MANIPULATING AND CONTROLLING A DATABASE

Querying the database to retrieve exactly the desired information
Updating data while maintaining database integrity
Controlling access to data for security
CREATING AND USING VIEWS

Defining views for simplicity and security
Customising windows into the database
Querying and updating through views
Database Directions
EXTENDED CAPABILITIES OF THE RDBMS

Encapsulating function and data
User-defined datatypes and methods
ENFORCING BUSINESS RULES FOR DATA INTEGRITY

Defining declarative constraints
Server-side programming in Java or a procedural language
Trends

Modelling in analysis and design
Focusing on business rules
Creating an intelligent server
Using stored procedures and triggers

...''

Phone:0800 282 353,020 7874 5000,0131 226 6243

School Address:

Learning Tree International Ltd.
Euston House
24 Eversholt Street
London, NW1 1AD
Telephone:0800 282 353

EIS Building
39 Palmerston Place
Edinburgh EH12 5AU
Telephone: 0131 226 6243
Fax: 0131 226 5967

United Kingdom

Jobs & Resumes: London, Edinburgh
Houses & Roommates: London, Edinburgh

SQL Server 2000 Database Administration
SQL Server Transact-SQL Programming
SQL Server 2000 Data Transformation Services
SQL Server 2000 Reporting Services
SQL Queries for SQL Server
Integrating Access with SQL Server
High-Performance SQL Server Databases
Developing ADO.NET Applications for SQL Server
Virtual Server and Workstation Technology
Storage Network Design and Configuration
Crystal Reports
Power Excel: Reporting and Decision Making
Technical Writing Introduction
Domino 6 System Administration
Introduction to Programming with .NET
Visual Basic .NET Programming
C# Programming
Developing Visual C++ .NET Applications
ASP.NET Introduction

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.