This advanced series of workshops was created for coders with a basic profiency in PHP / MySQL development. These sessions cover the development of real world applications, including the latest industry techniques for creating real world PHP applications.
1. Relational Database Design
Instructor: David Kelleher
Brighton, MA | 7 - 10 pm
Course fee: $150 (regular price:
This workshop will introduce the concepts of relational database design. The level is appropriate for programming beginngers, or for those who have used MySQL or SQL Server, but do not have a formal background in proper schema design for relational databases including multiple tables and relationships.
- Relational Data Modeling
- Physical, Logical, and Display Schemas
- Data Redundancy, Integrity, and Anomalies
- Functional Dependency
- Entities, Attributes, and Relationships
- Primary and Foreign Keys
- Referential Integrity
- Real world database modeling exercises
- Complex SQL joins
The emphasis will be on the logic and design of web databases, and will not require computers, or include writing any code.