Web design, PHP and MySQL

This course teaches you the complete workflow for modern web design with a focus on HTML, CSS and Visual Studio Code as well as the most important basics of PHP and MySQL. You will also learn how artificial intelligence (AI) is used in the profession.
  • Certificates: Certificate "Web design with HTML, CSS and Visual Studio Code"
    Certificate "Basics PHP/MySQL"
  • Examination: Praxisbezogene Projektarbeiten mit Abschlusspräsentationen
  • Teaching Times: Full-time
    Monday to Friday from 8:30 a.m. to 3:35 p.m. (in weeks with public holidays from 8:30 a.m. to 5:10 p.m.)
  • Language of Instruction: German
  • Duration: 12 Weeks

Web design (HTML/CSS/Visual Studio code)

HTML and CSS (approx. 6 days)

HTML introduction

Basic framework

Tags for text creation (h1-h6, p, br, span)

Text format commands

Integrating graphics

Links (internal, external, phone, mailto link)

Favicons

Lists and tables

Correct syntax structure

Checking with W3C validation tool

CSS introduction

Integration options for CSS specifications (internal, external, inline style)

Basic commands (text design, font color, background color)

HTML containers

Use and styling of containers

Integration of YouTube and Google Maps

Video and audio player

Object-fit


VS Code (approx. 1 day)

Introduction to VS Code

Additional extensions for VS Code. (e.g. Live Server, Emmet Commands, Copilot (AI))

AI usage in combination with VS Code


Layout techniques (approx. 4 days)

Classes, IDs, selectors

Introduction box model

Padding, margin, border, border-radius and their shorthands

Flex-Box introduction

Layouts with flex box

Alignment with Flexbox

Introduction to Grid System

Layouts with Grid

Alignment with Grid System

Floating text around images with float and clear

General display properties of tags

Background images


Status and values (approx. 1 day)

Introduction of pseudo-classes (hover, active, focus, nth-child, first-child, last-child)

Pseudo elements (::before, ::after, content)

Specificity (value of codes)


Positioning (approx. 2 days)

Introduction to positions

Static, absolute, fixed, sticky, relative

Left, right, top, bottom, z-index

Dropdown menus

:target

:target in combination with navigation menus and modals


Forms (approx. 2 days)

Introduction to forms

Fieldset, legend

Inputs, textareas, labels, values, name, selects

Autocomplete

Form design with CSS

Integration of php-script in action with AI


Effects and fonts with CSS (approx. 1 day)

CSS transition effects

Transition, filter, transform

Color gradients, box-shadow, text-shadow

Font integration with @font-face


Responsive web design (approx. 2 days)

Introduction to responsive design

Media queries, breakpoints

Landscape, portait mode

Responsive images with picture and srcsets

Image editing, compression of images

Generating images with AI


Search engine optimization (approx. 1 day)

Introduction to SEO

On-page optimization and use of AI-generated texts

Performance optimization to improve SEO and presentation of suitable tools


CSS techniques and interaction (approx. 2 days)

CSS variables

Dark mode

Calculation with CSS

Introduction to CSS animations

Duration, delay, direction, timing-function, iteration-count, fill-mode

Animated burger button


One-pager and multilingualism (approx. 2 days)

Introduction One-Pager

Smooth-scroll

Integration of fontawesome library

Dealing with SVG graphics

Layer integration and CSS customization

Multilingual websites


Extensions and frameworks (approx. 1 day)

Introduction to Bootstrap

Use of Bootstrap components

Responsive design with Bootstrap


JavaScript (approx. 3 days)

Introduction to JavaScript

JavaScript/jQuery methods

Create jQuery Lightbox

Variables

If-else statements

Scroll, window, resize

arrays

For-loop

Math object


Legal requirements and project management (approx. 2 days)

Internet law

Copyrights in relation to AI/KI

Accessibility

Project management


Project work (approx. 10 days)

To consolidate the content learned

Presentation of the project results

Basics PHP/MySQL

Basics of PHP development (approx. 5 days)

Setting up a modern development environment

Introduction to Docker for local development

Overview of IDE tools (Visual Studio Code, PhpStorm, etc.)

Git workflow

PHP syntax and basic concepts

