Tecnosoft | Training Instistute Website

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

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 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
Types of Extents
Managing Extent Allocation
Tracking Free Space

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

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

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

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

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

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

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

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

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

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

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

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)

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

Server level Harding
Database Level Harding

SQL Server DBA

Duration

Online Fee

Classroom Fee

Students Enrolled

Reviews

Upcoming Batch Schedule for Online Training

Can’t find a batch you were looking for?

Enroll Now

Course Curriculam

Introduction to SQL Server 2005/2008

Introduction of Computer

Upgrading to SQL Server 2005/2008

Pages & Extents

File & File groups

Memory Architecture

Configuring SQL Server

Managing Services

Migrating SQL Server

Security, Automation

Automating Administrative tasks

Monitoring SQL Server

High Availability and Replication

Backup & Restore

Log Shipping

Database Mirroring(HOT Standby)

Replication

Clustering SQL Server

Performance Tuning & Indexing

Advantages of SQL DBA

New features of Harding levels in SQl DBA

Our Courses

Related Courses

Our Courses

Scroll to top