PHP with MySQL online training

php with MySQL course content

    Installation:

  • Introduction PHP and Mysql
  • PHP Installation
  • MySQL Installation
  • Apache Installation.
  • XAMPP and WAMPP Installation
  • PHP Basics:

  • Embedding PHP in HTML
  • Embedding HTML in PHP
  • Introduction Variable
  • Using variables
  • Understanding Data Types
  • Using Operators
  • Writing Statements and Comments
  • Using Conditional Statements
  • If(), else if() and else if condition
  • Statement
  • Arrays and Custom Functions:

  • Creating an Array
  • Modifying Array Elements
  • Processing Arrays with Loops
  • Grouping Form Selections with Arrays
  • Using Array Functions
  • Creating User-Defined Functions
  • Defining and Invoking Functions
  • Creating basic programs with PHP:

  • 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
  • MySQL SERVER:

  • Understanding an RDBMS
  • Understanding a Relational Database
  • Understanding Tables, Records, and Fields
  • Understanding Primary and Foreign Keys
  • Understanding SQL and SQL Queries
  • Understanding Database Normalization
  • Using the MySQL Command-Line Client
  • Working with Databases and Tables:

  • Creating Databases
  • Creating Tables
  • Specifying Field Data Types
  • Selecting the Most Appropriate Data Type
  • Adding Field Modifiers and Keys
  • Selecting a Table Type
  • Altering Tables
  • Altering Table and Field Names
  • Altering Field Properties
  • Adding and Removing Fields and Keys
  • Altering Table Types
  • Backing Up and Restoring Databases and Tables
  • Backing Up Databases and Tables
  • Restoring Databases and Tables from Backup
  • Dropping Databases and Tables
  • Viewing Database, Table, and Field Information
  • Editing Records 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 Subqueries
  • Using Table and Column Aliases
  • Using PHP with MySQL:

  • Managing Database Connections
  • Performing Queries
  • Processing Result Sets
  • Queries Which Return Data
  • Queries That Alter Data
  • Handling Errors
  • Using Ancillary Functions
  • Creating Forms with HTML:

  • HTML Basics
  • Creating Forms with HTML
  • Validations with JavaScript:

  • Introduction to Java Scripting
  • Types of Java Scripts
  • Variables, operators, loops
  • Using Objects, Events
  • Common java script functions
  • Using JavaScript in Dreamweaver
  • Java Script Validations
  • Project

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

Contact Us

Tel: +91-8897400222
USA: +1-512-800-7568
EMAIL: info@mentorsinn.com

Testimonials

"The training was pretty good, and though I was the only one in the online session the class was very much interactive, it was a very good experience, and I am also looking forward to take more trainings from Mentors Inn on other technologies as and when required for me." - Srikanth (PHP)