$50

Live MS SQL Server Database Training - Online Instructor Lead

Event Information

Share this event

Date and Time

Location

Location

Sholla Corporation

8204 Fenton Street

#223

Silver Spring, MD 20910

View Map

Refund Policy

Refund Policy

No Refunds

Friends Who Are Going
Event description

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

Date and Time

Location

Sholla Corporation

8204 Fenton Street

#223

Silver Spring, MD 20910

View Map

Refund Policy

No Refunds

Save This Event

Event Saved