This is an example of a simple banner

Training: PHP MySQL Fundamentals

Ref. PHP-01
Duration:
3
 jours
Exam:
Not certifying
Level:
Fondamental

PHP MySql Training

Learn to master the basics of PHP and MySQL development

Do you want to become a skilled PHP developer, capable of creating dynamic applications connected to databases? Our PHP and MySQL training takes you step-by-step, from your first scripts to advanced database management. Through progressive modules, you will learn how to configure a MySQL database, store and retrieve information, while mastering fundamental concepts such as variables, arrays, and much more. This comprehensive course will transform your knowledge into practical skills.

A hands-on training for all levels

Whether you’re a beginner or looking to enhance your skills, this course equips you with the tools to excel in PHP scripting and MySQL database manipulation. You will learn how to design efficient web applications and manage your data effectively.

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

Eligible Funding

ITTA is a partner of a continuing education fund dedicated to temporary workers. This fund can subsidize your training, provided that you are subject to the “Service Provision” collective labor agreement (CCT) and meet certain conditions, including having worked at least 88 hours in the past 12 months.

Additional Information

Master the basics of PHP with our comprehensive training

Our PHP MySQL training guides you step by step to understand and master the fundamentals of the PHP language, whether you are a beginner or already familiar with development. Through a structured and pedagogical journey, you will learn how to set up your work environment and create your first PHP scripts. This training emphasizes simplifying the sometimes complex concepts of PHP MySQL while preparing you for real-world projects.

Understanding and using variables in PHP

In this module, we dive into the use of variables in PHP. You will discover how to manipulate variables and the operators associated with them to perform dynamic operations. This skill is essential for any developer looking to create flexible and customizable applications.

The power of arrays in PHP: from basics to complex structures

Arrays are at the heart of many complex algorithms. Our training explains how to use simple, associative, and multidimensional arrays to structure your data efficiently. We also cover Super Global arrays to optimally interact with data. Understanding these concepts allows you to better manage data within your PHP projects.

Managing conditions and loops for dynamic scripts

A good developer must know how conditions and loops work. You will learn to master complex conditions and different loops (while, for, foreach), enabling you to create interactive PHP scripts adapted to different scenarios of your application.

Creating custom PHP functions

Good code structuring comes through the use of custom functions. This module guides you through creating and optimizing functions in PHP while explaining how to use arguments and return values effectively for reusable and organized scripts.

Working with files on a server

Managing files on a server is a key skill for any PHP developer. You will learn how to read, write, and manipulate CSV files as well as manage files stored on a server securely. This knowledge is essential to develop complete and robust web applications.

Sending emails with PHP

Integrating email sending functionality in PHP is a sought-after skill. This module teaches you how to send plain text or HTML emails directly from your PHP application while managing different formatting and customization options.

Interacting with a MySQL database

Our training also focuses on mastering MySQL, a database widely used with PHP. You will learn how to configure and interact with a database, manage queries, and manipulate records to create complete and dynamic applications.

Deepening PHP classes and objects

This module will help you understand the use of objects in PHP, such as the Date object, strings, and the management of sessions and cookies. These advanced concepts are essential for developing professional and secure PHP applications.

With this PHP MySQL training, you will gain solid skills to master web development, relying on recognized technologies such as PHP and MySQL. Don’t miss this opportunity to take a step forward toward a competent and in-demand developer career.

Prix de l'inscription
CHF 2'150.-
Inclus dans ce cours
  • Training provided by an industry expert
  • Digital documentation and materials
  • Achievement badge
Mois actuel

lun15Sep(Sep 15)09:00mer17(Sep 17)17:00VirtuelVirtual Etiquettes de sessionPHP-01

lun15Sep(Sep 15)09:00mer17(Sep 17)17:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionPHP-01

lun20Oct(Oct 20)09:00mer22(Oct 22)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionPHP-01

lun20Oct(Oct 20)09:00mer22(Oct 22)17:00VirtuelVirtual Etiquettes de sessionPHP-01

lun24Nov(Nov 24)09:00mer26(Nov 26)17:00VirtuelVirtual Etiquettes de sessionPHP-01

lun24Nov(Nov 24)09:00mer26(Nov 26)17:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionPHP-01

lun22Déc(Déc 22)09:00mer24(Déc 24)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionPHP-01

lun22Déc(Déc 22)09:00mer24(Déc 24)17:00VirtuelVirtual Etiquettes de sessionPHP-01

Contact

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Opening hours

Monday to Friday
8:30 AM to 6:00 PM
Tel. 058 307 73 00

Contact-us

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Make a request

Contact

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Opening hours

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

Contact us

Your request