Microsoft training courses | Wise Owl - home page

Phone (01457) 858877 or email

SQL Server training courses and training resources

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!


 

Microsoft SQL Server training courses - scheduled

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 Learn you how to program in SQL, including creating stored procedures and user-defined functions (two days)
Reporting Services Learn how to use SSRS to create reports, including charts, gauges and the like (2 days)
Advanced SSRS For those who already know how to create reports in SSRS, find out more about what this great product can do!
Analysis Services Learn about cubes, the MDX language and even basic data-mining on this SSAS 3-day course.
Integration Services 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.

Back to top ...


 

SQL Server course training materials / user manuals

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.

Back to top ...


 

SQL Server training course 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!

Category Exercises Notes
SQL exercises 75 Exercises in writing SQL and programming in SQL
SSRS exercises 53 Exercises in creating reports in SSRS
SSAS 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!

Back to top ...


 

SQL Server versions

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.

Back to top ...


 

SQL Server online training resources: tutorials, videos and blogs

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!

Back to top ...


 

SQL Server consultancy and database development

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!

Back to top ...


 

SQL Server training venues

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!

Back to top ...


All content copyright Wise Owl Business Solutions Ltd 2013. All rights reserved.