MySQL – introduction

Course objectives

Understanding MySQL databases, acquiring practical programming skills, performing queries and creating procedures. Learning the basics of programming.

Benefits

• Workshop participants will learn about:
  • Concepts for MySQL databases
  • MySQL server and client
  • Ability to install, create databases, objects
  • Performing operations using MySQL Workbench
  • Rules for creating database objects
  • Rules for creating queries
  • Rules for creating functions and procedures
  • Operations on data stored in databases
• Participants will acquire detailed knowledge allowing for:
  • Installation of MySQL own server
  • Creating and managing schemes
  • Creating objects
  • Basics of MySQL database administration
  • Basics of optimization

Training scope

• 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

Audience

All individuals starting to work with databases or wanting to consolidate and expand their knowledge, members of project teams.