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 of Microsoft SQL Server 2008. Comparing the different editions. Overview of Data Platform components. Overview of new features.
Using the Upgrade Advisor to prepare existing SQL Server databases. System requirements. Installing SQL Server 2008. Verifying the installation. Reviewing Installed components and Services.
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 Data Files, Transaction Log files and Filegroups. Setting Database Options.
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.
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
Course participants are provided with a manual containing fully worked examples and explanations of the techniques covered in this course.
“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.”