Sorry, Presently We are Not Offering This Course
Learn PHP MySQL Online and become a professional PHP developer. PHP MySQL is Open Source and is being used by most of the corporate companies and mnc companies for both small and large projects. Due to rapid growth in PHP MySQL, PHP Developers have many job opportunities in India and Abroad.
In our Online PHP Training we train the students to understand the concepts of programming, business logic building, work with php functions, database design and implementation. At the end of the course you will be able to develop your own web application.
PHP MySQL Course Syllabus
HTML Concepts
- Introduction to HTML
- HTML Tags
- HTML Form Tags
- Creating Forms with HTML
PHP Introduction and Installation
- Introduction PHP and MySQL
- Server Side Technologies
- PHP MySQL Environment
- Installation of XAMPP
- Configuration of Apache / PHP
- Common Errors in Installation
- Using the Dreamweaver for PHP
PHP Programming Concepts
- First PHP Program
- Introduction to Variables
- Using Variables
- SuperGlobal Variables
- Understanding Data Types
- Using Operators
- Writing Statements and Comments
- Conditional Statements in PHP
- Switch() Statement
- Using the for() Loop
- Using the while() Loop
- Using the do while () Loop
- Using the foreach () Loop
- Working with Arrays
- Processing Arrays with Loops
- Grouping Form Selections with Arrays
PHP Functions
- PHP Functions
- User-Defined Functions
- Predefined Functions
- General Functions
- String Functions
- Mail Functions
- File Functions
- Array Functions
- Date / Time Functions
- Session Functions
- Cookie Functions
PHP Programs
- Working with Forms
- File Uploads using PHP
- Creating Mails
- Working with Files
- Working with Sessions
- Working with Cookies
- User Authentication Program
- Working with Date and Time
- Creating a Simple Gallery Page
Introduction to MySQL Database
- Understanding an Databases
- Relational Database (RDBMS)
- Tables, Records, and Fields
- Primary and Foreign Keys
- What is SQL ?
- MySQL Command-Line Client
Working with Databases and Tables
- Using PHPMyAdmin
- Creating Databases / Tables
- Specifying Data Types
- Adding Keys
- Altering Tables
- Altering Table and Field Names
- Altering Field Properties
- Adding and Removing Fields and Keys
- Altering Table Types
- BackUp and Restore of Databases and Tables
- Dropping Databases and Tables
- Viewing Database, Table, and Field Information
Using SQL to Perform Queries
- SQL Concepts
- 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
- Union / Join Tables
- Using Subqueries
- Using Table and Column Aliases
- User Priveleges
Using PHP with MySQL
- MySQL Functions
- Managing Database Connections
- Performing Queries
- Processing Result Sets
- Pagination Program
- Queries Which Return Data
- Queries That Alter Data
- Delete Records
- Handling Errors
Validations with JavaScript
- Introduction to Java Script
- Types of Java Scripts
- Variables, operators, loops
- JS Event Handler
- Common Java Scripts
- Using JavaScript in Dreamweaver
- Java Script Validations
PHP Mini Project
- PHP Project Requirements Analysis
- Designing Database Architecture
- Using a Layout Design
- Working with HTML Forms
- Writing the SQL Statements
- Project code Execution
- Project Testing
- Making the PHP Project Online