Home
  Technology Courses
  Management Courses
  Certification
  MyHistory
 Course Schedule
  Free Catalog
  About Us
  What's New
  Contest
  Contact Us
Photo Galary
 
SQL Server 2008 Database Administration: Hands-On
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 database permissions management
  • Implement backup and recovery strategies and manage transaction logs
  • Automate administrative activities with SQL Server Agent multistep jobs
  • Perform routine maintenance to correct fragmentation and database corruption

 

Course Benefits

SQL Server 2008 provides a robust platform that enables organizations to run their most demanding, mission-critical applications. This hands-on course provides you with the knowledge and skills to install SQL Server 2008, create and modify storage structures, manage security and back up and recover databases. Throughout the course, you gain experience in performing administration tasks and techniques.

 

Who Should Attend

Those responsible for administering SQL Server 2008. A basic understanding of SQL Server 2008 or experience at the level of , "SQL Server 2008 Comprehensive Introduction." Those with a DBA background in SQL Server 2005 should take , "SQL Server 2008 Skills Upgrade."

 

Hands-On Training

Throughout 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
  • Importing and exporting data
  • Backing up and restoring databases
  • Configuring Database Mail
  • Carrying out routine database maintenance
  • Monitoring server health

 

SQL Server 2008 Installation and Features
Installing SQL Server
  • Choosing installation options
  • Upgrading from previous versions
  • Employing multiple instances
Essential tools
  • SQL Server Management Studio
  • Transact-SQL
  • SQL Server Configuration Manager
  • SQLCMD
  • PowerShell
  • Policy-based management
Creating and Managing Databases
Storage structures
  • Examining disk structures
  • Creating databases, filegroups and transaction logs
Managing database space
  • Permitting automatic database growth
  • Expanding databases by adding files
  • Specifying database options
Moving databases
  • Scripting objects and moving data with Transact-SQL
  • Detaching and attaching databases
  • Copying databases with the Copy Database Wizard
Implementing Server and Database Security
Creating logins
  • Contrasting Windows and SQL Server authentications
  • Authorizing logins
  • Making logins members of server roles
  • Enforcing password policy
Authorizing database access
  • Designing schemas
  • Adding users
  • Delegating privileges with pre-defined roles
  • Defining new roles
  • Assigning users to roles
  • Handling mismapped logins
Granting permissions
  • Allowing server, database, schema and object access
  • Interaction of roles and permissions
  • Overcoming broken ownership chains
Migrating Data
SQL Server Integration Services
  • Packages
  • Control flows
  • Connections
  • Data flows
  • Business Intelligence Development Studio
Building simple packages
  • Importing data from various data sources
  • Exporting data to different data stores
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
  • Testing recovery scenarios
  • Performing a piecemeal restore
  • Recovering user databases
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
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
  • Defining performance data collectors
  • Querying the Management Data Warehouse
Introducing the Resource Governor
  • Identifying priority activities
  • Balancing diverse workloads

Copyright ©2008, www.galaxy.ps

Designed By: Mohammed Fuqaha