SQL Server DBA Online Training

SQL Server DBA Online Training

SQL Server DBA Online Training
SQL Server DBA Online Training

SQL Server DBA Online Training Course Content:

Module1: Starting with SQL Server

  • Responsibilities of Database Administrator
  • Types of DBAs
  • History of SQL Server
  • Editions of SQL Server
  • Tools of SQL Server
  • Differences between Standard and Enterprise editions
  • Instances types in SQL Server o Default Instance o Named Instance
  • SQL Server Services o Instance aware services o Instance unaware services

Module2: Installing SQL Server

  • Pre-requisites
  • Installation
  • Post Installation verification Session

Module3: Functioning of Databases

  • Database
  • Types of Database and Brief explanation o System Databases o User Database
  • Database Architecture o Pages o Extents o File groups o Database
  • Transaction Architecture
  • Creating Database
  • Modifying Database o Adding Files o Moving and renaming of Database files
  • Database modes
  • Real time Scenario

Module4: Security

  • Authentication Types in SQL Server
  • Types of Login
    • Windows Login
    • Database modes
    • SQL Login
  • Creating Users and Logins
    • Server roles
    • Password policy
    • Understanding Database and Server Roles
    • Permissions
    • Working on access level issues
    • Orphan users Finding and Fixing
    • Important Queries

Module5: Database Backups and Restoration

  • Database Backups
    • Why we need backups
  • Types of Backup
    • Full Backup
    • Differential Backup
    • Transaction Log Backup
  • Copy-only, Mirrored, Split and Tail log Backups
  • Differences between backups
  • Backup Strategy
  • Understanding how the data moving from Log to Data File, CHECKPOINT
  • Monitoring the space usage of Log File and fixing
  • Checking the backup files VALID or CORRUPTED
  • Backup storage tables
  • Important Queries
  • Performing Restorations
    • Types of Restoration
    • Attach and Detach
    • Shrinking files

Module6: Recovery Models of Database

  • Types of Recovery Models
    • Full
    • Bulk Logged
    • Simple
  • Differences between Recovery Models
  • Setting Recovery Models according to the Scenarios with examples

Module7: Automation of SQL SERVER

  • Working with SQL SERVER Agent
    • Creating Jobs
    • Managing Jobs and Resolving issues
    • Monitoring Jobs
    • Monitoring Tables
  • Log Shipping
  • Mirroring
  • Replication
  • Clustering

HIGH AVAILABILTY CONCEPTS

Module1: Log Shipping

  • Log Shipping o Working with Log Shipping o Terminology o Pre-requisites to implement Log Shipping o Different modes of Log Shipping o Configuring Log Shipping o Monitoring o Manually Performing Failover o Log Shipping Tables
  • Discussing Real Time Scenarios

Module2: Database Mirroring

  • Working with Database Mirroring
    • Terminology
    • Pre-requisites to implement Mirroring
    • Pre check mirroring ports ENABLED or DISABLED
    • Architecture
    • Operating Modes
    • Differences between Modes
    • Port numbers involved in Mirroring
    • Requirements for Mirroring
    • Configuring Mirroring
    • Mirroring failover
    • Issues on Mirroring

Module3: Replication

  • Working with Replication
    • Terminology
    • Pre-requisites to implement to Replication
    • Types of Replications
    • DISTRIBUTOR Database
    • Agents involved in Replication
    • Configuring Replication
    • Resolving Issues

Module4: Clustering

  • Introduction about clustering
  • Clustering Architecture
  • Importance of IP’s involved in Clustering
  • SAN importance
  • Drive dependency
  • Nodes in Clustering
  • Important commands

Module 5: Always On

  • What is availability group
  • Advantages of HADRON(Always on)

DIFFERENCES BETWEEN ABOVE HIGH AVAILABILTY CONCEPTS and ADVANCED CONCEPTS

Module1: Monitoring Tools

  • System Monitor
  • SQL Server Profiler
  • SQL Server and Windows Error Logs

Module2: Database Performance Tanning

  • Indexes
  • Types of indexes
  • Fragmentation in Indexes
  • Types of Fragmentations
  • Database Tuning Advisor
  • Dead Locks
  • Blockings
  • Terminating Processes

Module3: Managing the SQL Server and Databases

  • Starting SQL Server in Single user mode
  • Changing the Default path of Database files
  • Modifying the Logical and Physical names of database files

High Lights

  • Discussions on Real time scenarios
  • Replying to Questioner mails on subject doubts

* Windows and SQL cluster configuration
* SQL2012 new feature (Always On) Configuration

Drop your query

What my Client's Say?

 

  • Prabhu is an excellent instructor, very patient and thorough. I have tried another training class and EXPLORE IT far exceeds other trainers and their methods ~ Hassan Malik

  • An extremely helpful and informative course. Training materials were well organized and provided good case studies. Instructor was extremely professional and pleasant to learn from.~ Bhavani Sudarshnam

  • The training was clear and detailed. I like Parker's style of teaching as the recurrent training is a thorough review of the HR. Every opportunity for the student to ask questions was provided. ~ Yiting Chen

  • Jane Anderson conducted the class in a very professional manner. Examples were very relevant and I feel that I gained a lot from the updated materials this year.~ Somesh Taneja

  • Prem was a great instructor. Thanks Prem for making the training easy to understand. A lot of information was covered. He made the approach easy to follow.~ Komali Sambakula

  • She wants to make sure that her students walk away from her course with a good working knowledge. She is an excellent trainer and cares that all of her students learn the material.~ Kiran Jain

  • Krishna is very thorough and professional. He made the code very understandable. I was very impressed with his teaching methods and presentation of the regulations. EXPLORE IT is the best! ~ Rajesh Isukapalli

  • Mr. Chris Brown was very affirmative with the course, on time and fluent. This is my second recourse with him. I hope to take his course as long as I am shipping at my current job. ~ Awais Rahim