Backend Developer and Scrum Master (PSM II)

The course provides detailed knowledge of JavaScript and Ajax, PHP and MySQL as well as SQL for a functioning backend as the foundation of every website. With the Professional Scrum Master (PSM II), you will also deepen your knowledge of the Scrum framework and develop advanced coaching and leadership skills.
  • Certificates: Certificate "Backend Developer"
    Certificate "Professional Scrum Master (PSM II) from Scrum.org"
  • Additional Certificates: JavaScript Developer" certificate
    Certified PHP Developer" certificate
    Certificate "Relational Databases SQL"
  • Examination: Praxisbezogene Projektarbeiten mit Abschlusspräsentationen
    Certified PHP Developer
    Scrum.org-Zertifizierung PSM II - Professional Scrum Master (in englischer Sprache)
  • 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: 24 Weeks

JavaScript Developer

JavaScript Basics (approx. 7 days)

Introduction to JavaScript, history, areas of application

ECMA script versions

Integration of JavaScript in HTML

IDE: Installation and introduction to WebStorm

Language elements: variables, constants, typing

Primitive data types: Number, String, Boolean

Collection data types: Arrays, objects

Copy by reference vs. copy by value

Arithmetic and logical operators

Control structures: conditions, loops, functions

Scope, global scope, block scope

Error handling

Local storage: Webstorage, IndexedDB

JSON

ES6 import/export

Version control with Git

Introduction to GitHub


DOM manipulation with JavaScript (approx. 5 days)

basics

Selecting HTML

Content and attributes

styling

Events, event object, bubbling

Observer

- Intersection observer

- Mutation observer

Create, copy, move, delete DOM elements


Frameworks/Libraries (approx. 1 day)

Create your own library


AI (approx. 1 day)

Presentation of specific AI technologies in the professional environment

Artificial intelligence (AI) in the work process

Integration of AI in the IDE

Use of AI for code completion, refactoring and learning support


Project work (approx. 6 days)

To consolidate the content learned

Presentation of the project results


JavaScript deepening (approx. 5 days)

Canvas, drawing, animating

Spread syntax, destructuring

Creating objects with constructors, classes, factories

Inheritance of classes

Getters and setters, static methods

Fields, private fields

Prototyping

Map and set data types

Promise, concatenation, async-await syntax

Webworker


Ajax (approx. 1 day)

Introduction to

How it works

HTTP requests

Fetch()-API

Web services:

- JSON

- XML

Communication with APIs


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 noSQL database

Building your own REST APIs with Express

API endpoints: GET, POST, JSON handling

Insight into hosting (e.g. dedicated servers, managed hosting, cloud hosting)


Single Page Application (approx. 2 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


TypeScript (approx. 2 days)

Installation and application

Static typing

Dynamic data types

Complex data types

Decorators


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

Composer & 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. 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

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. 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

Introduction to design patterns (factory, strategy)

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, models, blade templates

Eloquent ORM and database migrations

RESTful API development

Caching and performance optimization

Creation of Artisan Commands

Events, listeners & broadcasting (Laravel Echo)

Queues & Jobs (+ Laravel Horizon)

Notifications & Mail

Sanctum + Passport (Token-Auth for SPAs and APIs)

API resources & rate limiting


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

Agile project management with Scrum: Master (PSM II)

Deepening the Scrum framework (approx. 2 days)

Scrum principles, values and rules

Roles and artifacts in the Scrum framework

Scrum events (e.g. sprint goal)

Measurement and metrics in Scrum

Meaning of "Done" for product increments


Servant Leadership (approx. 2 days)

Servant leadership at its best!

Self-organization and personal responsibility

Support for the scrum team, the product owner and the organization


Artificial intelligence (AI) in the work process

Presentation of specific AI technologies

and possible applications in the professional environment


Complex situations and challenges (approx. 4 days)

Analyzing and resolving team conflicts

Dealing with complexity and removing obstacles (impediments)

Understanding the challenges of middle management

Applying Scrum in complex and real-life situations


Coaching skills and techniques (approx. 3 days)

Methods and tools for effective coaching of teams

Facilitation techniques

Collaboration techniques

Giving constructive feedback

Supporting the development process


Organizational development and change (approx. 4 days)

Effects of Scrum on the organizational structure

Methods for promoting change in the organization

Bringing about change and support in the Scrum team environment


Project work, certification preparation and Scrum.org certification Professional Scrum Master (PSM II) in English (approx. 5 days)



Changes are possible. The course content is updated regularly.

A sound knowledge of web design, especially HTML and CSS, is required as well as a good knowledge of English for the Scrum certification exam. Successful Professional Scrum Master (PSM I) certification and at least one year's experience as a Scrum Master are recommended.

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.

After this course, you will also have a firm grasp of the Scrum framework and be able to initiate and implement changes in the organization. You will tackle complex situations and challenges with the help of Scrum techniques and be able to conduct coaching sessions with the Scrum team.

Web designers, web developers and specialists from related IT fields who want to actively participate in the conception, design and technical implementation of modern web applications and would like to acquire practical knowledge of JavaScript.

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.

In addition, you will deepen your knowledge of the Scrum framework and develop advanced coaching and leadership skills. With the official certificate from Scrum.org, you will receive internationally recognized proof of your acquired qualifications.

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.