PHP-MySQL Summer Training 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

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

Working with 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 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

JavaScript

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

PHP LIVE Project

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