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

advanced

Course length

2 days

Language

Course code

KT21010147

Order

Category:

Database MySQL

Do you want this tailor-made course to your company? Contact us

Courses with lecturer

Term

Language

Place

Form

Price without VAT

13. - 14. 1. 2025

Language

Place

online

Form

virtual classroom

Code of the course: KT21010147-0024

Price without VAT

13 000 Kč

Order

27. - 28. 2. 2025

Language

Place

online

Form

virtual classroom

Code of the course: KT21010147-0023

Price without VAT

13 000 Kč

Order

Open term

Language

Place

online

Form

virtual classroom

Code of the course: KT21010147-0003

Price without VAT

13 000 Kč

Order

Open term

Language

Place

online

Form

virtual classroom

Code of the course: KT21010147-0004

Price without VAT

13 000 Kč

Order

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?

News with the course

Database 7. 4. 2021

Database systems trainings

Database systems are a great potential for today's companies. There are many database products on the market that compete on performance, reliability, scalability, and many other factors. In the field of databases, we offer courses in PostgreSQL, MongoDB, MySQL.

More news