Multiple Dates

Live MS SQL Server Database Training - Online Instructor Lead

Event Information

Share this event

Date and Time



Sholla Corporation

8204 Fenton Street


Silver Spring, MD 20910

View Map

Refund Policy

Refund Policy

No Refunds

Event description


SQL DBA Online Training

Introduction of SQL SERVER Architecture

  • Basic SQL Architecture
  • SQL DB Files
  • Locks in SQL Server
  • Transaction Isolation Levels
  • System Databases

SQL SERVER Installation: (Live Example)

  • System Requirements & suggestions
  • `SQL server Installation using GUI
  • SQL Server Installation using Configuration.ini
  • Rebuilding Master DB
  • SQL server upgrade, Patching & SQL DB Migration

SQL Server Backup & Restore: (Live Example)

  • DB structure based on Recovery Models

  • Relation with Recovery Models & Backup solutions
  • Types of Backups including Copy only
  • Maintenance plans
  • DBA Email Alerts
  • Understanding SQL LSN & Backups
  • Database Restore & Recovery

  • Full Database Restore
  • Full DB restore & transaction logs recovery
  • Restoring System DBs (Recap on SQL Server Installation Rebuilding Master DB)
  • Understanding SQL LSN & Backups-Restore

Data Movement

  • Data Import & Export using BCP Commands
  • Data Import & Export using SQL Import & Export Wizard

Security Concepts in SQL

  • SQL Server Authentication Vs Windows Authentication
  • Logins & Users of SQL Server
  • Understanding Server Level Roles
  • User Defined Server level Roles
  • Contained Database Configuration. (Depends on the environment)
  • Transparent Data Encryption (TDE)

Performance Tuning

  • Database indexes understanding
  • Checking index defragmentation & Maintenance
  • Database Health Check
  • Understanding SQL Server Profiler
  • Creating & Running Traces
  • Understanding Extended Events
  • Creating & configuring Extended Events

Advanced SQL Server Technology (Live Examples whichever is possible)

  • Log Shipping
  • Database Mirroring
  • Clustering
  • Replication
  • Always On Technology
  • Column Store Index
  • Using SSD in SQL 2012

  • 64 hours Hands on Training

  • Completely Practical and Real-time

  • Suitable for Starters + Working Professionals

  • Session wise Handouts and Tasks + Solutions

  • Weekly Mock Interviews, Certifications

  • Certification & Interview Guidance

  • Job Placement Assistance

What are the benefits of Live Online Classes?

  • Save money with affordable class pricing and no travel expenses

  • Save time. The class comes to you!

  • Learn more in a place where you’re comfortable and can avoid distractions

  • No setup required, just access to high-speed Internet

  • Learning that engages you with real-time interaction with instructors and peers

  • Choose what you need to learn from a wide range of classes

  • Lab - Remote access of our lab and tutorial sessions

Share with friends


Sholla Corporation

8204 Fenton Street


Silver Spring, MD 20910

View Map

Refund Policy

No Refunds

Save This Event

Event Saved