Backend Developer and Scrum Master (PSM II)

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

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)

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

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)