Backend developer and programming with Python

Free of cost

by funding

The course teaches you JavaScript, Ajax and the programming of dynamic websites with PHP and MySQL. You will also learn about relational databases with SQL and the Python programming language and find out how artificial intelligence is used in your profession.
  • Certificates: Certificate "Backend Developer"
    Python" certificate
  • Additional Certificates: JavaScript Developer" certificate
    Certified PHP Developer" certificate
    Certificate "Relational Databases SQL"
  • Examination: Practical project work with final presentations
    Certified PHP Developer
  • 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

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

PHP Developer: Object orientation and Laravel framework

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)

Relational databases with SQL

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

Programming with Python

Python basics (approx. 1 day)

History, concepts

Usage and areas of application

syntax


First steps with Python (approx. 5 days)

Numbers

Strings

Date and time

Standard input and output

list, tuple dict, set

Branches and loops (if, for, while)


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, recursion

Functional programming


Troubleshooting (approx. 0.5 days)

try, except

Intercept program interruptions


Object-oriented programming (approx. 4.5 days)

Python classes

Methods

Immutable objects

Data class

Inheritance


Graphical user interface (approx. 1 day)

Buttons and text fields

Grid layout

File selection


Project work (approx. 3 days)

To consolidate the content learned

Presentation of the project results



Changes are possible. The course content is updated regularly.

This course requires a sound knowledge of web design with HTML and CSS.

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

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.