×
1 Choose EITC/EITCA Certificates
2 Learn and take online exams
3 Get your IT skills certified

Confirm your IT skills and competencies under the European IT Certification framework from anywhere in the world fully online.

EITCA Academy

Digital skills attestation standard by the European IT Certification Institute aiming to support Digital Society development

LOG IN TO YOUR ACCOUNT

CREATE AN ACCOUNT FORGOT YOUR PASSWORD?

FORGOT YOUR PASSWORD?

AAH, WAIT, I REMEMBER NOW!

CREATE AN ACCOUNT

ALREADY HAVE AN ACCOUNT?
EUROPEAN INFORMATION TECHNOLOGIES CERTIFICATION ACADEMY - ATTESTING YOUR PROFESSIONAL DIGITAL SKILLS
  • SIGN UP
  • LOGIN
  • INFO

EITCA Academy

EITCA Academy

The European Information Technologies Certification Institute - EITCI ASBL

Certification Provider

EITCI Institute ASBL

Brussels, European Union

Governing European IT Certification (EITC) framework in support of the IT professionalism and Digital Society

  • CERTIFICATES
    • EITCA ACADEMIES
      • EITCA ACADEMIES CATALOGUE<
      • EITCA/CG COMPUTER GRAPHICS
      • EITCA/IS INFORMATION SECURITY
      • EITCA/BI BUSINESS INFORMATION
      • EITCA/KC KEY COMPETENCIES
      • EITCA/EG E-GOVERNMENT
      • EITCA/WD WEB DEVELOPMENT
      • EITCA/AI ARTIFICIAL INTELLIGENCE
    • EITC CERTIFICATES
      • EITC CERTIFICATES CATALOGUE<
      • COMPUTER GRAPHICS CERTIFICATES
      • WEB DESIGN CERTIFICATES
      • 3D DESIGN CERTIFICATES
      • OFFICE IT CERTIFICATES
      • BITCOIN BLOCKCHAIN CERTIFICATE
      • WORDPRESS CERTIFICATE
      • CLOUD PLATFORM CERTIFICATENEW
    • EITC CERTIFICATES
      • INTERNET CERTIFICATES
      • CRYPTOGRAPHY CERTIFICATES
      • BUSINESS IT CERTIFICATES
      • TELEWORK CERTIFICATES
      • PROGRAMMING CERTIFICATES
      • DIGITAL PORTRAIT CERTIFICATE
      • WEB DEVELOPMENT CERTIFICATES
      • DEEP LEARNING CERTIFICATESNEW
    • CERTIFICATES FOR
      • EU PUBLIC ADMINISTRATION
      • TEACHERS AND EDUCATORS
      • IT SECURITY PROFESSIONALS
      • GRAPHICS DESIGNERS & ARTISTS
      • BUSINESSMEN AND MANAGERS
      • BLOCKCHAIN DEVELOPERS
      • WEB DEVELOPERS
      • CLOUD AI EXPERTSNEW
  • FEATURED
  • SUBSIDY
  • HOW IT WORKS
  •   IT ID
  • ABOUT
  • CONTACT
  • MY ORDER
    Your current order is empty.
EITCIINSTITUTE
CERTIFIED

EITC/WD/PMSF PHP and MySQL Fundamentals

by EITCA Academy / Tuesday, 02 February 2021 / Published in

Current Status

Not Enrolled
Enroll in this programme to get access

Price

€110.00

Get Started

Enrol for this Certification

EITC/WD/PMSF PHP and MySQL Fundamentals is the European IT Certification programme on the fundamentals of the PHP: Hypertext Preprocessor and the MySQL, an open-source Relational Database Management System, which constitute basic technologies for the dynamic web pages generation and the technology of Content Management Systems (CMS).

The curriculum of the EITC/WD/PMSF PHP and MySQL Fundamentals focuses on practical skills in PHP and MySQL for dynamic web sites development organized within the following structure, encompassing comprehensive and structured EITCI certification curriculum self-learning materials supported by referenced open-access video didactic content as a basis for preparation towards earning this EITC Certification by passing a corresponding examination.

PHP and MySQL are considered standard competences for dynamic web sites developers. PHP as a scripting language is commonly used to generate dynamic content of websites by working with a server’s web site database. The most common relational database management system is an open-source system called MySQL. Majority of web sites on Internet is run by the pair of these two technologies (additionaly powered by Linux open-source operating system and the open-source Apache web server, together making a LAMP technology stack: Linux-Apache-MySQL-PHP, powering most of the most), with most popular Content Management Systems (CMS) also programmed in PHP and MySQL. All professional web developers should be proficient with both PHP and MySQL technologies.

