MySQL – introduction

Why take this course

Want to understand how databases work and learn to manage them efficiently? With this training, you will master the fundamentals of working with MySQL – one of the most popular databases in the world. You’ll learn how to write queries, create database objects, and perform data operations you can use as a developer, analyst, or administrator.

What you’ll learn

• Install and configure the MySQL server
• Create databases, tables, views, and other objects
• Write SQL queries and subqueries
• Join data from multiple tables using JOIN
• Create and use stored functions and procedures
• Manage transactions and events
• Use indexes and optimize queries
• Understand metadata structure and the PERFORMANCE schema
• Work with MySQL Workbench

Certification & Exam

Upon completing the course, you will receive a personalized certificate confirming your skills in working with MySQL – including creating queries, database objects, functions, procedures, and managing a database environment. There is no final exam – active participation in the sessions is enough.

Who is this course for

• Individuals starting out with databases
• Project team members and data analysts
• Developers wanting to learn a relational database
• Administrators and IT specialists expanding their SQL skills

Topics covered

• Installation of MySQL server
• MySQL server and client
• MySQL Workbench
• Objects and data types
• Tables and views
• Indexes – types, rules of application, use
• Keys
• Queries and subqueries (correlated, uncorrelated, scalar, …)
• Subqueries using IN, NOT IN, ANY, ALL, SOME, EXISTS, NOT EXISTS
• Join
• Built-in functions and creation of own functions
• Transactions
• Query optimization
• Stored procedures
• Triggers and event management
• Reporting
• metadata
• PERFORMANCE scheme and its applications
• Practical exercises