Variables, data types, constants

Arrays and strings (incl. new functions in PHP 8.x)

Expressions, operators, control structures

Functions, anonymous functions and closures

PHP 8.x innovations

Union types and named arguments

Introduction to attributes

Composer and package management

PSR standards


Artificial intelligence (AI) in the work process

Presentation of specific AI technologies

and possible applications in the professional environment


Web development and interactivity (approx. 3 days)

HTTP and form processing

GET and POST requests

Dealing with cookies and sessions

Validation and sanitization of user input

Dynamic content and interactivity

Output of dynamic content (e.g. user forms, calculation tasks)

AJAX and JSON-based interaction

Security and error handling

Protection against XSS, CSRF and SQL injection

Error logging and debugging (with tools such as Xdebug)


Working with databases (approx. 4 days)

SQL and database basics

Basic principles of relational databases and MySQL

Database design and normalization

PHP and database integration

PDO connection and secure SQL queries

Simple CRUD operations with MySQL

Input and output of database content on websites

NoSQL databases and modern storage solutions

Alternative storage with Redis (caching, sessions)


PHP frameworks (approx. 3 days)

Introduction to modern PHP frameworks

Laravel: Introduction, routing, controllers and views

Advantages of using PHP frameworks (e.g. code reusability, security, modularity)

Tools for modern PHP development

Introduction to CI/CD pipelines (e.g. GitHub Actions, GitLab CI)

Use of Docker for the deployment of PHP applications

Architecture classification: monolith vs. microservices


Project preparation and planning (approx. 2 days)

Planning a PHP project

Structuring and creating a schedule for the project work


Project work (approx. 4 days)

To consolidate the content learned

Presentation of the project results



Changes are possible. The course content is updated regularly.

You know the complete workflow for a modern web design and produce user-friendly and sophisticated websites.

Once you have completed the course, you will also have mastered the basics of the PHP scripting language and the MySQL database system.

Web designers, web programmers, graphic designers, media designers, specialists from artistic professions or people who are responsible for the conception, design and practical implementation of websites and want to acquire the necessary knowledge and skills.

Nowadays, almost all companies rely on an attractive Internet presence to represent them as a company. The main potential employers are graphic design, advertising, web, multimedia or full-service agencies, as well as software and database providers. Web design skills are required in almost all sectors. With the appropriate know-how, self-employment is also an interesting prospect.

Your meaningful certificate provides a detailed insight into the qualifications you have acquired and improves your career prospects.

Didactic concept

Your lecturers are highly qualified both professionally and didactically and will teach you from the first to the last day (no self-study system).

You will learn in effective small groups. The courses usually consist of 6 to 25 participants. The general lessons are supplemented by numerous practical exercises in all course modules. The practice phase is an important part of the course, as it is during this time that you process what you have just learned and gain confidence and routine in its application. The final section of the course involves a project, a case study or a final exam.

 

Virtual classroom alfaview®

Lessons take place using modern alfaview® video technology - either from the comfort of your own home or at our premises at Bildungszentrum. The entire course can see each other face-to-face via alfaview®, communicate with each other in lip-sync voice quality and work on joint projects. Of course, you can also see and talk to your connected trainers live at any time and you will be taught by your lecturers in real time for the entire duration of the course. The lessons are not e-learning, but real live face-to-face lessons via video technology.

 

The courses at alfatraining are funded by Agentur für Arbeit and are certified in accordance with the AZAV approval regulation. When submitting a Bildungsgutscheinor Aktivierungs- und Vermittlungsgutschein, the entire course costs are usually covered by your funding body.
Funding is also possible via Europäischen Sozialfonds (ESF), Deutsche Rentenversicherung (DRV) or regional funding programs. As a regular soldier, you have the option of attending further training courses via Berufsförderungsdienst (BFD). Companies can also have their employees qualified via funding from Agentur für Arbeit (Qualifizierungschancengesetz).

We will gladly advise you free of charge.

0800 3456-500 Mon. - Fri. from 8 am to 5 pm
free of charge from all German networks.

Contact

We will gladly advise you free of charge. 0800 3456-500 Mon. - Fri. from 8 am to 5 pm free of charge from all German networks.