Microsoft SQL Server 2008 courses

For both IT professionals and developers U2U offers a complete technology learning track on SQL Server technologies.

Our team of SQL Server trainers, directed by dr. Nico Jacobs, deliver not only the trainings scheduled at U2U Brussels, but also deliver onsite courses and workshops in Europe and Middle East. Also our team delivers on a regular basis seminars at Microsoft events on the latest SQL Server technologies.

Upgrade to MS SQL Server 2008

The new SQL Server 2008 builds on top of the SQL Server 2005 version, and extends this in many areas: Development, management as well as Business intelligence. The first three days of the course, we take developers and IT pros with a working knowledge of SQL Server 2005 into the new development and administration features of SQL Server 2008. Topics: Introducing the pillars of Sql Server 2008. Declarative Management Framework. Maintaining SQL Server 2008. Beyond relational: new and enhanced data types. Enhancements to Transact-SQL. The last two course days, targeted at people who are already familiar with the business intelligence products on SQL Server 2008, we present the new and improved aspects of SQL Server 2008 in Integration Services, Analysis Services and Reporting Services, with demos as well as hands-on exercises.

MS SQL Server 2008 for Developers

Nearly any business application is based on a relational database to store and deliver data. In the U2U courses for SQL Server developers, you will learn how to develop a database in SQL Server 2008 and quickly understand that a database is more than ‘just a bunch of tables’. Database features such as asynchronous database communications, index design, denormalisation, .NET integration... are a few of the topics on your menu !

MS SQL Server 2008 for Administrators

At U2U we have one 5 day course on SQL Server Administration. You can learn in that course how to install, configure and maintain a SQL server 2008 database... without forgetting the new 2008 features, such as the resource governor, the new auditing and the policy based management.

MS SQL Server 2008 Business Intelligence

Reporting and analysis applications are becoming more important in today's business applications. Queries that aggregate over a large portion of the data in a relational database slow down this database. Therefore, OLAP (OnLine Analytical Processing) cubes have been invented to provide performant aggregation querying over large amounts of data. Usually, not all the data needed for analysis or reporting is in the right format on the right location, Therefore, it is common to have an integration phase before the actual analysis or reporting phase to prepare the data.

In the USQ5BI course on Business Intelligence, you get an overview of the features of the server side Business Intelligence tools that Microsoft ships.For an in-depth course on Integration Services, we refer to course USQ5IS, for Analysis Services we refer to course USQ5AS and for Reporting Services we refer to USQ8RS.