Academy Class delivers PHP / MySQL training courses from beginner to advanced levels. All PHP / MySQL training is taught by industry-experienced instructors, who aim to make sure you learn everything needed to put your new skills into practice in the workplace.
Here at Academy Class, we like to make sure you have fun, learn lots and leave delighted!
Your PHP / MySQL training course will feature small class sizes, state-of-the-art Mac and PC workstations, great learning environments, industry-certified trainers, the latest courseware, and careful attention to your specific needs and experience. Additionally, if you’re not confident about using what you learn on our public scheduled PHP / MySQL training courses, you can retake the class free of charge within 6 months of your first day of training. That’s the unique Academy Class Guarantee of Learning Satisfaction, delivering peace of mind for your training investment.
*All classes at Academy Class’s begin at 10AM and end between 4 and 5PM
PHP training in the USA – Our partner in the USA, Ledet Adobe Training Centers offers PHP training classes in Atlanta, Chicago, Denver, San Diego and Washington DC.
Introduction to PHP Structure and Syntax Array types Sorting arrays Escape sequences Conditional decision making – if, else, and elseif Embedding PHP in Web pages Mathematical functions Why write your own functions Basic OOP Why use a database – The three-tier architecture approach Connecting to the database
Static Webpages are no longer sufficient for the needs of the Internet in the 21st Century.
An increasing number of business sites use databases to store data and produce dynamic Webpages. PHP and mySQL are a cost-effective but powerful solution to building database driven Websites which can be developed on Windows and deployed on either Windows or Unix(Linux)servers. This course does not cover the PHP language itself in great depth but concentrates on getting up and running with the mySQL database, using PHP as the server-side control.
PHP is a powerful, free server-side language which is relatively easy to learn for those who have never programmed before.
Who is this course for?
The course is aim for participants who already know at least the basic of HTML and has done some programming in a modern programming language before.
Assumed Knowledge
Computer literacy: the ability to use a mouse and keyboard; familiarity with common computer software; the ability to open and save files. A basic familiarity with HTML, CSS and the creation and management of a website.
What you will learn
Upon successful completion of this course, students will be able to install and configure PHP, mySQL and Apache Webserver on Windows, how databases are used on the Web, use PHPmyAdmin to create and edit databases, query your database with basic SQL commands, program with basic PHP statements, use PHP to communicate with your database, Add, Delete and Modify data in the browser, build a complete Data Management system with PHP and mySQL.
Introduction to PHP
Why choose PHP/MySQL/Apache
PHP’s purpose and capabilities
Server Side Vs. Client Side Scripting
What PHP looks like – Basic structure
Setting your development environment up with your testing server
Testing PHP installations in your server
Which servers can use php
Where to write the php code and using which applications
Language Basics
Structure and Syntax
Data Types in PHP
Using Variables and Constants
Processing data using operators
Understanding Arrays
Working with combinations of Data Types, Variables and Arrays
Arrays
Array types
Multi-dimensional arrays
Getting data out of arrays
Array operations
addition
comparing
Counting
Searching
Flipping/Reversing
Deleting elements within an array
More Arrays
Sorting arrays
sort
asort
ksort
natsort
shuffle
key sort
Stacks and Queues
push/pop
shift/unshift
Sets
array_diff
array_intersect
Strings
Escape sequences
Variables and string combined
Escaping literal values
Length
translation
comparison
searching
matching
search and replace
Giving your code life – Control Structures
Conditional decision making – if, else, and elseif
True, false, and evaluation of expressions
Multiple and nested conditions
Short Circuit Evaluation – break and continue
The ‘?’ Operator
Decision making using the switch statement
Iterations using while, do…while, for and for each loops
Iterating through an array
Terminating code using exit, return, and die
Creating Dynamic Web Content
Embedding PHP in Web pages
Retrieving user input through forms, using the GET and POST method
Handling the date and time
Dynamically including code using include and require
mail and php
Cookies
Using PHP’s built-in functions
Mathematical functions
Generating random numbers
Creating custom functions
Why write your own functions
Syntax for defining a function
Variable scope, and the global statement
Adding in function parameters
Return values from functions
Objects and Classes
Basic OOP
Constructors/Destructors
Visibility & Scope
Static
Constants
Introduction to Databases
Why use a database – The three-tier architecture approach
Introducing MySQL and PHPMyAdmin
Understanding the database structure
Creating a simple database
Basic SQL commands
Making PHP and MySQL work for each other
Connecting to the database
Displaying database content through PHP
Inserting and deleting data into the Database
Updating data in the Database
Security considerations
So you wish to know more? Simply enter your details - and we'll contact you back.
Course Materials
We typically supply detailed course notes or a reference text, or in some cases both. Either way, we try to provide sufficient supporting material so that you can return to your work place with sufficient confidence to permit further learning.
We like to look after our customers with:
Luncheon Vouchers are provided so you can get lunch of your choice from one of the many local Cafes. We also provide Chilled water, posh coffee & Tea, biscuits and sweets, sugar and spice and all things nice!
90 DAY Support
There is nothing worse than leaving a course and feeling left on your own. We like to ensure our customers have all the support and backup they need which includes 90 days unlimited support by phone or email, and a free re-sit of the course you attended within 6 months.
You also get
A certificate of completion.
The academy class guarantee
Did you know that Academy Class is also 100% committed to ensuring you understand the concepts we teach in all our classroom-based courses and that you have met the course objectives?
We understand that you rely on us to get a good grasp the key concepts taught in our training. We also realise that if you don’t fully understand the content when you leave, the money and time you’d spend repeating the same course is a cost your business could do without.
We believe that our high-quality training courses will meet and exceed your expectations and enable you learn the concepts you need to know, first time. And we want you to be confident that we’ll support you through your learning experience by proving our commitment to delivering a high-quality & easily-understood course.
That’s why we’ve introduced the Academy Class Guarantee.
Here’s how it works
We make an upfront commitment to you that you’ll be comfortable with what you learn in our classes.
If you don’t feel that you’ve grasped the concepts and can put the training into practice, we invite you to repeat the same course within a six-month period absolutely free of charge*.
Academy Class’s Guarantee, means you can rest assured that if you’re still uncertain about what you’ve learned, you can come back free of charge* and sit the class again. It’s that simple.
*Academy Class Guarantee Terms and Conditions
Guarantee offer is only made to the original person attending a Academy Class classroom training course and is not transferable.
Attendees returning for a repeat sitting of a course must bring their original manual and materials for use on the day.
Bookings for a repeat sitting of a classroom course must be made via the Academy Class Hotline 0800 043 8889 and are subject to availability.
Guarantee offer is valid for 6 months from the date of the original classroom course, after which date it becomes null and void.
Offer is only applicable for one repeat sitting of the same course originally attended.
Cancellation of Course - Academy Class reserves the right to cancel at its sole discretion any particular course. In the event that a specific course is cancelled then participants
enrolled in that course will be transferred to the next available course and notified by Academy Class of the change.
Students should be aware that there is always a chance that they will be “bumped” into the next class if it were to fill up with paying students. Even if you are bumped, we do guarantee that you will be afforded 1 refresher of your training class.
Discounts
At Academy Class, we strive to provide you with high quality training at “value for money” prices. Academy Class has launched some very special and unique training savings plans for its customers. The savings make Academy Class’s training courses for creative’s and developers more affordable and flexible for a wider range of organisations and individuals.
Early Bird
Book in Advance and Get an Early Bird Discount with 30% Off Standard Price*
We’ve looked at the airlines and this seems to work for them so why not training? Book any Academy Class course 3 months in advance and we’ll give you this for 30% less than the standard price.
*(15% off Jumpstart courses. Cannot be used on top of any other discount / offer or with ANY Creative License Package or Off Peak classes)
Group Bookings
Discounts apply to bookings of two or more people from one organisation: 10% off for two people, 15% for three etc.
Training Vouchers
Academy Class vouchers are an effective way to save on your training costs, ensuring the maximum benefit from all training investment. Designed to suit an organisation’s long-term training needs, Vouchers are an excellent opportunity.
Education, Charity & Freelance Discounts
If you work for a charity, educational establishment or work freelance or an independent basis, and are funding your training yourself, you can claim a 15%* discount on any of our open courses.
*(cannot be used on top of any other discount or offer or with any Jumpstart Class, Creative License Package or Off-Peak classes which are already heavily discounted classes)
