PHP

Introduction to PHP MySQL (Module 1)

• Introduction to Dynamic Websites
• What is Scripting ?
• Introduction to PHP
• Introduction to MySQL
• Configuring and Testing software.
• XAMPP and WAMPP Installation

HTML Concepts (Module 2)

• Markup Languages
• Syntax of HTML
• HTML Tags
• HTML Forms
• Form Elements
• CSS Basics

PHP Programming (Module 3)

• Syntax of PHP
• Embedding PHP in HTML
• Embedding HTML in PHP
• Introduction to PHP Variable
• Using PHP Variables
• Understanding Data Types
• Using Operators
• Writing Statements and Comments
• Using Conditional Statements

PHP Functions (Module 4)

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

PHP Advanced Concepts (Module 5)

• 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.

Introduction to MySQL Database ( Module 6)

• Understanding an RDBMS
• Understanding a Relational Database
• Introduction to MySQL 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

Working with MySQL Database (Module 7)

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

SQL and Performing Queries (Module 8)

• Inserting Records
• Editing and Deleting Records
• Performing Queries
• Retrieving Specific Columns
• Filtering Records with a WHERE Clause
• Using Operators
• Sorting Records and Eliminating Duplicates
• If(), else if() and else if condition Statement
• Switch() Statements
• Using the while() Loop
• Using the do() Loop
• Using the for() Loop
• Limiting Results
• Using Built-In Functions
• Grouping Records
• Joining Tables
• Using Subqueries
• Using Table and Column Aliases

Working with PHP & MySQL (Module 09)

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

Java Script (Module 10)

• Introduction to Java Script
• Variables, operators, loops
• Using Objects, Events
• Common java script functions
• Java Script Validations

Live PHP Project (Module 11)

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

Live Project

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