Training Courses
Course Outline for SQL Server Training

What is SQL Server?

SQL Server is Microsoft's relational database management system (RDBMS). It is a full-featured database primarily designed to compete against competitors Oracle Database (DB) and MySQL. Like all major RBDMS, SQL Server supports ANSI SQL, the standard SQL language.

CURRICULUM

SQL Server

Module

Module

  • 2.1 Pre installation steps
  • 2.2 Installation
  • 2.3. Post installations steps
  • 2.2 Adding/removing features
  • 2.2 Interview Q&A
    •

Module

  • 3.1 Over view of SQL Server service packs, CU and hotfix
  • 3.2 Pre patch/service pack installation steps
  • 3.3 Patching on standalone servers
  • 3.4 Patching on Cluster servers ( Active/Passive & Active/Active)
  • 3.3 Post patch/service pack installation steps
  • 3.3 Removing the service pack
  • 3.3 Interview Q&A
    •

Module

  • 4.1 Server Architecture
  • 4.2 Creating Databases & Over view of database properties
  • 4.3 Database Architecture
  • 4.4 Log Architecture
  • 4.5 Over view of System databases
  • 4.6 Interview Q&A
    •

Module

  • 5.1 Recovery models
  • 5.2 Backup types
  • 5.3 Performing Backup and Restoration
  • 5.4 Recovery Methods
  • 5.5 Page level restore
  • 5.6 Database movement methods ( Attach/Detach, Import/export, copy only & Script Generation)
  • 5.7 Database file movement
  • 5.8 Linked server and creation
  • 5.9 Interview Q&A
    •

Module

  • 6.1 Authentication modes
  • 6.2 Creating logins and users
  • 6.3 Understanding server and Database roles
  • 6.4 Assigning/Removing roles to logins/users
  • 6.5 Granting/revoking object level access
  • 6.6 Security Auditing
  • 6.7 Interview Q&A
    •

Module

  • 7.1 Side by side upgrade
  • 7.2 Inplace up grade
  • 7.3 Database Refresh
  • 7.4 Edition upgrade
  • 7.4 Interview Q&A

Module

  • 8.1 Maintenance plan
  • 8.2 Jobs and alerts
  • 8.3 Database mail configuration
  • 8.4 Interview Q&A
    •

Module

  • 9.1 Logshipping
    • Overview
    • Pre requisites
    • Configuration
    • Failover process
    • DR Test
    • DB Refresh
    • Patching on Log shipping databases
    • File Adding and users adding
    • Issues & Interview Q&A
  • 9.2 Database mirroring
  • Overview
  • Types of mirroring
  • Pre requisites
  • Configuration
  • Failover process
  • DR Test
  • Patching
  • DB Refresh
  • File Adding and users adding
  • Snapshot creation
  • Issues & Interview Q&A
  • 9.3 Replication (Snapshot, Transactional and Merge replication)
    • Overview
    • Pre requisites
    • Types of Replication
    • Configuration
    • Tables adding & removing
    • Patching
    • Issues & Interview Q&A
  • 9.4 Always ON
    • Overview
    • Pre requisites
    • Configuration
    • Failover process
    • Patching
    • DB Refresh
    • File Adding and users adding
    • DR Test
    • Issues & Interview Q&A
  • 9.5 Clustering
    • Overview
    • Pre requisites
    • Configuration
    • Failover process
    • Disk adding
    • Patching
    • Issues & Interview Q&A
    •

Module

  • DBCC and DMV's
  • Locks
  • Isolation levels
  • Blocking
  • Dead locks
  • Indexes
  • Update stats
  • Fragmentation
  • Query Execution
  • Interview Q&A
    •

Module

;