Training: PHP MySQL Fundamentals

Ref. PHP-01
Duration:
3
 days
Exam:
Not certifying
Level:
Fundamental

Description

Designed to provide beginner programmers with a solid foundation in the PHP language, this course guides you through the basics of PHP with an experiential approach. PHP Fundamentals course provides you with an overview of the PHP language, main concepts, and helps you develop and adopt the methodologies and best practices of coding professionally in PHP.

Participant profiles

  • Non programmers and beginners with less than 6-12 months of software development experience who want to learn the basics of the PHP language
  • Web designers who intend to learn the basics of professional web programming and become PHP Developers would benefit from this course

Objectives

  • Understand the syntax and structural elements of PHP
  • Know how to correctly apply the various control-flow structures
  • Understand PHP data types, type-juggling, and operator precedence
  • Organize code into reusable functions
  • Accomplish tasks using PHP’s wealth of built-in file system and array functions
  • Understand essential elements of HTTP such as cookies and sessions
  • Understand the basics of validating input and escaping output
  • Build forms to collect information from a user
  • Interact with a database using PHP’s MySQL functions

Prerequisites

  • Basic knowledge of HTML
  • Some familiarity with web sites – what they are and the very basics of how they work – but no programming experience

Course content

Module 1: Your First PHP Scripts
  • Lesson 1: Setting up your Environment
  • Lesson 2: Understand PHP development workflow
  • Lesson 3: Writing your first scripts
  • Lesson 4: Echo, print() and printf()
Module 2: Variables
  • Lesson 1: Introducing variables
  • Lesson 2: Variable operators
Module 3: Arrays
  • Lesson 1: Declaring simple PHP arrays
  • Lesson 2: Associative arrays
  • Lesson 3: Multidimensional arrays
  • Lesson 4: Super Global arrays
Module 4: Conditionals
  • Lesson 1: Simple conditionals
  • Lesson 2: Complex conditionals
  • Lesson 3: Switch/Case/Break
  • Lesson 4: Ternary cperator
Module 5: Loops
  • Lesson 1: While… Do While Loop
  • Lesson 2: For loops
  • Lesson 3: Foreach loops
Module 6: Custom PHP Functions
  • Lesson 1: Includes
  • Lesson 2: Creating a simple function
  • Lesson 3: Function arguments
  • Lesson 4: The return statement
Module 7: Server File I/O
  • Lesson 1: Saving files on the server
  • Lesson 2: Reading files on the server
  • Lesson 3: Append and delete
  • Lesson 4: CSV files
Module 8 : Sending email with PHP
  • Lesson 1: Sending text e-mail
  • Lesson 2: Sending HTML e-mail
Module 9 : Working with the mySQL Database
  • Lesson 1: Setting up the database
  • Lesson 2: Retrieving a query from the database
  • Lesson 3: Storing information in the database
  • Lesson 4: Deleting and updating database records
  • Lesson 5: Complex queries
Module 10: Useful PHP classes and objects
  • Lesson 1: Date object
  • Lesson 2: Strings in PHP
  • Lesson 3: sessions
  • Lesson 4: cookies

Documentation

  • Digital courseware included

Lab / Exercises

  • During the course participants are encouraged to actively participate in the learning experience by running example files during lectures and performing coding challenges during labs.
  • Each lab session allows you to compare your solution to the instructor’s

Complementary courses

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.
Prix de l'inscription
CHF 2'150.-
Inclus dans ce cours
  • Training provided by an industry expert
  • Digital documentation and materials
  • Achievement badge

lun08Avr(Avr 8)09:00mer10(Avr 10)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionPHP-01

lun08Avr(Avr 8)09:00mer10(Avr 10)17:00VirtuelVirtual Etiquettes de sessionPHP-01

lun13Mai(Mai 13)09:00mer15(Mai 15)17:00VirtuelVirtual Etiquettes de sessionPHP-01

lun13Mai(Mai 13)09:00mer15(Mai 15)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionPHP-01

lun17Juin(Juin 17)09:00mer19(Juin 19)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionPHP-01

lun17Juin(Juin 17)09:00mer19(Juin 19)17:00VirtuelVirtual Etiquettes de sessionPHP-01

lun22juil(juil 22)09:00mer24(juil 24)17:00VirtuelVirtual Etiquettes de sessionPHP-01

lun22juil(juil 22)09:00mer24(juil 24)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionPHP-01

lun26Aoû(Aoû 26)09:00mer28(Aoû 28)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionPHP-01

lun26Aoû(Aoû 26)09:00mer28(Aoû 28)17:00VirtuelVirtual Etiquettes de sessionPHP-01

lun30Sep(Sep 30)09:00mer02Oct(Oct 2)17:00VirtuelVirtual Etiquettes de sessionPHP-01

lun30Sep(Sep 30)09:00mer02Oct(Oct 2)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionPHP-01

lun04Nov(Nov 4)09:00mer06(Nov 6)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionPHP-01

lun04Nov(Nov 4)09:00mer06(Nov 6)17:00VirtuelVirtual Etiquettes de sessionPHP-01

lun09Déc(Déc 9)09:00mer11(Déc 11)17:00VirtuelVirtual Etiquettes de sessionPHP-01

lun09Déc(Déc 9)09:00mer11(Déc 11)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionPHP-01

Horaires d’ouverture

Du lundi au vendredi, de 8:30 à 18:00.

Contactez-nous

Votre demande

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request

X
X
X
X