ll Course Details :

Course Name : Scriptgiant Certified PHP and MySQL Programmer [ for beginners ]

Course Duration : 3 Months

Course Fees : Rs.15,000/- in 2 Installments or Rs.14,000 in one Payment

ll What you'll learn :

• You will learn to create a (CMS) Content Management System like WordPress, Drupal or Joomla
• You will learn how to use Databases
• You will learn MySQL
• Object Oriented Programming
• You will learn how to launch your application online
• How to use forms to submit data to databases
• How to use AJAX to submit data to the server without refreshing the page
• You will learn about PHP security
• You will learn about sessions
• Password hashing
• Email sending
• You will learn to use composer (PHP package manager)
• You will learn to create clean URL's and remove the .php from files
• You will learn to use bootstrap by getting experience from the project
• You will learn to debug your code
• You will learn to create pagination
• You will code refactoring
• You will learn to debug (fix your code)

lll Course Details :

The First Steps :

• Introduction
• Updated - Course Overview
• Local Development Environment Tools
• Course Exercise / Reference Files - Udemy Video Walk Through
• Editors I recommend
• Download and Install Development Editor
• Embedding PHP in HTML
• Using Dynamic Data
• Inserting Comments in PHP
• Practice Section

Data Types and More :

• Variables in PHP
• Math
• Arrays
• Associative Arrays
• Practice Section 2
• First steps

Control Structures :

• if Statements
• Comparison and Logical Operators
• Switch Statements in PHP
• While Loop in PHP
• For Loop in PHP
• Foreach Loop in PHP
• Practice Section

Custom Functions :

• Defining functions
• Function Parameters
• Return Values From Functions
• Global Variable and Scope
• Constants
• Newer Way of creating a Constant
• Practice Section

PHP Built-in Functions :

• Math Functions
• String Functions
• Array Functions
• Practice

How To Use Form Data :

• Checking for Form Submission
• Extracting Information from form
• Validating The Form Values
• External Page Submission
• Practice Section

How To Use Databases :

• Introduction to Databases
• Introduction to PHPmyadmin
• Creating a Database in PHPmyadmin
• Creating Tables and Inserting Data in PHPmyadmin
• Markup for Login Page
• Receiving Post Data From Check
• Connecting to the Database using PHP
• Creating Records into the database table with PHP
• Reading Information in the Database with PHP
• Creating the Update Records Form
• Fixing Name Attribute Value
• Query to Read Id's
• Query to Update Username and Password
• Refactoring The Update Query into a Function
• Delete Records From Database with PHP
• Making All Files Modular and Refactoring
• Practice

PHP Security :

• SQL Injection - How to Prevent it
• Password Encryption
• Practice Section

PHP and The Web :

• Introduction to HTTP Requests and more
• Using The GET super Global
• Using the Post Super Global
• About Cookies in PHP
• Setting Cookies with PHP
• Reading Cookies in PHP
• How use Sessions in PHP
• Practice Section

Object Oriented PHP Introduction :

• What are classes and objects ? Introduction
• What are classes and how to define them in PHP
• What are class methods and how to create them
• How to instantiate a class
• Adding Properties to Our Class
• Class inheritance
• Constructors
• Data Access
• Static Data in Classes

Live Project :

• Ecommerce

Preparation for Interview :

• Tips for interview
• Prepare Resume
• Submit application for interview