PHP & MYSQL :
Html and Css
MYSQL
Ø RDBMS overview
Ø Introduction to Mysql Database
· What is a Database?
· Why Use a Database?
· Helpful Tool – phpMyAdmin.
Ø Creating Your First Database
Ø Mysql localhost
Ø Database Creation
· DDL
· DML
· DRL
Ø Mysql data types
Ø MySQL Tables
Ø Create Table MySQL
· PRIMARY KEY
· Foreign key
Ø MySQL Insert
· Inserting Data Into Your Table
MySQL Query
Ø Using MySQL SELECT & FROM
Ø Usage Query WHERE With Wildcard
Ø Sorting a MySQL Query - ORDER BY
Ø Like operator in mysql
Ø Update
Ø Delete
Ø MySQL GROUP BY - Aggregate Functions
· COUNT
· SUM
· AVG
· MIN
· MAX
Ø MySQL – Formats
· Time – Formats
Ø Index on tables
Ø MySQL Join Table Setup
Ø Views
Ø Cursors
Ø Functions
Ø Mysql stored procedures
Ø Triggers
Ø PHP with MYSQL
PHP
Ø Introduction to PHP
Ø PHP Script
Ø Operators
§ Arithmetic operators
§ Assignment operators
§ Comparison operators
§ Logical operators
Ø Conditional and Looping
§ If and else statements
§ Switch Statements
§ While
§ Do..while
§ For
§ Foreach
Ø Functions
§ Passing Parameters to Functions
§ Functions within Functions
§ Pass by references
§ Scope of the Variables
Ø Classes and Objects
§ What is a class
§ What is a objects
§ Extends
§ The Keyword Final
§ abstract classes
§ Interfaces
§ Exceptions
Ø Working with Forms
§ Creating Forms
§ Post and Get Operations
§ Creating Cookie
Ø Advanced PHP Topics
§ Require
§ Include
§ Constructor
§ Destructors
§ Patterns
§ Magic Methods
Web servers-OVERVIEW
Java script
Ajax
Class project
CMS ::
Joomla, Drupal, Magento.. etc..
Online Training Class for All Course for EveryOne : ( at Low Price , Avoid Traffic, Save Time & Money)
Corporate Training , Class Room Training , Weekends Training , Production Training & Online Training for all Courses.
Get a Demo Class in Online Just from ur Home computer. Internet Connection , Skype ID , Remoting Our System and attend demo online. Add Our Id to your Skype contact is : smart.multimedia
We are also providing real time Projects for every student from all sections. Please contact us.
For Other Courses and More Information Contact Us :
Get Production Training and Corporate Training for all Multimedia Courses from the best.
|