SAINORA

HomeCourses PHP MYSQL

PHP MYSQL

Module 1

  • Introduction to SDLC
  • Normalization Techniques

Module 2: MYSQL Database

  • Introduction to MYSQL
  • Data Definition using SQL
    • Databases, Data Types, Views
    • Tables, Constraints and Indexes
  • Basic Data Manipulation using SQL
    • Recurring SQL Constructs
    • Adding data, Modifying data
    • Removing data, Searching data
  • Advanced Data Manipulation using SQL
    • Expressions, Joining Tables
    • Grouping and Aggregate Functions
  • Transactions
    • Transaction Concepts
    • SQL for working with Transaction

Module 3 : Web Application Technology

  • HTML,HTML5
    • Introduction to HTML
    • List & Table
    • Form & Input Tags
    • Introduction to HTML5
    • HTML5 Elements
    • HTML5 Semantics
    • HTML5 Migration
  • CSS
    • Introduction to CSS
    • CSS Properties
  • CSS3
    • Introduction to CSS3
    • Animations
    • Text
    • Gradients
    • Columns
    • Transitions
    • Responsive Web Design
  • Bootstrap
    • Introduction to Bootstrap
    • Bootstrap Examples
  • JavaScript
    • Introduction to JavaScript
    • About Client Side Scripting
    • JS Basics
    • JS Object
    • JS BOM
    • JS DOM
    • JavaScript Validation
    • JavaScript Events
  • jQuery
    • Introduction to jQuery
    • jQuery Effects
    • jQuery Events
  • jQuery UI
    • Introduction to jQuery UI
    • jQuery Interactions
    • jQuery Widgets

Module 4 : PHP

  • Overview of PHP
    • Static vs Dynamic Web Sites
    • Dynamic Content from Databases
    • Developing Dynamic Internet Applications
    • Client-Side Scripting vs Server-Side Scripting
    • Overview of PHP Advantages & Capabilities
    • Configuring PHP.INI
    • PHP vs ASP
  • Basic Scripting and Looping Constructs
    • PHP Scripting Fundamentals
    • Print Statement, Code Blocks
    • Primitive Data Types
    • Defining Constants and Variables
    • Looping Constructs
    • While, Do While, For, Exit & Break
  • PHP Operators
    • Logical Operators
    • Relational Operators
    • Bitwise Operators
    • Other Operators
  • Conditional Constructs
    • True and False , if, else and else if
    • Switch/Case Statement
    • The ? (Ternary) Operator, Timestamps
  • Arrays & Functions in PHP
    • What are Arrays? , Usage of Arrays in PHP
    • Indexing Arrays , Initializing Arrays
    • Adding and Removing from Arrays
    • One-dimensional , Multidimensional Arrays
    • Array Functions
    • Introduction to Functions
    • Declaring Functions, Scope
    • Passing Arguments ,Returning Values
    • Include Files, Require Statement
    • Recursion, Dynamic Function Calls
    • Predefined PHP Functions, Mailing Functions

Module 5 : Classes and Objects (PHP 5)

  • Introduction
  • Auto loading Objects
  • Constructors and Destructors, Visibility
  • Scope Resolution Operator (::)
  • Static Keyword, Class Constants
  • Class Abstraction, Object Interfaces
  • Overloading, Object Iteration
  • Patterns, Magic Methods
  • Final Keyword, Object Cloning
  • Comparing Objects, Reflection
  • File Handling
    • Searching File Contents with Regular Expressions
    • Changing and Editing File Contents
    • Splitting and Joining Information Inside Files
    • File Uploading
    • String Functions
    • Regular Expression Functions
    • Reading, Writing and Deleting Files
    • Handling File Permissions
    • File Locking
    • Reading Directory
    • Creating and Deleting Directories
  • Working with Databases and Forms
    • Configuring PHP for Database Support
    • PHP's Database APIs
    • PHP's SQL API, MySQL vs Access
    • MySQL vs SQL Server
    • Database Driver Class Wrappers
    • ODBC , Simple SQL Queries via PHP
    • Tracking Visitors with Session IDs
    • Populating Forms
    • Retrieving Data from Forms
  • Using Cookies with PHP
    • Purpose of Cookies, Cookie Myths
    • Setting Cookies, Retrieving Cookies
    • Expiring Cookies, Deleting Cookies
    • Storing Arrays in Cookies
  • Miscellaneous PHP Tasks
    • Error Logging
    • Session Management & Maintaining State
    • Using Environmental Variables
    • Changing Execution by
    • Redirecting to Others URLs
    • Embedding Javascript with PHP
    • Using HTTP & FTP Protocols to Pass Data
    • Showing Different Data to Different Browsers
    • Getting IP Addresses from Visitors
  • Arrays & Functions in PHP
    • What are Arrays? , Usage of Arrays in PHP
    • Indexing Arrays , Initializing Arrays
    • Adding and Removing from Arrays
    • One-dimensional , Multidimensional Arrays
    • Array Functions
    • Introduction to Functions
    • Declaring Functions, Scope
    • Passing Arguments ,Returning Values
    • Include Files, Require Statement
    • Recursion, Dynamic Function Calls
    • Predefined PHP Functions, Mailing Functions

Module 6 : Aptitude Skills

  • Quantity Aptitude, Percentages
  • Time and Work, Profit  and Loss Problems
  • Time and Distance , Age and Relations Problems
  • Direction Problems
  • ODD Man Out and Series Problems
  • Puzzles
  • Verbal and Non Verbal Reasoning

Module 7 : Soft Skills

  • Personality Development and Enhancement Positive Thinking Effective Communication Presentation Skills
  • Leadership and Team Work
  • Inter-Personal Skills, Resume Building Group Discussions

Project

  • Developing user friendly project in web based application