Brand Names and Trade Marks are the property of their respective holders and are used for description purposes only.

Microsoft SQL Server 2005 provides a new Management Studio, integration with Visual Studio 2005, and the Microsoft .NET common language runtime - all of which help you build, debug, and operate applications faster and more efficiently.
SQL Server 2005 provides a comprehensive business intelligence platform for data integration, analysis, and reporting that helps you turn insight into action and make better decisions, faster.
SQL Server 2005 supports the highest performance, availability and security to run your most demanding applications with native data encryption, secure default settings, and password policy enforcement.

Course 2789: Administering and Automating Microsoft SQL Server 2005 Databases and Servers

One day; Instructor-Led

This one-day instructor-led course provides students with the knowledge and skills to administer and automate Microsoft SQL Server 2005 databases and servers. This course focuses on the need to maintain administration and automation information.

Labs Include:

Creating Maintenance Plans. Creating Database Change Control Procedures. Configuring And Using the SQL H2 Tool. Moving Packages Between Database Servers. Initializing a Transactional Subscription From a Backup. Configuring Reporting Services.

Course 2786: This two-day instructor-led course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL Server 2005 database infrastructure.

Course 2788: This three-day instructor-led course provides students with the knowledge and skills to design high availability database solutions using Microsoft SQL Server 2005. The course focuses on teaching experienced database administrators working in enterprise environments to design database solutions that meet the availability needs of their organization. It emphasizes that students should think broadly about high availability, which includes thinking about the database itself and about their entire environment, including business needs; regulatory requirements; and network, systems, and database considerations during design. Students will also learn how to document and test the high availability database solution.

Course 2781: This three-day instructor-led course provides students with the knowledge and skills to design server-side solutions for Microsoft SQL Server 2005.

•	Designing Security for Microsoft SQL Server 2005 Course 2787: This two-day instructor-led course enables database administrators who work with enterprise environments to design security for database systems using Microsoft SQL Server 2005.

•	Designing the Data Tier for Microsoft SQL Server 2005 Clinic 2783: This one-day instructor-led clinic provides students with the knowledge and skill to design the data tier for Microsoft SQL Server 2005.

•

Implementing a Microsoft SQL Server 2005 Database Course 2779: This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database.

•

•

Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services Course 2791: This three-day instructor-led course teaches students how to implement an Analysis Services solution in their organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution.

•

Implementing and Maintaining Microsoft SQL Server 2005 Integration Services Course 2792: This three-day instructor-led course teaches students how to implement an Integration Services solution in their organizations. The course discusses how to develop, deploy, and manage Integration Services packages

•

Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services Course 2793: This three-day instructor-led course teaches students how to implement a Reporting Services solution in their organizations. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution

•	Maintaining a Microsoft SQL Server 2005 Database Course 2780: This learning product will enable IT Professionals to become skilled on the maintenance related product features and tools of SQL Server 2005

•	Maintaining a Microsoft SQL Server 2005 Database Course 2780: This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2005 database.

•

