ZOBS is a IT training and web design company based in Newport, near Cardiff, South Wales, UK. We’re one of the UK’s leading specialists in providing training in all SAP modules.

Call Back Request:

Contact Us

  • Call Now:01633746212
  • Email Adress: info@zephyromega.co.uk
  • Address Info: Unit 3, NTS Plaza,
    113-114 Commercial Road,
    NP20 2GW

Close Call Back Request

Call Back Request

Leading IT Training & Web Design Agency in Newport, Gwent UK.
We’re one of the UK’s leading specialists in providing training in all SAP modules.

SQL Server DBA

Course Details of SQL Server DBA

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
    • Default Instance
    • Named Instance
  • SQL Server Services
    • Instance aware services
    • 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
    • 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

Module4:  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

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