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:
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!
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 SQL Server courses we have scheduled for the next 3 months:
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 SQL Server 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!
Blogs on SQL Server
The blogs below include a full tutorial on writing SQL, and all sorts of goodies on SSIS, SSRS and SSAS.
Videos on SQL Server
We have a range of videos on all things SQL Server.
SQL Server training venues
Most of our SQL Server scheduled courses run in Manchester or London, but we also do onsite training anywhere in the UK.
