Tecnosoft | Training Instistute Website

SQL Server DBA

Home > Courses > Microsoft Office



Online Fee


Classroom Fee


Students Enrolled



Upcoming Batch Schedule for Online Training

Tecnosoft provides flexible timings to all our students. Here are the Online Training Schedule in our branches. If this schedule doesn’t match please let us know. We will try to arrange appropriate timings based on your flexible timings.

  • 27-04-2020 Monday (Monday - Friday)Weekdays Regular 08:00 AM (IST)(Class 1Hr - 1:30Hrs) / Per SessionCourse Fees
  • 30-04-2020 Thursday (Monday - Friday)Weekdays Regular 08:00 AM (IST)(Class 1Hr - 1:30Hrs) / Per SessionCourse Fees
  • 25-04-2020Saturday (Saturday - Sunday)Weekend Regular11:00 AM (IST) (Class 3Hrs) / Per SessionCourse Fees
  • 25-04-2020Saturday (Saturday - Sunday)Weekend Fast-track 10:00 AM (IST)(Class 6Hrs - 7Hrs) / Per SessionCourse Fees
Tecnosoft Calender
Can’t find a batch you were looking for?

Enroll Now

Get Instant access to 5000+ Online courses

Course Curriculam

Introduction to SQL Server 2005/2008

  • Overview on RDBMS and Beyond Relational
  • System Databases
  • Distribution Database
  • What’s New in SQL Server 2008
  • What is difference between SQL2000,2005 and 2008

Introduction of Computer

  • Installation of SQL Server 2005/2008
  • H/W Requirements
  • S/W Requirements
  • Multiple Instances
  • User Databases
  • SSMS Environment
  • Trouble Shooting Techniques
  • Installation of SQL2000,2005 and 2008

Upgrading to SQL Server 2005/2008

  • Upgrading the server by applying service packs
  • Upgrading the server by Appling hot fixes
  • In-place up gradation from SQL Server 2005 to 2008
  • Upgrade Advisor

Pages & Extents

  • Pages
  • Extents
  • Types of Extents
  • Managing Extent Allocation
  • Tracking Free Space

File & File groups

  • Database files
  • How to rename the database
  • Primary Data files
  • Secondary Data files
  • Log files
  • Database File groups (Primary & User-defined)
  • How to rename the data files and log files.
  • How to change the collation settings.
  • How to change the database from multi user to single_user mode.
  • How to change the database to read-only mode.
  • How to add .ndf(next data file) file while data file disk is full.
  • How to monitoring the Disk spaces and failed connected server

Memory Architecture

  • 32-bit Vs 64-bit Architecture
  • Dynamic Memory Management
  • Effects of min and Max server memory
  • Using AWE

Configuring SQL Server

  • Configuring Network protocols from SQL Server Manager
  • Configuring features by using SQL Server surface area Manager
  • Configuring other settings through sp_configure
  • Dedicated Administrator Connection (DAC)
  • Connecting to DAC

Managing Services

  • Starting and Stopping Services through Configure Manger
  • Net Command
  • Start Up Parameter
  • Starting SQL Server in single user mode
  • Default Parameter and Advanced Parameter

Migrating SQL Server

  • Difference between in-place & Side by Side
  • Migrating by using Back and restore method
  • Migrating logins
  • Migrating Jobs
  • Migrating DTS Packages to SSIS
  • Import & Export

Security, Automation

  • How to create logins
  • How to assign databases for logins
  • How to mapping the logins from Production server to Standby server
  • What is the difference between Server Roles and Database Roles
  • What is Schema
  • How to create Schema and How to assign Schema for Tables
  • How to give column level permissions to particular tables
  • What is Orphan Users
  • How to check the Orphan User Report
  • How to fix the Orphan Users

Automating Administrative tasks

  • About SQL Server Agent
  • Creating Jobs, Alerts and Operators
  • Scheduling the Job
  • Creating Maintenance Plans
  • Working with Job activity monitor

Monitoring SQL Server

  • Monitoring SQL server process by activity monitoring
  • Monitoring Job activities by Job activity monitoring
  • Monitoring SQL Server Error Logs/Windows by log file viewer
  • Creating Maintenance Plans
  • Working with Job activity monitor
High Availability and Replication

Backup & Restore

  • Recovery Models (Simple,Full & Bulk-Logged)
  • How backups works
  • Types of Backups
  • Full Backup
  • Diff Backup
  • T-Log Backup
  • Copy Only
  • Mirror
  • Tail-Log
  • Compressed Backups
  • Restoring Modes (With Recovery, No Recovery, Read Only/Stan by)
  • Performing Restore(Point-in-time recovery)

Log Shipping

  • Log Shipping Architecture
  • Building DRS for Log-Shipping
  • Pre-requisites/log-shipping process
  • Deploying Log Shipping
  • Working with Log Shipping Monitor
  • Log shipping role changing
  • Removing Log Shipping
  • How to run the script when DR server is out of sync

Database Mirroring(HOT Standby)

  • Overview of database mirroring
  • Operating modes in database mirroring
  • Pre-requisites for database mirroring
  • Deploying database mirroring
  • Fail-over from principle to mirror
  • Working with database mirroring monitor
  • Advantages and Disadvantages of database mirroring
  • Database snapshots
  • Using Database snapshots for reporting purpose


  • Replication overview
  • Replication models (Snapshot/Transnational/Merge)
  • Replication agents
  • Configuration distributor
  • Deploying transaction replication for high availability
  • Working with database mirroring monitor
  • Creating Subscriptions (Homogeneous/Heterogeneous)
  • Monitoring replication by using replication monitor
  • Scripting replication

Clustering SQL Server

  • What is a cluster
  • Types of clustering
  • SQl server clustering concepts
  • Installing and configuring SQL server 2005 clustering

Performance Tuning & Indexing

  • Index architecture
  • How to optimally take advantages of indexes
  • Clustered & Non-clustered Indexes
  • Index fragmentation
  • Index defragmentation options/Update statistics
  • SQL profile
  • DTA (Database Engine Tuning Adviser)

Advantages of SQL DBA

  • How to detach and attach database from one server to another server
  • How to copy database from one server to another server
  • Blocking and Ded locks
  • DR Drills (When primary servery is down then how to make secondary server as primary)
  • How to switch over and switch backup of servers
  • DBCC Commands
  • How to shrinking Primary File, Secondary File and Log file (.ndf, .mdf and .ldf)
  • How to create linked server from SQL server to Oracle server
  • How to generate the script from databases
  • Explain about database sizes and over all databases of project

New features of Harding levels in SQl DBA

  • Server level Harding
  • Database Level Harding

We are providing Free Tool for SQL Basics

Scroll to top