Mail : training@ecorptrainings.com
India : +91-8143-111-555
USA : +1-703-445-4802
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog

Workday HCM Demo New Batches Starting from Tuesday... 01-11-2016
Search Course Here




Live Chat
Support
Microsoft SQL Server 2008 DBA Online Training

Microsoft SQL Server 2008 DBA

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.
prerequisties
    Attendees should be comfortable with Windows server architecture. Some experience of programming and/or XML would be useful but not mandatory.
Duration
Online
  • It is a 16 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

Corporate
  • It is a 4 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
Classroom
    Private Classroom arranged on request and minimum attendies for batch is 4.
course content
  • SQL Server 2008 Overview
    • Availability and Scalability Features
    • Security Features
    • Data Management Features
    • Administration and Maintenance Features
    • Development Features
    • To enable SQLiMail
    • Testing mail delivery

  • Installing SQL Server 2008
    • SQL Server 2008 Editions
    • Installing Microsoft SQL Server
    • System Requirements
    • Preparing for a SQL 2008 Installation
    • Installation Checklist
    • Setup Features
    • Using the System Consistency Checker
    • Component Install
    • Unattended Installation
    • Installation Sequence
    • Installation Maintenance

  • Upgrading from previous versions of SQL Server
    • Retaining SQL 2000 / 2005
    • To verify the Installation
    • Administrative Tools
    • Upgrading to SQL Server Management Studio
    • Management Studio Windows
    • Registered Servers
    • Object Explorer
    • Review Database Objects
    • Modify Database Properties
    • Create Database Scripts
    • The Maintenance Plans Node
    • Solution Explorer
    • Query Editor
    • Template Explorer
    • Dynamic Help
    • Upgrading to SQL Server Computer Manager
    • SQL Server 2008 Services node
    • SQL Server 2008 Network Configuration node
    • SQL Server 2008 Native Client Configuration node
    • The SQLCMD Management Utility
    • SQLCMD Syntax
    • SQLCMD Variables
    • Dedicated Administrative Connection
    • SQL Server Management Studio SQLCMD Mode
    • Using SQL Management Objects
    • SMO Object Model

  • Monitoring the Database Server
    • Managing Metadata Views
    • Metadata Storage
    • System Views
    • Information Schema
    • Catalog Views
    • Sys All
    • Dynamic Management Views
    • System Stored Procedures

  • Database and Index Maintenance
    • Index Management
    • New Index Features
    • Creating Indexes
    • Online Index Maintenance
    • Parallel (multiple CPU) Index Operations
    • Lock Options
    • Included Columns in Indexes
    • Partitioned Tables and Indexes
    • XML Index Support
    • Altering an Index
    • Rebuilding an Index
    • Reorganising an Index
    • Disabling an Index
    • Dropping an Index
    • Index Fragmentation
    • Using the Database Tuning Advisor

  • Securing SQL Server 2008
    • Implementing Securables
    • New Security Features
    • Principals
    • Securables
    • Permissions
    • Permission Types
    • Managing Logins
    • Managing Users
    • Managing Schemas
    • Schema Definition
    • Using Schemas
    • Managing Execution Context
    • Managing Permissions
    • Manage Server Permissions
    • Manage Server-Scope Securable Permissions
    • Manage Database Permissions
    • Manage Database-Scope Securable Permissions
    • Managing Certificates
    • Native Data Encryption
    • Code and Module Signing

  • SQL Server Disaster Recovery
    • Disaster Recovery
    • SQL 2008 Disaster Recovery Feature
    • Enhanced Features
    • Database Snapshots
    • Creating a Snapshot
    • Common Snapshot Applications
    • Undeleting table rows
    • Undoing a table update
    • Recovering a dropped object
    • Backup and Restore
    • Backup Changes
    • Restore Changes
    • Media Integrity Changes
    • Recovering the MASTER Database
    • Create a mirrored backup
    • Restore from the backup mirror
    • Create a snapshot
    • Restore the snapshot data
    • Automate the creation of daily snapshots

  • Database Availability
    • SQL Server 2008 Data Availability
    • Database Mirroring
    • The Witness Server and Automatic Failover
    • Configuring Database Mirroring
    • Transaction Safety Level
    • Operating Modes
    • High Availability Operating Mode
    • High Protection Operating Mode
    • High Performance Operating Mode
    • Mirroring Security
    • Monitoring Mirroring
    • Database States for Database Mirroring
    • Prepare the Servers
    • Configure Mirroring
    • Verify Principal and Mirror Access
    • Execute the Mirror Failover
    • Verify Mirror and Witness Status
    • Terminating the Mirror Session

  • Replicating Information
    • Replication Enhancements
    • Stand-alone Replication Monitor
    • Support for Oracle Publishing
    • HTTP Synchronisation for Merge Replication
    • Subscriber Initialisation
    • Replicating DDL Statements
    • Modified User Interface
    • Replication Management Objects
    • To Configure Publishing and Distribution
    • Configuring Peer-to-Peer Replication
    • Create a Publication
    • Create a Subscription with RMO

  • SQL Server 2008 Integration Services
    • Creating the Database Objects
    • Creating a Package Using Business Intelligence Studio
    • Integration Services Project Template
    • OLE DB Command object
    • Column Mappings
    • Adding a Data Viewer

  • Monitoring and Performance
      Optimal Data Storage
    • Diagnostic Tools
    • Query Analyzer
    • Database Engine Tuning Advisor
    • Index Optimisation
    • Federated Database Servers
    • Partitioned Indexes
    • Lock optimsation
    • Best Practices for Native XML Web Services
Videos

Microsoft SQL Server 2008 DBA Videos will be updated soon
To watch more Videos Click Here

Flash News


AngularJS New Batch Start From 09th OCT & 10th OCT.


Hadoop Dev New Batch Start From 10th OCT & 11th OCT.


IBM COGNOS TM New Batch Start From 11th OCT & 12th OCT.


Informatica Dev New Batch Start From 12th OCT & 13th OCT.


Mean Stack New Batch Start 13th OCT & 14th OCT.

SAP BODS new Batch Starting From 14th OCT & 15th OCT.

SAP S/4 HANA New Batch Start From 15th OCT & 16th OCT
.

Tableau New Batch Start From 16th OCT & 17th OCT

PUBLIC DEMO

(1) Workday Technical Demo Training

Demo Schedule : 09:30A.M EST / 08:30A.M CST / 6:30A.M PST on 13th OCT & 07:00A.M IST on 14th OCT

(2) SAP MII Demo Training

Demo Schedule : 09:30A.M EST / 08:30A.M CST / 6:30A.M PST on 13th OCT & 07:00A.M IST on 14th OCT

SOLVE YOUR QUERIES ONLINE
Email :
Rediff Bol :
ecorptrainings@rediffmail.com
Google Talk :
ecorptrainings@gmail.com
MSN Messenger :
ecorptrainings@hotmail.com
Yahoo Messenger :
ecorptrainings@yahoo.com
Skype Talk :
ecorptrainings