MySQL Courses
Stage 1
MySQL success characteristic.
Characterization of MySQL features.
How to install MySQL 5.x server.
MySQL schematization overview.
An introduction to the programs that are used to work with the server.
An introduction to the utilities that are used to work with the server.
Familiarity with server console commands.
An introduction to USE operators.
An introduction to SHOW statements.
INFORMATION_SCHEMA is a database.
How to use it in order to have information about metadata.
Practice.
Database design algorithm.
Introduction to MySQL 5.x – Central Data Types.
How to make the best choice of type in order to save your data.
How the database is normalized.
Characteristics of the keys.
Workbench 8.0.x package overview.
Techniques for its application in database design.
Practice.
Stage 2
Familiarity with SQL expressions.
An introduction to database architecture definition statements.
Overview of constraints and indices.
How to remove an index from a table.
How to add it.
Acquaintance with manipulation operators.
Practice.
Characteristic of the SELECT statement.
An overview of the ORDER and WHERE predicates.
What are aggregate functions.
Familiarity with sampling limits.
Introduction to the HAVING predicate.
The process of joining tables.
Practice.
| Phone: | + 485 144 71 894 |
|---|---|
| Company name: | Atlantox Sp. z o.o. |
| Address: | Marcina Kasprzaka 31, 01-234 Warszawa, Polska |
| ITN: | 5272942960 |
| REGON: | 387623853 |
| Email: | support@atlantox.com |
| Email: | office@atlantox.com |
