Basics of MS SQL Server Training

MS SQL Server is a relational database management system, which is developed by Microsoft. The primary function of SQL Server is to store and retrieve data as requested. There are several numbers of version of SQL Server are available in the market for a different workload. MS SQL Server is a SQL based client-server relational database.

Components ofSQL Server

  • Databases
  • Database Files and File Groups
  • Transaction Logs
  • Backup and Recovery
  • Protocols
  • Microsoft Clusters
  • Disaster Recovery

SQL Server Database

  • System databases
  1. Master
  2. Model
  3. MSDB
  4. Resource
  5. Tempdb
  • User databases

SQL Server Files

  • Binaries
  • Datafiles (.mdf, .ndf)
  • Transaction log files (.ldf)
  • Backup files and snapshot files
  • Filegroups

sql server training-bigclasses
SQL Server Transaction Log

When the end of the logical log reaches the end of the physical log file, the new log records wrap around to the start of the physical log file.

SQL Server Recovery Model Architectures

  • Simple: Truncate occurs on checkpoint
  • Bulk-Logged: All operations are logged except bulk operations
  • Full: All operations are logged

MS Cluster Server

Implementation consideration – Hardware, software and network


  • FCP
  • iSCSI
  • SMB

Disaster Recovery
Failover clustering is used to failover automatically if a hardware failure or a software failure occurs.

About SQL Server DBA Online Training @ BigClasses

BigClasses is one of the best online training organizations offer SQL Server DBA training. We have qualified and experienced faculties who are responsible for taking the online sessions. We provide study materials and 24 hours support to our national and international learners as well. If you are interested inSQL Server DBA online training, contact us for the detailed course and the free demo classes.

India: +91 800 811 4040 USA: +1 757 905 2515