RKG Logo training-ITBiz
RKG Logo
Home Courses Fees Schedule REGISTER NOW Corporate Training Locations
Microsoft Office Tools
Adobe Acrobat Courses
SharePoint Training
Microsoft Dynamics
Social Media Courses
Project Management
Application Devp Tools
Oracle Developer Tools
Data Warehouse & BI
Data Base & System Admin
Programming Languages
Reporting Tools
Networking & Security
Web Technologies
Medical Records
Business Skills
ERP Training
Corporate Training On-Site
SQL Server 2008 Admin
SQL Server 2008 Admin
SQL Server 2008 Database Administration
Software Version Microsoft SQL Server 2008
Course Duration 4 Days
Course Type Class Room and Instructor-Led On-Line (E-Learning) Hands-On Training
Course Overview SQL Server 2008 provides a robust platform that enables organizations 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. 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
  • Backing up and restoring databases
  • Managing transaction logs
  • Configuring Database Mail
  • Carrying out routine database maintenance
  • Monitoring server health
Intended Audience for this course Those responsible for administering SQL Server 2008. A basic understanding of SQL Server 2008 or experience. This course is also designed for those who have technical background, knowledge with any computer language, Java, J2EE, XML, .NET Developers, ERP Developers, DBAs, Technical Consultants, Students and also those who want to become SQL Server 2008 Administrators.
Course Topics
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
  • Policy-based Management
Creating and Managing Databases
  • Storage structures
  • Examining disk 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
  • Authorizing logins
  • Making logins members of server roles
  • Enforcing password policy
Authorizing 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
  • 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

Enroll Online   

Live Chat
Enroll Online
Enroll By Fax
Fee & Schedule
Send Message
Follow us on .....
For further information call 949-387-3772 or FAX 949-681-8247 or email to info@SONUtraining.com
SONU Training is the training wing of RKG Technologies Inc
Disclaimer: RKG Technologies is not linked with Microsoft, Oracle, Adobe, IBM or any other software company we provide training
Copyright © 2004 RKG Technologies Inc. All rights reserved.