PHP MySQL Training In Patna

INTRODUCTION

• Basic Knowledge of websites
• Introduction Of Dynamic Website
• Introduction to PHP
• Why and Scope of PHP
• XAMPP Installation

HANDLING HTML FORM WITH PHP

• Hypertext Markup Languages
• Structure of HTML
• Basic HTML Tags
• Advanced HTML Tags
• Introduction to Doc Types Web Design with CSS
• Introduction to Cascading Style Sheets

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

PHP FUNCTION

• 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

ADVANCED CONCEPTS

• Reading and Writing Files
• Reading Data from a File
• 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

INTRODUCTION TO DATABASE-MYSQL DATABASE

• 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
• Dealing with Dates and Times
• Executing External Programs

MYSQL DATABASE&TABLES

• Creating MySQL Databases
• Creating Tables
• Selecting the Most Appropriate Data Type
• Adding Field Modifiers and Keys
• Selecting a Table Type
• Understanding Database Normalization
• Altering Table and Field Names
• 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

SQL 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 Table and Column Aliases

WORKING WITH PHP&MYSQL

• Managing Database Connections
• Processing Result Sets
• Queries Which Return Data
• Queries That Alter Data
• Handling Errors

PHP PROJECT

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