×
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 BY EITHER YOUR USERNAME OR EMAIL ADDRESS

CREATE AN ACCOUNT FORGOT YOUR PASSWORD?

FORGOT YOUR DETAILS?

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 Authority

EITCI Institute

Brussels, European Union

Governing European IT Certification (EITC) standard 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 admin / Tuesday, 02 February 2021 / Published in Uncategorized
Current Status
Not Enrolled
Price
€110
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 video didactic content as a reference for this EITC Certification.

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. Unlimited consultancy with domain experts are also provided.
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/

Certification Programme Curriculum

Expand All
Introduction 1 Topic
Expand
Lesson Content
0% Complete 0/1 Steps
Reasons to learn PHP
Getting started with PHP 2 Topics
Expand
Lesson Content
0% Complete 0/2 Steps
Installing PHP (XAMPP)
Your first PHP file
PHP data structures 5 Topics
Expand
Lesson Content
0% Complete 0/5 Steps
Variables and constants
Strings
Numbers
Arrays
Multidimensional arrays
PHP procedures and functions 5 Topics
Expand
Lesson Content
0% Complete 0/5 Steps
Loops
Booleans and comparisons
Conditional statements
Continue and break
Functions
Advancing in PHP 3 Topics
Expand
Lesson Content
0% Complete 0/3 Steps
Variable scope
Include and require
Project header and footer
Forms in PHP 4 Topics
Expand
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
Expand
Lesson Content
0% Complete 0/2 Steps
Showing errors
Checking for errors and redirecting
Getting started with MySQL 4 Topics
Expand
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
Expand
Lesson Content
0% Complete 0/3 Steps
Rendering data to the browser
The explode function
Control flow alt syntax
Advancing with MySQL 3 Topics
Expand
Lesson Content
0% Complete 0/3 Steps
Saving data to the database
Getting a single record
Deleting a record
Expertise in PHP 6 Topics
Expand
Lesson Content
0% Complete 0/6 Steps
Design elements
Ternary operators
Superglobals
Sessions
Null coalescing
Cookies
Working with files in PHP 2 Topics
Expand
Lesson Content
0% Complete 0/2 Steps
File system – part 1
File system – part 2
Classes and objectes in PHP 2 Topics
Expand
Lesson Content
0% Complete 0/2 Steps
Classes and objects – part 1
Classes and objects – part 2
EITC/WD/PMSF PHP and MySQL Fundamentals
  • Tweet

About admin

Home » My Account

Certification Center

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

USER MENU

  • My Bookings

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
  • About
  • Contact

Eligibility for EITCA Academy 80% EITCI DSJC Subsidy support

80% of EITCA Academy fees subsidized in enrolment by 8/2/2023

    EITCA Academy Administrative Office

    European IT Certification Institute
    Brussels, Belgium, European Union

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

    13 hours agoThe #EITC/IS/QCF Quantum Cryptography Fundamentals (part of #EITCA/IS) attests expertise in #QKD, #BB84, #B92 and… https://t.co/YCcJMB537X
    Follow @EITCI

    Automatically translate to your language

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


    © 2008-2023  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 a question? Ask us!
    Do you have a question? Ask us!
    :
    :
    :
    Send
    Do you have a question? Ask us!
    :
    :
    Start Chat
    The chat session has ended. Thank you!
    Please rate the support you've received.
    Good Bad