Advanced Programming

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

Thursday Evenings: July 12, July 19, July 26
Brighton, MA | 7 - 10 pm
Course fee: $150 (regular price: $195)

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.

Course outline:

  • 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
  • Normalization
  • Indexes
  • Real world database modeling exercises
  • SQL
  • 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.

Register Now

To reserve a seat in a workshop, email, call 617-599-8085, or complete the form below.

An information packet including directions and details will be emailed to reigstrants.

Cancellation policy: Full refund is offered up to 7 days before start date. Within 7 days, a packet of the full course materials will be mailed to registrant instead of a credit or refund. Course cancellations due to low enrollment will be fully refunded. Classes cancelled due to inclement weather will be rescheduled.