Professional Web Development

 Introduction to Course and outcomes:

• Introduction to Web , Web applications
• Introduction to Database and its types
• Introduction languages ,scripting languages

Environment setup and overview of PHP MySQL:

• Decisions about a testing environment
• Installing Apache, PHP and MySQL on your computer(Xampp)
• Using PHP, MyAdmin
• Why use PHP and MySQL?
• The PHP programming environment

Overview of PHP:

• Overview of PHP
• Setting up a PHP page
• Learning basic syntax
• Echoing HTML output to the browser
• Variables in PHP
• Using loose typed variables
• Assigning variables

Variables in PHP:

• Using loose typed variables
• Assigning variables
• Overview of numeric, string and other types
• Global Variables & Data Types
• Global Variables in PHP
• Data Types in PHP

Global Variables in PHP:

• $GLOBLAS, $SERVER, $_POST, $_GET, $_POST
• Php Operators
• Arithmetic operators
• Logical operators
• Comparisons

Introduction to strings and Arrays:

• Concatenating strings
• String functions
• Numerically Indexed Array
• Associative Arrays
• Multidimensional Arrays

Control structures in PHP, function and class:

• The If statement
• FOR loops
• While loops
• The Switch
• PHP Function and Class

Introduction to Structured Query Language (SQL): 

• Introduction to SQL
• Create Database and Database Table 
• SQL SELECT Statement
• SQL AND, OR and NOT Operators
• The SQL INSERT INTO Statement

Database Design:

• SQL UPDATE Statement
• SQL DELETE Statement
• SQL LIKE Operator
• SQL Joins(Inner Join, Left Join, Right Join, Full Join)

How to Normalization in Database: 

• What is Normalization?
• Types of normalization?
• Design a database and apply normalization

Project (Create CRUD Application):

• Form and Table design with Bootstrap
• Design a database and Table
• Database Connection with PHP

Project work (Create CRUD Application):

• How to read data from a Database?
• Strategies for sending data from the HTML form
• Data update method
• How to delete data from a table