PHP/SQL 2: Relational Theory and Logical Design
In this course, you will learn advanced database theory, design, optimization, and security.
Upon completion of this course, you will be able to:
- Create, administer, back up, and optimize databases and user permissions in MySQL.
- Import and export files based on SQL results.
- Demonstrate understanding of relvars, views, and Relational Algebra.
- Design a database logically using predicates and constraints, keys, and orthogonality.
- Normalize relational databases to prevent design flaws.
- Translate logical design into SQL tables.
- Prevent database security holes, update anomalies, and SQL injection attacks using PHP.
- Design and create a fully-functioning social networking site using PHP and SQL.
From beginning to end, you will learn by doing SQL-based projects and submitting them for instructor feedback. These projects, as well as the final project, will add to your 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.
This course counts toward the PHP/SQL Programming Certificate Series.
Prerequisites: PHP/SQL 1: Introduction to Database Programming, or equivalent skills. This course is meant for the intermediate or advanced database programmer.
90 Clock-hours 6 CEUs
Course Details and Syllabus
|Course:||PHP/SQL 2: Relational Theory and Logical Design|
|Time Frame:||This course is online and self-paced. You can expect to work approximately 90 hours on this course.|
|Technical Requirements:||As long as you have a web browser and internet connection, you can take this course from anywhere in the world.|
|CEUs:||6 Continuing Education Units with official letter from O’Reilly Media.|
|Software:||The web-based Learning Sandbox® provided for you will contain all your lessons, projects, quizzes, account files, editors, and programming tools necessary to build your skills from beginning to end, even beyond coursework. In addition, you’ll be provided with a mySQL account that can be accessed through the Sandbox or, if you prefer, any normal SSH program. No other software is needed.|
|Instructor:||You will have one instructor throughout the course who will evaluate your projects and quizzes, hand them back for improvement when necessary, and coach you throughout your skills advancement.|
|Book:||All required course materials and software are included online within the Learning Sandbox®. However, within a few weeks of enrolling, you’ll receive the e-book SQL and Relational Therapy, Second Edition as a reference resource from O’Reilly.
|Certificates:||Completion of this course counts toward the PHP/SQL Programming Certificate Series.|
|Prerequisites:||Introduction to PHP and PHP/SQL 1: Introduction to Database Programming, or equivalent skills in PHP and SQL. This course is meant for the intermediate or advanced database programmer.|
|Topics:||The Relational Model, Relational Algebra, Database Theory, Logical Design, Normalization, Predicates and Constraints, Keys and Integrity, Preventing SQL Injection, Form and Database Checking, Transactions and Rollback, Database Users and Permissions, Analyzation and Database Backup, etc.|