Jump to course:
iact

SQL Server 2008 – Installation and Admin

Overview

This course teaches the main facets of SQL Server 2008 Installation and Administration. The course will walk through installation options  from creating databases and tables, through securing, backing up and restoring, to monitoring and optimising performance.

The course is designed new database administrators and those managing a Windows Server environment who need to learn how to install and configure SQL Server 2008.

Overview

Overview of Microsoft SQL Server 2008. Comparing the different editions. Overview of Data Platform components. Overview of new features.

Installation

Using the Upgrade Advisor to prepare existing SQL Server databases. System requirements. Installing SQL Server 2008. Verifying the installation. Reviewing Installed components and Services.

Management Tools

Using the SQL Server Management Studio. Managing the environment with layouts. Registering additional servers. Using the Object Explorer. Working with Scripts, Projects and Solutions. Using the Query Editor. Using SQL Server Computer Manager. Using sqlcmd.

Creating Databases

Creating Data Files, Transaction Log files and Filegroups. Setting Database Options.

Database Objects

Creating tables. Understanding SQL Server Datatypes. Inserting, updating and deleting data. Querying data. Creating views and stored prodedures. Custom Data Types. Using .NET and XML datatypes.

Securing SQL Server 2008

Configuring access for security principals. Managing securable objects. Accessing system tables via Catalog views. Configuring
password policies and user mapping/impersonation for SQL standard accounts. Using encryption.

Securing Database Objects

Creating users and roles. Configuring object permissions. Understanding object ownership and schemas. Setting the execution context for stored procedures.

Backing up Databases

Creating backup files and backup sets. Backing up user and system databases using Transact-SQL and the GUI. Backing up databases located on multiple files and file groups. Designing a backup strategy.

Restoring Databases

The SQL Server recovery process. Restoring user databases. Restoring damaged system databases. Verifying backups. Setting restore options. Detaching and attaching databases.

Fault Tolerance Features

Configuring fault tolerance using database mirroring across servers. Configuring tolerance and load-balancing using database snapshots. Configuring failover clustering. Setting up and configuring replication.

Automating Administrative Tasks

Scheduling and monitoring administration tasks, such as query plan and index rebuilding. Using alerts and operators. Troubleshooting automated tasks, alerts and notifications. Creating a Database Maintenance Plan.

Performance Monitoring and Tuning

Using the Database Tuning Advisor. Monitoring using SQL Server Profiler. Analysing system performance by querying system metadata. Using DDL triggers for monitoring schema changes. Configuring event notifications.

Questions and Answers

No prior experience with database administration is required, although exposure to key terms such as tables, columns and rows is useful. Some experience with Windows administration concepts such as file system management and security are advantageous, but not required.

Course participants are provided with a manual containing fully worked examples and explanations of the techniques covered in this course.

This course teaches administrators how to install Microsoft SQL Server 2008, create and manage databases, create and deploy a security strategy, backup and restore databases, perform administrative tasks, monitor and optimize performance, and transfer and migrate data into databases.
Create and work with databases and data, with a large focus on querying and programming data access.

 3 Days

 

Course Testimonials

“The trainer’s knowledge of the subject matter was impeccable and this, matched with the very relevant course materials, ensured the course was a big success. We would certainly use Software Paths again for training in the future.”

Kainos

 
 

Start Dates

Looking for course dates? Find dates for your course here.


Find a Date