MySQL 8.x Programming

MySQL Overview - MySQL Server Integration - MySQL Server Databases - MySQL Server Security - Working with MySQL Server

MySQL Program Structures - Designing an Organization's Application Architecture - MySQL Server Programming Tools - The MySQL Programming Language - The Individual Elements of MySQL - Additional Language Elements - Ways to Execute MySQL Statements

Creating databases with MySQL Server - Creating databases - Creating file groups - Managing databases - Introduction to data structures

Creating tables with MySQL Server - Creating data types - Creating tables - Generating column values - Generating scripts

Creating data integrity with MySQL Server - Data integrity types - Enforcing data integrity - Defining MySQL Server constraints - Constraint types - Disabling MySQL Server constraints - Using default values and rules with MySQL Server - Choosing the appropriate method for enforcing data integrity

Managing indexes with MySQL Server - Introducing indexes - The index architecture of MySQL Server - Retrieving stored data by MySQL Server - Managing index and heap structures by MySQL Server - Choosing which columns to index

MySQL Creating and Working with Indexes - Creating Indexes - Managing Indexes - Introduction to Working with Statistics - Setting Up Indexes Using the Index Optimization Wizard - Performance Aspects of MySQL Server

Working with views on MySQL Server - Introduction to views - Benefits of views - Defining views - Modifying data using views - Optimizing performance using views

Stored Procedures and MySQL Server - Introduction to Stored Procedures on MySQL Server - Creating, Executing, Modifying, and Deleting Stored Procedures - Using Parameters in Stored Procedures - Executing Advanced Stored Procedures - Handling an Error Message on MySQL Server - Performance Aspects

MySQL functions - Types of custom functions on MySQL Server - Definition of custom functions on MySQL Server - Examples of custom functions on MySQL Server

MySQL Triggers - Introduction to Triggers - Definition of Triggers - How Triggers Work - Examples of Triggers - Performance Aspects

Distributed Data Storage with MySQL Server - Introducing Distributed Queries on MySQL Server - Running an Ad Hoc Query for a Remote Data Source - Setting Up a Connection Server Environment - Running a Query on a Connection Server - Running a Stored Procedure on a Connection Server - Managing Distributed Transactions - Modifying Data on a Connection Server - Using Partitioned Views on MySQL Server

MySQL Logical Operators - Queries using the AND operator - Queries using the OR operator - Queries using join operations

Working with transactions and locks on MySQL Server - Introduction to transactions and locks on MySQL Server - Managing transactions on MySQL Server - SQL Server locks - Managing locks

Basic knowledge of SQL

We conduct this seminar online for you. You can book the training as a public seminar or as a company seminar. The practical exercises are carried out in our Remotelab and make up 40-50 percent of the seminar.

• Implementation guarantee - Implementation guarantee for two or more participants
• Mobile classrooms - the ideal complement for company seminars
• Free support - for questions after the seminar
• Delivery on account - no prepayment required
• Interview with the trainer / quality assurance - get to know and assess the trainer in advance
• Clarify seminar requirements - review your knowledge with the trainer
• Assistance with travel costs - we cover part of the costs of hotel accommodation
• Meals - all day cold / hot drinks and a full lunch in the restaurant
• Location of training centres - always centrally located and easily accessible
• Discount - we have attractive prices, take advantage of our additional discounts
• Remotelabs - rent our Remotelabs for your own seminars or as a complement to your company seminars