Microsoft SQL Server Administration

Equips participants with essential skills to effectively manage, secure, and optimize SQL Server databases, ensuring high performance, reliability, and data protection in enterprise environments.

Explore Training Partner with Us
Microsoft SQL Server Administration

Microsoft SQL Server Administration

Equips participants with essential skills to effectively manage, secure, and optimize SQL Server databases, ensuring high performance, reliability, and data protection in enterprise environments.

Contact Us

What You’ll Learn

  • 📘 Introduction to Databases
  • 📘 How is Data Stored?
  • 📘 Table, Column, Rows and Keys
  • 📘 Keys - Primary, Unique and Foreign
  • 📘 Transaction and ACID Properties
  • 📘 Database Normalization
  • 📘 DDL Statements
  • 📘 DCL Statements
  • 📘 TCL Statements
  • 📘 Stored Procedures
  • 📘 Functions
  • 📘 Triggers
  • 📘 Indexes
  • 📘 Indexes based on Configuration
  • 📘 Data Pages and Index Fragmentation
  • 📘 Indexing Lab
  • 📘 MSSQL Management Tools
  • 📘 Exploring SQL Server Management Studio
  • 📘 Exploring SQL Server Configuration Manager
  • 📘 System Databases
  • 📘 Master Database
  • 📘 Tempdb Database
  • 📘 MSDB Database
  • 📘 Model and Resource Database
  • 📘 Pages, Extents, and PFS
  • 📘 MSSQL Architecture
  • 📘 Transaction Log Architecture
  • 📘 Backups and Recovery Models
  • 📘 Full Backups
  • 📘 Differential Backups
  • 📘 Transactional Log Backups
  • 📘 Lab - Backups
  • 📘 Restore and Recovery Overview
  • 📘 Point in Time Restore of a Database
  • 📘 Lab - Backup and Restore
  • 📘 DBCC CHECKDB Command
  • 📘 Page Level Restore
  • 📘 Restore Master Database
  • 📘 Maintenance Plan
  • 📘 MSSQL Security Model
  • 📘 Authentication Modes
  • 📘 Server Logins and Roles
  • 📘 Database Users and Roles
  • 📘 Permissions (GRANT, DENY, REVOKE)
  • 📘 SQL Server Agent
  • 📘 Jobs and Schedules
  • 📘 Additional Agent Components
  • 📘 High Availability and its Types
  • 📘 Replication and Transactional Replication
  • 📘 Transactional Replication LAB
  • 📘 Log Shipping
  • 📘 SQL Server Query Tuning
  • 📘 Query Optimization Lab
  • 📘 SQL Server Encryption
  • 📘 Transparent Data Encryption (TDE)
📘

13

Sections

📋

55

Chapters

Why Train with ByteSize?

🎓

Free Access to LMS with AI Q&A

Enjoy complimentary access to our Learning Management System (LMS) with AI-powered Question & Answer features to enhance your learning experience.

🎮

Surveys, Quizzes and Games

Make learning interactive and engaging with our innovative tools like surveys, quizzes, and games tailored to boost retention and fun.

📊

Access to Learner Dashboard

Monitor learner progress with our comprehensive dashboards, providing real-time insights to measure engagement and performance.

Let’s Build Your Team’s Skills

Take the first step to transform your organization with data analytics. Fill out the form, and we’ll get back to you with a tailored solution.