Mindmajix
For individuals


Recorded Video Learning

  • Access to high quality Videos
  • Self-paced learning content designed by Experts

Instructor Led Live Online Training

  • Live Interactive training
  • Certified & industry expert Trainers
  • On Demand Dedicated Cloud lab access
  • 24x7 Support & Assistance
  • Fast-track / Regular / Weekend


  • Start training at your convenient time
  • For business


    Corporate training

    • Self-paced e-learning and/or instructor-led options)
    • Course, category, and all-access pricing
    • Enterprise-class learning management system (LMS)
    • Enhanced reporting for individuals and teams
    • 24x7 assistance and support

    Course Details

    The SQL Server Database system from Microsoft Corporation has gained popularity over the last years, and it is believed to be one of the bestest relational database systems in this marketplace.

    SQL provides high-quality database support which exceeds performance expectations. SQL Database Administrator performs the task of monitoring of database server. SQL DBA also manages the hundreds of SQL Server instances, SAN storage and security.

    SQL Server DBA Training Overview

    Our training course is carefully designed for starters as well as for working professionals. The course includes SQL Server Architecture in detail, Understanding Query Design, Query Performance Tuning, Troubleshooting, Disaster Recovery (DR) and High Availability (HA) Solutions including SQL Clustering with Always-On (AAG).

    We bring to you the technical and practical training on SQL DBA where the trainee can enhance the complete knowledge of database theory, database design, RDMS, distributing computing architectures, storage, recovery etc.

    All the sessions are completely practical – LIVE to understand Business Level critical data development and management.

    The sessions are well explained by 10+years experienced Skilled IT Professionals.

    SQL Server DBA Training Curriculum

    SQL Server Fundamentals & T-SQL

    Get started with the introduction, installation and components of sql server, configuring tools, providing services and authentication and many more are learnt in this module.

    Topics- SQL Server Installation
    Services & Authentication
    SQL Server Components & Firewall
    SSMS
    Configuration Tools & SMO
    Protocols & Server Aliases
    Linked Servers & Types

    Know the creation and modification of sql database, recommendations of data and log files and the offline/online options of db.

    SQL Database Creation
    Files & File Group Options
    Data File Recommendations
    Log File Recommendations
    DB Offline & Online Options
    Database Modifications

    Here, you’ll learn about the aliasing, schemas, data types and table design of T-SQL and also the comparison between delete & truncate.

    Table Design and T-SQL Data Types
    INSERT & SELECT Options
    Aliasing
    Schemas
    Tables & File Group Usage
    DELETE versus TRUNCATE

    This chapter describes about the constraints and it’s properties & objects and also the different keys and it’s uses.

    Constraints – Properties & Objects
    UNIQUE KEY and NOT NULL
    PRIMARY KEYS & Usage
    Composite Keys
    CHECK and DEFAULTS

     

    Learn the different types of queries and bulk operations in the lesson.

    EXISTS
    APPLY
    WHERE
    ORDER BY
    GROUPING
    HAVING
    Sub Queries & Nested Queries
    Bulk Operations – Local & Remote

     

    This chapter describes the views as physical & virtual objects, types of views and the issues with alter table.

    Views as Virtual Objects
    Views as Physical Objects, SCHEMA BINDING
    ENCRYPTION
    Issues with ALTER TABLE
    System Views & Dynamic Management Views
    Views with Joins and Views

     

    You’ll know the types, architecture, working, performance and uses of indexes.

    Architecture of Table Indexes
    Clustered & NonClustered Indexes
    SORT_IN_TEMPDB
    ONLINE
    FILLFACTOR and PAD_INDEX
    Execution Plans and Performance
    Unique Indexes and Uses
    Working with Indexed Views

     

    About Stored Procedure and it’s use, types of parameters, dynamic sql queries and also procedure cache & recompilation are included in this module.

    Stored Procedures & Use
    Variables and Parameters
    SCHEMABINDING
    ENCRYPTION
    INPUT & OUTPUT Parameters
    Dynamic SQL Queries
    Procedure Cache & Recompilation

     

    Different types of functions and the uses of it are discussed in this chapter.

    Functions Use & Types
    Scalar & Table Valued Functions
    SCHEMABINDING
    ENCRYPTION
    System Functions and Events
    Date
    Time
    String and Metadata Functions

     

    Understanding the DML triggers & performance, types of cursors and it’s usage and also the inserted & deleted tables.

    DML Triggers & Performance
    INSERTED and DELETED tables
    STATIC and DYNAMIC cursors
    SCROLL & FORWARD_ONLY
    LOCAL and GLOBAL cursors
    KEYSET Cursors and Usage
    Embedding Cursors in SPs

     

    What are transaction types and it’s use?, blocking the DML/DDL operations, commit & rollback options and many more are learnt in this module.

    Transaction Types & Use
    Blocking – DML Operations
    Blocking – DDL Operations
    COMMIT & ROLLBACK Options
    SAVEPOINT & CHECKPOINT
    Deciding Transaction Types
    Querying SQL_MODULES View

    Basic SQL DBA

     

    What is the significance, types, hints, usage of locks?, types of isolation levels & models and the issues of real-time data deployment are discussed in this chapter.

    Significance of LOCKS and Usage
    Types of Locks and Lock Hints?
    Isolation Levels – Types & Usage
    Choosing best Isolation Level
    TempDB Issues with Isolation Levels
    Recovery Models and Options
    Choosing Best Recovery Model
    Real-time Data Deployment Issues

    The focus in this course is to know the types, validations, restore paths and audits of backup, need for backup strategies, different options and MSDB history tables.

    Need for Backups Strategies
    Database Backups and Partial Backups
    FORMAT
    INIT
    SKIP
    CHECKSUM Options
    Backup using T-SQL Scripts & UI
    Backup validations and Restore Paths
    MSDB History Tables
    Backup Audits
    Compressed Backups and Expiry
    Log backups and Truncation options
    Backup Audit Tables in MSDB
    Media Sets and Media Truncate Options

    Learn How to restore the database, types of restore and how can we provide backup or recovery path using T-SQL & UI..

    Need for Restores and Types
    Backup Verification using T-SQL & UI
    Restore Phases and Recovery Path
    Database
    File Group
    File Restores
    PARTIAL and Piecemeal Restores
    Point-In-Time Restores and Options
    Compressed Tail Log Restores
    Recovery
    MOVE and FILELISTONLY Options

    Understand how to Create jobs using UI and T-SQL Scripts, Schedules the Job Steps, Monitoring the Job Activity, How do you configure DB Mail and many more.

    Creating Jobs using UI
    Creating Jobs using T-SQL Scripts
    Understanding Job Steps and Schedules
    Backup Schedules & Jobs using Scripts
    Job Failures and History View
    Enabling and Disabling Jobs
    Job Activity Monitor and Agent Status
    Alert System and DB Mail Configuration

    Get a brief understanding on How to Install Replication and Configure it, Types and Alerts of replication, How to monitor Replication and also about DB Recovery Process.

    Replication Architecture and Configuration
    Snapshot and Transactional Replications
    Merge Replication
    DB Recovery process
    Peer-Peer with Backup Initialization
    Replication Types – PUSH & PULL
    Replication Alerts
    Warnings and Emails
    Replication Monitors and Event Watch
    Replication for Load Balancing & DR
    Agent Operators, Notifications / Emails
    Data Access Modes and Agent Properties

    Here you’ll learn about the Log shipping and DB Mirroring configuration and its modes respectively and how can regain the disaster recovery in SQL Server.

    Disaster Recovery in SQL Server
    Log Shipping Configuration and Modes
    Manual DB Failover using Log Shipping
    DB Mirroring Configuration and Modes
    Automatic and Manual Failover Options
    Mirror Monitors
    Network Considerations
    Comparing Log Shipping and Mirroring

    Levels of Security Implementation
    Server level Logins and DB level Users
    Server Roles and User Mappings
    Schema Level Security and DB Roles
    Table and Column permissions
    DB roles
    Data Encryption Keys and Certificates
    Login Failures
    Authentication Audits

    Types of Audits and SQL Tools
    Server level Audits and Error Logs
    Activity Monitors and IO Usage Reports
    SQL Profiler, Deadlock Graphs and Filters
    DMVs for Query Audits
    Tempdb Audits
    DMFs for Index
    Session and Log Audits
    DMFs
    DMVs for Queries
    Tempdb Audits
    Important Queries for DBCC
    Important DMVs and DMFs
    Security Audits and Profiling

    Advanced SQL DBA

    Database Maintenance Plan Strategies
    Wizard Based DMPs and Schedules
    Control Flow Tasks
    Precedence Usage
    Index Rebuilds and Reorganization
    Deciding Fill Factor and PAD_INDEX Options
    Managing MSDB and TEMPDB
    Using NOTIFY OPERATOR task in DMP
    Using UPDATE STATISTICS and Agent
    Maintenance Issues in Real-time

    Able Partitions and Compressions
    Aligned Partitions and FillFactor
    Managing Partitions for Query Tuning
    Statistics with Indexes and Partitions
    Full Text Search Usage and Catalogs
    Full Text Indexes for Query Tuning
    CHANGE_TRACKING options
    Use Tuning Implementations with Cache
    Compressed Indexes with Partitions

    Creating Workload Files using Profiler
    Workload Tables with SQL Profiler
    TUNING Templates and Column Filters
    Index Selectivity and DTA Usage
    Filtered Indexes and Index Sizing
    Role of Statistics in Performance Tuning
    Index Fragmentation and REBUILDS

    LOG SPACE Issues – Alerts and Solutions
    TEMPDB Issues – Alerts and Solutions
    MEMORY Issues – Alerts and Solutions
    DB STATE Issues – Alerts and Solutions
    Network Issues – Alerts and Optimizations
    Using PERFMON Counters and Filters
    Replication and Mirroring Thresholds
    Activity Monitor and Deadlock Issues

    Working with SQL Engine Properties
    DTC and Remote Connection Properties
    Query Governor and Timeout Options
    Database State Properties and Options
    Policy Based Management (PBM) Usage
    Database Facets and Conditions
    Scheduling and Reporting Policies
    Resource Governor & Browser Tools
    Server Properties and Configurations

    Establish Downtime
    Sample Notifications
    PRIOR Maintenance activities
    Precautions
    Applying Patch/hot fix and Service Packs
    Verifying Updates and SmokeTest Options
    Understanding Upgrade Advisor Issues
    Server Upgrades and Smoke Tests
    Rollback Service Packs and Precautions
    System Database Rebuilds

    Windows and SQL Licensing Options
    Domain Controller and Active Directory
    Windows and Network Configuration
    PING tests and DTC Configurations
    QUORUM settings and SAN Settings
    SQL Server Cluster Installation
    SQL Group and RAID Configurations
    Virtual SAN Setup and Verification

    SQL Cluster Node Installation
    QUORUM Check and DTC Settings
    Connection Issues and Drains
    SQL Cluster Configurations and Heartbeat
    Security Issues with Solutions
    Storage Issues with Solutions
    Always-On (AAG) Groups and HA
    Practical Considerations For HA

    Faqs

    Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Mindmajix verifies their technical background and expertise.

    We record each LIVE class session you undergo through and we will share the recordings of each session/class.

    Trainer will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.

    If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

    The Training itself is Real-time Project Oriented.

    Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

    There are some Group discounts available if the participants are more than 2.

    As we are one of the leading providers of Online training, We have customers from USA, UK, Canada, Australia, UAE, Qatar, NZ, Singapore, Malaysia, India and other parts of the world. We are located in USA. Offering Online Training in Cities like

    Minneapolis, Melbourne, Jacksonville, Davidson, Murfreesboro, Auckland, Carlsbad,  San Marcos, Tacoma, Bellevue, Garland, Raleigh-Cary, Fort Lauderdale, Miami, Toronto, Wellington, Gilbert, Tempe, Alexandria, Chandler, Scottsdale, Peoria, Honolulu, Raleigh, Nashville, Plano, Montreal, Calgary, Edmonton, Saint John, Vancouver, Richmond, Mississauga, Saskatoon, Kingston, Kelowna, Hyderabad, Bangalore, Pune, Mumbai, Delhi, Dubai, Doha, Brisbane, Perth etc…

    • SQL Server DBA Training Washington, DC
    • SQL Server DBA Training Virginia
    • SQL Server DBA Training New Jersey
    • SQL Server DBA Training Illinois
    • SQL Server DBA Training North Carolina
    • SQL Server DBA Training California
    • SQL Server DBA Training Maryland
    • SQL Server DBA Training Georgia
    • SQL Server DBA Training Texas
    • SQL Server DBA Training New York
    • SQL Server DBA Training San Francisco
    • SQL Server DBA Training Oregon
    • SQL Server DBA Training Ohio
    • SQL Server DBA Training Florida
    • SQL Server DBA Training Seattle
    • SQL Server DBA Training Chicago
    • SQL Server DBA Training Dallas
    • SQL Server DBA Training Los Angeles
    • SQL Server DBA Training Baltimore
    • SQL Server DBA Training Houston
    • SQL Server DBA Training San Diego
    • SQL Server DBA Training Santa Clara
    • SQL Server DBA Training Columbus
    • SQL Server DBA Training Towson
    • SQL Server DBA Training Salt Lake City
    • SQL Server DBA Training Austin
    • SQL Server DBA Training Sunnyvale
    • SQL Server DBA Training Franklin
    • SQL Server DBA Training Orlando
    • SQL Server DBA Training Boston
    • SQL Server DBA Training San Jose
    • SQL Server DBA Training St. Louis

    SEND A QUERY

    Course Reviews

    4.5

    1541 ratings
    • 51079
    • 4231
    • 3154
    • 262
    • 115

    Drop Us A Query


    Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
    Course Adviser

    Fill your details, course adviser will reach you.