PHP/SQL 2: Relational Theory and Logical Design
The versatility of Database Programming cannot be unlocked unless you begin with a robust, scalable design. A thorough understanding of the Relational Model and Logical Design are necessary in order to build databases that remain consistent and secure as they handle massive amounts of data.
A professional database programmer will also need skills in translating the theoretical Logical Design to an equally safe and secure physical design in SQL, fully utilizing all tools possible in SQL as well as PHP to enforce the consistency and security of the design.
In this course, students will learn advanced database theory, design, optimization, and security. From beginning to end, participants will learn by doing their own SQL-based projects using PHP, and then handing them in for instructor feedback. These projects, as well as the final project (a social networking site), will add to the student's portfolio and will contribute to certificate completion. Besides a browser and internet connection, all software is provided online by the O'Reilly School of Technology.
Upon completion of the course, students will earn 4 CEUs (Continuing Education Units) and a CEU letter from the University of Illinois Office of Continuing Education. This is the third course in the PHP/MySQL Certificate Series, after Introduction to PHP and PHP/SQL 1: Introduction to Database Programming.
To see the topics covered in PHP/SQL 2: Relational Theory and Logical Design, please see the Syllabus and Course Details.
Course Syllabus
Earn a Certificate
for Professional Development from the University of Illinois' Office of Continuing Education upon completion of a selected series of courses.
