Show all

MySQL - basics of SQL language

The course will teach participants the basics of SQL in the environment of the MySQL database system. Participants will explain how data is stored in databases, show commands for manipulating data in tables and especially querying data using the SELECT statement. They will also learn more complex querying options, such as joining tables, query conditions, and using functions. The course is also suitable for complete beginners with SQL language. 
Level
Designed for participants without knowledge and experience
basic
Course length
2 days
Language
 cz  eu
Course code
KT21010146
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
5. - 6. 9. 2024
Language
Place
online
Form
virtual classroom
?
Online training with a lecturer at a specific time.
Code of the course: KT21010146-0018
Price without VAT
13 000 Kč
5. - 6. 12. 2024
Language
Place
online
Form
virtual classroom
?
Online training with a lecturer at a specific time.
Code of the course: KT21010146-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: KT21010146-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: KT21010146-0004
Price without VAT
13 000 Kč

Course content

  • Introduction to the MySQL environment - history, changes, introduction to the MySQL platform, advantages and disadvantages
  • Basics of SQL language - syntax, expressions, comments, sample statements, database creation, case sensitivity depending on the platform
  • Table structure - data types: numeric, character, binary, NULL value, table creation and deletion
  • Commands for working with data - INSERT, UPDATE, DELETE
  • Basics of SELECT - FROM statement, data sources, column naming in results, ORDER BY clause, LIMIT
  • WHERE condition - AND, OR, NOT, IN, BETWEEN statements, etc., work with NULL
  • Joining tables - reasons, principles, JOIN statements - LEFT, RIGHT, INNER, OUTER, CROSS, NATURAL
  • Joining queries - UNION, INTERSECT
  • Basics of indexes - use, principle, PRIMARY KEY, adding indexes
  • Introduction to functions and subqueries - built-in functions, aggregation functions, subqueries EXISTS and NOT EXISTS 

Materials

Materials are in electronic form.

Lecturers

David Solnař
David Solnař

Freelance Consultant and Trainer Oracle, SQL Server, MySQL, .NET, WPF, ASP.NET

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

Contact us

Follow-up courses

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

Contact us

Why with us