Over

120,000

Worldwide

We are open on weekdays & weekends

Sun - Sat 7.00 AM - 9.00 PM

Call +91 40 2374 6666

 

SQL Server DBA Online Traininig

Introduction to SQL SERVER

  • Responsibilities of Database Administrator
  • Types of DBA’s
  • History of Sql Server – Versions
  • What’s new in Sql Server 2012 for Administrators
  • Editions of SQL server
  • Tools of SQL server
  • Difference between enterprise and Standard editions
  • Requirements – Hardware and Software
  • Instances – Default Instance and Named Instance
  • Sql Server Services
  • Client Server Connectivity Issues 

Installing and Configuring SQL Server

  • Installations
  • View installation process with log files.
  • Adding and removing components
  • Installing Service Packs
  • Configuration
  • startup parameters
  • configuring data file and log file paths
  • Memory configuration
  • Remote Connections
  • configuring network protocols and ports
  • configuration services
  • configuring default backup folder and authentication windows registry

Working with Databases

  • System databases
  • Moving System databases
  • Handling TempDB database
  • Database Architecture
    • Data Files
    • Log files
    • File Groups
    • Extents
    • Pages -types
    • Page architecture
    • Tracking free space
  • Create databases
  • Adding files, filegroups

Security

  • Security in Sql Server 2012 and 2014
  • Security Enhancements
  • Types of Authentication
    • windows authentication
      • creating logins from windows users and groups
      • orphan logins
    • Sql Server authentication
    • creating SQL logins and testing logins
    • Setting authentication mode
    • security auditing
    • server role
    • working with users
    • Resolving orphans roles
    • database roles, custom and application roles
    • Permissions
    • Encryption and Decryption
    • Working with certificates and schemas
    • Security catalog views and stored procedures

Backup and Restore

  • Full
  • Bulk logged
  • Simple
  • Setting Recovery Model
  • Database backups
  • Backup types – Full, Differential, Transaction, File or Filegroup
  • copy-only, Mirrored and tall log backups
  • Backup System databases
  • Compressions

Row Compression, Page Compression,
Data Partitions, Table Compression using T-SQL,
Compressing Backups

  • using LiteSpeed for backups
  • point-in-time recovery
  • Viewing complete details in backup process

Replication

  • Replication and advantages
  • New features 2008 R2 / 2012
  • Replication Entities
  • Replication Architecture
  • Replication Agent
  • Types of Replication
  • Congfiguring Replication
    • SnapShot Replication
    • Transactional Replication
    • Merge Replication
  • Peer to Peer Replication
  • Configuring oracle publication
  • Replication Topologies
  • Managing replication
  • Monitoring and Tuning Replication

Automation Administrative tasks

  • Working with database mail
    • mail architecture
    • Configuring profiles and Accounts
    • Sending Mail
  • Configuring linked Servers
  • Implementing Automation
    • Configuring SQL Server Agent
    • Creating Operators, Alerts, Jobs
    • Managing jobs and resolving errors
    • Monitoring jobs
    • Auto alert when jobs are enabled, disabled and failed
    • Database snapshots
    • Reverting from snapshot
    • Maintenance plans

High Availability

  • Introduction to High Availability
  • Working with log Shipping
    • Features
    • Jobs
    • Requirements to implement Log Shipping
    • Configuring Log Shipping
    • Monitoring Log shipping
    • Manually performing fail over
    • Transferring logins
    • Log Shipping tables and stored procedures
    • Handling out of sync Issues

Working with Database Mirroring

  • Advantages
  • Architecture
  • Operating modes
  • Servers involved in Mirroring
  • Requirements of Mirroring
  • Configuring
  • Monitoring
    • using Mirroring Monitor
    • using System Monitor
    • using Profiler
    • using System views and Stored procedures
  • Mirroring Fail over
  • Mirroring system tables and stored procedures

Advanced Administration Concepts

  • Monitoring and Tuning SQL Server
    • Performance counter setup
    • Measuring performance of sql server
    • Tuning Queries
    • Tuning Databases
    • Tuning physical architecture of databases
    • using DTA
  • Monitoring Tools
    • System Monitor
    • SQL Server Profiler
    • Database Engine Tuning Advisor
    • Dynamic Management Views
    • Sql Server and Windows Error Logs
    • Trouble Shooting
    • Physical server performance
    • Connectivity to SQL Server
    • Database performance
  • Managing Concurrency
    • SQL Server Architecture
      • Relation Engine
      • Storage Engine
      • Buffer pool
      • Managing Execution plans
    • Locks
    • Dead Lock
    • Transaction Isolation Levels
    • Understanding Blocking
    • Terminating processes
    • using DAC
  • Managing Database
    • Manage Index Fragmentation
    • Manage Statistics
    • Shrink Files
    • Performance database integrity checks by using DBCC CHECKDB
    • Index Rebuilding and Reorganizing
  • SQL Server Up Gradation
  • using DBCC commands
  • Resource Governor
  • Trouble Shooting SQL Server
    • Managing Resource Utilization
    • Resource Governor
    • Resource Pools
    • Creating a Resource Pool
    • Workload Groups
    • Creating a workload Group
    • Classification
    • Creating a classifier Function

Clustering in Sql Server

  • Introduction to cluster environment and features
  • overview of windows clustering
  • How SQL Server Supports Clustering
  • Requirements
  • Installing and configuring Sql Server Clustering
  • Moving groups
  • Adding Node on a sql server Failover cluster
  • Troubleshooting cluster issues
  • Patching clustered instances

SQL Server 2012 DBA concepts

  • Introduction to Sql Server 2012 environment
  • Always On (HA/DR) features
  • Column store indexes
  • contained databases
  • user defined server roles
  • database recovery advisor

New/Updated DMVs( Dynamic Management Views) Overview of windows clustering.

Comments are closed.
LayerSlider

Latest Posts

Teachers

Kishore
Introduction to SQL SERVER Responsibilities of Database Administrator Types of DBA’s History of Sql Server – Versions What’s new in Sql Server 2012 for Administrators Editions of SQL server Tools […]
Sudhakar Landa
Introduction to SQL SERVER Responsibilities of Database Administrator Types of DBA’s History of Sql Server – Versions What’s new in Sql Server 2012 for Administrators Editions of SQL server Tools […]

Naresh i Technologies

In this era of globalization and free trade, India has to be as competitive as any other country in the world in the areas of technology, quality, cost and service. As such the Software Companies are forced to adopt modern technology and concepts in order to be competitive globally.

  • Blended Course Content
  • Flexible Batch Timings
  • 24x7 Lab Facility
Close Popup Window

Registration Form