Processing your application. Please be patient while we make sure we receive every piece of it.
SQL Server 2008
LearnBlock: SQL Administration Survival Skills
1 Day
Course OverviewThis course will cover the essentials skills needed to install and maintain a SQL Server in support of another technology. It is intended to provide a basic set of skills for non-DBAs. Due to the dynamic nature of this course, the depth to which a topic will be covered will be driven by the participants. As such, it is possible that not all topics will be addressed in depth. ObjectivesAfter completing this course, students will have the knowledge to install SQL Server 2008, understand SQL security mechanisms, be able to backup and restore SQL databases, understand general monitoring concepts, and be able to set up a simple maintenance plan.AudienceThis course is for system administrators who are familiar with other products and need to support a SQL Server database backend for those products. This course is suitable for individuals using both SQL Server 2008 R2 and SQL Server 2012. PrerequisitesThe prerequisites for this course include experience supporting Windows server environments. A familiarity with T-SQL is beneficial. Students should come with topics and questions in mind to get the most from this mode of training.
Price: $690
To find out more available information
about this course, please contact us:

To find out more available information
about this course, please contact us:

To find out more available information
about this course, please contact us:

LearnBlock SQL AdministrationSurvival Skills


Module 1: Introduction to SQL Server2008 R2 and its Toolset
This module introduces you to the entireSQL Server platform and its major tools. This module also covers editions,versions, basics of network listeners, and concepts of services and serviceaccounts.
· Introduction to SQL ServerPlatform
· Working with SQL Server Tools
· Configuring SQL Server Services
Module 2: Installing and Configuring SQL Server 2008R2
This module details installing andconfiguring SQL Server 2008 R2.
· Preparing to Install SQL Server2008 R2
· Installing SQL Server 2008 R2
· Upgrading and AutomatingInstallation
Module 3: Working with Databases
This module describes the systemdatabases, the physical structure of databases and the most commonconfiguration options related to them.
· Overview of SQL Server Databases
· Working with Files and Filegroups
· Moving Database Files
Module 4: Backup of SQL Server 2008 R2 Databases
This module describes SQL Server 2008 R2Backup and the backup types.
· Backing up Databases andTransaction Logs
· Managing Database Backups
· Working with Backup Options
Module 5: Restoring SQL Server 2008 R2 Databases
This module describes the restoration ofdatabases.
· Understanding the Restore Process
· Restoring Databases
· Working with Point-in-timeRecovery
· Restoring System Databases andIndividual Files
Module 6: Authenticating and Authorizing Users
This module covers SQL Server 2008 R2security models, logins and users.
· Authenticating Connections to SQLServer
· Authorizing Logins to AccessDatabases
· Authorization Across Servers
Module 7: Assigning Server and Database Roles
This module covers fixed server roles,fixed database roles and user-defined database roles.
· Working with Server Roles
· Working with Fixed Database Roles
· Creating User-defined DatabaseRoles
Module 8: Authorizing Users to Access Resources
This module covers permissions and theassignment of permissions.
· Authorizing User Access to Objects
· Authorizing Users to Execute Code
· Configuring Permissions at theSchema Level
Module 9: Automating SQL Server 2008 R2 Management
This module covers SQL Server Agent,jobs and job history.
· Automating SQL Server Management
· Working with SQL Server Agent
· Managing SQL Server Agent Jobs
Module 10: Performing Ongoing Database Maintenance
This module covers database maintenanceplans.
· Ensuring Database Integrity
· Maintaining Indexes
· Automating Routine DatabaseMaintenance
Module 11: Monitoring SQL Server 2008 R2
This module introduces DMVs and theconfiguration of data collection.
· Monitoring Activity
· Capturing and Managing PerformanceData
· Analyzing Collected PerformanceData
Module 12: Troubleshooting Common SQL Server 2008 R2Administrative Issues
This module covers common issues thatrequire troubleshooting and gives guidance on where to start looking forsolutions.
· SQL Server TroubleshootingMethodology
· Resolving Service-related Issues
· Resolving Concurrency Issues
· Resolving Login and ConnectivityIssues