About Trainer

  • 10+ years of IT experience
  • 2+ years of onsite experience
  • Certified
  • Working as an Architect
  • Excellent in Communication

About SQL Server DBA

 
 
 
 
ONLINE TRAINING IN SQL Server DBA BY OUR REALTIME/CERTIFIED PROFESSIONALS
Course Pre-requisites:
  • Basic DB Admin Knowledge
Training Material:
  • Class PPT’s (Soft Copy)
  • Session recordings (optional)
  • Manuals
SQL Server DBA Online Training Course Outline:
  • SQL Server Architecture
  • SQL Server Installation
  • SQL Server instance Maintenance
  • Database backup
  • Database Restoration
  • Database Management
  • Indexing
  • Monitoring and Optimizing
  • SQL Server Performance
  • SQL Server High Availability
  • SQL Server High Availability
  • Network Storage and Virtualization
  • T SQL Concepts
  • SQL Server Security
  • Database Capacity Management
Course Contents:
Unit 1: SQL Server Architecture
  • RDBMS
  • Physical Architecture
  • Logical Architecture
  • Memory Architecture
Unit 2: SQL Server Installation
  • Install SQL Server and related components
  • File location, default paths, service accounts
  • SQL Server instance Configuration
  • Server wide settings for AWE, PAE, Max Memory
  • SQL Server Configuration manager
Unit 3: SQL Server Instance Maintenance
  • System databases and their usage
  • SQL Server Agent Jobs
  • Create and schedule jobs
  • Notification of job execution
  • Disabling and Enabling Jobs
  • Change job step order
  • Managing SQL Server agent alerts
  • Security Policy (Authentication Mode)
  • User Roles
  • Login creation / enabling / disabling
Unit 4: Database backup
  • Recovery Models
  • Full Backup
  • Differential Backup
  • Transaction Log Backup
Unit 5: Data Restoration
  • Restoration
  • Point in Time Restoration
  • Disaster recovery
Unit 6: Database Management
  • Database Maintenance Plans
  • Database integrity using CHECKDB and CHECKALLOC
  • Data Import and Data Export
Unit 7: Indexing
  • Clustered Index
  • Non Clustered Index
  • Enabling and disabling indexes
  • Rebuilding Index
  • Reorganizing indexes
Unit 8: Monitoring and Optimizing
  • Identifying SQL Server Service problems
  • DB Engine Service
  • SQL Agent Service
  • Locks
  • Blocks
  • Deadlocks
  • Activity Monitor and DMVs
Unit 9: SQL Server Performance
  • SQL Server Profiler
  • DMVs
  • perfmon
Unit 10: SQL Server High Availability
  • Log Shipping
  • Mirroring
  • Clustering
  • Always ON
  • Replication
  • Service Broker and End Points
Unit 11: Network Storage and Virtualization
  • Virtualization using Hypervisor
  • Netapps storage
Unit 12: T SQL Concepts
  • DDL operations
  • DML Operations
  • Stored Procedure
  • Function
  • Cursor
Unit 13: SQL Server Security
  • Authentication and Authorization
  • auditing
  • Login creation
  • Granting permission at object level
Unit 14: Database Capacity management
  • Configuring SQL Mail
  • Automation
  • Capacity Monitoring
 
 
 
 

Testimonials

  • The fact that they have a set format of teaching, which creates a schedule for a student, and a step-by-step process that covers the entire Netezza syllabus. I can surely assure eTraining provides a great help for Netezza curriculum.
    - Shannon D.

  • The BEST I liked about the tutors in eTraining is the amount of practical knowledge these guys have and the way they bring in the same to students perspective while Teaching. Glad I took DB2 course from eTraining.
    - Rubeena Khan

  • I found classes very helpful. What you Teach is AWESOME
    - Gopal