SQL Server DBA Online Training

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

• 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

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