Relational Database Design Concepts training seminars presented by Hands-On Technology Transfer register now on FindaSeminar.com

findaseminar logo balls FindaSeminar.com
event search registration and marketing services since 2002
Advanced Search
 
 

** NOTE: All April seminars are live Virtual or Online click to view events.

Relational Database Design Concepts  

 Email information about this seminar Relational Database Design Concepts by Hands-On Technology Transfer to yourself your manager or associates Email this event... View and register for other training seminars like Relational Database Design Concepts by Hands-On Technology Transfer on FindaSeminar.com Find similar training.. Find and register for other training seminars by Hands-On Technology Transfer on FindaSeminar.com Other seminars from Hands-On Technology Transfer

By:

Hands-On Technology Transfer   

For:

IT professionals interested in learning RDB design

Cost:   

see Registration info for seminar cost, group discount etc.

Seminar Summary:

This relational database design class develops relational database design skills and techniques. Practical methodologies such as E-R diagrams and normalization forms are emphasized. (see full course description)

 

 Seminar / Training class dates & locations

 

No seminar dates for this event are currently scheduled.  Please use the seminars search box above or choose one of the following additional training search options to find similar training.

relational+database+design+SQL+sequel+db+RDB training seminars workshops conferences online training

Providers course catalog

Find seminars by state

Find seminars by city

Request on site training

Use Advanced Search

NEW  Don't miss training you want to attend

Receive a personal Training Alert when training you want to attend comes to your area. Create a personal Training Alert now  it's Free and only takes a minute!


 

 

 

share this page 

print the agenda print agenda for the Relational Database Design Concepts seminar

 

 

Training Course Syllabus:


Relational Database Design Concepts Hands-On Training Class

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 Outline:

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
  • Estimating Table Sizes
  • 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
    • Supertype / Subtype Entities
  • 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
  • Storage Considerations
Populating the Database
  • Creating and Manipulating Data
    • INSERT
    • UPDATE
    • DELETE
    • TRUNCATE
  • Controlling transactions
    • COMMIT
    • ROLLBACK
    • SAVEPOINT
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
  • 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, MINUS and INTERSECT
  • Grouping, Filtering and Sorting Query Results
  • Subqueries
  • Tips for Developing Complex SQL Queries

Seminar Summary:

This relational database design class develops relational database design skills and techniques. Practical methodologies such as E-R diagrams and normalization forms are emphasized. (see full course description)

print this agenda print agenda for the Relational Database Design Concepts training seminar

 view dates and locations for this seminar

 

 

 

Custom Search