Radical Technologies
  • News Update: - AWS Solution Architect Exam - Get 50 % Off before April 10th 2017.....Vmware VCP 6.0 + 6.5 Combo on High End Cisco UCS Servers ...Openstack Version 8.0 New Batch Registration Started ....Bigdata Hadoop - Experience Our Expertise ... Real 16 Node Hadoop Cluster Build on Amazon Cloud... Available Discounted Oracle Global Certification Vouchers...Aws , Salesforce, RHCSA , RHCE Sure Shot Exam Preparation Sessions....Mastering Devops .......Chef+Puppet+Docker+Ansible + Salt Stack + Jenkins +Git +Nagios +Jira......ServiceNow Combo.... Admin + Scripting and Implementation + Advanced administration.....Oracle Exadata Training on High End Cisco UCS Servers ....Congratulations to All RHCSA and RHCE Certified Students- Next RHCSA and RHCE Exam date- April 30th 2017.
  • COMBO COURSES

    RedHat Linux, Vitualization, Cloud, Hadoop,Datawarehousing Combo Courses with Discounted Price.....

    Readmore..

  • ONLINE TRAINING

    Radical Technologies provides best Online Training with Real-time Projects by Industry Experts....

    Online Schedule

  • BATCH SCHEDULE

    Best Classroom Training from Industry Consultants on High end Real-time Enterprise servers...

    Classroom Schedule

  • CERTIFICATIONS

    Authorized Exam Center for RedHat, Oracle, IBM, Microsoft, Cisco, Salesforce, AWS etc...

    Readmore..

MS SQL SERVER DBA

Best MS SQL Server Training in Pune 

 SQL Server Training by  Certified Instructors

Duration of Training: 8 weekends

MS SQL SERVER DBA SYLLABUS

Session 1: Starting with SQL Server  

  • Responsibilities of Database Administrator
  • Types of DBA’s
  • History of SQL Server – Versions
  • What’s new in SQL Server 2012 & 2014 for Administrators?
  • SQL Server 2008 & 2012 Service Packs
  • Editions of SQL Server
  • Differences between Enterprise and Standard Editions
  • Requirements
    • Hardware
    • Software
  • Instances
    • Advantages of Instances
    • Types
      • Default Instance
      • Named Instances

Session 2: Installing and Configuring

  • Installing SQL Server 2008 & 2012
    • Pre –Installation Steps
    • Installations
    • Viewing Installation process with Log files
    • Common issues
    • Adding or removing components
    • Installing Service Packs 
  • Configuration
    • Configuration of Various Services
    • Startup Parameters
    • Configuring data files and log file paths
    • Memory Configuration
    • Remote Connections
    • Configuring network protocols, Ports
    • Configuring Services
    • Configuring default backup folder.

Session 3: Working with Databases  

  • Working with Databases
    • System Defined databases
    • Moving System Databases
    • Handling TempDB database 
  • Database Architecture
    • Data Files
    • Log Files
    • Filegroups
    • Extents
    • Pages –Types
    • Page Architecture
    • Tracking Free Space
    • Log file full – How to troubleshoot. 
  • Creating Databases
  • Adding files, Filegroups

Session 4: Implementing Security

  • Security in SQL Server 2012
  • Security Enhancements
  • Types of Authentications.
    • 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
    • Understanding Server roles
    • Working with users
    • Resolving Orphan users
    • Understanding database roles
    • Understanding permissions
    • Working with certificates and schemas
    • Security catalogue views and stored procedures
    • Major Issues

Session 5: Backup and Restoration

  • Understanding Transaction Log Files
  • Understanding Checkpoints and Lazy writer
  • Truncation log file
  • Recovery ModelsSetting Recovery Model
    • Full
    • Bulk Logged
    • Simple
  • Database Backups
    • Why we need backups 
  • Backup TypesCopy-Only, Mirrored and Tail log backups
    • Full
    • Differential
    • Transaction Log
    • File or Filegroup
  • Backup Devices
  • Performing Restoration
  • Backup System Databases
  • CompressionsUsing LiteSpeed for Backups
    • Row Compression
    • Page Compression
    • Compressing Backups
  • Point-in-time Recovery
  • Viewing complete details of backup process
  • Issues related to backups

Session 6: High Availability

  • Introduction to High Availability

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

6.1.2 Working with Database Mirroring

  • Advantages
  • Architecture
  • Operating Modes
  • Server involved in Mirroring
  • Requirements for Mirroring
  • Configuring
  • MonitoringMirroring Fail Over
    • Using Mirroring Monitor
    • Using System Monitor
    • Using Profiler
    • Using System views and SPs
  • Mirroring System Tables and Stored Procedures
  • Major issues with Mirroring 

6.1.3  Replication

  • Replication and Advantages
  • New Features
  • Replication Entities
  • Replication Architecture
  • Replication Agents
  • Types of Replications
  • Configuring Replication
    • Snapshot Replication
    • Transactional Replication
    • Merge Replication
    • Peer to Peer replication
    • Managing Replication
    • Monitoring and Tuning Replication

Session 7: Automating Administrative Tasks

  • Working with Database MailConfiguring Linked Servers
    • Mail Architecture
    • Configuring Profiles and Accounts
    • Sending Mails
  • Implementing Automation
    • Configuring SQL Server Agent
    • Creating Operators, Alerts, Jobs
    • Managing jobs and resolving errors
    • Monitoring Jobs
    • Auto alert when jobs are enabled, disabled or failed

Session 8: Advanced Administration Concepts

  • Maintenance Plans
  • Monitoring and Tuning SQL Server
    • Performance counters Setup
    • Measuring performance of 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 
  • TroubleshootingLocks
    • Physical Server Performance
    • Connectivity to SQL Server
    • Database Performance
  • Managing ConcurrencyLocks
    • SQL Server Architecture
      • Relational Engine
      • Storage Engine
      • Buffer Pool
      • Managing Execution Plans
  • Dead Locks
  • Transaction Isolation Levels
  • Understanding Blocking
  • Terminating Processes
  • Using the DAC
  • Managing Databases
    • Manage Index Fragmentation
    • Manage Statistics
    • Shrink Files
    • Performing database integrity checks (DBCC CheckDB)
    • Index Rebuilding and Reorganising
    • Migrations
    • Using DBCC Commands
    • Resource Governor

Session 9: Clustering SQL Server

  • Clustering SQL Server
  • Overview of windows Clustering
  • Requirements
  • Installation and configuration of SQL Server Clustering
  • Applying Service packs and fixes
  • Moving groups
  • Adding node on a SQL Server Failover Cluster
  • Troubleshooting Cluster issues. 

Session 10: Performance Tuning

  • Blocking
  • Dead Locking
  • Index’s Rebuild & Reorganise
  • Locks Types
  • Trace Flags
  • DMV’s

Session 11: Introduction of SQL Server 2014

Note : Industry Expert and with Real Time Scenarios.

 

Summary
Review Date
Reviewed Item
After taking the guidance from Deepak, I can feel that there is a huge change in the confidence while working on Database. It is my privilege to get an opportunity to learn from his industry experience. Very well organized teaching structure and intellectually motivating.He encourages independent thinking and creates a learning atmosphere. The way he communicates the teaching information is very clear and organized..
Author Rating
51star1star1star1star1star