PHP is a general-purpose scripting language especially suited to web development. It was originally created by Danish-Canadian programmer Rasmus Lerdorf in 1994. The PHP reference implementation is now produced by the PHP Group. PHP originally stood for Personal Home Page, but it now stands for the recursive initialism PHP: Hypertext Preprocessor. PHP code is usually processed on a web server by a PHP interpreter implemented as a module, a daemon or as a Common Gateway Interface (CGI) executable. On a web server, the result of the interpreted and executed PHP code – which may be any type of data, such as generated HTML or binary image data – would form the whole or part of an HTTP response. Various web template systems, web content management systems, and web frameworks exist which can be employed to orchestrate or facilitate the generation of that response. Additionally, PHP can be used for many programming tasks outside of the web context, such as standalone graphical applications and robotic drone control. Arbitrary PHP code can also be interpreted and executed via command-line interface (CLI). The standard PHP interpreter, powered by the Zend Engine, is free software released under the PHP License. PHP has been widely ported and can be deployed on most web servers on almost every operating system and platform, free of charge. The PHP language evolved without a written formal specification or standard until 2014, with the original implementation acting as the de facto standard which other implementations aimed to follow. Since 2014, work has gone on to create a formal PHP specification.

MySQL is an open-source relational database management system (RDBMS). Its name is a combination of My, the name of co-founder Michael Widenius’s daughter, and SQL, the abbreviation for Structured Query Language. A relational database organizes data into one or more data tables in which data types may be related to each other; these relations help structure the data. SQL is a language programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a relational database in a computer’s storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups. MySQL is free and open-source software under the terms of the GNU General Public License, and is also available under a variety of proprietary licenses. MySQL was owned and sponsored by the Swedish company MySQL AB, which was bought by Sun Microsystems (now Oracle Corporation). In 2010, when Oracle acquired Sun, Widenius forked the open-source MySQL project to create MariaDB. MySQL has stand-alone clients that allow users to interact directly with a MySQL database using SQL, but more often MySQL is used with other programs to implement applications that need relational database capability. MySQL is a component of the LAMP web application software stack (and others), which is an acronym for Linux, Apache, MySQL, Perl/PHP/Python. MySQL is used by many database-driven web applications, including Drupal, Joomla, phpBB, and WordPress. MySQL is also used by many popular websites, including Facebook, Twitter or YouTube.

To acquaint yourself in-detail with the certification curriculum you can expand and analyze the table below.

The EITC/WD/PMSF PHP and MySQL Fundamentals Certification Curriculum references open-access didactic materials in a video form. Learning process is divided into a step-by-step structure (programmes -> lessons -> topics) covering relevant curriculum parts. Participants can access answers and ask more relevant questions in the Questions and answers section of the e-learning interface under currently progressed EITC programme curriculum topic. Direct and unlimited consultancy with domain experts is also accessible via the platform integrated online messaging system, as well as through the contact form.
For details on the Certification procedure check How it Works.

Curriculum Reference Resources

PHP Manual
https://www.php.net/manual/en/

PHP Official Releases
https://www.php.net/downloads

W3Schools PHP Tutorial
https://www.w3schools.com/php/

MySQL Documentation
https://dev.mysql.com/doc/

MariaDB Documentation
https://mariadb.org/documentation/

W3Schools SQL Tutorial
https://www.w3schools.com/sql/

Visual Studio Code editor
https://code.visualstudio.com/

XAMPP Apache + MariaDB + PHP + Perl
https://www.apachefriends.org/index.html

Exemplary files for the curriculum reference lessons
https://github.com/iamshaunjp/php-mysql-tutorial/

Download the complete offline self-learning preparatory materials for the EITC/WD/PMSF PHP and MySQL Fundamentals programme in a PDF file

PDF Icon EITC/WD/PMSF preparatory materials – standard version

PDF Icon EITC/WD/PMSF preparatory materials – extended version with review questions

Certification Programme Curriculum

