Prerequisites Windows NT Administration or equivalent experience is required. SQL Introduction or a working knowledge of basic SQL statements (SELECT, UPDATE, INSERT, DELETE) is required.
Duration 2 day(s)
Installing SQL Server
Introducing SQL Server
Getting Started with SQL Server
Configuring the Server for Installation
Installing SQL Server
Working with Administrative Applications
Administering SQL Server
Working with the Service Manager
Exploring the Enterprise Manager
Viewing Table Data in the Enterprise Manager
Working with the Query Analyzer
Getting Help from Books Online
Managing Server and Database Security
Getting Started with SQL Server Security
Choosing an Authentication Mode
Creating Server Logins
Managing Database Users and Roles
Assigning Permissions to Users and Roles
Using Views to Control Access to Data
Using Stored Procedures to Control Access to Data
Working with Databases
Creating a Database
Managing Database Files
Configuring Database Options
Deleting a Database
Generating Scripts for Recreating Objects
Backing Up and Restoring Data
Understanding SQL Server Backup
Creating a Backup Device
Backing Up a Database
Backing Up a Transaction Log
Restoring a Database
Scheduling a Backup
Automating Server Administration
Configuring the SQL Server Agent Service
Creating Operators to Receive Messages
Scheduling Jobs
Working with Server Error Messages
Creating Alerts
Importing and Exporting Data
Importing Data
Exporting Data
Exploring the Data Transformation Services Designer
