Course schedule
Duration: 5 days.
To view the schedule for this class, click here.
Who should attend
The audience for this course include Database Administrators, Web Developers and programmers
Prerequisites
The participants should have a conceptual
understanding of RDBMS and fair knowledge
of SQL commands. The candidates should also
be conversant with HTML and general programming
logic.
INTRODUCTION TO WEB DEVELOPMENT
• An Introduction to Web Development
• HTML Basics
• Advanced HTML
INTRODUCTION TO WEB DATABASE APPLICATION
• Introduction to Web Database Application
• Introduction to MySQL
• Introduction to PHP
• How PHP and MySQL Work Together?
SETTING UP YOUR WORK ENVIRONMENT
• Setting Up MySQL Server
• Setting Up PHP Server
BUILDING A DATABASE
• Creating a New Database
• Deleting a Database
• Adding Tables to a Database
• MySQL Datatype Names
• Changing the Database Structure
• Communicating with MySQL
MOVING DATA IN AND OUT OF THE DATABASE
• Adding Information
• Retrieving Information
• Combining Information from Tables
• Updating Information
• Removing Information
PROTECTING YOUR DATA
• Controlling Access to Your Data
• Setting Up MySQL Accounts
GENERAL PHP
• Adding a PHP Section to an HTML Page
• Writing PHP Statements
• Using PHP Variables
• Using PHP Constants
• Working with Numbers
• Working with Character Strings
• Working with Dates and Times
• Comparing Values
• Joining Comparison with and/or/xor
• Adding Comments to Your Program
PHP BUILDING BLOCKS FOR PROGRAMS
• Using PHP Arrays
• Useful Conditional Statements
• Using Loops
• Using Functions
DATA IN, DATA OUT
• Connecting MySQL and PHP
• Getting Information from a Database
• Getting Information from the user
• Putting Information into Database
MOVING INFORMATION FROM ONE PAGE TO THE NEXT
• Moving Information from Page to Page
• Using PHP Sessions
