Microsoft SQL Training Courses

We offer a two-day course unravelling the mysteries of SQL, a two-day advanced SQL programming course, a two-day SSRS training course, a one-day course showing how to upsize an Access database to SQL Server or tailored individual SSRS or SQL training or consultancy, depending on your time constraints and budget! All of our SQL training uses Transact-SQL or T-SQL, the Microsoft SQL Server dialect.

Please click on the SQL training course below that you are interested in. If you're not sure which is the right Microsoft SQL training course for you, please call us on the number above to speak directly with one of our trainers.

Microsoft SQL Training Courses

Course Days Description Pounds
Writing SQL 2 You may have a fantastic database, but unless you can extract useful information from it, it may as well not exist! This two-day course shows you how to mine your database, from getting a mailing list of people meeting certain criteria through to compiling summary information for the board. Note that the SQL language varies slightly between different database providers; this course teaches the T-SQL or Transact-SQL language using SQL Server 2005. 595
SQL Programming and Stored Procedures 2 If you are comfortable creating queries in SQL, maybe it is time to move on to learn more advanced programming topics? This two day course assumes that you know how to use the main SQL keywords SELECT, FROM, WHERE, GROUP BY and ORDER BY, and shows you how to really progam in SQL Server. Learn how to write stored procedures, create 3 different types of function, use subqueries effectively - and much more! 695
Upsizing Access to SQL 1 Have you got an Access database which is getting unwieldy? Symptoms to watch out for include a database which runs slowly, or one which crashes a lot. If this sounds familiar, maybe it is time to upsize to SQL Server. In theory you could just the Access upsizing wizard, but bitter experience tells us that this will leave a host of issues unsolved. This one-day course tells you what to look out for when upsizing, and gives you invaluable hints and tips to make the upsizing process easier and the final SQL Server database more reliable. 375
SSRS 2 In the current business environment organisations need to be able to transform data into clear, concise, user-friendly formats. This two-day SQL Server Reporting Services (SSRS) course shows you how to create, execute and manage reports. Using SQL Server 2005 Business Intelligence Studio you will create interactive reports and learn how to deploy and export them in various formats. You will also learn how to create ad hoc reports using the Report Builder and Report Model projects. 595
Tailored SQL 1 If you want to book tailored training in SQL, you want someone who knows the subject inside out, and who has developed databases in Access and SQL Server for many years. We have been writing SQL for many years and would now consider ourselves to be SQL gurus. Let us pass on to you as much of our accumulated knowledge as we can in a day (or book 2 or 3 days, to give us plenty of time to understand your database in detail). 595

Click on any of the SQL training courses above to see what the course covers in detail, and to see our current Microsoft SQL training course schedule.

Onsite Microsoft SQL training

Much of our Microsoft SQL training is onsite Microsoft SQL training. If you have three or more people who want training in the same subject, why not organise a course at a time and place of your convenience, where you choose the subject, duration and syllabus? Not only will you get computer training exactly tailored to your needs, but for groups of 3 or more it can work out cost-effective.

For example, you might have a CRM system written in SQL Server 2005, and want to get sales data from it. You could book a one-day tailored training course to explain your SQL server database structure and show how to use SQL to extract sales data.

Many other companies will claim to offer this service, but few have the expert staff, courseware and exercise systems in place to support it. Please call (01457) 858877 or email us to ask for more details.

Microsoft SQL Training Schedule

To see a list of the Microsoft SQL training courses that we currently have scheduled, click on one of the following links:

Recommended sites: TechTutorials

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