Creating and Implementing Database Objects in SQL Server 2005

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

Overview

To create and implement key database objects in SQL Server 2005

Target Audience

Professionals typically pursuing a career as a Database Administrator, Database Developer or Business Intelligence Developer; individuals who do not work with SQL Server as a part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators among others

Prerequisites

This is a high-level technical path and candidates for the exam, and hence learners should be expert in the following areas: Tools usage UI navigation Wizards usage Writing code in the appropriate language (Transact-SQL, CLR Language, other scripting languages, etc.) Code debugging or syntactic issue resolution Troubleshooting Accomplishing specific focused tasks through the use of code or UI navigation

Expected Duration

190 min.

Course Objectives

Creating and Implementing Database Objects in SQL Server 2005

  • create a database table in SQL Server 2005, given a scenario.
  • create a database view in a given scenario.
  • create a database table and a database view.
  • identify recommended guidelines for designing indexes.
  • create a database index in a given scenario.
  • create an online index in SQL Server 2005.
  • create functions and triggers in a given scenario.
  • create stored procedures in a given scenario.
  • manage stored procedures in a given scenario.
  • create and implement a stored procedure.

 

SUBSCRIPTION COST



 

NEED HELP OR NOT SURE?