Syllabus

Web Development Fundamentals

• Introduction to Web Technology
• Choosing Code Editors / IDEs
• Understanding HTML Markup
• Introduction to HTML5
• Introduction to CSS
• Introduction and difference between Server Side and Client Side Scripting Language
• Using Bootstrap framework

PHP Introduction

• Introduction
• PHP as a Server Side Scripting Language
• How PHP scripts works and why use PHP?
• Installation and Configuration: Setting up PHP Development Environment
• AMP Stack and Working with configuration files (php.ini and httpd.conf)
• PHP CLI (Command Line Interface)
• Runtime Configuration
• Basic overview of working in team using version control tool like GIT, Github,
• Other tools overview like composer for package management
• Syntax, Quotes, Comments and Special Characters
• Building and running our first program
• Data types
• Debugging basics
• PHP web concepts
  • Web Architecture (Client / Server communications)
  • How to embed PHP into HTML
  • How to embed HTML into PHP
  • Validating and Escaping

PHP Identifiers

• Variables
• Constants
• Arrays
• Single Dimensional & Multi-Dimensional Arrays
• Accessing Arrays
• Playing with Arrays
• Array functions ? size, merging, sorting etc...

Operators

• Introduction
• Assignment Operators
• Arithmetic Operators
• Comparison Operators
• Increment / Decrement Operators
• String Operator (Concatenation)
• Logical (or Relational) Operators
• Conditional (or ternary) Operator

Control Structures (Conditional statements and Loops)

• Usage of Control structures
• Types of Conditional Statements
• if else condition
• The switch statement
• Loop Statements
• for, while , do while loops
• break and continue statements
• foreach loop
• Nested control structures and loops

Understanding HTTP Verbs and Methods

• GET Method
• POST Method
• Form Handling with these Methods
• Working with forms (in detail)
• Creating a form with different form inputs
• Using hidden fields
• Redirecting the user from one page to another
• File handling using form (multipart form data)

PHP Global Variables (Superglobals)

• $GLOBALS
• $_SERVER
• $_REQUEST
• $_POST
• $_GET
• $_FILES
• $_ENV
• $_SESSION
• $_COOKIE

Session

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

Function

• Introduction
• Usage of function
• Types of function (Predefined (Inbuilt) & User Defined function)
• Function parameters (With or without and conditional parameters)
• Arguments by value and reference
• Returning values from a function
• Variable Scopes of a function
• Working with Some useful functions
• Date and time function
• Include and require
• Templating using include and require

String Manipulation & Patterns

• Formatting String for Presentation (printf, sprintf)
• Formatting String for Storage
• Joining and Splitting String
• Comparing String
• Matching and replace Substring
• Extracting substrings
• Determining the length of string
• String Patterns
• Matching patterns
• Finding matches
• Replace patterns

Sending Email

• Introduction to SMTP
• Sending Emails with PHP

Database

• Introduction To Database
• What is RDBMS technology?
• Difference between SQL and NoSQL Database
• Introduction to MySQL / MariaDB and Other databases
• Understanding Database, Tables, Fields
• Introduction to SQL (Structured Query Language)
• Data modeling
• MySQL Command Line Usage / Terminal MySQL
• Using Database Management tools (phpMyAdmin/ MySQL Workbench etc.) to handle database
• Creating and managing database
• Selecting Database
• Creating Tables
• 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

Advanced Course

Introduction to Object Oriented Programming

Database Operations Advanced Topics

• User Management and Privileges
• GRANT and REVOKE Statements
• Creating Primary, Index and Unique Keys
• Primary Key, Foreign Key Relationship and Mapping
• Maintaining Foreign Key Constraints
• Joins and Types of JOINS with examples
• Sub Queries
• VIEWS
• Functions, built
• in functions, User defined functions
• Prepared Statements
• Stored Procedures and Triggers
• PL/SQL (CASE, LOOPS and Cursors)
• Transactions
• Patterns in database design

JavaScript and jQuery Basics

• Introduction to JavaScript
• Data types, operators, conditions
• Events, function
• Array and Objects
• jQuery Syntax, Events
• Some jQuery functions
• jQuery Syntax and Events
• jQuery Effects
• jQuery Selectors and Traversing
• jQuery Custom Functions
• jQuery load, get, post
• jQuery Ajax

Internet communications and Validations

• HTML web forms and URLs
• Server side input validation
• Client side input validations
• Session and cookie protection
• Output control
• Headers and browser caching

Web Security in PHP

• Introduction to Web Security
• Cross Site Scripting (XSS) / CSRF Attacks
• Client side Validating Forms with JavaScript
• HTML5 Form Validation
• Server side Validating Forms

Project Work - A Project on PHP using database