Orange Coast Database Associates Database Training, Design and Programming Course Listing Page

Course Description

News and special offers from Orange Coast Database Associates
News

 Home-->Courses-->dbd200

Related Courses

Group Training

Individual Training

Scheduled Classes

What's New!

FAQ's

Site Map

Free Catalogs

Special Offers

Request Information or Quote

Sales: 800-355-9855

Home

About Us

Catalog

Calendar

Contact Us

DBD200: Introduction to Relational Databases

Book List | Course Links

Tuition: $490.00 per student

Length: 2 days

Synopsis: 2 day course on the basics of relational database design including tables, fields, keys, indexes, views, normalization, entity relationship diagrams, and SQL. Students will construct a simple ERD using Visio or another modeling tool. DBD201 Accelerated Database Design is s shorter version of this course.

Formats: Custom group at your facility or ours and private training.

Scheduling: Group and individual training are both custom scheduled to meet your needs.

Group Discounts: 2-4 students 20%, 5-8 30%, >8 quote

 

Format this document for printing

Session 1Relational Database Foundations4.0 Hours
 
  • Relational Database Concepts
  • System Architectures; File Server, Lan, Intra/Internet
  • Relational Database Foundations
  • Data Structures; Lists, B-Trees, Hashes, Indexes
 
Session 2Relational Database Modeling and Design4.0 Hours
 
  • Relational Database Modeling
    • Entities
    • Attributes
    • Relationships
  • Entity Relationship Diagrams (ERD's); Chen, Others
  • Database Normalization; 1st, 2nd and 3rd normal forms
 
Session 3Application Development4.0 Hours
 
  • SQL (DDL)
    • Create, Alter statements
    • Constraints, Indexes
  • SQL (DML)
    • SQL Select Statement; grouping; calculations
    • Insert, Update and Delete SQL statements
  • Application Development
  • Multi-user issues (Security, Concurrency, etc.)
  • Emerging Technologies
 

Materials: Course workbook and training certificate.

 

Location: Classes are normally taught on-site at your facilities or at our studio in San Juan Capistrano, Orange County, California. We may also be able to host the class in a rented university classroom near you. Please see FAQs if interested.

Related Services

Need help with a project? We may also provide programming and consulting services covering the above material. See Programming and Consulting for more information.


Copyright(2001-2016) D.H.D'Urso & Associates

Contact Information | FAQ's | Site Map | Back | Home | Top