PHP MYSQL TRAINING CLASSES

Courses Info

COURSE CONTENT AND SYLLABUS

  1. Introduction of PHP and MYSQL
  2. Benefits of using PHP and MYSQL
  3. SETUP
  4. Testing the page
  5. Troubleshooting Installation Errors
  1. Using Functions in PHP
  2. User-defined functions in PHP
  3. Predefined functions in PHP
  4. String
  5. File
  6. Date
  7. Mail
  1. Write your first PHP Program
  2. Embed PHP in HTML/ HTML in PHP
  3. PHP data types
  4. Variables
  5. SuperGlobal variables
  6. Operators
  7. Conditional Statements
  8. Loops(For, While, Do While, Foreach)
  1. Why Use Array
  2. Types of Arrays
  3. Creating Arrays
  4. Accessing Arrays
  5. Array Function
  1. What is Database
  2. Understanding an RDBMS
  3. Understanding Tables, Records and fields
  4. SQL Language
  5. Using the MYSQL Command-line Client
  1. Inserting Records
  2. Editing and Deleting Records
  3. Performing actions on Queries
  4. Retrieving specific columns
  5. Filtering records with a WHERE clause
  6. Using Operators
  7. Sorting Records and Eliminating Duplicates
  8. Limiting Results
  9. Using Built-in Functions
  10. Grouping Records
  11. Joining Tables
  12. Using Subqueries
  13. Using Table and column aliases