SQL Training – Advanced

Acuity Training London
4.0
2 reviews
  • I found the course quite amazing and Iam very much looking forward for more courses from here very soon.
    ← | →
  • I had opted for Management Training and I found the course and really fruitfull and was taught amazingly by knowledgeable trainer.
    ← | →

Course

In London

£ 795 VAT inc.

The best SQL Server courses

See all

See all

Description

  • Type

    Course

  • Location

    London

  • Duration

    2 Days

This advanced SQL training course will further develop your use of SQL to manage a relational database.

By the end of this advanced course you will be a very capable SQL user confident to use its more complex commands when viewing and managing tables. You will also be able to run complex queries.

Facilities

Location

Start date

London
See map
99 Bishopsgate, EC2M 3XD

Start date

MayEnrolment now closed
FebruaryEnrolment now closed
MarchEnrolment now closed
AprilEnrolment now closed

About this course

To develop your knowledge of writing SQL scripts to manage data stored in a relational database.
This course is suitable for anyone who wants to learn the advanced SQL querying whether they work with Microsoft SQL Server, Microsoft Access, Oracle, MySQL, Google BigQuery or other database systems.

Delegates for this course should have a basic understanding of SQL select statements.

This course assumes a knowledge of SQL to the level of our Introduction course.

This is a fun, hands-on course during which you will be encouraged to work individually to practice the techniques that you are being taught.

Please see here if you are looking for Microsoft SQL Server specific courses.

Our courses run from 9.30 am to approximately 4.30pm.
We include everything that you will need for a productive day’s training.
When you book a course with us you get the following:
A full colour advanced 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 in our onsite cafeteria.
Refreshments though out the day.
Training in fully air conditioned facilities from an experienced SQL instructor.
We do not have a dress code. Please come wearing whatever your are most comfortable wearing.

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 found the course quite amazing and Iam very much looking forward for more courses from here very soon.
    ← | →
  • I had opted for Management Training and I found the course and really fruitfull and was taught amazingly by knowledgeable trainer.
    ← | →
100%
4.9
excellent

Course rating

Recommended

Centre rating

Cathryn Jayne in Thames Ditton

4.0
07/02/2018
What I would highlight: I found the course quite amazing and Iam very much looking forward for more courses from here very soon.
What could be improved: Nothing
Would you recommend this course?: Yes

Daniel Rodrigues

4.0
06/01/2018
What I would highlight: I had opted for Management Training and I found the course and really fruitfull and was taught amazingly by knowledgeable trainer.
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

  • Writing
  • Access
  • Presentation
  • Transactions
  • Database
  • SQL
  • Database training
  • Syntax
  • Maths
  • SQL Database
  • SQL Server

Course programme

Getting Started

• Relational database concepts
• The role of SQL and ANSI standards

Creating our training database

• Creating a database
• Creating tables
• SQL data types
• Altering tables (adding, dropping and renaming columns)
• Table and column constraints
• The role of indexes
• Inserting data
• Importing data

SQL Scripts

• Good practice when writing SQL queries
• Exploring the templates and stored procedures available in SSMS
• Saving script files v saving stored procedures
• Using Parameterised queries

Advanced SQL SELECT statements

• Recap on writing JOIN statements and column and table aliases
• ISNULL() function v IS NULL criterion
• Useful string, date and convert functions •Aggregate functions
• Group by clause including rollup
• IF and CASE
• UNION queries

DML and Transaction Control

• Working with INSERT
• Working with UPDATE
• Working with DELETE
• Creating computed columns
• Using Begin transactions with Commit and Rollback
• Simple error trapping

Sub Queries and Window Functions

• Writing sub queries
• Over() and Over(Partition by)
• Row() v Rank()

Managing Views

• Creating a view
• Selecting data using a view
• Altering and dropping views

See related categories

SQL Training – Advanced

£ 795 VAT inc.

The best SQL Server courses

See all

See all