Sunday, 7 September 2014

PHP and MySql

PHP

  • Introduction to PHP
  • Installation and Configurations
  • LAMP, WAMP, XAMPP, MAMP
  • Comments
  • Output function
  • Data types
  • Variables
  • Declarations
  • Arrays
  • Types of arrays
  • Array functions
  • Strings
  • String functions
  • Conditional Statements
  • if
  • if...else
  • if...elseif....else
  • switch
  • Loops
  • while
  • do...while
  • for
  • foreach
  • continue
  • break
  • Functions
  • Creating Functions
  • Functions without parameters
  • Functions with parameters
  • Functions with return values
  • Date and Time Functions
  • time()
  • getdate()
  • date()
  • Super Globals
  • $_SERVER
  • $_GET
  • $_POST
  • $_SESSION
  • $_COOKIES
  • $_FILES
  • $_REQUEST
  • File uploading
  • File mime types
  • File type restriction
  • Sessions
  • Introduction to session
  • Creating session
  • Creating session variable
  • Calling session variable
  • Creating Login and Logout session
  • Destroying sessions and session variables
  • Cookies
  • Introduction to cookies
  • Types of cookies
  • Creating cookies
  • Accessing cookies
  • Destroying cookies
  • Mail Function
  • Include Require Controls
  • Encryption in PHP
  • Types of errors
  • Working with the Files
  • Opening a file
  • Reading a file
  • Writing a file
  • Closing a file
  • Directory Functions
  • MySQL

  • MySQL Introduction
  • MySQL Installation
  • MySQL PHP Syntax
  • MySQL Connection
  • MySQL Create Database
  • MySQL Drop Database
  • MySQL Select Database
  • MySQL Data Types
  • MySQL Create Tables
  • MySQL Drop Tables
  • MySQL Insert Query
  • MySQL Select Query
  • MySQL Where Clause
  • MySQL Update Query
  • MySQL Delete Query
  • MySQL Like Clause
  • MySQL Sorting Results
  • MySQL Using Join
  • MySQL NULL Values
  • MySQL Transactions
  • MySQL Alter Command
  • MySQL Indexes
  • MySQL Database Export
  • MySQL Database Import
  • Object Oriented Programming
  • Classes, Objects
  • Properties, Methods
  • Class Modifiers
  • Encapsulation
  • Class Inheritance and types
  • Constructor
  • Magic methods
  • Exceptions Handling
  • Try, Throw, Catch
  • AJAX
  • Creating AJAX Object
  • Intialising Object
  • Sending Request
  • Getting Response
  • Readystate
  • CMS

  • DRUPAL
  • JOOMLA
  • Word Press
  • Project


Duration : 45 hrs


jQuery, AJAX and JSON

jQuery

  • Introduction
  • jQuery Features
  • Including jQuery
  • Selectors
  • Document Ready Function
  • DOM manipulation
    • - HTML manipulation
    • - Modifying Attributes
    • - CSS manipulation
  • DOM Traversing
  • jQuery Events
    • - Mouse Events
    • - Keyboard Events
  • jQuery Effects
    • - hide/show
    • - slideUp/slideDown
    • - fadeOut/fadeIn
    • - animate
    • - toggle
  • AJAX methods
    • - ajax
    • - ajaxSetup
    • - getScript
    • - load
    • - get
    • - post
  • AJAX Events
    • - ajaxStart
    • - ajaxSend
    • - ajaxComplete
    • - ajaxStop
    • - ajaxError
  • jQuery UI Library
    • - Interactions
    • - Widgets
    • - Effects
    • - jQuery theming
  • Overview of JSON

Duration : 25 hrs


HTML5, CSS3 and Responsive Layout

HTML5

  • Introduction
  • New Features
  • Structure of HTML5 document
  • Semantic/Structural Elements
  • Audio
  • Video
  • Web Forms 2.0
  • Canvas
  • Drag and Drop
  • Web Storage
  • Geolocation
  • SVG
  • Web worker
  • Application Cache
  • File API

CSS3

  • Introduction
  • Border
  • Background
  • Text Effects
  • 2D Transforms
  • 3D Transforms
  • Transitions
  • Animation
  • Multiple Columns

HTML5 Cross Browser Polyfills

Media Queries

Responsive Layout


Duration : 25 hrs


HTML4, CSS2 and JavaScript

HTML4

  • Introduction
  • Tools needed
  • Document Structure
  • The Header Section
  • The Body Section
  • Tags and Attributes
  • Headings
  • Text Formatting
  • Images
  • Hyperlinks
  • Font
  • Colors
  • Scrolling Text
  • Lists
  • Tables
  • Forms
  • Frames
  • Evolution of Layouts

CSS2

  • Introduction
  • Types of Style Sheets
  • Types of Selectors
  • Div and Span
  • Background
  • Font
  • Text
  • Links
  • List
  • Table
  • Box Model
  • Margin
  • Border
  • Padding
  • Display & Visibility
  • Positions
  • Web Layout
  • CSS3 features

JavaScript

  • Introduction
  • Data Types
  • Popup Boxes
  • Conditional Statements
  • Loops
  • User-defined Functions
  • Document Object Model(DOM)
  • Objects
  • Browser Object Model(BOM)
  • Time
  • Form Validation
  • Working with Images

Duration : 30 hrs


Courses Offered