PHP Mysql Training

Learn how to use the building blocks of the Web to create beautiful, interactive websites.

WHY PHP MySQL TRAINING ?

In this time-tested Web Development course, you will find all that is needed to be a professional web developer. The course has been designed meticulously by our professional web developer-cum-trainers who has PHP/MySql web development experience more than 12 years.
This course has been designed specially for those who want to do online course. Either you are a working professional who wants to enhance your web development skill or you are a fresher who wants to build career in website development,this course is for you.

Training Process :
In this course, we start from basic. So that if any one who does not have previous knowledge can understand from ground level.Once the candidate get fundamental knowledge we make them to meander into the gallery of real life smaller projects. Along with our trainer, we also make you to work so that you can do on your own. And in this online web development course,finally you will work on real-life projects.
Focus on real-life project: Our main focus is on real-life projects, once you get subject knowledge on different topics, we encourage you to develop real-life projects, so that you can get confidence. We make you to work in two-way. At one hand, you will be learning and at the other hand you will be implementing the same in the project. So, at the end your course is complete and also your project.

Course Demo :
Before you enroll with our course,you would like to take a look at the video demos that we have included with each topics.Seeing the video, you can understand what kind of projects you will be doing during the training course.

Video Tutorials :
Though,this is real-time tutor based online course, but we provide you a lot of course materials along with not less than 50 video tutorials recorded by our team. This will help you in practicing at home. And even your course is complete, the video will be a supporting learning tool for you.

Prerequisites and Requirements

  •   Most Advance & latest course
  •   Low fees for vast course
  •   Industry-expert trainers
  •   Live projects
  •   Free domain of your choice
  •   100% job placement
  •   Videos

At the end of this course you will:

  •   Most Advance & latest course
  •   Low fees for vast course
  •   Industry-expert trainers

Duration & Fees

  • Course Fee : INR 20,000/- OR $220
  • Duration : 2.5 Months
  • Classes : 3 days in a week, each class 1.5 hours. (Weekend facility also available)

Our Trainers

  •   Umar A Rahman (Available)
  •   Asif Khan (Available)
  •   Anuradha Mahato (Available)
  •   Sourendranath Maity (Available)
  •   Arup Kr. Mondal (Available)

    PHP Introduction

  • What is PHP?
  • The history of PHP
  • Why PHP?
  • Installation and Configuration

    PHP Getting Started

  • Writing your first PHP program
  • Show output
  • Understanding physical and virtual paths, localhost
  • PHP Comments

    PHP Data Types

  • Variables
  • Strings
  • String functions
  • Numbers part one: Integers
  • Numbers part two: Floating points

    PHP If Else.. ElseIf

  • If statements
  • Else and elseif statements
  • Logical operators
  • Switch statements

    PHP Loops

  • While loops
  • For loops
  • Foreach loops
  • Continue
  • Break
  • Understanding array pointers

    PHP Array

  • One dimensional Array
  • Two dimensional arrays
  • Associative arrays
  • Array functions

    PHP String

  • Substr
  • Explode
  • Implode

    User-Defined Functions

  • Defining functions
  • Function arguments
  • Returning values from a function
  • Multiple return values
  • Scope and global variables
  • Setting default argument values

    Debugging

  • Common problems
  • Warnings and errors
  • Debugging and troubleshooting

    Building small website using PHP

  • Links and URLs
  • Using GET values
  • Encoding GET values
  • Encoding for HTML
  • Including and requiring files
  • Modifying headers
  • Page redirection
  • Output buffering

    PHP Forms and Form Data

  • Building forms
  • Detecting form submissions
  • Single-page form processing
  • Validating form values
  • Problems with validation logic
  • Displaying validation errors
  • Custom validation functions
  • Single-page form with validations

    Working with Cookies and Sessions

  • Working with cookies
  • Setting cookie values
  • Reading cookie values
  • Unsetting cookie values
  • Working with sessions

    MySQL

  • MySQL introduction
  • Creating a database
  • Creating a database table
  • CRUD in MySQL
  • Populating a MySQL database
  • Relational database tables
  • Populating the relational table

    Using PHP to Access MySQL

  • Database APIs in PHP
  • Connecting to MySQL with PHP
  • Retrieving data from MySQL
  • Working with retrieved data
  • Creating records with PHP
  • Updating and deleting records with PHP
  • SQL injection
  • Escaping strings for MySQL
  • Introducing prepared statements

    Project – CMS (Content Management System)

  • Layout of a website
  • Building the CMS database
  • Establishing your work area
  • Creating and styling the first page
  • Making page assets reusable
  • Connecting the application to the database

    Using Site Navigation to Choose Content

  • Adding pages to the navigation subjects
  • Refactoring the navigation
  • Selecting pages from the navigation
  • Highlighting the current page
  • Moving the navigation to a function

    Application CRUD

  • Finding a subject in the database
  • Refactoring the page selection
  • Creating a new subject form
  • Processing form values and adding subjects
  • Passing data in the session
  • Validating form values
  • Creating an edit subject form
  • Using single-page submission
  • Deleting a subject
  • Cleaning up
  • Assignment: Pages CRUD
  • Assignment results: Pages CRUD

    Introduction to Object-Oriented Programming (OOP)

  • Introducing the concept and basics of OOP
  • Defining classes
  • Defining class methods
  • Instantiating a class
  • Referencing an instance
  • Defining class properties

    OOP in Practice

  • Understanding class inheritance
  • Setting access modifiers
  • Using setters and getters
  • Working with the static modifier
  • Reviewing the scope resolution operator
  • Referencing the Parent class
  • Using constructors and destructors
  • Cloning objects
  • Comparing objects

    PHP Files and Directories

  • File system basics
  • Understanding file permissions
  • Setting file permissions
  • PHP permissions
  • Accessing files
  • Writing to files
  • Deleting files
  • Moving the file pointer
  • Reading files
  • Examining file details
  • Working with directories
  • Viewing directory content

    PHP Emails

  • Configuring PHP for email
  • Sending email with mail()
  • Using headers
  • Reviewing SMTP
  • Using PHPMailer

Course Duration & Fees

   Course Fee : INR 14,000/- OR $219

   Duration : 2.5 Months

   Classes : 3 days in a week, each class 1.5 hours. (Weekend facility also available)

    study materials

  •   E Books : 6
  •   Videos : 20

    mode of training

  •   Instructor Based Live Training

    certificate

  •   We Will Issue Certificate After Successful Completion of the Course.

    training language

  •   English
  •   Hindi
  •   Bengali

Have questions or queries? Just drop an email or call us.

  •   +91 8583959528
  •   +91 8583959528
  •   suhanasoft
  •   enquiry@aceproschool.com

Join us with an aim our experts will give wings to your dream.