DB581 Introduction to SQL and Relational Databases via MySQL

Duration: 3 Days

Intended Audience

There are no formal pre-requisites for this course. However, an understanding of databases and some exposure to information technology in general would be helpful. It is a course for beginners and developers who will be required
to work with databases in general and MySQL in particular.

Synopsis - Course Objectives

This course covers the basics of the SQL language as implemented by MySQL.

It aims to provide delegates with practical experience in writing SQL statements and running
these statements using the MySQL client program and, also, MySQL Workbench.

The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced.

Objectives

The DDL (Data Definition Language) and DML (Data Manipulation Language) parts of SQL are covered.
DDL statements are used to create tables and other database objects. DML statements are used to
query the database to extract information from it.