This page has 0 threads | Add post

Group classroom and online training courses

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:

Introduction to SQL Advanced SQL Fast track SQL Reporting Services Advanced SSRS Fast track SSRS Report Builder Introduction to SSIS Advanced SSIS Fast track SSIS SSAS Tabular Model

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:

Small course sizes - we have a maximum of 6 people on each classroom or online course.
A trainer! And not just anyone - our courses are only ever given by full-time Wise Owls.
Full colour courseware and exercises of oustanding quality.
A no cancellation guarantee (once you've booked and confirmed your training course, it will run).
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.
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).
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:

A computer for each delegate (obviously).
Lunch out each day at a local restaurant (chosen on the day of the course, after discussion!).
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
Advanced SQL	Thu/Fri 21-22 November 2024	21-22 Nov	2	Online	£950	Fully booked
Fast track SQL	Wed/Fri 27-29 November 2024	27-29 Nov	3	Online	£1,295	Book places
Advanced SSRS	Mon/Tue 02-03 December 2024	02-03 Dec	2	Online	£950	Book places
Introduction to SQL	Thu/Fri 05-06 December 2024	05-06 Dec	2	Online	£825	Book places
Fast track SSRS	Mon/Wed 09-11 December 2024	09-11 Dec	3	Online	£1,295	Book places
Introduction to SSIS	Mon/Tue 09-10 December 2024	09-10 Dec	2	Online	£825	Book places
Reporting Services	Thu/Fri 12-13 December 2024	12-13 Dec	2	Online	£825	Book places
Report Builder	Thu/Fri 12-13 December 2024	12-13 Dec	2	Online	£825	Book places
Advanced SQL	Thu/Fri 09-10 January 2025	09-10 Jan	2	Online	£950	Book places
Fast track SQL	Tue/Thu 14-16 January 2025	14-16 Jan	3	Manchester	£1,595	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!

SQL exercises

SSRS exercises

SSIS training exercises

SSAS exercises (tabular model)

Blogs

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

SQL

Reporting Services

Integration Services

Analysis Services (tabular)

Videos

We have a range of videos on all things SQL Server.

Report Builder videos

Selecting data in SQL

Advanced SQL

Reporting Services

Advanced SSRS

Integration Services

SQL Tips

Tips and tricks

Have a look at our SQL Server tips and tricks.

SQL Server tips

Training venues

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

Onsite SQL Server training (UK)

This page has 0 threads

Add a new post