|
Provided by: Hands On Technology Transfer, Inc. Microsoft SQL Server 2008 AdministrationSQL |
 |
This class consists of five days of hands-on training that focus on the fundamentals of administering the SQL Server 2008 database engine. Participants in this course will come away with the knowledge and experience required to administer SQL Server 2008. The course focuses on performing common administrative tasks, understanding how SQL Server works under the covers, and optimizing SQL Server performance as well as assuring high data availability. Attendees will learn how to install, configure, manage, secure, automate, monitor, and optimize SQL Server 2008. You will also learn how to create, manage, back up, and restore individual databases, transfer and replicate data, configure for high availability, and plan disaster recovery.
Emphasis is placed on how SQL Server 2008 is architected, so that you will be able to make the proper decisions in configuring and managing your SQL Server instances. The hands-on labs provide comprehensive practice performing common administrative tasks.
Course Prerequisites: Familiarity with database concepts, Windows desktop navigation and software installation techniques.
Emphasis is placed on how SQL Server 2008 is architected, so that you will be able to make the proper decisions in configuring and managing your SQL Server instances. The hands-on labs provide comprehensive practice performing common administrative tasks.
Course Prerequisites: Familiarity with database concepts, Windows desktop navigation and software installation techniques.
|
|
||||||||||||||
Training
Provided by Hands On Technology Transfer, Inc.
- M asked: I am sourcing ILT courseware for Microsoft SQL Server Administration for persons. Do you sell courseware? Does it come with an eval copy of the server software?
- L asked: Hi, I would like to know if I can order a trainer manual for SQL Server administration, how much will it cost, and when can you deliver it. I would like to have one asap. Thank you! Odette Dallas, TX com
- A asked: I trying to become a database administrator and I was wondering if this course is a good starting point that will allow me to build a foundation of becoming a database administrator. Can you give me the dates, times, and locations that this course is offered.
Microsoft SQL Server 2008 Administration
Microsoft SQL Server 2008 Administration Course Overview:
An Overview of SQL Server 2008
An Overview of SQL Server 2008
- SQL Server 2008 Architecture
- Available Features and Tools
- New Capabilities
- SQL Services
- Product Licensing
- Product Editions
Installing SQL Server 2008
- Preparing for Installation
- Creating Users for Service Accounts
- Choosing Appropriate File Locations
- Choosing Instance Names
- Installing SQL Server 2008
- Choosing Appropriate Features
- Specifying Service User Accounts
- Choosing Licensing Mode
- Choosing Appropriate Collation
- Installing Multiple Instances
- Upgrading to SQL Server 2008
Configuring SQL Server 2008
- Registering Servers
- Using Metadata Views to Obtain Object Properties
- Using Object Explorer
- Configuring a SQL Server Instance
- Configuring Object Properties
- Using the Query Window
- Creating Transact SQL Projects
- Managing Services
- Configuring Server Network Connections
- Configuring Client Connections and Aliases
- Configuring the Surface Area of SQL Server
- Configuring Policy-Based Management
- Creating a Central Management Server
- Using the Dedicated Administrator Connection
- Configuring Data Replication
- Creation and Maintenance of Full-Text Catalogs
- Describing Full-Text Search
- Creating DDL Triggers
- Creating Event Notifications
- Configuring SQL Server Audit
- SQL Server Management Studio
- SQL Server Configuration Manager
- SQL Server Books Online
- SQLCMD
- Using the Windows Performance Tool to Detect the Cause of a Bottleneck
- Using SQL Server Profiler
- Using Dynamic Management Functions
- Interpreting Management Studio Reports
- Using Activity Monitor
- Creating Databases
- Creating Tables
- Specifying Data Types
- Creating Indexes
- Describing Data File Structure
- Describing Log File Structure and Function
- Creating Filegroups
- Configuring Filestream Storage
- Creating and Using Database Snapshots
- Moving a Database to Another SQL Server
- Describing Index Structures
- Clustered Indexes
- Nonclustered (NC) Indexes
- Choosing Appropriate Clustered Index
- Choosing Appropriate NC Indexes
- Detecting Index Fragmentation
- Rebuilding and Reorganizing Indexes
- Using the Database Engine Tuning Advisor
- Generating and Interpreting Query Plans
- Configuring the Resource Governor
- SQL Server Security Architecture
- Defining Principals and Securables
- Using the Security Hierarchy
- Creating Logins and Users
- Applying Password Policies to SQL Logins
- Creating Roles
- Granting Permissions
- Using SQLCMD to Test Permissions
- Creating and Using Certificates
- Setting Execution Context
- Encrypting Data
- Encrypting Databases
- Creating Maintenance Plans
- Job Creation and Execution
- Creating Schedules for Jobs
- Creating and Using Proxies
- Configuring Alerts
- Creating and Using Operators
- Configuring and Using Database Mail
- Using bcp and BULK INSERT
- Using the Import/ Export Wizard
- Using Integration Services to Import Data
- Choosing Appropriate Database Recovery Model Option
- Describing Automatic Recovery
- Choosing an Appropriate Backup Strategy
- Determining Backup File Contents
- Designing a Database Recovery Plan
- Using Backup Compression
- Use of Filegroups in a Backup Strategy
- Restoring the Master Database
- Rebuilding System Databases
- Maintaining Data Integrity
- Creating Constraints
- Describing and Using DML Triggers
- Configure Data Compression
- Setting Transaction Isolation Levels
- Capturing Changed Data
Maintaining High Availability of Data
- Purpose of Windows Clustering
- Implementing Database Mirroring
- Use of Log Shipping
About The Training Provider: Hands On Technology Transfer, Inc.
Hands On Technology Transfer, Inc. - Hands On Technology Transfer, Inc. (HOTT) offers competency-based IT training programs in more than 75 cities across the United States, Canada and the United Kingdom, covering over 60 IT subject areas. These programs are designed with one main goal - making sure you and your staff will be competent and productive. Topics include .NET, SQL, Java, UNIX/ Linux, HTML, PHP, Windows Administration,...
