-
Certificates: Certificate "Basics PHP/MySQL"
-
Additional Certificates: Certificate "Content Management Systems (CMS) with Wordpress"
-
Examination: Praxisbezogene Projektarbeiten mit Abschlusspräsentationen
-
Teaching Times: Full-timeMonday 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: 8 Weeks
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
Content management systems (CMS) with WordPress
Getting Started with WordPress (approx. 4 days)
WordPress.com vs. WordPress.org
Web Hosting and Providers (e.g., LocalWP)
Folder Structures and Databases
Frontend and Backend – Managing, Sorting, and Filtering Objects
Creating and maintaining blog posts
Page Types, Website Structure, Categories
Media management and editing
Comment feature, spam protection
Block Editor, Classic Editor, and HTML Editor
Blocks (design, media, widgets, external content)
Security Basics: Updates, Password Protection
AI in the Workflow (approx. 1 day)
AI-generated text, meta descriptions, and images
AI assistants in plugins and page builders
Copyright, Data Protection, Quality Control
WordPress Themes and Responsive Design (approx. 3 days)
Criteria for Selecting Themes
Free vs. Paid Themes
Web Design Basics (Typography, Colors)
HTML and CSS Basics
Block Themes (Site Editor, theme.json, Global Styles)
Child Themes and Custom CSS
Classic Themes (Customizer, Menus, Widgets)
Implementing Complex, Responsive Layouts
Implementing an Accessible Layout: Contrast, Alt Text, Semantic HTML
AI-powered layout and image optimization
Functionality Expansion with Plugins (approx. 2 days)
Installing and managing plugins
Selection criteria: Up-to-date, ratings, compatibility
Popular Categories: Forms, SEO Tools, Security Plugins
Page builder plugins
AI plugins: chatbots, text/image generation
Website Administration and WooCommerce (approx. 5 days)
SEO/SEA Strategies
Multilingual Websites
User Management and Role Concepts
Legal Notice and Privacy Policy (GDPR)
Legal Obligations for Online Stores: BFSG, Accessibility Statement, Risks of Fines
System Administration, Security, Performance
Analytics and Tracking (e.g., Google Analytics, Matomo)
Backups
Online Store Planning and Configuration
Product Setup (Categories, Variants, Images, etc.)
Payment, Shipping, Taxes
Order Processing
Woo Themes and Their Customization
AI-powered product descriptions
Project Work (approx. 5 days)
Preparation of a project paper followed by a presentation of the project results
Changes are possible, the course content is updated regularly.
Once you have completed the course, you will have mastered the basics of the PHP scripting language and the MySQL database system.
In addition, you are proficient in using the WordPress content management system and the WooCommerce e-commerce platform, and you are able to install and manage a fully functional website that includes an online store, a news blog, and appropriate plugins, create page structures with static and dynamic content, and design modern, responsive web layouts.
This course is designed for web designers, web programmers, and professionals in related IT fields who play a key role in the conception, design, and practical implementation of websites and who wish to acquire the necessary skills and basic programming knowledge for these tasks.
Media designers, graphic designers, web designers, social media and online marketing managers, professionals in editorial, journalism, or creative fields, as well as individuals who play a key role in the conception, design, and practical implementation of websites and who wish 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.
With additional knowledge of WordPress, you will have knowledge of one of the most widespread WCMS, which is frequently used in online marketing in particular.
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).