Show all

MySQL - advanced querying in SQL

The course MySQL - advanced querying in SQL deepens the knowledge of participants about the advanced possibilities of the SQL language in the environment of the MySQL database system. Students will learn advanced querying capabilities using the SELECT statement, use subqueries and functions, show the principle of transactions, data import and export options, query optimization and, last but not least, learn to use the new version from MySQL 5.0 - views. If you already have experience writing SQL queries, are working on the MySQL platform and want to learn useful advanced query techniques, this course is ideal for you. 
Level
Designed for participants with advanced knowledge and experience
advanced
Course length
2 days
Language
 cz  eu
Course code
KT21010147
MySQL
Category:
Do you want this tailor-made course to your company? Contact us

Courses on a specific date with a live lecturer

Term
Language
Place
Form
?
How and where the course takes place.
Price without VAT
12. - 13. 8. 2024
Language
Place
online
Form
virtual classroom
?
Online training with a lecturer at a specific time.
Code of the course: KT21010147-0022
Price without VAT
13 000 Kč
26. - 27. 9. 2024
Language
Place
online
Form
virtual classroom
?
Online training with a lecturer at a specific time.
Code of the course: KT21010147-0020
Price without VAT
13 000 Kč
Open term
?
We will agree on a specific date together. This is a non-binding order.
Language
Place
online
Form
virtual classroom
?
Online training with a lecturer at a specific time.
Code of the course: KT21010147-0003
Price without VAT
13 000 Kč
Open term
?
We will agree on a specific date together. This is a non-binding order.
Language
Place
online
Form
virtual classroom
?
Online training with a lecturer at a specific time.
Code of the course: KT21010147-0004
Price without VAT
13 000 Kč

Course content

  • Advanced SELECT statement options - advanced operators, regular expressions, LIKE
  • Subqueries - purpose, use, correlated and standalone subqueries, operators EXIST, ANY, IN, ALL
  • Advanced functions - functions for working with date, data conversion, metadata, working with XML, aggregation functions
  • Transactions - meaning, principle, use in MySQL, locking, isolation level
  • Views - meaning, use, creation, novelty in MySQL
  • Triggers - what are triggers, syntax, deleting a trigger
  • Import and export data
  • Query optimization - optimization principles, use of indexes, EXPLAIN, summary tables

Materials

Materials are in electronic form.

Do you want this tailor-made course for your company?

Contact us

Previous courses

Do you want this tailor-made course for your company?

Contact us

Why with us