 |
Customer Service or Enrol: 0800 282 353 or +44 1372 364610 |
 |
|
 |
| |
You Will Learn How To
- Administer SQL Server 2005 with SQL Server Management Studio and Transact-SQL
- Create and manage databases, transaction logs and database snapshots
- Implement login and database security and manage permissions
- Develop a backup and recovery strategy
- Manage complex multistep jobs with SQL Server Agent
- Deploy and manage transactional replication
Course Benefits
Administration of your organisation's SQL Server databases is improved by effectively maximising the scalability, availability and security features of SQL Server 2005. This course offers extensive experience using SQL Server 2005 tools to install SQL Server, create and modify storage structures, back up and recover databases, and manage security.
Who Should Attend
Those interested in SQL Server administration. Course 131, "SQL Server 2005 Comprehensive Introduction", or equivalent experience is assumed. Those with a background in database administration in SQL Server 2000 or 7 should take Course 129, "SQL Server 2005 Administration: Skills Upgrade".
Hands-on Training
Throughout this course, a series of extensive hands-on exercises provides you with practical experience administering SQL Server 2005. Exercises include:
- Administering SQL Server 2005 with graphical tools and Transact-SQL
- Creating databases
- Implementing security for logins, databases and objects
- Backing up and restoring databases
- Recovering the master database
- Maintaining a hot standby server with mirroring
- Configuring Database Mail
- Managing transactional replication
Course Content
- Services
- Editions
- System and user databases
- SQL Server Management Studio
- Transact-SQL
- Surface Area Configuration
- SQL Server Configuration Manager
- Choosing installation options
- Employing multiple instances
- Upgrading from previous versions
- Applying a Service Pack
- Examining storage structures
- Creating databases and transaction logs
- Handling dynamic database growth
- Reclaiming unused space
- Detaching and attaching databases
- Copying databases with the Copy Database Wizard
- Contrasting Windows and SQL Server authentications
- Authorising logins
- Making logins members of server roles
- Enforcing password policy
- Designing schemas
- Adding users
- Defining new roles
- Delegating privileges with pre-defined roles
- Assigning users to roles
- Granting server, database, schema-scoped and object permissions
- Interaction of roles and permissions
- Packages
- Control flows
- Data flows
- Connections
- Business Intelligence Development Studio
- Importing data from Access
- Exporting a table to Excel
- Transaction log architecture
- Choosing a recovery model
- Performing full, log and differential backups
- Recovering system and user databases
- Selecting a mirroring architecture
- Configuring the mirror and witness servers
- Monitoring database mirroring
- Taking a snapshot of the mirror
- Configuring the Agent
- Setting up Database Mail
- Defining jobs to handle routine tasks
- Creating alerts and operators
- Associating alerts with jobs
- Publish/subscribe metaphor
- Replication types
- Replication agents
- Configuring the Publisher and Distributor
- Creating publications
- Subscribing to publications
- Identifying problems with Activity Monitor
- Querying Dynamic Management Objects
- Deploying the Performance Dashboard
- Analysing trends with the SQL Server Health and History tool (SQLH2)
|
SQL Server is a trademark of Sybase, Inc.
|
|
|
|
|
| |
| Customer Service or Enrol: 0800 282 353 or +44 1372 364610 |
|
|
Print Friendly
E-mail a Colleague
Course PDF
Course FAQ
Home
