Bartle House training room, Manchester, United Kingdom
Have you got a corporate database from which you want to extract information? It might be Access, or it might be Sage or in SQL Server. This one-day course will not show you how to build new databases, but it will show you how to get information out of existing ones. The course explains how databases are constructed, then shows the ins and outs of creating queries and reports. Read more »
London, United Kingdom
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 query data using SQL, and shows you how to really progam in SQL Server. Learn how to write stored procedures; learn the differences between temporary tables, table variables, common table expressions, derived tables and the two types of table-valued function, and when to use each tool; find out what cursors are, and when you should avoid them; and learn about debugging and error trapping. Read more »