SQL for intermediate users

Course code: SQLIU

SQL is an essential language for everyone working with data. In this course we go beyond the basics and provide an overview of some advanced functionality, like using regular expressions for analyzing text data (pattern matching, log analysis) and optimizing queries.

Objectives:

  • MySQL overview
  • Use advanced techniques with the SELECT statement
  • Use subqueries
  • Overview and use the advanced features
  • Advanced techniques of SQL language
460 EUR

557 EUR including VAT

The earliest date from 10.04.2024

Selection of dates
onas
Do you have a question?
+420 731 175 867 edu@edutrainings.cz

Professional
and certified lecturers

Internationally
recognized certifications

Wide range of technical
and soft skills courses

Great customer
service

Making courses
exactly to measure your needs

Course dates

Starting date: 10.04.2024

Type: Virtual

Course duration: 2 days

Language: cz/sk

Price without VAT: 460 EUR

Register

Starting date: 17.06.2024

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 460 EUR

Register

Starting date: 19.08.2024

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 460 EUR

Register

Starting date: 14.10.2024

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 460 EUR

Register

Starting date: 09.12.2024

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 460 EUR

Register

Starting date: Upon request

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 460 EUR

Register

Starting
date
Place
Type Course
duration
Language Price without VAT
10.04.2024 Virtual 2 days cz/sk 460 EUR Register
17.06.2024 In-person/Virtual 2 days en/cz 460 EUR Register
19.08.2024 In-person/Virtual 2 days en/cz 460 EUR Register
14.10.2024 In-person/Virtual 2 days en/cz 460 EUR Register
09.12.2024 In-person/Virtual 2 days en/cz 460 EUR Register
Upon request In-person/Virtual 2 days en/cz 460 EUR Register
G Guaranteed course

Didn't find a suitable date?

Write to us about listing an alternative tailor-made date.

Contact

Course structure

MySQL overview

  • Overview of the MySQL database system
  • The installation procedure
  • MySQL Tools

Advanced techniques with the SELECT statement

  • Advanced operators
  • Regular Expressions
  • LIMIT
  • Practical examples

Subqueries

  • Reason for using subqueries
  • Stand-alone subqueries
  • Correlated subqueries
  • Subquery Operators (EXISTS, IN, ANY, ALL)
Overview and use the advanced features
  • Functions for working with different data types
  • Conversion of data types
  • Metadata function
  • Working with XML
  • Advanced aggregation techniques

Advanced techniques of SQL language

  • Working with hierarchical data structures and recursion
  • Advanced techniques of joining data sources
  • Action queries
  • Advanced subqueries and operators

Follow-up courses

MongoDB Developer en/cz

Vendor: EDU Trainings

Area: Databases

Price from

885 EUR without VAT

MongoDB Administration en/cz

Vendor: EDU Trainings

Area: Databases

Price from

885 EUR without VAT

MySQL Administration en/cz

Vendor: EDU Trainings

Area: Databases

Price from

620 EUR without VAT

MySQL Performance en/cz

Vendor: EDU Trainings

Area: Databases

Price from

620 EUR without VAT

PostgreSQL Administration en/cz

Vendor: EDU Trainings

Area: Databases

Price from

620 EUR without VAT

PostgreSQL for DB Developers en/cz

Vendor: EDU Trainings

Area: Databases

Price from

620 EUR without VAT

PostgreSQL Performance en/cz

Vendor: EDU Trainings

Area: Databases

Price from

620 EUR without VAT

SQL for beginners en/cz

Vendor: EDU Trainings

Area: Databases

Price from

460 EUR without VAT

MS SQL Server administration comprehensively and efficiently en/cz

Vendor: EDU Trainings

Area: Databases

Price from

1 210 EUR without VAT

Optimization and monitoring of T-SQL queries en/cz

Vendor: EDU Trainings

Area: Databases

Price from

790 EUR without VAT

ComGate payment gateway MasterCard Logo Visa logo