Managing and Maintaining Microsoft SQL Server 2005 Course 2785: This Distance Learning version of the course consists of 10 online live instructor-led sessions over 5 weeks (2hrs 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.

•	Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server­ 2005 Workshop 2790: The purpose of this two-day workshop is to teach database administrators working in enterprise environments how to determine and troubleshoot performance issues using Microsoft SQL Server 2005.

•	Tuning and Optimizing Queries Using Microsoft SQL Server 2005 Workshop 2784: This three-day instructor-led workshop provides database developers working in enterprise environments using Microsoft SQL Server 2005 the knowledge and skills to evaluate and improve queries and query response times.

•

Upgrading to Microsoft SQL Server 2005 Course 7031: This course is intended for experienced database professionals who will be responsible for upgrading to SQL Server 2005. The target students for this course already have an understanding of how to use the SQL Server 2000 and SQL Server 2005 and understand the new features and capabilities of SQL Server 2005.

•	Writing Queries Using Microsoft SQL Server 2005 Transact-SQL At the end of this three-day course, students who are new to SQL Server will learn how to write basic Transact-SQL queries for Microsoft SQL Server 2005.

This Script is used to create a Backup for a Filegroup

BACKUP DATABASE [TestDB] -- backup the database in the [ ]
FILEGROUP = N'PRIMARY' -- backup just the primary file group
TO  DISK = N'F:\Backup\TestDB.bak'-- the backup file to create
WITH NOFORMAT, NOINIT, -- Format the tape, NoInit = append to existing file
NAME = N'AW_IT_assets-Full Filegroup Backup', -- name of the tape
SKIP, NOREWIND, NOUNLOAD -- skip errors, don't rewind when done, eject tape when done.
GO

This Script is used to create a Database

use master
go
create database TestDB -- database name of new database
on (name = 'transacttestdb', -- logical name of the file (used by SQL Server)
   filename = 'C:\TestDB\TestDB.mdf', -- primary file of the database
size = 20 mb, -- default size is 20mb
filegrowth = 0) -- default filegrowth as specified by SQL Server (usually 10% of starting size a.k.a. 2mb)
log on (name ='transacttestdb_log', -- log file for the database
   filename = 'D:\TestDB\TestDB_log.ldf', -- should be on a seperate disk for better performance.
size = 5 mb, -- default size should be 1/4th of the data file size
filegrowth = 0) -- default filegrowth as specified by SQL Server (usually 10% of starting size a.k.a. 500KB)

 SQL 2000 Courses:

Course 2071: Querying Microsoft SQL Server 2000 with Transact-SQL (two days)

Course 2072: Administering a Microsoft SQL Server 2000 Database (five days)

Course 2073: Programming a Microsoft SQL Server 2000 Database (five days)

Course 2074 : Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000 —Five days

SQL Server 2005 Books

Inside Microsoft SQL Server 2005: The Storage Engine This practical, hands-on book offers deep, thorough coverage of the internals of architecture and resource management in SQL Server 2005, focusing on the Storage Engine. The book features extensive code samples and table examples.

Programming Microsoft SQL Server 2005 Get the straightforward information you need to learn the core programmability features in SQL Server 2005. This guide offers hands-on programming instruction, practical examples, and code samples to help you design and develop robust database applications and business intelligence solutions.

Microsoft SQL Server 2005: Database Essentials Step by Step The popular, learn-by-doing tutorial—updated for SQL Server 2005. Teach yourself the fundamental techniques for designing, building, testing, and deploying SQL Server databases—one step at a time.

Microsoft SQL Server 2005: Applied Techniques Step by Step A skill-building, learn-by-doing tutorial to help developers and database administrators with basic product knowledge begin to master SQL Server 2005.

MCITP Self-Paced Training Kit (Exam 70-443): Designing a Database Server Infrastructure Using Microsoft SQL Server 2005 Announcing an all-new Microsoft Certified IT Professional (MCITP) Training Kit designed to help maximize your performance on Exam 70-443, an exam for the new MCITP: Database Administrator certification. This kit packs the tools and features exam candidates want most—including in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and a robust testing suite. It also provides real-world scenarios, case study examples, and troubleshooting labs for skills and expertise that you can apply to the job.

SQL Server 2000 Books

Microsoft SQL Server 2000 Reporting Services Step by Step Teach yourself how to author, deploy, and manage reports over the Web with SQL Server Reporting Services—one step at a time! Learn how to exploit the range of reporting capabilities at your own pace through hands-on exercises and practical examples.

Microsoft SQL Server 2000 DTS Step by Step Teach yourself how to develop a data movement application with SQL Server 2000 Data Transformation Services (DTS)—one step at a time! Discover the full range of DTS capabilities at your own pace through dozens of hands-on exercises and code examples.

Microsoft SQL Server 2000 High Availability Ensuring 24/7 database availability is crucial to your company’s success. Discover the best ways to help keep your critical, Microsoft SQL Server 2000–based systems up and running—and secure—with this in-depth guide, straight from the source.

MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 System Administration, Exam 70-228, Second Edition Learn how to install, configure, and administer SQL Server 2000—as you prepare for MCP Exam 70-228, a core requirement for MCDBA certification and an elective for the MCSE and MCSA tracks.

MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 Database Design and Implementation, Exam 70-229, Second Edition Learn how to design and implement database solutions using SQL Server 2000 Enterprise Edition—as you prepare for MCP Exam 70-229, a core requirement for MCDBA certification and an elective for the MCAD, MCSE, and MCSA tracks.