Microsoft SQL Server 2008 System Administration Fundamentals
Course: SSADMF
Duration: 3 Days
Level: I
On our website at:
http://www.verhoef-training.com/courses/SSADMF.html
Course Summary
This 3 day course is intended for students who need to learn
the essential skills necessary to maintain a Microsoft
SQL Server 2008 database infrastructure. Being concise
and hands-on, it is aimed at quickly getting students
familiar with the Microsoft SQL Server 2008 administration
concepts, tools and utilities. This course is effectively
an abridged version of the full 5 day Microsoft SQL Server
2008 System Administration course.
Topics Covered In This Course
Install and Configure SQL Server 2008
- Installation Prerequisites
- The Installation Process
- Post Install Configuration Options
Creating, Configuring and Managing Databases
- Creating a Database
- Configuring and Managing a Database
- Database Schemas
Creating and Managing Tables
- Creating a Table
- Native SQL Server Data Types
- Columns and Column Properties
Implementing and Managing Data Integrity
- Introducing Data Integrity
- Using Constraints to Implement Data Integrity
Creating and Managing Indexes
- SQL Server Index Architecture
- Creating Clustered Indexes
- Creating Non-Clustered Indexes
SQL Server 2008 Security
- Overview of SQL Server Security
- Security at the Server Level
- Security at the Database Level
Transferring Data
- Overview of Data Transfer
- Examining the Data Transfer Utilities
- Bulk Loading Data
- Using the Import/Export Wizard
- Introducing SQL Server Integration Services (SSIS)
Backups and Recovery
- Backup Types and Strategies
- Backing up a Database
- Restoring a Database
- Online Restore Operations
- Database Snapshots
- Recovering System Databases
SQL Server Automation
- Overview of SQL Server Automation
- The SQL Server Agent Service
- Creating Maintenance Plans
- Creating and Managing Jobs
- Creating and Managing Operators
- Creating and Managing Alerts
Monitoring SQL Server
- Overview of Performance Monitoring
- Viewing the Current Activity
- Using System Monitor
- Using SQL Server Profiler
What You Can Expect
Upon successful completion of this course, students will
be able to:
- Perform an Installation of SQL Server 2008
- Configure SQL Server Post Installation
- Plan and Create Databases
- Configure and Manage Databases
- Create a Database Schema
- Create Tables in a Database
- Understand and Implement Data Integrity
- Understand and Implement SQL Server Indexes
- Understand and Implement SQL Server 2008 Security
- Understand Data Transfer Utilities
- Backup and Restore Databases
- Create and Implement Database Snapshots
- Automate Tasks in SQL Server 2008
- Use the SQL Server 2008 Tools and Utilities to Monitor Performance
Recommended Prerequisites
An understanding of working in a Microsoft Windows operating
system environment.
An understanding of relational databases and design principles.
Some experience of the SQL language would be beneficial.
Related Courses
Code |
Course Title |
Duration |
Level |
|
SSADM |
SQL Server 2012 Administration |
5 Days |
I |
Details |
PSSQLS |
Maintaining SQL Server using PowerShell |
3 Days |
II |
Details |
Every student attending a Verhoef Training class will receive
a certificate good for $100 toward their next public class taken
within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a
single student in any of our public or web-based classes.
Contact your account manager or our sales office for details.