Implementing and Maintaining a Microsoft SQL 2005 Database (Certificate)

Techno-ed
Islamabad, Karachi, Lahore, Pakistan

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This Five-day instructor-led course training event provides delegates with the knowledge and skills needed to implement and maintain a Microsoft SQL Server 2005 database. The course focuses on how to use SQL Server 2005 product features and tools related to implementing and maintaining the database. This event will also give delegates an overview of writing and creating Transact SQL queries.This is an accelerated training event that will use elements from M2779 and M2780 courses, the delegates will also be supplied with an additional book (Learning SQL on SQL Server 2005) to supplement the course notes.

Who will the course benefit?
This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for Implementing and maintaining a SQL 2005 database. The course is also suitable to any IT Professionals wanting to update their skills from SQL 2000 to SQL 2005

Course Objectives
To provide SQL Server 2005 administration and programming skills for Database Professionals.

Skills Gained
This course will enable delegates to:

Install and configure SQL Server 2005.
Manage database files.
Manage security.
Perform administrative tasks.
Monitor and Troubleshoot SQL Server.
Transfer data.
Maintain high availability.
Create databases and database files.
Create data types and tables.
Use XML-related features in Microsoft SQL Server 2005.
Plan, create, and optimize indexes.
Implement data integrity in Microsoft SQL Server 2005 databases by Using constraints, triggers, and XML schemas.
Implement views, stored procedures and functions.
Implement managed code in the database.
Use Service Broker to build a messaging-based solution.
Prerequisites
All delegates should have a working knowledge of:

� Basic knowledge of the Microsoft Windows operating system and its core functionality.

� Working knowledge of Transact-SQL.

� Working knowledge of relational databases.

� Some experience with database design.

Follow-on Courses

MS2781 - Designing MS SQL Server 2005 Server-Side Solutions
Course Content

Installing and configuring SQL Server 2005
Preparing to install SQL Server
Installing SQL Server
Managing a SQL Server 2005 Installation

Managing Databases and Files
Planning databases
Creating databases
Creating Filegroups
Creating Schemas
Creating Database Snapshots
Managing databases

Creating Data Types and Tables
Creating Data Types
Creating Tables
Creating Partitioned Tables

Writing Queries Using Transact-SQL
Getting started with Transact-SQL.
Performing basic queries.
Grouping and summarizing data.
Joining data from multiple tables.
Working with subqueries.
Modifying data.
Querying metadata, XML, and full-text indexes.
Using programming objects for data retrieval.
Using advanced querying techniques.

Using XML
Retrieving XML by Using FOR XML
Shredding XML by Using OPENXML
Using the xml Data Type

Creating and Tuning Indexes
Planning Indexes
Creating Indexes
Optimizing Indexes
Creating XML Indexes

Implementing Data Integrity
Data Integrity Overview
Implementing Constraints
Implementing Triggers
Implementing XML Schemas
Implementing Views
Introduction to Views
Creating and Managing Views
Optimising Performance by Using Views

Implementing Stored Procedures and Functions
Implementing Stored Procedures
Creating Parameterized Stored Procedures
Creating Functions
Handling Errors
Controlling Execution Context

Implementing Managed Code in the Database
Introduction to the SQL Server Common Language Runtime
Importing and Configuring Assemblies
Creating Managed Database Objects

Using Service Broker
Service Broker Overview
Creating Service Broker Objects
Sending and Receiving Messages

Managing Security
Overview of SQL Server Security
Securing the Server Scope
Securing the Database Scope
Implementing Cryptography in SQL Server

Disaster Recovery
Planning a Backup Strategy
Backing Up User Databases
Restoring User Databases
Recovering Data from Database Snapshots
System Database and Disaster Recovery

Monitoring SQL Server
Viewing Current Activity
Using System Monitor and SQL Server Profiler
Using DDL Triggers and Event Notifications

Transferring Data
Overview of Data Transfer
Introduction to SQL Server Integration Services (SSIS)
Using SQL Server Integration Services

Automating Administrative Tasks
Automating Administrative Tasks in SQL Server 2005
Configuring the SQL Server Agent
Creating Jobs and Operators
Creating Alerts
Managing Multiple Servers
Managing SQL Server Agent Security

Maintaining High Availability
Introduction to High Availability
Implementing Server Clustering, Database Mirroring and Log Shipping

Introduction to Replication
Overview of Replication

Examinations
Recommended as preparation for Exam 70�31: Microsoft SQL Server 2005 - Implementation and Maintenance.
...''

Phone:+92-42- 585 4881-5

School Address:

Lahore
33-L, Gulberg III, Near Askari Flats, Kalma Chowk, Lahore
Ph: +92-42- 585 4881-5

Islamabad
Address: 13-P, Empire Center, 2 nd Floor, F-7 Markaz, Jinnah Super, Islamabad.
Ph: +92-51- 2654108

Karachi
190-A, Block -AS.M.C.H, Shahrah-e-Faisal, Karachi.
Ph: +92-21- 4381833-4



Jobs & Resumes: Islamabad, Karachi, Lahore
Houses & Roommates: Islamabad, Karachi, Lahore
Travel Agencies: Islamabad, Karachi, Lahore

Search other schools for Implementing and Maintaining a Microsoft SQL 2005 Database training resources.

Oracle9i Database: Fundamentals
Oracle Database 10g: Programming with PL/SQL
Oracle9i Forms Developer: Build Internet Applications
Oracle9i Reports Developer
Oracle Database 10g Admin- (OCA)
Oracle Database 10g Admin (OCP)
Oracle 11i E-biz Solutions
Oracle 11i Financials General Ledger
Oracle Jdeveloper
Implementing a Microsoft SQL Server 2005 Database
Maintaining a Microsoft SQL Server 2005 Database
Updating Your Database Administration Skills to Microsoft SQL Server 2005
Updating Your Database Development Skills to Microsoft SQL Server 2005
RH 033 Red Hat Linux Essentials
RH 133 Red hat Linux System Administration
RH 253 Red hat Linux Network & Security
IT Essentials
Network Operating Systems
Building Cisco Multilayer Switched Networks

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges.