SQL DBA

 

 

 

FACULTY    : ARIVAND

 

UNLIMITED WI-FI

DURATION : 40 Hrs

 

DEMO DATE:

 


v  Overview on RDBMS and Beyond Relational

v  System Databases

v  What’s Editions and Versions in SQL Server 2005

Installation of SQL Server 2005/2008

v  H/W Requirements

v  S/W Requirements

v  Multiple Instances

v  User Databases

v  SSMS Environment

v  Trouble Shooting Techniques

Upgrading to SQL Server 2005/2008

v  Upgrading the server by applying service packs

v  Upgrading the server by Appling hot fixes

v  In-place up gradation from SQL Server 2005 to 2008

v  Upgrade Advisor

Pages & Extents

v  Pages

v  Extents

v  Types of Extents

v  Managing Extent Allocation

v  Tracking Free Space

File & File groups

v  Database files

v  Primary Data files

v  Secondary Data files

v  Log files

v  Database File groups (Primary & User-defined)

Memory Architecture

v  32-bit Vs 64-bit Architecture

v  Dynamic Memory Management

v  Effects of min and Max server memory

v  Using AWE

Configuring SQL Server

v  Configuring Network protocols from SQL Server Manager

v  Configuring features by using SQL Server surface area Manager

v  Configuring other settings through sp_configure

v  Dedicated Administrator Connection (DAC)

v  Connecting to DAC

v  Configuring Database Mail

v  Configuring Alert System in SQL Server agent

v  Configuring Database Settings

v  Configuring Memory Settings

Managing Services

v  Starting and Stopping Services through Configure Manger

v  Net Command

v  Command Prompt (sqlsrvr.exe)

v  Start Up Parameter

v  Starting SQL Server in single user mode

v  Default Parameter and Advanced Parameter

Migrating SQL Server

v  Difference between in-place & Side by Side

v  Migrating by using Back and restore method

v  Migrating logins

v  Migrating Jobs

v  Migrating DTS Packages to SSIS

v  Import & Export

Security, Automation

v  Security Principles

v  Server and Database Principle

v  Database Role

v  Creating Logins and mapping Users to databases

v  Creating Schemas

Automating Administrative Tasks

v  About SQL Server Agent

v  Creating jobs, Alert and Operators

v  Scheduling the job

v  Creating Maintenance Plans

v  Working with job activity monitor

Monitoring SQL Server

v  Monitoring SQL Server Process by activity Monitor

v  Monitoring job activities by job activity Monitor

v  Monitoring SQL Server Error Logs/Windows by log file viewer

High Availability and Replication

Backup & Restore

 

v  Recovery Models (Simple, Full & Bulk – Logged)

v  How Backups works

v  Types of Backups

v  Full Backup

v  Diff Backup

v  T-log Backup

v  Copy Only

v  Mirror

v  Tail – Log

v  Compressed Backups

v  Restoring Modes (With Recovery, No Recovery, Read Only/Stand by)

v  Performing Restore (Point –in – time Recovery)

Log Shipping

v  Log Shipping Architecture

v  Building DRS for Log – Shipping

v  Pre – requisites/log-shipping Process

v  Deploying Log Shipping

v  Working with Log Shipping Monitor

v  Log shipping role changing

v  Removing Log Shipping

Database Mirroring

v  Overview of Database Mirroring

v  Operating Modes in Database Miring

v  Pre – Requisites for Database Mirroring

v  Deploying Database Mirroring

v  Fail – over from principle to Mirror

v  Working with Database Mirroring Monitor

v  Advantage & Disadvantage of Database Mirroring

v  Database Snapshots

v  Using Database Snapshots for reporting purpose

Replication

v  Replication Overview

v  Replication Models (snapshot/Transactional/Merge)

v  Replication agents

v  Configuration Distributor

v  Deploying Transaction Replication for High Availability

v  Creating Subscriptions (Homogeneous / Heterogeneous)

v  Monitoring replication by using replication monitor

v  Scripting Replication

Clustering SQL Server

v  What is a cluster & overview of windows Clustering

v  SQL Server Clustering Concepts

v  Installing Services pack & hot fixes on a cluster

v  Installing and Configuring SQL Server 2005 clustering

v  Moving Groups between nodes

v  Cluster Administrator

v  Adding a node on a SQL Server 2008 Failover cluster

v  Applying patches on a SQL Server 2008 cluster

Performance Tuning & Indexing

v  Index Architecture

v  How to optimally take advantage of indexes

v  Clustered & Non – clustered indexes

v  Index fragmentation

v  Indexing Defragmentation options \update Statistics