WHAT WE DO - Training & Mentoring
Implementing a SQL Server 2005 Database
Implementing a SQL Server 2005 Database
(Course 2779 - 5 days)
Learning Objectives & Approach:
This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database.
Key Topics:
During this course, you'll learn about:
- creating databases and database files
- creating data types and tables
- using XML-related features in Microsoft SQL Server 2005
- planning, creating and optimizing indexes
- implementing data integrity in Microsoft SQL Server 2005 databases by using constraints, triggers and XML schemas
- implementing views
- implementing stored procedures and functions
- implementing managed code in the database
- using Service Broker to build a messaging-based solution
Targeted Participants:
Database Administrators and IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for implementing a database.
Prerequisites:
Before attending this course, students must have:
- a 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
Course Fee:
For public courses, $2,375.00 (CAD) per participant. Group rates are available for both public and private courses - please inquire.
Registration:
Courses can be held at your site, or on-site at our training facility located in downtown Calgary, Alberta (Canada). Your team can join a public course, or request a private session.
To register for this course, use the "Register" link below.
Next public course: Sep 20 - 24