Book your training online... 1000's of courses, 100's of locations, 1 website!

Less

COURSE FINDER

or

MySQL Intermediate Beginners

Click to Enquire

Categories: MySQL Training Courses

£765 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

Telephone Hotline 01933 233884

Enter a location to find distance

Find Location

Reset Map

Location	Region	Start Date	Days	Price ex. VAT
London	London, London All Areas, London West, South East	Wed 26 Feb 25 Three day duration, date as indicated.	3	£765 + VAT	BOOK	ENQUIRE
Milton Keynes	East Anglia, Midlands, South Central England	Wed 26 Feb 25 Three day duration, date as indicated.	3	£765 + VAT	BOOK	ENQUIRE
Portsmouth	South Central England, South East	Wed 26 Feb 25 Three day duration, date as indicated.	3	£765 + VAT	BOOK	ENQUIRE
Southend-on-Sea	East Anglia, London All Areas, London East, London North, South East	Wed 26 Feb 25 Three day duration, date as indicated.	3	£765 + VAT	BOOK	ENQUIRE
London	London, London All Areas, London West, South East	Wed 5 Mar 25 Three day duration, date as indicated.	3	£765 + VAT	BOOK	ENQUIRE
Milton Keynes	East Anglia, Midlands, South Central England	Wed 5 Mar 25 Three day duration, date as indicated.	3	£765 + VAT	BOOK	ENQUIRE
Portsmouth	South Central England, South East	Wed 5 Mar 25 Three day duration, date as indicated.	3	£765 + VAT	BOOK	ENQUIRE
Southend-on-Sea	East Anglia, London All Areas, London East, London North, South East	Wed 5 Mar 25 Three day duration, date as indicated.	3	£765 + VAT	BOOK	ENQUIRE
London	London, London All Areas, London West, South East	Wed 12 Mar 25 Three day duration, date as indicated.	3	£765 + VAT	BOOK	ENQUIRE
Milton Keynes	East Anglia, Midlands, South Central England	Wed 12 Mar 25 Three day duration, date as indicated.	3	£765 + VAT	BOOK	ENQUIRE
Portsmouth	South Central England, South East	Wed 12 Mar 25 Three day duration, date as indicated.	3	£765 + VAT	BOOK	ENQUIRE
Southend-on-Sea	East Anglia, London All Areas, London East, London North, South East	Wed 12 Mar 25 Three day duration, date as indicated.	3	£765 + VAT	BOOK	ENQUIRE
Courses found 1 to 12 of 12				1
Click location to see venue		Move cursor over calendar icon to see course dates

Close map

Telephone Hotline

01933 233884

(Monday to Friday - 8:00am to 5:30pm).

Email Enquiries

[email protected]

GET A QUOTE