Show findcourses.com as: Mobile

Relational Database Design Concepts

Hands On Technology Transfer, Inc.
Training overview
Professional Course
Webinar, Self-paced Online, Virtual Classroom
21 hours (live)/30 days (on-demand)
From 1,495 USD

Start dates
Online
1,495 USD
Inquire for more information

Online
1,495 USD
Start anytime

Online
1,495 USD
Start anytime

Course description

Relational Database Design Concepts

This course 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.

Who should attend?

General computer knowledge.

Training content

  • Developing Relational Databases
  • Transforming to Physical Design
  • Manipulating Table Data Using SQL's Data Manipulation Language (DML)
  • Manipulating Query Results
  • Working with Table Expressions
  • Building a Logical Data Model
  • Constructing the Database Using DDL
  • Writing Basic SQL Queries
  • Advanced Query Techniques

Course delivery details

Delivery Options: Attend face-to-face in the classroom,remote-live or via on-demand training.

Certification / Credits

  • Design normalized table structures for relational databases
  • Create databases and tables
  • Using primary and foreign keys
  • building a logical data model
  • Implementing the data model with DDL
  • Creating, modifying and dropping database objects
  • Writing SQL Queries
  • Using inner and outer joins
  • Manipulating query results

About HOTT

Hands On Technology Transfer, Inc.

Hands On Technology Transfer (HOTT) was established in 1995 and has always had the same mission: to provide the best possible IT training and always assure that students attain competence and confidence in the skills being taught. HOTT’s innovative approach...


Read more and show all training delivered by this supplier

Contact this provider

Fill out your details to find out more about Relational Database Design Concepts.

  Contact the provider

  Get more information

  Register your interest

Country *

Contact info

Hands On Technology Transfer, Inc.


 Show phone number
www.traininghott.com


Contact provider

Have a question about this course? Fill out this form and the provider will get in touch with you shortly

Training reviews

No reviews available

Need help with your search?

findcourses.com offers a free consultancy service to help compare training for you and your team

Request a free quote

Request a free training quote