Course details
Overview:
Elements of this syllabus are subject to change. This 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.
Objectives:
- 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.
Course Location
About Global Knowledge Egypt
Global Knowledge is the worldwide leader in IT and business skills training. They deliver via training centers, private facilities, and the Internet, enabling their customers to choose when, where, and how they want to receive training programs and learning services.
See all Global Knowledge Egypt coursesSQL Server Related Questions
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- MCSA Windows Server 2016 (70-740) Lead AcademyAED 92
AED 1,432Duration: Upto 6 Hours - SpeedGrade CC 1TRAININGAED 78
AED 563Duration: Upto 14 Hours