SQL beginner training

You are new in the field of relational SQL databases and have the task to learn the SQL language. This training teaches you the SQL basics.

Requirements

You are an experienced user of Linux or Windows systems and you ideally have already learned another programming language.

Audience

• Future MySQL application developer
• Future MySQL and MariaDB database administrators
• System administrators with MySQL database responsibility
• Business analysts

Contents

• SQL, relations and relational databases
• Connecting to and accessing databases
• SELECT, WHERE, JOIN
• Functions
• GROUP BY, ORDER BY, DISTINCT
• UNION and sub queries
• DML commands: INSERT, UPDATE and DELETE
• DDL commands: CREATE, ALTER, DROP
• Data types
• Indexes
• Views
• Query Tuning basics

Duration

3 days

Booking trainings

Trainings for Germany can be booked on-line here and trainings in Switzerland here.

Advanced trainings

• MySQL and MariaDB beginner training
• MySQL and MariaDB developer training