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