MySQL/SQL: beginner to advanced training course

Eesti keeles Русский

This four week training course is not only for software developers, but first for all professionals, who work with data collection, data processing and data analysis.

All training is provided in the our training rooms in the centre of Tallinn (Tartu mnt. 18). All training materials and licences are included in the price. If you need we provide also the personal laptop for you for the whole training period .

Ask the question: training@gamma-intelligence.com

Please send us email if you have any questions: training@gamma-intelligence.com.

Call us: (372)55581521

Call us 55581521. We answer all your questions

Course description:

Target group: Professionals, who work with data collection, data processing and data analysis.

Trainer: Maksim Kolodijev (MsDegree - Computers and Systems Design)

Duration: 4 weeks

Language: english, russian is also available

Participants limit: up to 8 persons

Volume and duration: 48 academic hours (4 weeks)

Price: 800 EUR + VAT 24%

Requirements for students:

Confident PC user

English A2/B1

Personal laptop (Windows/Mac), NB: we provide laptop for the whole training period

After completion this training you will learn how to:

create your own databases using MySQL DBMS based on your system requirements

effectively work with tables and views;

create simple and complex SQL queries, join the tables, order, sort and aggregate data;

work SQL user defined functions and stored procedures

Additional information:

Basic rules of Gamma Intelligence training courses (estonian)
Training process quality assurance rules (estonian)

Module	Description	Duration
Introduction to databases and Structured Query Language (SQL)	Introduction to databases. MySQL. Database configuration. Structured Query Language (SQL)	4 ac. h.
SQL conception	SQL conception. Simple queries SQL	8 ac. h.
SQL operators and constructions	SQL operators and constructions	12 ac. h.
Working with views	Create, use and delete views	4 ac. h.
Advanced SQL: User-defined functions and stored procedures	User-defined functions and stored procedures	8 ac. h.
SQL and MySQL best practices	SQL and MySQL best practices	12 ac. h.