-
Certificates: Certificate "Backend Developer"
Certificate "PCEP™ - Certified Entry-Level Python Programmer" -
Additional Certificates: JavaScript Developer" certificate
Certified PHP Developer" certificate
Certificate "Relational Databases SQL" -
Examination: Praxisbezogene Projektarbeiten mit Abschlusspräsentationen
Certified PHP Developer
Certified Entry-Level Python Programmer (PCEP™) (in englischer Sprache) -
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: 24 Weeks
JavaScript Developer
JavaScript Basics (approx. 7 days)
Introduction to
ECMA script versions
Integration into HTML pages
Language elements: variables, constants, typing
Primitive data types: Number, String, Boolean
Collection data types: Arrays, objects, arithmetic operators
Control structures: Conditional statements, loops, functions
Blockscope
Local storage: Webstorage, IndexedDB
Error handling
Introduction to the WebStorm development environment (IDE)
Artificial intelligence (AI) in the work process
Presentation of specific AI technologies
and possible applications in the professional environment
DOM manipulation with JavaScript (approx. 4 days)
basics
Selecting HTML
Content and attributes
styling
Events, event object, bubbling
Observer
- Intersection observer
- Mutation observer
Create, copy, move, delete DOM elements
AJAX (approx. 1 day)
Introduction to
Functionality
Prerequisites
HTTP requests
XMLHttpRequest object
Web services
- JSON
- XML
Frameworks/Libraries (approx. 2 days)
Create your own library
jQuery
Using jQuery and Ajax in WebStorm
Project work (approx. 6 days)
To consolidate the content learned
Presentation of the project results
JavaScript deepening (approx. 7 days)
Canvas, drawing, animating
Array methods, copy by reference
Spread syntax, destructuring
Creating objects with constructors, classes, factories
Getters and setters, static methods
Fields, private fields, alternatives
Inheritance of classes
Prototyping
Map and set data types
Promise, concatenation, async-await syntax
ES6 import
Webworker
NodeJS (approx. 4 days)
Structure and installation
Built-in modules, custom modules, NPM
Upload to NPM
File type MD
Create web server (Express)
Own middleware
Fetch syntax for AJAX requests
Upload files to server
Real-time communication with websockets
Communication with database (noSQL)
Single Page Application (approx. 3 days)
ReactJS:
- Introduction, theoretical consideration, installation
- Virtual DOM
- Expressions, state hook, effect hook
- Components, nesting, parameter passing
- User input, content update, event listener
- Routing
VueJS:
- Introduction, theoretical consideration
- Virtual DOM
- Integration, expressions, directives
- Event listeners, data binding, methods
- Custom directives
- Components, nesting
- Routing
Web components:
- Advantages and disadvantages
- Custom Elements, Shadow DOM
- Integration of HTML templates and CSS
files
- Transfer of parameters, slots, attributes
- Create and call custom events
Project work (approx. 6 days)
To consolidate the content learned
Presentation of the project results
PHP Developer: Object orientation and Laravel framework
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
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
PHP Frameworks (approx. 2 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
Project preparation and planning (approx. 1 day)
Planning a PHP project
Structuring and creating a schedule for the project work
Project work (approx. 1 day)
To consolidate the content learned
Presentation of the project results
Object-oriented programming (approx. 5 days)
Basics of OOP in PHP 8.x (classes, objects, methods, properties)
Constructor property promotion, attributes, union types
Inheritance, polymorphism, interfaces, traits
SOLID principles and dependency injection
Unit tests with PHPUnit
Exception handling and debugging
Use of a modern framework (Laravel) (approx. 5 days)
Introduction to Laravel
Routing, controllers, blade templates
Eloquent ORM and database migrations
RESTful API development
Caching and performance optimization
Create a sample website (approx. 5 days)
Planning and implementing a modern web application
Integration of APIs and front-end frameworks
Responsive design with Tailwind CSS or Bootstrap
Deployment with Docker
Project work, certification preparation and certification exam "Certified PHP Developer" (approx. 5 days)
Relational databases with SQL
Basics of database systems and SQL (approx. 3 days)
Overview of database systems and models
Redundant data and data integrity
Normalization and BCNF
Database design and entity relationship model (ERM)
Primary and foreign keys
Relationships between relations
Data types in SQL
Indexes and performance
Constraints and validation
Queries (SQL)
Forms and reports in modern DBMS
Circular reference and dependency management
Introduction to SQL Server Management Studio (SSMS) (approx. 2 days)
Overview of SQL Server and SSMS
Physical database design
Creating tables and defining data types
Constraints, default values and relationships
Database diagrams and relationships
Backup and restore
Artificial intelligence (AI) in the work process
Presentation of specific AI technologies
and possible applications in the professional environment
Introduction to DDL (Data Definition Language) (approx. 8 days)
SQL basics and advanced syntax
Creating tables and defining constraints
Operators and function definitions
Queries and manipulation of data
Error handling and transaction management
DCL - Data Control Language and Security (approx. 1 day)
User administration and authorizations
Roles, authorizations and auditing
Data types, data import and export in modern systems (approx. 1 day)
Data import and export
Modern data types
Project work (approx. 5 days)
To consolidate the content learned
Presentation of the project results
Programming with Python
Python basics (approx. 1 day)
History, concepts
Usage and areas of application
syntax
Lexis, semantics
PEP-8 conventions
Interpreter vs. compiler
First steps with Python (approx. 5 days)
Numbers
Strings
Date and time
Standard input and output
Numeric operators
Comparison, logical and bitwise operators
Data type conversion
list, tuple dict, set
List functions and methods
Branching and loops (if, for, while)
member operators
Artificial intelligence (AI) in the work process
Presentation of specific AI technologies
and possible applications in the professional environment
Functions (approx. 5 days)
Define your own functions
Variables
Parameters and arguments
Return values
Recursion
Namespaces
Functional programming
Troubleshooting (approx. 0.5 days)
try, except
Error types
Intercepting program interruptions
Error forwarding between functions
Object-oriented programming (approx. 4.5 days)
Python classes
Methods
Immutable objects
Data class
Inheritance
Project work, certification preparation and certification exam "PCEP™ - Certified Entry-Level Python Programmer" in English (approx. 4 days)
Changes are possible. The course content is updated regularly.
Once you have completed the course, you will know the complete workflow for modern web design and will be able to program user-friendly and sophisticated websites.
You also have a compact, basic knowledge of programming with Python. You will be able to confidently handle the programming language with its classes, libraries and functions.
The course is aimed at web designers, web programmers and specialists from related IT fields who are responsible for the conception, design and practical implementation of websites and want to acquire the necessary skills and basic programming knowledge.
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.
The versatility of Python makes employees with the relevant skills attractive in numerous industries and companies. People with programming skills in Python are particularly sought after in web development, machine learning and data analysis.
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).