This course looks at many of the new features within Microsoft SQL Server 2008 and will give you a first look at Microsofts new powerful database server. You will learn about new T-SQL data types and syntax enhancements, see how to store and manipulate unstructured data, and learn about the SQL CLR and new advances in client data access. Youll also take a first look at the new Visual Studio Team System Edition 2008 for Database Professional, and check out the new and improved administrative features in PowerShell, security, FullText search, and many more.
At Course Completion:
After completing this course, students will be able to:
Use the new features in Management Studio for administering a database, creating objects, and writing and debugging code.
Apply what's new in Integration Services, Reporting Services, Service Broker and Analysis Services.
Install or upgrade from an earlier version of SQL Server.
Use the new data types, including spatial data and heirarchyID.
Apply Sparse columns and column sets to effect databases size.
Exploit Table-valued parameters.
Use Grouping sets to streamline complex GROUP BY clauses.
Utilise the MERGE statement to perform multiple operations in a single statement.
Make use of enhancements to SQLCLR code.
Utilise Visual Studio 2008 Team System for Database Professionals, or Data Dude, to build database projects.
