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

  • Annual Maintenance Services on Computer/Laptops
    Annual Maintenance Services on Computer/Laptops
    Computer - Multimedia Classes - Jaipur (jaipur) - April 3, 2017 Check with seller

    We are India based IT Company provides services to protect your Computers,laptops from viruses. We provide computers/laptops/other hardware components on Sale/Purchase/Rent. For details about our services please visit our website www.indiadellsupport...

  • Agile Scrum Master Certification Online Training in Texas
    Agile Scrum Master Certification Online Training in Texas
    Computer - Multimedia Classes - Houston (Texas) - November 10, 2016 Check with seller

    A Certified Scrum Master is well equipped to use Scrum, an agile methodology to any project to ensure its success. The Agile Scrum Master course acquaints you with Agile and Scrum qualities and ideas, and helps you fabricate the essential abilities a...

  • 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...


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