Backend developer

JavaScript Basics (approx. 7 days)

Introduction to

Integration into HTML pages

Language elements

Variables, constants and data types

Operators

Control structures

Conditional statements

Loops

Functions

arrays

Objects

cookies

Web storage

Error handling

Artificial intelligence (AI) in the work process

Presentation of specific AI technologies

and possible applications in the professional environment

DOM manipulation with JavaScript (approx. 3 days)

Basics of

Selecting HTML

Content and attributes

styling

events

Creating DOM elements

Copying, moving and deleting DOM elements

AJAX (approx. 3 days)

Introduction to

Functionality

Prerequisites

http requests

XMLHttpRequest object

Synchronous and asynchronous requests

Web services/transmissions:

- JSON

- XML/XML response

Frameworks/Libraries (approx. 2 days)

Create your own library

jQuery

Advantages and disadvantages

Project work (approx. 5 days)

To consolidate the content learned

Presentation of the project results

JavaScript specialization (approx. 6 days)

Programming guidelines

ECMA script versions

Global and local scope, block scope

Arrow functions, difference to classic syntax

DOM: the event object

Rest parameter

Array method

High-order functions for arrays

Spread syntax, destructuring

Creating objects with constructors, classes, factories

Getters and setters, dynamic attributes

Prototyping, inheriting objects

Creating and managing maps and set collections

Iterators and generators

NodeJS (approx. 4 days)

Structure and installation

Modules

NPM

Create web server (Express)

Own middleware

REST methods

GET and POST

Data transfer

Upload files to server

Communication with MySQL database

Fetch syntax for AJAX requests

Promise for asynchronous functions

Websockets

Canvas element

Draw shapes

Fill methods

Integrate and animate pixel graphics

Single Page Application (approx. 3 days)

ReactJS:

- Introduction, theoretical consideration, installation

- Virtual DOM functionality and advantages

- Components, nesting, parameter passing

- Content update, event listener

VueJS:

- Introduction, theoretical consideration

- Virtual DOM, bidirectional data binding

- Expressions, directives, bindings

- Custom directives, computed properties components

Project work (approx. 7 days)

To consolidate the content learned

Presentation of the project results

Basics (approx. 5 days)

Setting up a development environment

Basics of syntax

Types, variables, constants (especially arrays and strings)

Expressions, operators, control structures, functions

Artificial intelligence (AI) in the work process

Presentation of specific AI technologies

and possible applications in the professional environment

Web context (approx. 3 days)

GET and POST requests

Cookies and sessions

Forms and validation (e.g. contact form)

Output of dynamic content (e.g. outputting the result of a calculation task)

Interaction and risk (approx. 2 days)

Error messages, logging and debugging

Security aspects (sanitization, code injection)

Databases (approx. 4 days)

Basics of SQL databases

PHP and MySQL (connection setup, simple database operations)

Input and output of database content on a website

PHP Frameworks (approx. 1 day)

What is a PHP framework?

Advantages of a PHP framework

Current PHP frameworks (Laravel, Symfony, Codelgniter, etc.)

Project preparation (approx. 1 day)

Planning and structuring PHP projects

Project work (approx. 4 days)

To consolidate the content learned

Presentation of the project results

Object-oriented programming (approx. 5 days)

Basics of object-oriented programming

Classes, objects, methods and properties

Constructor/Destructor, magic methods

Debugging objects

Complex object structures (nesting)

Inheritance, polymorphism, abstract classes, abstract methods

interfaces

Mapping object structures in relational databases, creating objects from relational data structures

Static methods

Automation, traits

Exception handling

ClassLoader

Use of a modern framework (approx. 5 days)

Introduction to the PHP framework Laravel

Setting up a Laravel project

Application routes with parameters and requirements

Use of controllers

Use of output templates

Database queries (CRUD operations with Doctrine ORM)

Create a sample website (approx. 5 days)

Planning and implementing an internet application

Project work, certification preparation and certification exam "Certified PHP Developer" (approx. 5 days)

Basics of database systems with Access (approx. 3 days)

Redundant data

Data integrity

Normalization

BCNF

DB design

Relationship 1:n, m:n

data types

tables

Primary and foreign keys

Referential integrity

Relationships between relations

Entity relationship model

Index, default value

Restrictions (check)

Queries

Forms, reports

Circular reference

Introduction to SQL Server Management Studio (SSMS) (approx. 2 days)

Overview of

Physical DB design

Creating tables

Data types in MS SQL

Primary Key

Restrictions, default values, diagram, 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 (approx. 8 days)

SQL basics

syntax

Commands

Multiple tables

Operators

Flow control

Scalar value functions

Table value functions

System functions

Procedures with and without parameters

Error types

Transactions, locks, DeadLock

DCL - Data Control Language (approx. 1 day)

Logins

User learning

roles

Authorizations

Data types, data import and export (approx. 1 day)

Data type geography

Data export, data import

Project work (approx. 5 days)

To consolidate the content learned

Presentation of the project results