SkillSoft Creating and Implementing Database Objects in SQL Server 2005 Training 英文正式版(培訓課程軟體)
Skill Soft 發佈的針對各項內容的培訓課程。
發佈說明:對應培訓課程分別是:《Flash 8 中的動畫製作》《ABAP 程式設計 II》
《ABAP 程式設計 I》《ABAP 基礎原理》《SQL Server 2005 數據庫效能和優化》
《SQL Server 2005 備份和還原》《SQL Server 2005 中的數據獲取和查詢執行》
《水晶報表 XI 的報告基礎》《管理和維護 SQL Server 2005 數據庫》
《安裝 SQL Server 2005》《建立和應用 SQL Server 2005 中的數據庫對像》
《Check Point NGX 安全策略》《工作流導航和在 Flash 8 中的發佈》
Overview/Description
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 Minutes
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.
Course Number: 234647_eng
|
|