Our training courses

Other training resources

Our training venues

Why we are different

SQL Server training courses

Wise Owl cover the full range of SQL Server training courses: SQL, SSRS, SSAS and SSIS, offering small course sizes (max 6 people) and friendly but expert online or classroom training.

We currently run the following scheduled SQL Server courses:

Not exactly the course contents you want? Why not consider organising your own tailored SQL Server course)?

More about our SQL Server training

SQL Server is Microsoft's flagship database. Simplifying slightly, you can divide it into the following parts:

Part

What it's used for

Database development

The first thing to do in SQL Server is to create a database, consisting of a number of different related tables. We don't run formal training courses in this as everyone's needs are different, but we can lend you our 30+ yeras of experience of building systems in the form of SQL Server consultancy.

Database querying

Most SQL Server users already have a database; what they want to do is to write queries to get the data out using Transact SQL, Microsoft's dialect of SQL (Structured Query Language). We run a two-day course showing how to select data from a database, and an advanced two-day course showing how to write stored procedures and program in SQL.

Database reporting

SQL queries just output data in tabular format. SQL Server Reporting Services (often abbreviated to SSRS) allows you to create paginated reports based on the tables in your database for printing, converting to Excel or emailing out to interested parties (Report Builder is a version of SSRS which allows you to create one report at a time - you can see the differences between SSRS and Report Builder here).

ETL

SQL Server Integration Services (often abbreviated to SSIS) allows you to Extract, Transform and Load data (so SSIS is often referred to as an ETL package). SSIS one of Wise Owl's favourite products, letting you draw pretty pictures showing how your data is moving around!

Data warehousing

A SQL Server database is called an OLTP (getting weary of these acronyms yet?) or online transaction processing database, but SQL Server also allows you to create an OLAP (online analytical processing) database using something called SQL Server Analysis Services (or SSAS for short). Past versions of SSAS required you to build something called cubes, but for many years now you have been able to use the SSAS tabular model to produce a database containing aggregated data for quick reporting.

If you're not sure where to start with all this, please get in touch and ask

10 things our courses include

Each of our scheduled courses (whether classroom or online) includes:

  1. Small course sizes - we have a maximum of 6 people on each classroom or online course.
  2. A trainer! And not just anyone - our courses are only ever given by full-time Wise Owls.
  3. Full colour courseware and exercises of oustanding quality.
  4. A no cancellation guarantee (once you've booked and confirmed your training course, it will run).
  5. A one gigabyte USB stick, containing course files, answers to exercises and (by the end of the course) your answers too, together with a nice pen.
  6. Unofficial help after the course (although we don't have a dedicated post-course support line, in practice trainers will be happy to answer the odd ad hoc question after a course has taken place).
  7. A certificate sent out digitally or in paper form (your choice) after each course, together with (for tailored courses) the trainer's thoughts on how the course went.

In addition, our classroom courses also include:

  1. A computer for each delegate (obviously).
  2. Lunch out each day at a local restaurant (chosen on the day of the course, after discussion!).
  3. Unlimited refreshments during the day, including Tassimo or Nespresso coffee and a range of biscuits and snacks to keep you going through those dark afternoon hours.

Still not convinced? You can read hundreds of testimonials to the quality of our training (all attributed and added in the last 3 years.

Scheduled SQL Server training dates

Here are the next SQL Server courses we have scheduled:

Course Dates Days Venue Price Booking
Reporting Services Mon/Tue 20-21 May 2024 20-21 May 2 Online £825 Book places
Advanced SQL Tue/Wed 21-22 May 2024 21-22 May 2 London £1,450 Fully booked
Fast track SSRS Tue/Thu 28-30 May 2024 28-30 May 3 Online £1,295 Book places
Introduction to SQL Thu/Fri 30-31 May 2024 30-31 May 2 Online £825 Book places
Report Builder Thu/Fri 30-31 May 2024 30-31 May 2 Online £825 Book places
Introduction to SSIS Thu/Fri 30-31 May 2024 30-31 May 2 Online £825 Book places
Advanced SQL Mon/Tue 10-11 June 2024 10-11 Jun 2 Online £950 Book places
Reporting Services Wed/Thu 19-20 June 2024 19-20 Jun 2 Online £825 Book places
Introduction to SQL Tue/Wed 25-26 June 2024 25-26 Jun 2 London £1,350 Fully booked
Report Builder Thu/Fri 27-28 June 2024 27-28 Jun 2 Online £825 Book places

All prices exclude VAT. If you can't see the dates you want, don't forget that you always have the option of arranging onsite training at your offices (we'll even provide the computers and projector).

Other SQL Server training resources

There are many ways in which we can help you learn SQL Server!

Exercises

We want you to know exactly what you're buying when you book out training, so we've published our SQL Server exercises online for you to inspect!

Blogs

The blogs below include a full tutorial on writing SQL, and all sorts of goodies on SSIS, SSRS and SSAS.

Videos

Tips and tricks

Have a look at our SQL Server tips and tricks.

Training venues

Most of our SQL Server scheduled courses run in Manchester or London, but we also do onsite training anywhere in the UK.

This page has 0 threads Add a new post

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.

End of small page here
Please be aware that our website uses cookies!
I'm OK with this Tell me more ...