Introduction 1 Topic
You don't currently have access to this content
Lesson Content
0% Complete 0/1 Steps
Reasons to learn PHP
Getting started with PHP 2 Topics
You don't currently have access to this content
Lesson Content
0% Complete 0/2 Steps
Installing PHP (XAMPP)
Your first PHP file
PHP data structures 5 Topics
You don't currently have access to this content
Lesson Content
0% Complete 0/5 Steps
Variables and constants
Strings
Numbers
Arrays
Multidimensional arrays
PHP procedures and functions 5 Topics
You don't currently have access to this content
Lesson Content
0% Complete 0/5 Steps
Loops
Booleans and comparisons
Conditional statements
Continue and break
Functions
Advancing in PHP 3 Topics
You don't currently have access to this content
Lesson Content
0% Complete 0/3 Steps
Variable scope
Include and require
Project header and footer
Forms in PHP 4 Topics
You don't currently have access to this content
Lesson Content
0% Complete 0/4 Steps
Working withs forms in PHP
XSS attacks
Basic form validation
Filters and advanced validation
Errors handling in PHP 2 Topics
You don't currently have access to this content
Lesson Content
0% Complete 0/2 Steps
Showing errors
Checking for errors and redirecting
Getting started with MySQL 4 Topics
You don't currently have access to this content
Lesson Content
0% Complete 0/4 Steps
Introduction to MySQL
Setting up a MySQL database
Connecting to a database
Getting data from a database
Further advancing in PHP 3 Topics
You don't currently have access to this content
Lesson Content
0% Complete 0/3 Steps
Rendering data to the browser
The explode function
Control flow alt syntax
Advancing with MySQL 3 Topics
You don't currently have access to this content
Lesson Content
0% Complete 0/3 Steps
Saving data to the database
Getting a single record
Deleting a record
Expertise in PHP 6 Topics
You don't currently have access to this content
Lesson Content
0% Complete 0/6 Steps
Design elements
Ternary operators
Superglobals
Sessions
Null coalescing
Cookies
Working with files in PHP 2 Topics
You don't currently have access to this content
Lesson Content
0% Complete 0/2 Steps
File system – part 1
File system – part 2
Classes and objectes in PHP 2 Topics
You don't currently have access to this content
Lesson Content
0% Complete 0/2 Steps
Classes and objects – part 1
Classes and objects – part 2
EITC/WD/PMSF PHP and MySQL Fundamentals
You don't currently have access to this content
Home » My Account

Certification Center

Programme Home
Introduction
Reasons to learn PHP
Getting started with PHP
Installing PHP (XAMPP)
Your first PHP file
PHP data structures
Variables and constants
Strings
Numbers
Arrays
Multidimensional arrays
PHP procedures and functions
Loops
Booleans and comparisons
Conditional statements
Continue and break
Functions
Advancing in PHP
Variable scope
Include and require
Project header and footer
Forms in PHP
Working withs forms in PHP
XSS attacks
Basic form validation
Filters and advanced validation
Errors handling in PHP
Showing errors
Checking for errors and redirecting
Getting started with MySQL
Introduction to MySQL
Setting up a MySQL database
Connecting to a database
Getting data from a database
Further advancing in PHP
Rendering data to the browser
The explode function
Control flow alt syntax
Advancing with MySQL
Saving data to the database
Getting a single record
Deleting a record
Expertise in PHP
Design elements
Ternary operators
Superglobals
Sessions
Null coalescing
Cookies
Working with files in PHP
File system – part 1
File system – part 2
Classes and objectes in PHP
Classes and objects – part 1
Classes and objects – part 2
EITC/WD/PMSF PHP and MySQL Fundamentals

USER MENU

  • My Account

CERTIFICATE CATEGORY

  • EITC Certification (105)
  • EITCA Certification (9)

What are you looking for?

  • Introduction
  • How it works?
  • EITCA Academies
  • EITCI DSJC Subsidy
  • Full EITC catalogue
  • Your order
  • Featured
  •   IT ID
  • EITCA reviews (Medium publ.)
  • About
  • Contact

EITCA Academy is a part of the European IT Certification framework

The European IT Certification framework has been established in 2008 as a Europe based and vendor independent standard in widely accessible online certification of digital skills and competencies in many areas of professional digital specializations. The EITC framework is governed by the European IT Certification Institute (EITCI), a non-profit certification authority supporting information society growth and bridging the digital skills gap in the EU.

Eligibility for EITCA Academy 80% EITCI DSJC Subsidy support

80% of EITCA Academy fees subsidized in enrolment by

    EITCA Academy Secretary Office

    European IT Certification Institute ASBL
    Brussels, Belgium, European Union

    EITC / EITCA Certification Framework Operator
    Governing European IT Certification Standard
    Access contact form or call +32 25887351

    Follow EITCI on X
    Visit EITCA Academy on Facebook
    Engage with EITCA Academy on LinkedIn
    Check out EITCI and EITCA videos on YouTube

    Funded by the European Union

    Funded by the European Regional Development Fund (ERDF) and the European Social Fund (ESF) in series of projects since 2007, currently governed by the European IT Certification Institute (EITCI) since 2008

    Information Security Policy | DSRRM and GDPR Policy | Data Protection Policy | Record of Processing Activities | HSE Policy | Anti-Corruption Policy | Modern Slavery Policy

    Automatically translate to your language

    Terms and Conditions | Privacy Policy
    EITCA Academy
    • EITCA Academy on social media
    EITCA Academy


    © 2008-2025  European IT Certification Institute
    Brussels, Belgium, European Union

    TOP
    Chat with Support
    Chat with Support
    Questions, doubts, issues? We are here to help you!
    End chat
    Connecting...
    Do you have any questions?
    Do you have any questions?
    :
    :
    :
    Send
    Do you have any questions?
    :
    :
    Start Chat
    The chat session has ended. Thank you!
    Please rate the support you've received.
    Good Bad