|
|
|
You Will Learn How To
- Administer SQL Server 2008 with SQL Server Management Studio and Transact-SQL
- Build databases and upgrade from prior versions
- Secure the server through logins and permissions management
- Automate administrative activities with SQL Server Agent multistep jobs
- Perform routine maintenance to correct fragmentation and database corruption
- Identify problems and monitor server health
Course BenefitsSQL Server 2008 provides a robust platform that enables organisations to run their most demanding, mission-critical applications. It is essential that database administrators know how to manage this complex platform correctly. This hands-on course provides you with the skills you need to install SQL Server, create and modify storage structures, manage security and backup and recover databases.
Who Should AttendThose responsible for administering SQL Server 2008. A basic understanding of SQL Server 2008 or experience at the level of Course 137, "SQL Server 2008 Comprehensive Introduction", is assumed.
Hands-On TrainingThroughout this course, a series of extensive hands-on exercises provides you with practical experience administering SQL Server 2008. Exercises include:
- Administering SQL Server 2008 with graphical tools and Transact-SQL
- Creating databases
- Implementing security for logins, databases and objects
- Backing up and restoring databases
- Managing transaction logs
- Configuring Database Mail
- Carrying out routine database maintenance
- Monitoring server health
Course ContentSQL Server 2008 Installation and Features
Installing SQL Server
- Choosing installation options
- Upgrading from previous versions
- Applying a service pack
Essential tools
- SQL Server Management Studio
- Transact-SQL
- SQL Server Configuration Manager
- Policy-based Management
Creating and Managing Databases
Storage structures
- Examining disc structures
- Creating databases and transaction logs
- Defining file groups
Managing database space
- Permitting automatic database growth
- Adding database files to expand databases
- Specifying database options
Moving databases
- Scripting objects and moving data with Transact-SQL
- Detaching and attaching databases
Implementing Server and Database Security
Creating logins
- Contrasting Windows and SQL Server authentication
- Authorising logins
- Making logins members of server roles
- Enforcing password policy
Authorising database access
- Adding users
- Defining new roles
- Delegating privileges with predefined roles
- Assigning users to roles
- Handling mismapped logins
Managing Permissions
Granting database-scoped privileges
- Permitting object creation
- Granting blanket permissions
Schemas
- Designing schemas
- Assigning a default schema
Handling object-level permissions
- Limiting object access
- Meeting complex permission requirements with roles
- Examining permission hierarchies
Recovering from Disasters
Backing up databases
- Choosing a recovery model
- Transaction log architecture
- Performing full, log and differential backups
- Reclaiming transaction log space
Restoring databases
- Recovering user databases
- Testing recovery scenarios
Automating Tasks with Jobs and Alerts
The SQL Server Agent
- Configuring the agent
- Setting up Database Mail
Multistep jobs
- Defining jobs to handle routine tasks
- Creating alerts and operators
- Associating alerts with jobs
Performing Database Maintenance
Fragmentation and database corruption
- Identifying and curing fragmentation
- Finding and repairing database corruption
Database Maintenance Plan Wizard
- Choosing maintenance tasks
- Scheduling plan execution
Monitoring SQL Server
Ad hoc monitoring
- Identifying problems with Activity Monitor
- Querying Dynamic Management Objects
The Management Data Warehouse
- Configuring data collection
- Reviewing the reports
|
<< Back to SQL Server
SQL Server 2008 is a registered trademark of Microsoft Corporation.
Learning Tree AnyWareTM is a trademark of Learning Tree International, Inc. in the United States and other countries, and is covered by a patent application pending in the United States.
|
|
Course Dates
 | Most events below can be taken in-class or live, online from your home or office with AnyWare. |
| 11 - 14 Sep | Stockholm enrol | | 13 - 16 Nov | Stockholm enrol | UK Dates | | 19 - 22 Jun | London enrol | | 4 - 7 Sep | London enrol | | 6 - 9 Nov | London enrol | | 8 - 11 Jan | London enrol | | 12 - 15 Mar | London enrol | | 14 - 17 May | London enrol | US Dates | | 5 - 8 Jun | Washington, DC enrol | | 19 - 22 Jun | New York enrol | | 24 - 27 Jul | Washington, DC enrol | | 31 Jul - 3 Aug | Washington, DC enrol | | 21 - 24 Aug | New York enrol | | 6 - 9 Nov | New York enrol |
For AnyWare enrollments, please register at least 7 days prior to the start of the course.
More Dates and Locations.
|
|
On-Site &
Custom Training
Bring this or any Learning Tree course to your location or have it customized for your organization.
|
|
Kursdeltagarnas genomsnittsbedömning
|
De senaste 12 månadernas bedömningar |
|
5 stjärnor:
|
|
74 % |
|
4 stjärnor:
|
|
23 % |
|
3 stjärnor:
|
|
3 % |
|
2 stjärnor:
|
|
0 % |
|
1 stjärna:
|
|
0 % |
|
"Jag har gått många kurser med Learning Tree så jag vet vad jag pratar om när jag säger att kurserna är väldigt, väldigt bra. Du får en effektiv och praktisk utbildning som du kan ta med dig till kontoret veckan därpå och börja använda dig av med en gång." |
|
 |
|
Se på svenska
