MySQL for Developers

Deze cursus leert je de kennis, vaardigheden, tools en problemen die betrokken zijn bij het schrijven van toepassingen met de MySQL-databaseserver. Het vormt de kern van het leertraject van MySQL Developer.

Database Administrators, Database Designers, Developers

Introduction 
MySQL Product 
MySQL Services and Support 
MySQL Resources 
Example Databases

MySQL Client/Server Concepts 
MySQL General Architecture 
Diskspace use 
Memory use

MySQL Clients 
Invoking Client Programs 
Using Option Files 
The MySQL Client 
MySQL Workbench 
MySQL Connectors 
Third Party APIs

Querying for Table Data 
The SELECT Statement 
Aggregating Query Results 
Using UNION 
Import and Export Data

Handling Errors and Warnings 
SQL Modes 
Handling Missing or Invalid Data Values 
Interpreting Error Messages 
Conditions and Signals 
Error Handling when using Connectors

Data Types 
Data Type Overview 
Numeric Data Types 
Character String Data Types 
Binary String Data Types 
Temporal Data Types 
Spatial Data Types 
NULLs

SQL Expressions 
SQL Comparisons 
Functions in SQL Expressions 
Comments in SQL Statements

Obtaining Metadata 
Metadata Access Methods 
The INFORMATION_SCHEMA Database/Schema 
Using SHOW and DESCRIBE 
The mysqlshow Command

Database 
Database Properties 
Good Design Practices 
Identifiers 
Creating Databases 
Altering Databases 
Dropping Databases

Tables 
Creating Tables 
Table Properties 
Column Options 
Creating Tables Based on Existing Tables 
Altering Tables 
Dropping Tables 
Foreign Keys

Manipulating Table Data 
The INSERT Statement 
The DELETE Statement 
The UPDATE Statement 
The Replace Statement 
INSERT with ON DUPLICATE KEY UPDATE 
The TRUNCATE TABLE Statement

Transactions 
What is a Transaction 
Transaction Commands 
Isolations Levels 
Locking

Joins 
What is a Join? 
Joining Tables in SQL
Basic Join Syntax 
Inner Joins 
Outer Joins 
Other Types of Joins 
Joins in UPDATE and DELETE statements

Subqueries 
Types of Subqueries 
Table Subquery Operators 
Correlated and Non-Correlated Subqueries 
Converting Subqueries to Joins

Views 
What are Views? 
Creating Views 
Updating Views 
Managing Views 
Obtaining View Metadata

Prepared Statements 
Why use Prepared Statements 
Using Prepared Statements for the mysql client 
Executing a Prepared Statement 
Deallocating a Prepared Statement 
Programming with Prepared Statements

Stored Routines 
What is a Stored Routine? 
Creating Stored Routines 
Compound Statements 
Assign Variables 
Parameter Declaration 
Execute Stored Routines 
Stored Routine Characteristics 
Examine Stored Routines

Triggers 
What are Triggers 
When to Use Triggers 
How to Delete Triggers 
Restrictions on Triggers

Optimization and Monitoring 
Overview of Optimization Principles 
Using Indexes for Optimization 
Using EXPLAIN to Analyze Queries 
Using Performance Schema to Analyze Performance 
Query rewriting techniques 
Optimizing Queries by Limiting Output 
Using Summary Tables 
Optimizing Updates

Conclusion

Ervaring met het maken van tabellen en query's in relationele databases en comfort met eenvoudige SQL-instructies en een andere programmeertaal, MySQL voor beginnerscursus

Geen