Introduction to SQL
Course
In Birmingham, London, Leeds and another venue.
Description
-
Type
Course
-
Location
-
Class hours
7h
-
Duration
1 Day
On completion of the course, the delegate will have a basic understanding of the structure of a relational database and the functions of a DBMS. They will have a working knowledge of the ANSI Standard Structured Query Language (SQL) allowing them to access database tables. Suitable for: This course is intended for people who need to access and work with relational databases.
Facilities
Location
Start date
Start date
Start date
Start date
Start date
About this course
Some previous programming or database experience would be useful.
Reviews
Subjects
- Creating SQL statements to query a database table
Course programme
The Introduction to SQL course is designed to give delegates practical experience in using ANSI standard SQL. As it is a generic course, some of the differences between different vendors' implementations will be noted.
Skills Gained
The delegates will practise:
- Creating SQL statements to query a database table
- Writing SQL statements to retrieve data from multiple tables
- Using standard aggregate functions
- Implementing Subqueries
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.
Course Objectives
To provide the knowledge and skills needed to retrieve and update data held in a relational database.
Introduction to SQL