PHP & MySQL

Are you looking to add web functionality that only server side scripting will allow? Then our two day PHP & MySQL course is the perfect place to start.
product
2 day course
Supporting material
Virtual, Private
Virtual Classroom
A convenient and interactive learning experience, that enables you to attend on of our courses from the comfort of your own home or anywhere you can log on. We offer Virtual Classroom on selected live classroom courses where this will appear as an option under the location drop down if available. These can also be booked as Private Virtual Classrooms for exclusive business sessions.
Private
A private training session for your team. Groups can be of any size, at a location of your choice including our training centres.

PHP is the language powering more than 80% of the web that uses server side technology, if you want your website to interact with a database and have back end functionality, then you need to know PHP.

This course starts from the beginning of setting up your server and writing your first line of PHP code. Then over two consecutive days you will gain understanding on how to send and receive information to and from a database and how to create secure interactive website functionality.

Through project based learning you will gain practical experience in working with variables, arrays, conditional statements, loops, functions, objects, error reporting and exceptions.

Our PHP & MySQL course is offered as a live Virtual Classroom or private training session and will be run over two consecutive days. It can be delivered at our own training venue in the World Trade Center, Barcelona, or any location of your choice.

Course overview
Who should attend:
If you want to take your first steps in becoming a backend developer, but currently have no experience and don’t know where to start, then this is the course for you. This course will run over two consecutive days.
Walk away with the ability to:
  • Customise your web server and use it to run your PHP programs
  • Work effectively with all the PHP variable types
  • Work with inbuilt PHP functionality to increase your workflow
  • Use conditional statements, loops, functions and objects to solve a range of problems
  • Setup and use a secure link with a database to run MySQL queries
Course agenda
Introduction
  • PHP Overview
  • XAMPP Setup
  • Hello World!
  • Comments
Variables
  • Declaration
  • Types
  • String Functions
Arrays
  • Declaration and Using
  • Associative Arrays
  • Multidimensional
  • Array Functions
Logic
  • If Statement
  • If Else Statement
  • Switch Statement
Loops
  • While Loop
  • Do…While Loop
  • For Loop
  • Foreach Loop
Functions
  • Declaration
  • Variable Scope
  • Passing Values
Objects
  • OO Programming
  • Class declaration
  • Methods & Properties
  • Inheritance
Database Introduction
  • Database Overview
  • MySQL
  • Command Line
  • phpMyAdmin
Using MySQL
  • Running a Query from PHP
  • Query Types
  • Relationships
  • Variable Types
  • Date & Time
MVC’s
  • Model View Controller Overview
  • Top MVCs
  • Advantages of Using a MVC
Book this course
550 ex IVA
Loading...
close
Don't miss out
Keep up to date with news, views and offers from Jellyfish Training.
Your data will be handled in accordance with our Privacy Policy