The basic seminar introduces you to the world of database queries from the open source programme MySQL. You will learn what a relational database concept is, how to edit data in tables and how to create and modify database objects. Link multiple tables in a query using joins to compile the required data. Control privileges at the object and system level and modify existing schema objects for which you retrieve metadata and create reports using dictionary views. Become familiar with date and other time functions and regular expression support in SQL. We show you the MySQL Workbench development tool for creating queries and administering databases.

What the Seminar will Cover:

• Introduction to MySQL Database
• Retrieving data with the SELECT statement
• Restricting and sorting data (WHERE / ORDER BY)
• Customising output with single row functions
• Conversion functions and conditional expressions
• Reporting with aggregated data using group functions
• Displaying data from multiple tables (JOINS)
• Solving queries with subqueries and CTE (WITH)
• Set operators
• Data manipulation (Data Manipulation Language)
• Creating and managing tables using DDL statements
• Creating additional schema objects
• User access control
• Schema object management
• Object management with data dictionary views
• Handling large amounts of data
• Data management in different time zones
• Data query with sub-queries
• Regular expression support

Target group: Beginners with little or no previous knowledge of MySQL

Prerequisites: Basic computer skills

Duration: 5 days

Note: The seminar focuses on MySQL concepts. Specific functions and syntax of other SQL dialects are not covered.

At the end of the seminar:

After the seminar, you will have developed a solid understanding of MySQL. You will be familiar with the basics, be able to understand and write SQL queries and develop simple database applications with MySQL.

How this seminar will help you: Mastering MySQL can prove beneficial in enhancing career opportunities and handling challenging tasks related to database applications.

Thank you for your interest in this seminar. We wish you a lot of fun!