• Springfield Campus, Cambridge Street, Wolverhampton, WV10 0JR
Loading Events

« All Events

SQL

April 27 - April 28

£450

Enable Technology Ltd, in partnership with ECMS, is offering a two-day SQL course on Tuesday 27th April and Wednesday 28th April 2021.  10:00am – 16:00pm each day. Training will be delivered online, directly to your computer desktop using Microsoft Teams. You do not need to have Microsoft Teams installed on your computer to join the class.

All you will need is a computer with a reasonable internet connection and a microphone to communicate with the tutor.

All delegates will receive an email invitation with a link to join the training prior to the session. You just need to click on the link to join the class. Each attendee will receive an electronic PDF training manual to keep for reference. Everyone is issued with an attendance certificate after the training.

This practical hands-on course assumes no prior SQL knowledge. Participants will learn how to query a relational database. At the end and the course delegates will be able to extract filtered information, group and aggregate data, write update, insert and delete SQL statements, create and edit tables, views and stored procedures.

The topics covered on the course are:

Overview of Relational Databases

The SQL standard

The ANSI standards

Components of a relational database

Normalised data

Anatomy of a table

Primary and foreign keys

Joins

Components of SQL

Data Manipulation Language

SELECT operations

DISTINCT

Virtual columns

Column aliases

Functions

Restricting the rows returned

Multiple conditions

Ordering data

Inserting rows

Updating rows

Deleting rows

Joining tables

The theory of joining tables

Cross, Inner, Outer, Full, Left and Right

Composite joins

Table aliases

SQL92 and SQL89 Join syntax

Data Definition Language

Data types

Column attributes

Create table

Primary and foreign keys

Referential integrity

Alter and drop tables

Views

Defining simple views

Views with virtual columns

Restricted-column views

Joined-table views

Restricted-row views

View restrictions

Summarised Queries

Table aggregates

GROUP BY and aggregates

The HAVING clause

Subqueries

Using Subqueries

EXISTS

Correlated Subqueries

Advanced Subqueries

Further Data Manipulation Language

Unions

Self joins

Price for one delegate: £450.00 + VAT (discounts available for multiple bookings)

Webinar delivery is supported by the ECMS.  By enrolling on this event you are agreeing to share your data with the ECMS and with the Training Provider.  The ECMS is required to collect and share your data in order to comply with its contractual obligations.  For further information please refer to the ECMS Privacy Notice @ ECMS Privacy Notice

Enable Technology Ltd is a Training Associate of the ECMS.

Details

Start:
April 27
End:
April 28
Cost:
£450
Website:
https://theecms.co.uk

Organizers

The ECMS
Enable Technology

Venue

Online