Phone (01457) 858877 or email
Wise Owl cover the full range of SQL Server courses: SQL, SSRS, SSAS and SSIS. Use the links below to get information on our courses, manuals, exercises, tutorials, blogs and more!
Think SQL Server is a sledgehammer, and your problem is a nut? Try our Access training instead!
Wise Owl run the following public courses in SQL Server:
| Course | Summary |
|---|---|
| Introduction to SQL | Learn how to select data using SQL two days) |
| Advanced SQL training | Learn you how to program in SQL, including creating stored procedures and user-defined functions (two days) |
| Reporting Services training | Learn how to use SSRS to create reports, including charts, gauges and the like (2 days) |
| Advanced SSRS training | For those who already know how to create reports in SSRS, find out more about what this great product can do! |
| Analysis Services training | Learn about cubes, the MDX language and even basic data-mining on this SSAS 3-day course. |
| Integration Services training | A two-day couse covering creating and scheduling packages to import and transform data. |
If you can't see the SQL Server course you want in the list above, it's always worth ringing us or contacting us online to see if we can tailor a course to your needs.
To help you decide whether Wise Owl training is for you, take a moment to download one of the typical SQL Server course manuals below (all of our manuals follow the same guidelines and style):
| Course manual | Chapter title |
|---|---|
| Integration Services | Data Flow |
| SSRS 2008 R2 | Report Items |
| Report Builder 3.0 | Formatting Reports |
| SQL | Using WHERE |
| Analysis Services 2008 R2 | Hierarchies and relationships |
| SSRS 2008 R2 | Embedding Code in Reports |
If you're a large company (and not a training organisation) you may want to consider licensing our SQL Server courseware.
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!
| Category | Exercises | Notes |
|---|---|---|
| SQL training exercises | 75 | Exercises in writing SQL and programming in SQL |
| SSRS training exercises | 53 | Exercises in creating reports in SSRS |
| SSAS training exercises | 21 | Exercises in creating cubes, dimensions, hierarchies and using MDX |
| SSIS training exercises | 18 | Exercises in creating and scheduling data transformation packages |
You'll get the answers to the exercises if you attend one of our SQL Server courses!
SQL itself may not have changed much over the different versions of SQL Server, but Reporting Services has:
For a more detailed guide to what's new in SQL Server 2012, try this SQL blog or this SSRS one.
We've published hundreds (literally) of blogs, tutorials and videos on SQL Server on this website:
| Online training | Notes |
|---|---|
| SQL tutorial online | Learn how to write SQL online! |
| SQL training videos | Videos showing how to write SQL programs |
| SSRS training videos | Videos showing how to create reports in Reporting Services |
| Blogs on SQL | All manner of blogs on issues and thoughts we've had about SQL programming |
| Blogs on SQL Server 2012 | Blogs specific to SQL Server 2012 |
| Reporting Services blogs | Blogs on foibles of SSRS, together with tutorial blogs |
| Analysis Services blogs | Things we've shared about Analysis Services |
We still think classroom training courses are the best way to learn, though!
We develop almost exclusively now in SQL Server (although we've built many an Access database in the past). We're particular gurus at writing SQL and at creating reports in Reporting Services, as well as at creating ASP.NET websites based on SQL Server back-end databases. Uniquely, we not only know all the software inside-out but have long experience of how to create systems which are easy to use and simple (not as easy as it sounds). Find out if we can help you!
We'll train on SQL Server at any venue in the UK (and overseas!), but our main venues for public SQL Server courses aree as follows:
| Training venue | Notes |
|---|---|
| SQL Server training London | We run our London SQL Server courses near Liverpool Street station |
| SQL training Manchester | Our Manchester training courses in SQL Server run just off St. Peter's Square |
| SQL training Birmingham | Our SQL Server courses in Birmingham run just off Victoria Square in the city centre |
Of course, we'll also do onsite tailored courses anywhere in the UK!