(2 customer reviews)

Php and MySQL: Beginner

£ 797.00 + VAT

What you will learn
ENQUIRE NOW
 

Description

  • DESCRIPTION
  • OUTLINE

This is delivered as a Live Online “Virtual Class” – What is a Virtual Class? More info here

Static Webpages are no longer sufficient for the needs of the Internet in the 21st Century. PHP is a powerful, free server-side language which is relatively easy to learn for those who have never programmed before. Topics covered include:

  • Structure and Syntax
  • Array types
  • Sorting arrays
  • Escape sequences
  • Conditional decision making
  • 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
WHO IS THIS COURSE FOR?

This course is for developers who need to grasp the latest PHP coding conventions and techniques. All the examples are based around the Object Oriented nature of PHP 5.x and best practice is encouraged throughout.

ASSUMED KNOWLEDGE

No previous PHP experience is required, but a good understanding of HTML and CSS will help you get the most from this course. No Javascript or SQL experience is expected, but we do include basic SQL queries and short Javascripts within the main course delivery.

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 & 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 and 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

Worried about COVID-19?

Good News! All of our courses are offered virtually in the comfort of your home or offices.

Academy Class Benefit from the Wisdom

Benefit from the Wisdom

Delivering Quality Training since 2006.

Training Budget Maximised!

Lower Price Match Guarantee & Flexible Training Vouchers

Practical, Cutting-Edge Training

From industry experienced professionals.

Work Faster, Earn More

Reduce your production time by improving all your workflow processes, best practices and shortcuts.

Gain a Competitive Edge

Boost your career by improving your skills and getting Accreditation.

Contact Information

Give Us A Call (United Kingdom)

Give Us A Call (United States)

Email Addresses

General Enquiries: office@academyclass.com

Training Enquires: training@academyclass.com

Support Enquiries: support@academyclass.com

    • DESCRIPTION
    • OUTLINE

    This is delivered as a Live Online “Virtual Class” – What is a Virtual Class? More info here

    Static Webpages are no longer sufficient for the needs of the Internet in the 21st Century. PHP is a powerful, free server-side language which is relatively easy to learn for those who have never programmed before. Topics covered include:

    • Structure and Syntax
    • Array types
    • Sorting arrays
    • Escape sequences
    • Conditional decision making
    • 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
    WHO IS THIS COURSE FOR?

    This course is for developers who need to grasp the latest PHP coding conventions and techniques. All the examples are based around the Object Oriented nature of PHP 5.x and best practice is encouraged throughout.

    ASSUMED KNOWLEDGE

    No previous PHP experience is required, but a good understanding of HTML and CSS will help you get the most from this course. No Javascript or SQL experience is expected, but we do include basic SQL queries and short Javascripts within the main course delivery.

    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 & 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 and 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

    Worried about COVID-19?

    Good News! All of our courses are offered virtually in the comfort of your home or offices.

    Academy Class Benefit from the Wisdom

    Benefit from the Wisdom

    Delivering Quality Training since 2006.

    Training Budget Maximised!

    Lower Price Match Guarantee & Flexible Training Vouchers

    Practical, Cutting-Edge Training

    From industry experienced professionals.

    Work Faster, Earn More

    Reduce your production time by improving all your workflow processes, best practices and shortcuts.

    Gain a Competitive Edge

    Boost your career by improving your skills and getting Accreditation.

    Contact Information

    Give Us A Call (United Kingdom)

    Give Us A Call (United States)

    Email Addresses

    General Enquiries: office@academyclass.com

    Training Enquires: training@academyclass.com

    Support Enquiries: support@academyclass.com

      • DESCRIPTION
      • OUTLINE

      This is delivered as a Live Online “Virtual Class” – What is a Virtual Class? More info here

      Static Webpages are no longer sufficient for the needs of the Internet in the 21st Century. PHP is a powerful, free server-side language which is relatively easy to learn for those who have never programmed before. Topics covered include:

      • Structure and Syntax
      • Array types
      • Sorting arrays
      • Escape sequences
      • Conditional decision making
      • 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
      WHO IS THIS COURSE FOR?

      This course is for developers who need to grasp the latest PHP coding conventions and techniques. All the examples are based around the Object Oriented nature of PHP 5.x and best practice is encouraged throughout.

      ASSUMED KNOWLEDGE

      No previous PHP experience is required, but a good understanding of HTML and CSS will help you get the most from this course. No Javascript or SQL experience is expected, but we do include basic SQL queries and short Javascripts within the main course delivery.

      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 & 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 and 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

      Worried about COVID-19?

      Good News! All of our courses are offered virtually in the comfort of your home or offices.

      Academy Class Benefit from the Wisdom

      Benefit from the Wisdom

      Delivering Quality Training since 2006.

      Training Budget Maximised!

      Lower Price Match Guarantee & Flexible Training Vouchers

      Practical, Cutting-Edge Training

      From industry experienced professionals.

      Work Faster, Earn More

      Reduce your production time by improving all your workflow processes, best practices and shortcuts.

      Gain a Competitive Edge

      Boost your career by improving your skills and getting Accreditation.

      Contact Information

      Give Us A Call (United Kingdom)

      Give Us A Call (United States)

      Email Addresses

      General Enquiries: office@academyclass.com

      Training Enquires: training@academyclass.com

      Support Enquiries: support@academyclass.com

        2 reviews for Php and MySQL: Beginner

        1. Murray Cowell, Belmont Internet Marketing

          I was absolutely delighted with the training and it will make a massive difference to my working life. The application I’m working on at the moment will reduce the time it takes me to convert a Photoshop file into an HTML website by about 50% or more, I reckon. It’s also given me the skills to develop much more sophisticated websites.

        2. Natasha

          Excellent admin and practical teaching. One of the teachers I had wasn’t great – but this was rectified promptly and a suitable solution offered. The next guy was fantastic.

        Add a review

        This site uses Akismet to reduce spam. Learn how your comment data is processed.