Introduction to Relational Databases 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.
Accelerated Relational Database Design Slightly shorter (1 day) version of DBD200 with minimal SQL. Ideal as a complement to one of the SQL courses. Students will construct, in Visio or another modeling tool, an Entity Relationship Diagram that applies to their application(s) during this course. The price for this course is reduced to $195 if taken in conjunction with an SQL course or a Microsoft Access course. The course is loosely based on the excellent textbook(s) by David Kroenke.
Relational Database Design with MySQL In this course, you will plan, design, and create a functional and efficient relational database. You can create effective database designs by applying the relational database design techniques taught in this course. MySQL will be used for implementation and is the basis for the manual. However, another database can be substituted upon request. Visio or equivalent design tools may be used for design. Students should have some familiarity with data tables and basic knowledge of how to create queries in Microsoft Access or equivalent.
Relational Database Design - A Practical Approach In this course students will learn the general principles involved in designing a database that complies with the relational database model. The conceptual content of this course is not specific to any software application but Microsoft Access will be used to perform the tasks in the lessons pertaining to queries. Visio or an equivalent modeling tool will be used for diagramming exercises. Students should have some familiarity with data tables and basic knowledge of how to create queries in Microsoft Access or equivalent.
Introduction to Database Diagramming with Lucidchart Hands-on short course in using Lucidchart to diagram relational database designs. Covers ERDs (Entity Relationship Diagrams), entities, attributes and relationships. Relationships covered are 1 to 1, 1 to many, many to many, recursive and subtype. Assumes some prior familiarity with relational databases.
Introduction to Database Diagramming with Visio Hands-on short course in using Microsoft Visio to diagram relational database designs. Covers ERDs (Entity Relationship Diagrams), entities, attributes and relationships. Relationships covered are 1 to 1, 1 to many, many to many, recursive and subtype. Assumes some prior familiarity with relational databases.
Individual Combo Training Passport 4 full days of Access, SQL and Database classes at a large discount. Valid for six-months from date of purchase. Additional days may be purchased on the original invoice or any time within the passport period.
Please refer to the Access Passport if interested in an even less expensive option for Microsoft Access.
Database courses are offered in two formats: 1) on-site at your location in the Greater Los Angeles and San Diego areas, 2) Online via Zoom remote learning.
(Final prices will reflect tuition, materials,
registration, applicable discounts and charges.)