Need Help? Call us at (281) 541-2807 Visit our Facebook Page Follow us on Twitter Subscribe to our RSS Feeds

Relational Database Design Concepts Training Seminar

presented by Hands-On Technology Transfer
View the Hands-On Technology Transfer

Bring a trainer to your location to deliver this class for groups of 10 or more.

Summary

This relational database design class develops relational database design skills and techniques

Course Topics: Computers / IT Training > Database  View/subscribe to this subcategory's RSS Feed

Workshop Description/Agenda

Students Will Learn:
  • Building a Logical Data Model
  • Entity-Relationship Diagrams
  • Data Normalization Forms
  • SQL Statement Syntax
  • Manipulating Query Results
  • Designing for Performance
  • Table Indexing

Course Description: This relational database design class develops relational database design skills and techniques. Practical methodologies such as E-R diagrams and normalization forms are emphasized. Attention is placed on designing for data integrity and efficiency at the same time. During hands on lab sessions students are required to design multiple database models from business requirements and specifications. Through hands on experience using SQL programming code to create, populate and manage relational tables, students will experience the necessity of proper design methods and gain an in depth understanding of the link between design, creation, and utilization. The impact of alternative designs on maintainability and database performance is emphasized.

Course Prerequisites: General computer knowledge. Familiarity with relational database concepts is helpful but not required.

Relational Database Design Concepts Course Overview:

Developing Relational Databases
  • Relational Database Fundamentals
  • Database Development Methodology Overview

Transforming to Physical Design

  • Migrating Entities to Tables
  • Selecting Primary Keys
  • Defining Columns
  • Enforcing Relationships with Foreign Keys
  • Enforcing Business Rules
    • NOT NULL, UNIQUE and CHECK Constraints
    • Assigning DEFAULT Values
    • DELETE and UPDATE Rules
  • Database VIEWs
  • Designing for Security: Users and Roles
Building a Logical Data Model
  • Understanding Data Analysis and Modeling
  • Identifying Entities and Attributes
  • Isolating Keys
  • Relationships between Entities (One-to-One, One-to-Many, Many-to-Many)
  • Creating Entity-Relationship Diagrams
  • Complex Modeling Issues
    • Exclusive and Recursive Relationships
  • Normalization as a Design Technique
  • Progressive Steps to Normalization (First, Second, and Third Normal Form)
  • Higher Levels of Normalization
  • Using Normalization to Build an E-R Diagram
  • Referential Integrity Enforcement and Implications
Designing for Performance
  • Indexing
  • Denormalization
  • Addressing Data Contention
Populating the Database
  • Creating and Manipulating Data
    • INSERT
    • UPDATE
    • DELETE
    • TRUNCATE
  • Controlling transactions
    • COMMIT
    • ROLLBACK
Constructing the Database
  • Creating the Database Objects
    • The Schema
    • Creating Tables, Indexes, Constraints and Views
  • Creating Roles and GRANTing Privileges
  • Managing Database Objects
    • Dropping Tables, Indexes and Views
    • Revoking Privileges
    • ALTERing Tables, Indexes and Views
    • Enabling and Disabling Constraints
Basic SQL Queries
  • Displaying Table Structures
  • SELECTing Column Data From a Table or View
  • SELECT DISTINCT Values
  • COUNTing Rows
  • Restricting Rows Using the WHERE Clause
  • Using Operators
    • Logical
    • Mathematical
    • Comparison
    • Concatenation
  • Sorting Results Using ORDER BY
  • Joining Multiple Tables
Manipulating and Summarizing Results
  • Using Row Functions
  • Using Column Functions
  • Handling NULLs
  • Aggregating Results Using GROUP BY
  • Restricting Groups with the HAVING Clause
Advanced Query Techniques
  • Outer Joins
  • Set processing: UNION, EXCEPT/MINUS and INTERSECT
  • Grouping, Filtering and Sorting Query Results
  • Subqueries
  • Tips for Developing Complex SQL Queries

Who Should Attend

Database Designers

Additional Information

Training Provider: Hands-On Technology Transfer

Course Topics: Computers / IT Training > Database

Training Course Summary: This relational database design class develops relational database design skills and techniques

Live Seminar Date/Location

Seminar Location

VENUE PROVIDE UPON REGISTRATION
ATLANTA, GA

Seminar Dates/Times

Start Date: 2020-05-04
End Date: 2020-05-06

Create Calendar Appointment Calendar Appointment Reminder

Seminar Price

$1,595.00

REGISTRATION OPTIONS

Register Online

Register By Phone - Call 806-410-3373

Register By FAX