Day 1: Fundamentals of Databases Using MySQL (EK085041)

Lesson 1: Familiarizing Yourself with the Fundamentals of Databases

Topic 1A: Identify the Database Development Life Cycle
Topic 1B: Explore the MySQL RDBMS

Lesson 2: Creating a Preliminary Database Design

Topic 2A: Analyze Database Requirements

Topic 2B: Identify Key Fields

Topic 2C: Create Entity Relationship Diagrams

Lesson 3: Applying Normalization Techniques

Topic 3A: Normalize Tables

Topic 3B: Denormalize Tables

Lesson 4: Using the SQL Commands to Work with Tables

Topic 4A: Discuss Structured Query Language (SQL)

Topic 4B: Create Tables Using the Data Definition Language (DDL) Commands

Topic 4C: Modify Data Using Data Manipulation Language (DML) Commands

Lesson 5: Working with Databases

Topic 5A: Use SQL Compound Statements

Topic 5B: Create Triggers

Lesson 6: Managing Databases

Topic 6A: Create Indexes

Topic 6B: Create Views

Topic 6C: Create Transactions

Lesson 7: Administering a Database

Topic 7A: Perform Database Administration

Topic 7B: Perform Backup and Recovery

Day 2 & 3: Introduction to PHP & Apache Web Server(EK085963)

Lesson 1: Getting Acquainted with PHP

Topic 1A: Understand PHP

Topic 1B: Use the Basic Syntax of PHP

Topic 1C: Use HTML and PHP

Topic 1D: Add Comments

Lesson 2: Working with Common PHP Script Elements

Topic 2A: Use Variables and Constants

Topic 2B: Work with Control Structure Statements

Topic 2C: Work with Arrays

Topic 2D: Use Functions

Topic 2E: Implement Object-Oriented Programming

Topic 2F: Include Content from Files

Lesson 3: Working with Forms

Topic 3A: Create Forms

Topic 3B: Validate a Form

Topic 3C: Email Data

Lesson 4: Addressing the Stateless Nature of HTTP

Topic 4A: Set Cookies and Session Variables

Topic 4B: Write Scripts Using Hidden Form Fields

Lesson 5: Accessing and Manipulating Data with PHP

Topic 5A: Interact with Databases

Topic 5B: Modify Database Records Using PHP

Topic 5C: Access Files and Directories

Day 4 & 5: Advance JavaScript & Ajax Programming (EK085959)

Lesson 1: Using Programming Techniques

Topic 1A: Maintain JavaScript Code
Topic 1B: Debug JavaScript Code

Lesson 2: Implementing Cross-Browser Compatibility

Topic 2A: Provide Support for Multiple Browsers
Topic 2B: Enable JavaScript
Topic 2C: Detect Browser and JavaScript Versions
Topic 2D: Detect Objects
Topic 2E: Handle Exceptions

Lesson 3: Using Custom Objects in JavaScript

Topic 3A: Create Custom Objects
Topic 3B: Use Constructor Functions
Topic 3C: Add Methods to Objects
Topic 3D: Use Prototype Functions

Lesson 4: Working with Arrays

Topic 4A: Create Arrays
Topic 4B: Delete Array Elements
Topic 4C: Use Multidimensional Arrays

Lesson 5: Handling Cookies Using JavaScript

Topic 5A: Use Cookie Objects
Topic 5B: Store Cookies
Topic 5C: Process Cookie Values
Topic 5D: Delete Cookies

Lesson 6: Validating Forms Using JavaScript

Topic 6A: Validate Forms Using the Generic Approach
Topic 6B: Implement Generic Validation Using Custom Objects

Lesson 7: Programming Using DOM API

Topic 7A: Traverse Documents

Topic 7B: Modify Documents

Topic 7C: Append Nodes to Documents

Lesson 8: Communicating with Plug-Ins and Server Applications

Topic 8A: Communicate with Adobe Flash Content

Topic 8B: Communicate with ActiveX

Topic 8C: Communicate with Server Applications

Lesson 9: Using Ajax

Topic 9A: Create an XMLHttpRequest Object

Topic 9B: Fetch Information from Servers Using the XMLHttpRequest Object

Lesson 10: Creating Applications with Ajax

Topic 10A: Create an Auto-Complete Application Using Ajax

Topic 10B: Interact with a Database Using Ajax

Topic 10C: Validate Forms Using Ajax

Topic 10D: Work with Third-Party Ajax Libraries

After completing this course, you will be able to:

• identify the fundamental concepts of databases and explore the MySQL RDBMS interface elements.
• create a preliminary database design.
• apply normalization techniques to a database.
• use SQL commands to execute simple queries.
• use SQL compound statements to query efficiently.
• manage databases by creating views, indexes, and transactions.
• administer and maintain a database.
• familiarize yourself with PHP.
• work with common PHP script elements.
• work with forms.
• address the stateless nature of HTTP.
• access and manipulate data with PHP.
• maintain JavaScript code using programming techniques.
• implement cross-browser compatibility using JavaScript.
• use custom objects in JavaScript.
• create and use arrays in JavaScript.
• handle cookies using JavaScript.
• validate forms using the generic approach.
• program using DOM API to traverse, modify, and append nodes to documents.
• communicate with Adobe Flash files, ActiveX controls, and server applications.
• use Ajax to fetch information from the server and display it on the web page.
• create applications with Ajax.