Microsoft SQL Server Database Administration

Concentrika poppy

About the course

The course is intended for those who need to find out how to administer an SQL Server database, be this from the viewpoint of DBA, project manager, developer, or as support staff. Throughout the course, the training follows a pattern of firstly how and why SQL Server works as it does, followed by how to engineer changes hands on. Lastly, as the course moves on and the delegate acquires more skills, business based workshops are introduced. These require you to decide how a database should be built, deployed and managed, as well as drawing upon the hands-on skills needed to effect an actual outcome based on your decisions.

On leaving the course, you will be able to build a database, create users and their infrastructure, interconnect databases and load data. You will understand how to roll out a system on another machine. Backup and restore forms a vital part of the training.

Delegates from Version 7 of SQL Server, as well as SQL Server 2000 will benefit from this course.

Prerequisites

Delegates should have some familiarity with SQL Server, at least at the introductory level. A general knowledge of the underlying WNT4 platform is required.

Duration

3 days

1. Introducing database administration

Responsibilities of a DBA
Elements of an RDBMS
Client server considerations
SQL Server 7 architecture

5. Moving data about the business

Connectivity options
Data transformation services
Linked servers
Bulk copying with the bcp utility
Distributed queries and rpc
The ‘bulk insert’ command
Running T-SQL commands files in batch – isql and osql

9. Replication

Replication architecture
Transaction consistency
Snapshot, merge and transactional replication

2. Installing SQL Server

6. Users and Security

User management strategies
Login names and user names
Managing security
permission and privilege
roles
trusted login

10. Trouble shooting

Performance monitoring
Changing and testing the system
Causes of problems – processes, data design, system settings

3. Managing the database environment

Components of a database
Creating and deleting a database
Startup and shutdown
System parameters

7. Backup and Recovery

Backup and recovery strategy
Types of failure
Types of backup
Logging strategies
Backup and restore techniques

4. Data storage

I/O architecture
Datafiles and filegroups
Planning database scope
Transportable databases
Tracking space usage

8. Automation

Components of automated administration
Setting up mail
Operators
Alerts
Jobs