PHP Mysql Training

Advance Level PHP Mysql Training In Nepal

PHP is a popular scripting language to generate dynamic web pages. It is used for making customized web solutions as it can be embedded with HTML with little effort. Further, it is relatively easy to code on PHP as it comprises simple formats, techniques and features. PHP has become a very popular learning course in Nepal as more developers are emerging in the local IT market. There are numerous Training providers in Nepal in the recent times; however, learning PHP from qualified and smart instructors always is a dream for the aspiring PHP developers.

Web Development Fundamentals

  • Introduction to Web Technology
  • Understanding HTML Markup
  • Introduction to HTML5
  • Exploring Domains, Web Hosting, Web Protocols like HTTP, FTP
  • Introduction to CSS
  • Introduction and difference between Server Side and Client Side Scripting Language
  • Basic understanding to Server Side Scripting Language like ASP and JSP
  • Conversion Requirement Into Design
    1. USE Case Diagram
    2. EER Model
    3. Schema Diagram
    4. Client Proposal
    5. SRS document
    6. Progress Report
    7. Final Report

Digging Into Web Development with PHP

  • Introduction to PHP
  • Why PHP is called Server Side Scripting Language
  • Setting up AMP stack with Apache, MYSQL and PHP
  • Setting up web server either with wamp, xampp or mamp
  • Learning Basics of server configuration with php.ini and httpd.conf
  • Why to use PHP?
  • Scenario of web development with comparison with PHP and other server side scripting language

PHP Basics:

  • Introduction to Variables
  • Understanding and working with Data Types
  • Categorization of Data Types
  • Introduction to Operators
  • Types Of Operators with suitable examples
  • Types of Errors

Looping and Conditional Statements:

  • Why to Use Conditional statements with suitable examples
  • Types of Conditional Statements
  • Simple if, Nested if with suitable examples
  • Switch statement
  • Understanding go to and break statement
  • Looping statement —Why to use?
  • For, while and do while statement with suitable examples
  • Programming practice illustrating looping and conditional statements

Functions in PHP

  • Use of function
  • Types of functions
  • Auto loading functions
  • Function with parameters
  • Function without parameters

String and Patterns

  • Understanding string and patterns
  • Comparing strings
  • Extracting substrings
  • Determining the length of strings
  • Case Sensitive string comparison

Arrays in PHP

  • Why to use Array?
  • Understanding Arrays in Depth
  • Array and Memory allocation
  • Types of Array with examples
  • Numeric key Array
  • Associative key Array
  • Single Dimensional and Multi-Dimensional Array
  • Mixed Arrays
  • Importance of Array in developing real world applications

Session and Cookies

  • Understanding Session and Cookies
  • Setting Cookies
  • Reading Cookies
  • Expiration of Cookies
  • Creating session
  • Assigning data to Session Variables
  • Reading From Session Variables
  • Destroying Session and Session Data

Understanding HTTP Verbs and Methods

  • GET Method
  • POST Method
  • DELETE Method
  • Form Handling with these Methods
  • Creating a form with different form inputs

Database Programming in PHP

  • Introduction to Database and tables, database objects
  • Database Management System
  • Relational Database management System Vs Database Management System
  • Introduction to MySQL
  • Entity and Attributes
  • Features of MySQL
  • Data Types in MySQL
  • Introduction to Query

Diving into MYSQL with Command Prompt

  • Opening and Running MYSQL with Command Prompt
  • Creating and managing database
  • Selecting Database
  • Creating Tables
  • Primary Key, Foreign Key Relationship and Mapping
  • Auto Increment and Indexing a columns in tables
  • Inserting Data into tables in different ways via query
  • Updating Data and Table Structure
  • Selecting from table in different ways
  • Deleting tables and drop database
  • Alter Table structure
  • Types of JOINS in MYSQL with examples
  • VIEWS , Stored Procedures, MySQL built-in functions , User defined functions in MySQL
  • How to use phpMyAdmin/ MySQL Workbench to handle database

