Bemerkung |
This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database.
This course is intended for IT Professionals who administer and maintain SQL Server databases.
After completing this course, students will be able to: • Create databases and database files. • Create data types and tables. • Use XML-related features in Microsoft SQL Server 2008. • Plan, create, and optimize indexes. • Implement data integrity in Microsoft SQL Server 2008 databases by using constraints. • Implement data integrity in Microsoft SQL Server 2008 by using triggers. • Implement views. • Implement stored procedures. • Implement functions. • Implement managed code in the database. • Manage transactions and locks. • Use Service Broker to build a messaging-based solution.
Before attending this course, students must have: • Basic knowledge of the Microsoft Windows operating system and its core functionality. • Working knowledge of Transact-SQL. • Working knowledge of relational databases. • Some experience with database design
Additional informations: http://www.microsoft.com/learning/en/us/syllabi/6232aprelim.mspx
(Sofern die deutschen Kursunterlagen verfügbar sein sollten, wird die deutsche Version im Schulungsraum verwendet. Die Kurssprache ist Deutsch) |
|