Express-SkillsTM:SQL
SQL (Structured Query Language) Training Course for Sheffield, Leeds, Manchester and Yorkshire
Course Information
| Course Code | XPR-SQL |
| Fee | £199 (Exclusive of VAT) |
| Duration | One Day |
| Delivery Format | Instructor-led |
| Scheduled Dates: |
| Apr 11 | May 11 | Jun 11 | Jul 11 | Aug 11 | Sept 11 | Oct 11 | Nov 11 | Dec 11 |
| - | 3 | - | 29 | - | - | 6 | - | 8 |
Introduction
The Express-SkillsTM series of courses are designed to provide highly practical core skills for IT professionals in an efficient timescale. Structured Query Language (SQL) skills are increasingly required and this course provides conceptual, 'hands-on' and applicable knowledge within this technology.
Audience
This course is pertinent to IT professionals including IT managers, database administrators, infrastructure technicians and application developers who require the skills to query and manipulate relational databases.
Completion
At course completion the learner should have attained knowledge, understanding and or skills in the following areas:
- Introduction to RDBMS Concepts
- Relational Database Design Overview
- Understanding SQL Concepts including DML, DDL and DCL
- Retrieving and Sorting Data
- Filtering Data
- Utilising Calculated Fields
- Data Manipulation Functions
- Grouping and Summarising Data
- Introduction to Subqueries
- Joining Tables Concepts
- Combining Multiple Queries
- Inserting, Deleting and Modifying Data
- Advanced Topics Introduction
Prerequisites
The learner should be IT literate, have attained a reasonable level of numeracy, have a logical approach and have utilised at least one operating system at an intermediate level.
Examinations
The course does not map to any presently available examinations.
Materials
A comprehensive student workbook and other relevant learning materials are provided.
Course Outline
Introduction to RDBMS Concepts
- Relational Database Management System Concepts
- Examples of Commercial RDBMS including SQL Server, Oracle and MySQL
Relational Database Design Overview
- Entity Modelling
- Datatypes
Understanding SQL
- Overview of DML, DDL and DCL
Retrieving and Sorting Data
- Using Wildcard Filtering
- SELECT Statement
- ORDER BY Statement
Filtering Data
- WHERE Clause Operators
- Wildcard Filtering
Utilising Calculated Fields
- Concatenating Fields
- Using Aliases
Data Manipulation Functions
- Numeric
- Text
- Datetime
Grouping and Summarising Data
- GROUP BY Clause
- Aggregate Functions
Introduction to Subqueries
- Purpose of Subqueries
- Writing Subqueries
- Filtering using Subqueries
Joining Tables
- Concepts of Joining
- JOIN Statement
Combining Multiple Queries
- UNION Statement
Inserting, Deleting and Modifying Data
- INSERT Statement
- UPDATE Statement
- DELETE Statement
Advanced Topics Introduction
- Views
- Stored Procedures
- Transactions
- Permissions