GnuGroup India

Course: PHP/MySQL 2: Relational Theory and Logical Design

Time Frame: You can expect to work approximately 60 hours on this course on a live project from our clients.

Technical Requirements: You need a web browser and internet connection, you can take this course from anywhere in the world.

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 iway However, within a weeks of enrolling, you'll receive the free book Database in Depth as a reference.

Certificates: Completion of this course counts toward the PHP/SQL Programming Certificate.

iway: Life long account on the iway, where you can download reference material and ebooks for life.
One Domain, 1GB web space, 2 Email id's @ your domains free as per policy. 

Fees: Rs 8000/-

Prerequisites: Basic PHP and PHP/MySQL: 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, Analyzable and Database Backup, etc.

Syllabus:

• Lab 1 -- Introduction and Review

  • How to Learn using 100% practical course
    

  • Understanding the Learning iway

  • Using the PHP  DBI, reviwed

   

• Lab 2 -- Database Administration for Programmers

  • Your Own DB Server

  • Creating and Altering Databases

  • Creating Database Logins

  • Importing and Exporting Delimited Files

   

• Lab 3 -- Relational Database Theory

  • The Relational Model

  • Relations, Attributes, and Tuples

  • Base Rel vars and Views

   

• Lab 4 -- Relational Algebra

  • Seven Relational Operators

  • Rel var Assignment

   

• Lab 5 -- Logical Database Design

  • Logical Design Using Predicates

  • Enforcing Integrity with Constraints

  • Keys and Entity Integrity

  • Foreign Keys and Referential Integrity

  • The Principle of Orthogonality

   

• Lab 6 -- Preventing Design Flaws with Normalization

  • First Normal Form, Revisited

  • Functional Dependencies

  • Boyce/Codd Normal Form

  • Nonloss Decomposition and Join Dependencies

   

• Lab 7 -- Logical Design in Practice

  • Translating Predicates into SQL Tables

  • Enforcing Constraints with Keys and UNIQUE

  • Choosing the Primary Key

   

• Lab 8 -- Using PHP to Protect your Database

  • Enforcing Constraints Through Form Checking

  • Preventing SQL Injection Attacks

   

• Lab 9 -- Avoiding Update Anomalies

  • Delete vs. Flag

  • Enforcing Referential Integrity Through Table Checking

  • Transactions and Rollback Functions

   

• Lab 10 -- Command-Line Database Safety

  • Granting and Revoking Permissions

  • Backing Up Your Database

  • Analyze, Check, and Optimize

   

• Lab 11 -- Planning a Database Project, part 1

  • Determining the Business Rules

  • Choosing Constraints and Keys

  • Designing and Normalizing the Relvars

   

• Lab 12 -- Planning a Database Project, part 2

  • Creating the SQL Database and Tables

  • Adding Keys

  • Flags, Users, and Permissions

  • Ensuring Safety

   

• Lab 13 -- Planning a Database Project, part 3

  • The Home Page

  • Allowing Members to Join

   

• Lab 14 -- Planning a Database Project, part 4

  • The Login Interface

  • Viewing Member Profiles

   

• Lab 15 -- FINAL PROJECT: Your Own Social Networking Site