|
MS-2785
IMPLEMENTING & MAINTAINING MICROSOFT SQL SERVER 2005
(Distance Learning)
Tuition: $2125
Elements of this syllabus are subject to change.
This Distance Learning version of the course consists of 10 online
live instructor-led sessions over 5 weeks (2 hours for each
session). These sessions would be accompanied by additional
self-paced e-learning content, scenario-based labs, and assessments
to provide students with the knowledge and skills to manage and
maintain Microsoft SQL Server 2005.
Prerequisites
Before
attending this course, students must have met at least one of the
following
-
Basic knowledge of
the Microsoft Windows op0erating system and its core functionality
-
Working knowledge of
Transact-SQL
-
Working knowledge of
relational databases
-
Some experience with
database design
-
Working knowledge of
XML
Microsoft Certified
Professional Exams
-
Exam 70-431: TS:
Microsoft SQL Server 2005 – Implementation and Maintenance
Skills Gained
At the
end of the course, students will be able to:
·
Install and configure
SQL Server 2005
·
Create databases and
database files
·
Create data types and
tables
·
Generate basic SQL
Server 2005 queries and XML reports
·
Manage SQL Security
This course syllabus
should be used to determine whether the course is appropriate for the
students, based on their current skills and technical training needs:
Course content, prices,
and availability are subject to change without notice.
-
Backup and restore
user databases
-
Recover system
database in the even of a disaster
-
Implement data
integrity for a database by using the constraints, triggers, and XML
schema
-
Implement basic
stored procedures and functions
-
Mirror SQL databases
|