Object Oriented Programming in PHP

  • Introduction to OOP
  • Example of different OOP languages
  • Features of OOP
  • Inheritance, Encapsulation, Abstraction etc.
  • Creating and Defining Class in PHP
  • Instantiating a class
  • Inheritance with examples
  • Introduction to Interface and functions
  • Constructors and Destructors
  • Preventing a Class from Inheritance( final keyword)
  • Access Modifiers (Public, Private and Protected illustrations ) in OOP: PHP
  • Abstract Class
  • Magic Functions

JSON and XML in PHP

  • Parsing XML
  • Fetching and handling RSS Feeds
  • Using XML as a String
  • Parsing JSON
  • JSON encoding
  • JSON decoding

Web Security in PHP

  • Introduction to Web Security
  • SQL Injection and Cross Site Scripting
  • How to prevent from attacks
  • Implementing Security in PHP
  • Security concerns in MySQL
  • Security concerns in the Web Authoring Tool

Email and File Handling and others

  • Sending Emails with PHP
  • Introduction to SMTP
  • File Handling Reading and Writing into files and different modes
  • Introduction to FTP
  • How to use FileZilla, CPanel with examples

JavaScript and Jquery Basics

  • Jntroduction to JavaScript
  • Data types, operators, conditions
  • Events, function
  • Array and Objects
  • Jquery Syntax, Events
  • Juery functions

Project Development Techniques

    • Understanding the Agile Methodology / xTreme Programming (Extreme Programming / Waterfall Model / Prototype Model) Defining and Choosing project Topics
    • Creating an project Architecture
    • Creating an designing database
    • Introduction to ER Diagram and Use Case Diagram
    • What is Prototyping?
    • Developing an WireFrame with tools (such as Blasamique wireframe)
    • Converting the project to machine level language with complete OOP

PHP Object Oriented Programming

  • PHP OOPs Basic (Introduction to class, Methods)
  • Constructors and Destructors
  • Access modifiers/specifiers
  • Inheritance
  • Abstract Classes, Interface
  • OOPs Keywords (Clas, autoload, Static & Final Keywords)
  • Polymorphism (Overloading)
  • Auto loading Classes / magic methods
  • Serializing Objects
  • Destroying Objects

Exception/Error Handling, Testing and Debugging

  • Handling PHP Exceptions
  • Using Try & Catch blocks
  • The Exception Object
  • Generating Custom Exceptions
  • Multiple Catch Blocks
  • PHP Error Handling
  • Error Logging and Reporting
  • Creating Custom Error Handlers
  • Suppressing Errors
  • PHP Debugging Methods
  • Using Debugging Tools (xdebug)
  • Creating Conditional Debug Code
  • Introduction to PHPUnit
  • Testing PHP Classes and Functions

PHP Database Extensions and Drivers

  • Depreciated MySQL extension
  • MySQL Improved Extension (mysqli – object based)
  • PHP Data Objects (PDO)
  • ODBC
  • Connecting with databases (mysql,pgsql,oracle)
  • Database Operations using different drivers

MYSQL Advance Topics

  • MySQL Command Line Usage
  • Using MYSQL Management Tools (workbench)
  • User Management and Privileges
  • GRANT and REVOKE Statements
  • Creating Index and Unique Keys
  • Maintaining Foreign Key Constraints
  • Joins and Sub Queries
  • Views and Inbuilt Functions
  • MySQL: Store Procedures and Triggers
  • PL/SQL ( CASE, LOOPS and Cursors)
  • Creating User Defined Functions (UDFs in MySQL)

Security Issues

  • Client side Validating Forms with JavaScript
  • HTML5 Form Validation
  • Server side Validating Forms
  • SQL/OS/Code Injection
  • XSS/CSRF Attacks
  • Session Fixation
  • Encryption with Mcrypt
  • HTTP Authentication
  • Web Server Security

Programming Techniques and Patterns

  • Code Architecture
  • Code Structure and Documentation
  • Managing Code Library and Folders
  • Modules (Modularizing a Web Site)
  • Bootstrap File
  • Introduction to Design Patterns
  • The Factory Pattern
  • The Singleton pattern
  • MVC Architecture Pattern

jQuery and Ajax

  • jQuery Syntax and Events
  • jQuery Effects
  • jQuery Selectors and Traversing
  • jQuery Custom Functions
  • jQuery load, get, post
  • jQuery Ajax