Subscribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..

Batch Date: Oct 16th @8:00PM

Faculty: Mr. Ahmed Shareef (18+ Yrs of Exp,.. & Real Time Expert)

Duration : 45 Days

Venue :
DURGA SOFTWARE SOLUTIONS,
Flat No : 202, 2nd Floor,
HUDA Maitrivanam,
Ameerpet, Hyderabad - 500038

Ph.No: +91 - 9246212143, 80 96 96 96 96

Syllabus:

SQL SERVER DBA

Introduction to DBA

• Database Environment
• DBA Types
• DBA Responsibilities

SQL Server Installation

• Versions & Features of SQL Server
• Installation Strategy
• Type of Installation
• System Requirements
• Pre-Installation Steps
• Instance Types
• SQL Server Services
• Installation Check List Documents
• Post Installation Steps

SQL Server Environment

• System Databases
• User Databases
• Database Setup
• Database Architecture
• SQL Server Optimized Configuration
• SQL Power Shell Scripts

Security in SQL Server

• Securing SQL Server Instances & Databases
• Types of Authentications
• Working with Permissions and Roles
• Application Roles
• Schemas
• Encryption & Decryptions

Disaster Recovery Planning

• Database Recovery Models
• Backup Strategies
• Recovery Planning
• Migrations of Databases & Servers
• Contained Database
• Maintaining Backup & Restore History

Automation

• Configuring Database mail
• Jobs
• Operators
• Alerts
• Monitoring of Automation Tasks

High Availability

• Need of High Availability
• Log Shipping
• Database Mirroring
• Clustering
• Always On

Replication

• Introduction to Replication
• Configuring Replication (publisher, subscriber, distributor)
• Types of Replication (snapshot, transactional, peer-to-peer, Merge)
• Replication Topologies
• Monitoring Replication

Monitoring Database System

• Windows and SQL Server Event Logs
• User Activity Tracking
• Performance base line
• CPU, RAM and I/O Utilization
• Performance Monitor
• SQL Server Profiler
• Database level Tuning
• Query / SP Tuning
• Resource Governor
• CDC (Change Data Capture)
• Data Collection
• DMVs and DMFs
• System Stored Procedures
• System Tables and Catalog Views
  

Objects Level Maintenance

• Data Partitions
• Indexes fragmentation
• Statistics Updation
• Consistency & Data integrity Check [DBCC]
• Copying objects from One Server to another Server
• Script based Backup of Objects

Upgrading SQL Server

• Upgradation Strategies
• Upgrade Advisor

Business Intelligence Administration

• Installing BI Components
• Configuration of BI
• Security in Integration, Reporting & Analysis Services

Third Party Tools

• SQL Doctor, SQL Virtual database
• SQL admin toolset
• SQL Traffic Accelerator
• SQL Diagnostic Manager