MySQL Intermediate Beginners

Click to Enquire

Categories: MySQL Training Courses

£760 per delegate. This may be less for special offers on specific course dates and in-company training courses

Duration: 3 days

Trainer: WC315P

Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...

Course Overview
Course Dates

Course Aims

This course provides the knowledge and skills needed to retrieve and update data held in a relational database.

Who Should Attend

Anyone who needs to understand and use SQL to manipulate a database. There are no formal pre-requisites for this Introduction to SQL course, although an understanding of databases and exposure to information technology in general would be useful.

Duration: 1 Day

Course Outline

Relational Database Concepts

- What is a Relational Database?
- Tables, Rows and Columns
- Indexes, Primary Keys and Foreign Keys
- Data Types
- The Data Dictionary
- Getting Started

SQL Language Essentials

- The Select Statement
- The Select and From Clauses
- Conditions and the Where Clause
- The Order By Clause
- Arithmetic Operations
- Column Aliases
- Practical Exercises

Summarizing and Grouping Data

- Aggregate Functions
- The Group By Clause
- The Having Clause
- Practical Exercises

Querying Multiple Tables

- Joining Tables
- Inner Joins
- Column Qualification and Table Aliases
- Outer Joins
- Self Joins
- Alternative Join Syntax
- Practical Exercises

Additional SQL Features

- Combining Queries
- The Union, Intersect and Minus Operators
- Basic Subqueries
- Practical Exercises

The course either has new dates in data loading, or is only run as a dedicated or In Company course.

Close map