Web Development Training Syllabus
1. Core PHP+MYSQL
(Level-1)
Introduction:
- What is PHP
- PHP is better than its alternatives
- Hardware and Software requirements
- What a PHP Script Looks Like
- Advantages of PHP
- Getting Started With PHP:
- How PHP scripts work
- Basic PHP syntax
- PHP data types
- PHP Variables
- Operators in PHP
- Conditional Statements
- Loops (If, If else and Switch)
SuperGlobals:
- $_GET
- $_POST
- $_REQUEST
- $_FILES
- $_SESSION
- $_COOKIES
- $_SERVER
- $_ENV
- String Manipulation:
- String Variables in PHP
- The Concatena
- tion Operator
- The strlen() function
- The strpos() function
- Joining and Splitting String
- Comparing String
Working with array:
- Types of Arrays
- Creating Arrays
- Accessing Arrays
- Single-Dimensional Arrays
- Multidimensional Arrays
PHP Function:
- User-Defined Functions
- Inbuilt functions
- Working with Forms
- Designing a Form
- $_GET and $_POST
- HTML and PHP code
- User Input
- Form Validation
MYSQL Database (Level-1):
- MYSQL Database
- Working with
- PHPMyAdmin
- Working with
- PHPMyAdmin
- What is Database
- Working with PHPMyAdmin
- Delete Record
- Database Models
- Creating Databases
- Update Record
- Tables, Records, and Fields
- Database Engines
- View Record
- SQL Language
- Datatypes in MySQL
- Drop Database/Tables
- MySQL Command-Line
- Creating Fields
- Primary / Foreign Keys
- Unique Key
- Insert Record
2. Advanced PHP Programming (Level-2)
- Cookies
- What is a Cookie
- Cookie Syntax
- How to Create a Cookie
- Storing data in Cookies
- How to Retrieve a Cookie Value
- How to Delete a Cookie
PHP
- File Upload
- Create an Upload-File Form
- Create
- the Upload Script
- Restrictions on Upload
- Saving the Uploaded File
- PHP
File Handling:
- Opening a File
- Closing a File
- Check End-of-file
- Reading a File Line by Line
- Reading a File Character by Character
Session:
- What is
- Session
- Creating Sessions
- Storing a Se
- ssion Variable
- Destroying a Session
- Classes & Object
- Object oriented concepts
- Define a class
- Class attributes
- An object
- Creating an Object
- Object properties
- Object Methods
- Object constructors and destructors
- Static Method
- Class Inheritance
- Abstract Class Implement Inheritance
Intergration to SQL with PHP Application (Level-2)
- SQL
- PHP MysQL Integration with SQL
- Basics of SQL
- How to PHP MySQL Integration Works?
- SQL Syntax
- Creating a database connection
- CRUD Operations
- Selecting the DB
- Insert Command
- Inserting data in database
- Retrieving data from Database
- Inserting data with a File
- Retrieving data with specific criteria
- retrieving all records
- Updating records
- retrieving specific record
- Alter table structure
- searching the records
- Deleting the records
- updating records
- Dropping tables
3. Live PHP/.NET Project Implementation
- Project Requirement Analysis
- Setup of Template
- Frontend Module:
- User Registration
- Verification Techniques
- Login with Sessions + Cookies
- View Content
- User Redirection script
- Adding Captcha to Forms
- Administrator Panel
- Admin Login
- View Users List
- Add / Edit / Delete Users
- Add Content on Site
- Edit / Update Content on Site
- PHP MYQL Resources
- PDF Material and Live Examples
- Useful PHP Scripts
- Useful Java Scripts
- Interview Questions and Answers
- Placement Preparation/Mock Test/ weekly Performance test for each Module.
