Call Us at: +1616-469-0394 | Email: info@hexissoft.com

Follow Us on: facebook_icon twitter-icon linkdein_icon

COURSES

QUICK ENQUIRY











aboutus_banner

SQL DBA

SQL Server DBA Online Training

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

  • Default Instance
  • Named Instance

SQL Server Services

  • Instance aware services
  • Instance unaware services

Installing SQL Server

  • Pre-requisites
  • Installation
  • Post Installation verification Session 

Functioning of Databases

  • Database

Types of Database and Brief explanation

  • System Databases
  • User Database

Database Architecture

  • Pages
  • Extents
  • File groups
  • Database
  • Transaction Architecture
  • Creating Database

Modifying Database

  • Adding Files
  • Moving and renaming  of Database files
  • Database modes
  • Real time Scenario

Security

  • Authentication Types in SQL Server

Types of Login

  • Windows Login
  • 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

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

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

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
Back to Top…