PHP

1.PHP Basics

  • Embedding PHP in HTML
  • Embedding HTML  in PHP
  • Introduction  Variable
  • Using  variables  
  • Understanding Data Types
  • Using Operators
  • Writing Statements and Comments
  • Using Conditional Statements
  • If(), else if() and else if condition Statement

2.Arrays and Custom Functions

  • Creating an Array
  • Modifying Array Elements
  • Processing Arrays with Loops
  • Grouping Form Selections with Arrays
  • Using Array Functions
  • Creating User-Defined Functions
  • Defining and Invoking Functions

3.Creating basic programs with PHP

  • Reading and Writing Files
  • Reading Data from a File
  • Writing Data to a File  
  • Testing File Attributes.
  • Managing Sessions and Using Session
  • Variables
  • Creating a Session and Registering Session
  • Variables
  • Destroying a Session
  • Storing Data in Cookies
  • Setting Cookies
  • Retrieving Cookie Data
  • Dealing with Dates and Times
  • Executing External Programs

4.Editing Records and Performing Queries

  • Inserting Records
  • Editing and Deleting Records
  • Performing Queries
  • Retrieving Specific Columns
  • Filtering Records with a WHERE Clause
  • Using Operators
  • Sorting Records and Eliminating Duplicates
  • Limiting Results
  • Using Built-In Functions
  • Grouping Records
  • Joining Tables
  • Using Subqueries  
  • Using Table and Column Aliases  

5.Using PHP with MySQL

  • Managing Database Connections
  • Performing Queries
  • Processing Result Sets
  • Queries Which Return Data
  • Queries That Alter Data
  • Handling Errors
  • Using Ancillary Functions  

6.Creating Forms with HTML

  • HTML Basics
  • Creating Forms with HTML  

7.Validations with JavaScript

  • Introduction to Java Scripting
  • Types of Java Scripts
  • Variables, operators, loops
  • Using Objects, Events
  • Common java script functions
  • Using JavaScript in Dreamweaver
  • Java Script Validations

8.Project

  • Requirements analysis of Project
  • Documentation of Project
  • Project code Execution
  • Project Testing

9.MySQL SERVER

  • Understanding an RDBMS
  • Understanding a Relational Database
  • Understanding Tables, Records, and Fields
  • Understanding Primary and Foreign Keys
  • Understanding SQL and SQL Queries
  • Understanding Database Normalization
  • Using the MySQL Command-Line Client

10.Working with Databases and Tables

  • Creating Databases
  • Creating Tables
  • Specifying Field Data Types
  • Selecting the Most Appropriate Data Type
  • Adding Field Modifiers and Keys
  • Selecting a Table Type
  • Altering Tables
  • Altering Table and Field Names  
  • Altering Field Properties  
  • Adding and Removing Fields and Keys
  • Altering Table Types
  • Backing Up and Restoring Databases and Tables
  • Backing Up Databases and Tables
  • Restoring Databases and Tables from Backup
  • Dropping Databases and Tables
  • Viewing Database, Table, and Field Information