Home

About Us

Catalog Main Catalog Microsoft Access Courses Database Development Courses Discounts and Passports Miscellaneous Fees & Services SQL Courses

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

Session 1	Relational Database Foundations	4.0 Hours
	Relational Database Concepts System Architectures; File Server, Lan, Intra/Internet Relational Database Foundations Data Structures; Lists, B-Trees, Hashes, Indexes
Session 2	Relational Database Modeling and Design	4.0 Hours
	Relational Database Modeling Entities Attributes Relationships Entity Relationship Diagrams (ERD's); Chen, Others Database Normalization; 1st, 2nd and 3rd normal forms
Session 3	Application Development	4.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 via online Remote Learning. 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.