Learn PHP and MySQL Training

Enroll now to start learning. Let's go!
Type: Online
Level: Intermediate
  Duration: 36hrs
Pax: 3 to 10 Students
Technologies: PHP and MySQL
Job Preperation: Yes
HandOuts: Yes
Pre-Requisites: HTML, Basic JS

Contact us if you want to experience the free demo of the training and one of our expert trainer will assist you online.

About This Specialization


This software and website development training provides an introduction to basic techniques used in
building functional, responsive, and interactive websites using MySQL and PHP.

MySQL and PHP are useful in in creating database-driven web applications.

Through Tektile’s web development courses, you will learn how to use these
two popular tools to achieve the more advanced objectives
for your software and website.

Training Goal


  • Learn the fundamentals of PHP
  • Learn basic Syntax PHP
  • Learn the how to create login form
  • Learn to manage sessions with PHP
  • Understand how MySQL works
  • Learn to send email with PHP.
  • Learn to create dynamic interactive pages with PHP.
target goal

Schedule


Class Schedule Start Date End Date Status
Every Sunday 9am - 3pm Sunday, 12th February 2017 Sunday, 19th March 2017 open

Syllabus


What is PHP?
History
Why choose PHP?
Installation overview

Viewing PHP configuration information (php.ini file)
Embedding PHP
“Hello World!”
Inserting comments

Variables
Strings
String functions
Numbers : Integers
Numbers: Floating points
Arrays
Array functions
Booleans and NULL
Type switching and casting
Constants

If statements
If Else statements
Nested elseif statements
Switch statements

While loops
For loops
Foreach loops
Do While
Understanding array pointers

Defining functions
Using functions
Returning values from a function
Setting global variables
Setting default values

Links and URLs
Using GET values
Building forms
Using POST values
Setting cookies
Establishing sessions
Headers and page redirection
Including and requiring pages

MySQL introduction
Creating a database in MySQL
Creating a table in MySQL
Working with field names
Populating a MySQL database
phpMyAdmin

Some Basics

  • Comments
  • Whitespace and Semi-colons
  • Case Sensitivity

SELECTing All Columns in All Rows
SELECTing Specific Columns
Sorting Records

  • Sorting By a Single Column
  • Sorting By Multiple Columns
  • Sorting By Column Position
  • Ascending and Descending Sorts

The WHERE Clause and Operator Symbols

  • Checking for Equality
  • Checking for Inequality
  • Checking for Greater or Less Than
  • Checking for NULL
  • WHERE and ORDER BY

The WHERE Clause and Operator Words

  • The BETWEEN Operator
  • The IN Operator
  • The LIKE Operator
  • The NOT Operator

Checking Multiple Conditions

  • AND
  • OR
  • Order of Evaluation

Subqueries
Joins

  • Table Aliases
  • Multi-table Joins

Outer Joins
Unions

  • UNION ALL
  • UNION Rules

MySQL PHP Interaction
Accessing data in MySQL with PHP
Applying Create Read Update Delete (CRUD )

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

Opening a File
Reading from a File
Writing to a File
File Locking
Uploading Files via an HTML Form
Getting File Information

Creating Content Management System
Building Blog website with user’s login form

FAQ’s


MySQL and PHP are two of the most advanced and widely used tools in website development today.

Learning how to use the most advanced tools will help you get a job quicker than those who just know how to use the basic HTML & CSS. Companies want to harness the power of the latest technologies, and you can do that with the use of MySQL and PHP.

You must be knowledgeable with HTML, CSS and Javascript.

Full payment before taking the said training. We will forward to you the Company Bank Account where you will deposit the training fee.

Enroll Now!

Accomplish the form below to enroll on this training. Once we received it one of our agent will send you the payment details.







Be Part of Our Team, become a trainer Apply Now