| Unit 1: Introduction to PHP MySQL
» Basic Knowledge of websites
» Introduction of Dynamic Website
» Introduction to PHP
» Why and Scope of PHP
» XAMPP and WAMP Installation |
Unit 7: Working with MySQL Database & Tables
» Creating MySQL Databases
» Creating Tables
» Introduction to MySQL Database
» Selecting the Most Appropriate Data Type
» Adding Field Modifiers and Keys
» Selecting a Table Type
» Altering Table and Field Names
» Altering Field Properties
» Backing Up and Restoring Databases and Tables
» Dropping Databases and Table Viewing Database,
Table, and Field Information |
| Unit 2: HTML, CSS
» Markup Languages
» Structure of HTML
» Basic HTML Tags
» Advanced HTML Tags
» Introduction to Doc Types Web Design with CSS
» Introduction to Cascading Style Sheets
» Types of Style Sheets
» Types of CSS Selectors
» CSS properties
» Converting Table layout to CSS
» Custom CSS Layout Design
» Creating simple and dropdown menus
» Creating Appealing forms using CSS
» CSS Tips and Optimization Techniques |
Unit 8: SQL and Performing Queries
» Inserting Records
» Editing and Deleting Records
» Performing Queries
» Retrieving Specific Columns
» Filtering Records with a WHERE Clause
» Sorting Records and Eliminating Duplicates
» Limiting Results
» Using Built-In Functions
» Grouping Records
» Joining Tables
» Using Table and Column Aliases |
| Unit 3: PHP Programming Basics
» Syntax of PHP
» Embedding PHP in HTML
» Embedding HTML in PHP
» Introduction to PHP Variable
» Understanding Data Types
» Using Operators
» Writing Statements and Comments
» Using Conditional Statements
» If(), else if() and else if condition Statement
» Switch() Statements
» Using the while() Loop
» Using the for() Loop |
Unit 9: Working with PHP & MySQL
» Managing Database Connections
» Processing Result Sets
» Queries Which Return Data
» Queries That Alter Data |
| Unit 4: PHP Functions
» 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 |
Unit 10: Java Script
» Introduction to Java Script |
| Unit 5: PHP Advanced Concepts
» Managing Sessions and Using Session Variables
» Creating a Session and Registering Session Variables
» Destroying a Session
» Storing Data in Cookies
» Setting Cookies
» Dealing with Dates and Times
» Executing External Programs |
Unit 11: PHP Project
» Project Discussion
» Requirements analysis of Project
» Project code Execution
» Project Testing |
| Unit 6: Introduction to Database – MySQL Database
» Understanding an RDBMS
» Introduction to MySQL Database
» Understanding Tables, Records and Fields
» Understanding SQL and SQL Queries
» Dealing with Dates and Times |
