MySQL/SQL: beginner to advanced

MySQL/SQL: beginner to advanced training course

Eesti keeles Русский

Tallinn:

02.05.2022 - 03.06.2022

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 .

Free consultation:

I agree to get special offers and news from Gamma Intelligence (not often than once per month)
I am not agree to get special offers and news from Gamma Intelligence

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 descritpion:

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

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.