Event Details

SQL Queries 1-Day 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.

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

INCLUDED:

What can/can't I bring to the event?

You can bring your own Laptop - let us know beforehand

You canbring your own data and examples - let us know beforehand

Refreshments: Tees, coffees and light refreshments are included in the price

Certificates: You will get attendance certificates

Notes: You will getbrief course notes

After course support: 24-hours turnaround email support is included in the price

Telephone support:Call if you have questions, although me may only answer at around 4pm after lessons.

On-site support: 2-hours on-site support is included after the course, to be used within 2 weeks of completion

We offer Training Courses in Software Packages:

Certification:

Our PCWorkshops certificates are assessment based.Our course outlines are in-line with Oracle courses. We assist with exam prep for the presitigeous, international Oracle Certified Associate qualification.

Our clients are:

Data analysts and all others who use large sets of dataSoftware companies, testing companies,companies who employ software developersCoders and new coders who need Accredited Java qualification

Customisation:

We can tailor courses. In addition, we are able to offer in-house training.What makes us different: all our Access Database, Excel, Word, Publisher, PowerPoint are offered as a standard on a 1-1 basis.The Excel VBA, Database Design, SQL, SSRS, SQL Report Builder and Java Courses are in groups of 4, but could also be 1-1.