PHP/MySQL Training Course in Delhi, India by IT People

1
PHP Training
2
Initially, web developers only used HTML to
design websites. The complete website content
would dwell on these HTML pages. For instance, if
a company wanted to advertise 100 products
online, then the web developer would have to
create 100 different HTML pages for each single
product. This was indeed time consuming for the
company as well as for the web developer. Also,
if a non-web designer started in creating or
accessing the HTML code, then it would lead to a
disastrous situation for the website. Thus, the
need for open source languages was felt. Today,
the popularity of open source languages is
catching up. One of the most popular and widely
used server side languages is PHP. Unlike
Javascript and HTML, PHP gives complete liberty
to the web developer to create dynamic, highly
interactive web pages for their clients. For a
web developer to keep pace with todays changing
technologies, it becomes essential to learn
server-side languages like PHP and MySQL. Not
just learning these languages, it is also
important to understand how these languages can
be optimally utilized to get the best
results.
3
Course Content

• Introduction to PHP MySQL (Session 1)
• Introduction to Dynamic Websites
• What is Scripting ?
• Introduction to PHP
• Introduction to MySQL
• Configuring and Testing software.
• XAMPP and WAMPP Installation
• HTML Concepts (Session 2)
• Markup Languages
• Syntax of HTML
• HTML Tags
• HTML Forms
• Form Elements
• CSS Basics

• PHP Programming (Session 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 (Session 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

4

• PHP Advanced Concepts (Session 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 (Session 6)
• Understanding an RDBMS
• Understanding a Relational Database
• Introduction to MySQL Database
• Understanding Tables, Records, and Fields

• Working with MySQL Database (Session 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

5

• SQL and Performing Queries (Session 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 (Session 9)
• Managing Database Connections
• Performing Queries
• Processing Result Sets
• Queries Which Return Data
• Queries That Alter Data
• Handling Errors
• Using Ancillary Functions
• Java Script (Session 10)
• Introduction to Java Script
• Variables, operators, loops
• Using Objects, Events
• Common java script functions
• Java Script Validations
• Live PHP Project (Session 11)
• Project Discussion
• Requirements analysis of Project

Course Duration 2 months Flexible
timing.   Course Fee Course fee Rs.
9,999/-  
6
IT People D-98/2, 1st Floor, Gali No. 4, Near
Laxmi nagar Metro Station, Laxmi Nagar, Delhi
-110092. Nearest Land Mark- Spice
Showroom Email ID  info_at_itpeoplenet.com Ph
91-11-42418334, Mobile [phone]