CIN – U80900PN2022PTC214565
PAN-AANCP2201J
TAN-KLPP04763D
PHP with MySQL Full Stack Development Internship
Program
SECTION 1: PHP TUTORIAL
Website basics
1. Project hosting in Internet
2. How to register a domain name in internet
3. How to use cPanel up upload your PHP Project to the Server.
WEBSITE DESIGNING with HTML,CSS,Bootstrap,Javascript:
1. Basic introduction to HTML, CSS, Bootstrap, Javascript.
2. How to Create Responsive Website from Scratch with Real Time Project.
Introduction to PHP:
1. PHP web architecture and PHP overview
2. PHP Installation - XAMPP optionally WAMP
3. First PHP program
4. Comments and PHP manual usage
5. PHP Echo, Print, Echo vs Print
Variable, Constant & Data types:
1. Variables
2. Rules for declaring PHP variables
3. PHP Variable Scope
a) Local variable
b) Global variable, Using $GLOBALS instead of global
c) Static variable
4. PHP $ and $$ Variables
5. PHP Constants, const keyword, Constant() function
6. Variables vs Constants
7. Data types
8. String functions
Sample programs
Operators & Control Structures:
1. Arithmetic Operators
2. Assignment Operators
3. Bitwise Operators
4. Comparison Operators
5. Incrementing/Decrementing Operators
6. Logical Operators
7. String Operators
8. Array Operators
9. Type Operators
10. Execution Operators
11. Error Control Operators
12. Conditional statements – If
13. Conditional statements – Else, Else..If
14. Control structure – Switch
Sample programs
Looping Statements:
1. Looping statements – While
2. Looping statements – Do While
3. Looping statements – For
4. Looping statements – for each
5. Control structure – Break
6. Control structure – Continue
Sample programs
Arrays and Foreach Loop
1. Indexed arrays
2. Printing an Indexed array
3. Associated arrays
4. Looping statement – Foreach
5. Multidimensional arrays
Sample programs
Functions
1. Functions – Introduction
a) PHP Parametrised Function
b) PHP Call By Value
c) PHP Call By Reference
d) PHP Default Argument Values Function
e) PHP Recursive Function
2. Functions with arguments
3. Usage of return keyword
4. Scope of variables
5. Default arguments in functions
Sample programs
PHP Strings
1. PHP string
2. PHP string functions
Sample programs
HTML Forms with PHP
1. Forms introduction
2. Using GET method
3. Using POST method
4. Using $_REQUEST super global
5. Form validation
Sample programs
PHP Include
1. Include and Require
2. Include_once, require_once
File handling
1. File upload
2. File download
Cookies in PHP
1. What is a Cookie?
2. How to see the cooking details in the browser
3. How to delete the cooking in PHP
Sessions in PHP
1. What is a session? How session works. 2. How to view the session ID. 3. How to create a
session variable
4. How to regenerate the session ID
5. How to destroy a session
PHP Mail
1. Mail handling with PHP mail
SECTION 2: MYSQL TUTORIAL
Introduction to MySQL
1. MySQL introduction
MySQL Datatypes and Constraints
1. MySQL Datatypes – Integer
2. MySQL Datatypes – Float
3. MySQL Datatypes – Date
4. MySQL Datatypes – String
5. MySQL Constraints – Not Null, Unique, Primary key
6. MySQL Constraints – Foreign Key, Default
Sample programs
MySQL Select, OrderBy, Limit
1. Select statement
2. Order By
3. Like Operator
Sample programs
MySQL Functions – Number, Date, Character, Control flow
1. Numeric functions
2. Date functions
3. String functions
4. Control flow functions
Sample programs
MySQL – Joins, GroupBy, Having, Subquery, Indexing
1. Inner Join
2. Outer Join – Left, Right
3. Self Join
4. Aggregate functions, Group By, Having
5. Subqueries
6. Any, All operators
7. Indexing
Sample programs
PHP with MySQL
1. How to make database connection from PHP with MySQL
2. Creating a database configuration file
3. How to insert data into the database in PHP
4. How to update data in the database in PHP
5. How to delete data from the database in PHP
6. How to retrieve the data from the database in PHP
7. OrderBy
Sample programs
SECTION 3: PROJECTS
Live Project Work
Extra: - Backend with core PHP and MySQL, Full Ecommerce flow integration
✓ Available Time Schedule and Features of Trainings –
1. Daily 2 hr Morning or Evening as per students Flexibility.
2. Hands On Experience on Live Projects.
3. Get 100% Job Assistance.
4. Get Internship Certificate from Our Company.
5. Learn From Experienced Industry Person
✓ Training Duration – 3 months
✓ Mode Of Training –Offline
