|
Diploma in Web Technologies ::
PHP & MYSQL :
Html and Css using for php
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..
100% Placements.
Totaly production training.
Duration for both courses : 45 Days ( Fast Track Also available)
Click here for Many Other Courses :
Graphic, Web , 3d Animation, Vfx, Avid, Fcp,Video Editing, Gaming , Programming, PHP & MSQL, Joomla, Drupal, Word Press, FLEX, Action Scripting, .NET, JAVA all Modules, Cad drawings, MSBI, Hardware and Networking,Accounting Packages, etc.,
Class Room Training
Corporate Training (@ desired place)
Weekends Training ( Saturday / Sunday)
Production Training ( Live Project Works)
Online Training. ( From any where in the World)
Online Training Class : ( at Low Price , Avoid Traffic, Save Time & Money)
Add Skype Id for Online Class / Demo : smart.multimedia
We are also providing Real Time Projects : For B.tech, MCA and All.
|
