SQL Training – Introduction

Acuity Training London
4.0
2 reviews
  • I had an wonderful experience with great trainers to teach. The course and the trainers are very much recommended.
    ← | →
  • Acuity and their classes are highly recommended for they give great attention to each individual. The centere is located amazingly too.
    ← | →

Course

In London

£ 495 VAT inc.

The best SQL Server courses

See all

See all

Description

  • Type

    Course

  • Location

    London

This 1 day (Structured Query Language) SQL training course will rapidly give you a thorough grounding in the basics of SQL. It will show you the key features and capabilities of SQL and get you using it as quickly as possible. The course covers elements of ANSI SQL using SQL Server as an example database.

Facilities

Location

Start date

London
See map
99 Bishopsgate, EC2M 3XD

Start date

Different dates availableEnrolment now closed
Different dates availableEnrolment now closed
Different dates availableEnrolment now closed

About this course

To give delegates an introduction to the features and capabilities of Structured Query Language (SQL). The course covers elements of ANSI SQL using Microsoft SQL Server as an example database.
This course is suitable for anyone who wants to learn the basics of SQL whether using Microsoft SQL Server, Microsoft Access, Oracle, MySQL, Google BigQuery or other database systems.

It is recommended that delegates have good experience of windows and some experience of relational databases.

Our courses run from 9.30 am to approximately 4.30 pm. While you are with us we are focused on offering you a relaxed and productive learning environment. When you book a course with use you get the following:
A full colour SQL course manual.
The exercises that you have worked on during your course to allow you to practice afterwards.
USB stick to take the exercises away.
Freshly prepared lunch
Refreshments though out the day.
Training in fully air conditioned facilities from an experienced SQL instructor.
A certificate of attendance.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.0
  • I had an wonderful experience with great trainers to teach. The course and the trainers are very much recommended.
    ← | →
  • Acuity and their classes are highly recommended for they give great attention to each individual. The centere is located amazingly too.
    ← | →
100%
4.9
excellent

Course rating

Recommended

Centre rating

Trusted Customer

4.0
06/01/2018
What I would highlight: I had an wonderful experience with great trainers to teach. The course and the trainers are very much recommended.
What could be improved: Nothing
Would you recommend this course?: Yes

Tyron van Rooyen

4.0
01/01/2018
What I would highlight: Acuity and their classes are highly recommended for they give great attention to each individual. The centere is located amazingly too.
What could be improved: Nothing
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2019

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 10 years

Subjects

  • Presentation
  • Transactions
  • Server
  • Works
  • Database
  • SQL
  • Database training
  • Syntax
  • Writing
  • Sql training

Course programme

Getting Started

We start this session with an overview of relational databases and how SQL works within that context. We also have a look at the database that we will be running out SQL queries on during this course and get comfortable with the interface.

The key topics trained are:

  • Relational Database Concepts
  • The role of SQL
  • Overview of the databases used in the workshop
Writing Basic SQL Statements

• The syntax of the SELECT statement
• Using the DISTINCT keyword
• ORDER BY
• Examples of WHERE criteria including wildcards, comparison operators, BETWEEN, LIKE, IN

Single Row Functions

• Performing mathematical calculations
• The types of functions available in SQL
• Useful date functions
• GetDate( )
• DateADD( )
• DateDIFF( )
• Conversion functions and their uses
• Column aliases

Grouping Data

• How to write aggregate queries
• COUNT Vs Count(*)
• GROUP BY
• HAVING

If time permits - SQL Joins

• The principle of including data from multiple tables in queries
• Joining multiple tables in the FROM clause
• Different join types including INNER and OUTER joins and SELF joins

See related categories

SQL Training – Introduction

£ 495 VAT inc.

The best SQL Server courses

See all

See all