SQL Server DBA

CloudLabs

Projects

Assignment

24x7 Support

Lifetime Access

.

Course Overview

SQL Server 2012 is Microsoft’s latest cloud-ready information platform. Organizations can use SQL Server 2012 to efficiently protect, unlock, and scale the power of their data across the desktop, mobile device, datacenter, and either a private or public cloud.

At the end of the training, participants will be able to:

Pre-requisite

Attendees should be comfortable with Windows server architecture. Some experience of programming and/or XML would be useful but not mandatory.

Duarion

5 days

Course Outline

  1. Availability and Scalability Features
  2. Security Features
  3. Data Management Features
  4. Administration and Maintenance Features
  5. Development Features
  6. To enable SQLiMail
  7. Testing mail delivery
  1. SQL Server 2008 Editions
  2. Installing Microsoft SQL Server
  3. System Requirements
  4. Preparing for a SQL 2008 Installation
  5. Installation Checklist
  6. Setup Features
  7. Using the System Consistency Checker
  8. Component Install
  9. Unattended Installation
  10. Installation Sequence
  11. Installation Maintenance
  1. Retaining SQL 2000 / 2005
  2. To verify the Installation
  3. Administrative Tools
  4. Upgrading to SQL Server Management Studio
  5. Management Studio Windows
  6. Registered Servers
  7. Object Explorer
  8. Review Database Objects
  9. Modify Database Properties
  10. Create Database Scripts
  11. The Maintenance Plans Node
  12. Solution Explorer
  13. Query Editor
  14. Template Explorer
  15. Dynamic Help
  16. Upgrading to SQL Server Computer Manager
  17. SQL Server 2008 Services node
  18. SQL Server 2008 Network Configuration node
  19. SQL Server 2008 Native Client Configuration node
  20. The SQLCMD Management Utility
  21. SQLCMD Syntax
  22. SQLCMD Variables
  23. Dedicated Administrative Connection
  24. SQL Server Management Studio SQLCMD Mode
  25. Using SQL Management Objects
  26. SMO Object Model
  1. Managing Metadata Views
  2. Metadata Storage
  3. System Views
  4. Information Schema
  5. Catalog Views
  6. Sys All
  7. Dynamic Management Views
  8. System Stored Procedures
  1. Index Management
  2. New Index Features
  3. Creating Indexes
  4. Online Index Maintenance
  5. Parallel (multiple CPU) Index Operations
  6. Lock Options
  7. Included Columns in Indexes
  8. Partitioned Tables and Indexes
  9. XML Index Support
  10. Altering an Index
  11. Rebuilding an Index
  12. Reorganising an Index
  13. Disabling an Index
  14. Dropping an Index
  15. Index Fragmentation
  16. Using the Database Tuning Advisor
  1. Implementing Securables
  2. New Security Features
  3. Principals
  4. Securables
  5. Permissions
  6. Permission Types
  7. Managing Logins
  8. Managing Users
  9. Managing Schemas
  10. Schema Definition
  11. Using Schemas
  12. Managing Execution Context
  13. Managing Permissions
  14. Manage Server Permissions
  15. Manage Server-Scope Securable Permissions
  16. Manage Database Permissions
  17. Manage Database-Scope Securable Permissions
  18. Managing Certificates
  19. Native Data Encryption
  20. Code and Module Signing
  1. Disaster Recovery
  2. SQL 2008 Disaster Recovery Feature
  3. Enhanced Features
  4. Database Snapshots
  5. Creating a Snapshot
  6. Common Snapshot Applications
  7. Undeleting table rows
  8. Undoing a table update
  9. Recovering a dropped object
  10. Backup and Restore
  11. Backup Changes
  12. Restore Changes
  13. Media Integrity Changes
  14. Recovering the MASTER Database
  15. Create a mirrored backup
  16. Restore from the backup mirror
  17. Create a snapshot
  18. Restore the snapshot data
  19. Automate the creation of daily snapshots
  1. SQL Server 2008 Data Availability
  2. Database Mirroring
  3. The Witness Server and Automatic Failover
  4. Configuring Database Mirroring
  5. Transaction Safety Level
  6. Operating Modes
  7. High Availability Operating Mode
  8. High Protection Operating Mode
  9. High Performance Operating Mode
  10. Mirroring Security
  11. Monitoring Mirroring
  12. Database States for Database Mirroring
  13. Prepare the Servers
  14. Configure Mirroring
  15. Verify Principal and Mirror Access
  16. Execute the Mirror Failover
  17. Verify Mirror and Witness Status
  18. Terminating the Mirror Session
  1. Replication Enhancements
  2. Stand-alone Replication Monitor
  3. Support for Oracle Publishing
  4. HTTP Synchronisation for Merge Replication
  5. Subscriber Initialisation
  6. Replicating DDL Statements
  7. Modified User Interface
  8. Replication Management Objects
  9. To Configure Publishing and Distribution
  10. Configuring Peer-to-Peer Replication
  11. Create a Publication
  12. Create a Subscription with RMO
  1. Creating the Database Objects
  2. Creating a Package Using Business Intelligence Studio
  3. Integration Services Project Template
  4. OLE DB Command object
  5. Column Mappings
  6. Adding a Data Viewer
    Optimal Data Storage
  1. Diagnostic Tools
  2. Query Analyzer
  3. Database Engine Tuning Advisor
  4. Index Optimisation
  5. Federated Database Servers
  6. Partitioned Indexes
  7. Lock optimsation
  8. Best Practices for Native XML Web Services

Reviews