EITC/WD/PMSF PHP and MySQL Fundamentals

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

Current Status

Price

€110.00

Get Started

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
EITC/WD/PMSF preparatory materials – standard version
EITC/WD/PMSF preparatory materials – extended version with review questions