SQL Server DBA Online Training

SQL DBA Clustering and AAG| SQL Server & DBA

SQL SERVER & DBA online training india
SQL SERVER DBA Online Training Course
Average Rating: 4.6
Votes: 231
Reviews: 141

Overview : SQL Server & DBA course essentials

QA Training Hub offers high quality and state-of-art real-time practical trainings on several Microsoft Technologies. Our main focus is on SQL DBA which enables students to understand its process and benefits viz. easy access to data, easy integration and reporting the data, easy sharing of information, powerful analysis of information, powerful analysis of information, massive scale and readiness for future. This online training program in SQL Server DBA will enhance the learning and skills of database developers, database administrators and business intelligence developers.

SQL Server DBA Online Training Course Content

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

QaTrainingHub.com | Students Also Viewed this Online Course Suggestions

For DotNet : Click here
For Active Server Page & .NET : Click here
For C Sharp : Click here
For SQL SERVER : Click here
For DB Testing : Click here
For ORACLE +DBA : Click here

More ideas & Relevant Searches for this Online Training Course Content...
  • SQL Server DBA Online Training
  • SQL Server DBA Online Training in Ameerpet
  • SQL Server DBA Training institutes in hyderabad
  • MS SQL Server DBA Training in Ameerpet
  • Best SQL Server DBA online Classes
  • SQL Server Online Training
  • SQL Server Classes
  • Microsoft .NET online Classes
  • Best MS .NET Online Training in India

Thanks for visiting our qatraininghub.com

"Let's Share, Sharing is Caring" & Like Our Fb Page..!
sql server & DBA online training course

Mr. Subba Raju

14+ Years