Creating and Implementing Database Objects in SQL Server 2008

This course is included in our On-demand training solution.


SQL Server 2008 is a robust database system that provides a number of database objects used to store and view data. In order to configure a SQL Server 2008 database to meet business requirements, administrators and developers must fully understand how to design, create, and configure these database objects. These objects include tables for storing data in the database, views to allow access to the data within specific tables, and indexes to optimize the performance of the database for data retrieval. This course identifies each of these database objects and demonstrates the steps required to administer them within the SQL Server 2008 Management Studio tool. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-433 TS: Microsoft SQL Server 2008, Database Development. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development certification.

Target Audience

IT professionals who have jobs in which database administration is their main area of responsibility, or who work in environments in which databases are central to their job roles. These job roles include • IT generalists who work in environments in which SQL Server 2008 is part of an overall solution • IT professionals who manage systems that run SQL Server 2008 • IT professionals who work with third-party applications that are built on SQL Server 2008 • Developers who build applications that use SQL Server 2008


The prerequisites for the exam are that candidates should have one to two years of experience using Microsoft SQL Server 2008 or two to three years of experience using a previous version of SQL Server.

Expected Duration

150 min.

Course Objectives

Data Types and Column Types in SQL Server 2008

  • recognize how to define data types and column types


Creating and Altering Tables in SQL Server 2008

  • recognize how to create and alter tables


Creating and Altering Views in SQL Server 2008

  • recognize the function of views, and how to create and modify them


Permissions and Database Documenting in SQL Server 2008

  • recognize how to secure objects and document the structure of a database


Introduction to Indexes in SQL Server 2008

  • recognize index types and how to design a database indexing strategy


Creating and Managing Indexes in SQL Server 2008

  • recognize how to create and manage indexes


Creating and Managing Database Objects