This SQL Server course will enable delegates to program databases. This includes developing in Transact-SQL. The course will cover the structure of a SQL Server 2008 database. Delegates will be able to create stored procedures, triggers, functions and views.
The course will cover improving database performance by indexing tables and using SQL Servers inbuilt tools. The course will also look at the new features in SQL Server 2008 that are not available in SQL Server 2005.
This course is designed for those who are responsible for implementing database objects and programming SQL Server databases by using Transact-SQL.
An understanding of basic relational database concepts, including:
• Logical and physical database design
• Relationships between tables and columns (primary and foreign keys, one-to-one, one-to-many, many-to-many)
Check out more programming courses by David Ringsell:
Copyright 20/12/12 - David Ringsell