Akasi Learning Key - Cours Datails

Course details

Relational Database Design Tool And Techniques

Course 00010

Beginner

3 days

PDF

Wishlist:

Share

Category: Database Programming

Description

Relational databases often drive the company-critical and web-enabled applications essential for achieving success in a highly competitive market. This training course is designed to deliver the groundwork for building and working with relational databases — including Oracle, SQL Server, and MySQL — and enabling you to develop and use relational databases in your environment.

What you'll learn

Extract core business data requirements from source documents

Design both conceptual and logical data models using requirements

Recognize and accurately model complex data relationships

Apply data normalization methods to refine data models

Physically deploy a relational schema from a logical model complete with tables, indexes, keys, and constraints

Pre-requisites

• Oracle's free SQL*Developer Data Modeler is used to design and generate a database
• PostgreSQL RDBMS along with the SQL Workbench/J IDE are used for database demonstrations and samples
• Concepts apply to any relational database environment

Curriculum

Module 1: Designing and Configuring a Linux Server

How data is accessed, organized, and stored

Relational and NoSQL database comparisons

Roles involved in database design, development, and administration

The database development process

Module 2: How a Relational DBMS Works

Terminology and definitions

Tables, attributes and relationships

Primary and foreign keys

Manipulating data: selection, projection, join, union, intersection, difference

An integrated, active data dictionary

Databases, accounts, and schemas

Module 3: Designing Data Models

Extracting core business information from requirements

Generating conceptual data entities

Transforming a conceptual model into a logical one

Building a physical database from a logical model

Building database documentation

Capturing core entities

Identifying entity attributes

Creating unique identifiers

Graphically representing a conceptual model

Apply data types to entity attributes

Describing relationships: one-to-one, one-to-many, many-to-many

Building recursive relationships

Understanding different modeling notations

Module 4: Normalization Techniques

Avoiding update anomalies

Identifying functional dependencies

Applying rules for normalization

Normalizing multi-valued attributes

Module 5: Building a Relational Database

Implementing keys from unique identifiers

Building foreign keys from relationships

Enforcing business rules with check constraints

Generating the DDL to build the database

Reverse engineering to capture the design of an existing database

Natural versus surrogate keys

Exploring lookup table deployment options

Examine vertical and horizontal data partitioning strategies

Using record timestamps

Get this Course

2800,00 €

• 3 days instructor-led training course
• After-course coaching available

• No schedule defined yet

Seat reservation

Oops! No seats reserved yet.