Please do not post duplicate ads. All Duplicate Ads will be deleted permanently. >> Adults content, escort service, massage parlours, astrology "vashikaran" etc. Ad listings are not allowed.

Check with seller Microsoft SQL Server DBA Course Coaching at Marathahalli Bangalore

Published date: November 7, 2015
Modified date: November 7, 2015
  • Location: Marathahalli, Bangalore, Karnataka, India

Microsoft SQL Server 2008 DBA Training Program


This course is a soup-to-nuts course that will teach you everything you need to build, configure a server, maintain a SQL Server disaster trouble shooting issue which you arise in day to day activities.

Course Outline:

Module-1 SQL Server Architecture

Introduction to SQL Server 2008
• Overview on RDBMS and Beyond Relational
• Big picture of SQL Server 2008
• Components & Services of SQL Server 2008
• Roles of production DBA
• System Databases
• Master, Model, MSDB, Tempdb & Resource
SQL Server 2008 Editions & Capacity Planning
• Principal Editions [Enterprise, BI, Standard]
• Specialized Editions [Web]
• Breadth Editions [Developer, Express]

• Database Files
• Primary data files
• Secondary data files
• Log Files

Module-2 Installing, Upgrading, Configuration, Managing services and Migration
SQL server 2008 Installation
• Planning the System/Pre-Requisites
• Installing SQL server 2008
• Best Practices on Installation
• Uninstalling SQL server
• Common Installation Issues
Upgrading to SQL server 2008 R2/2008
• Upgrading the server by applying service packs
• Upgrading the server by applying Hot fixes

Module-3 Security, Automation & Monitoring
Automating Administrative Tasks
• About SQL server Agent
• Creating Jobs, Alerts and Operators
• Scheduling the Jobs
• Working with Job activity Monitor
• Resolving failure Jobs
• Configuring Alert system in SQL server agent
• Best practices on job

Module-4Backup & Restore, High Availability & Replication
Backup & Restore:
• Recovery Models [Simple, Bulk-Logged & Full]
• How Backup Works
• Types of backups

Module-5 High Availability:
• Replication Overview
• Replication Models (snapshot/Transactional/Merge/Updatable/Peer to Peer)

Module-6Performance Tuning, Indexing & Optimizing SQL Server
Optimizing SQL server
• Index Architecture
• How to optimally take advantage of indexes
• Clustered & Non-Clustered indexes
• Covering Index or index with included column

Contact us for more details
9 9 8 6 5 4 1264


Useful information

  • Avoid scams by acting locally or paying with PayPal
  • Never pay with Western Union, Moneygram or other anonymous payment services
  • Don't buy or sell outside of your country. Don't accept cashier cheques from outside your country
  • This site is never involved in any transaction, and does not handle payments, shipping, guarantee transactions, provide escrow services, or offer "buyer protection" or "seller certification"

Related listings

  • Big Data and Hadoop Online Certification Course in Texas
    Big Data and Hadoop Online Certification Course in Texas
    Computer - Multimedia Classes - Houston (Texas) - September 23, 2016 499.00 Dollar US$

    What is Big Data and Hadoop? It is known as to be the process where huge amount of data is gathered, regulated and analysed before it is processed all throughout. In this whole series of process various patterns and different information are taken up...

  • Internship for Dot net, PHP & JAVA
    Internship for Dot net, PHP & JAVA
    Computer - Multimedia Classes - Thiruvananthapuram (Kerala) - March 9, 2016 Check with seller

    SCOPE INDIA providing an Internship for Dot net, PHP & JAVA. SCOPE INDIA (Suffix's Corporate Organisation for Professional Education), one of the best destination for Software and Networking training in Kerala. As a committed and dedicated organi...


    Leave your comment (spam and offensive messages will be removed)