MS SQL Server Administration 2022

Inquire now

Duration  5 days – 35 hrs.

 

Overview

 

The MS SQL Server Administration 2022 Training Course is a comprehensive program designed to equip participants with the essential skills and knowledge required to effectively manage and optimize Microsoft SQL Server environments. This course is ideal for IT professionals, database administrators, and anyone seeking to enhance their expertise in SQL Server administration.

 

Objectives

 

  • Acquire and enhance skills for creating and managing databases.
  • Acquire knowledge of SQL syntax and its use in retrieving and modifying data.
  • Apply safety protocols within the database.
  • Utilize advanced elements such as replication, automation, and Business Intelligence (BI).
  • Harness Microsoft SQL Server capabilities to generate intricate reports and solutions for developers.

Audience

 

  • IT Professionals
  • Database Administrators
  • System Administrators
  • IT Managers

Pre- requisites 

  • Participants are expected to have a basic understanding of database concepts and a working knowledge of Windows Server environments.
  • Knowledge of computer and Windows operating system.

Course Content

 

Basic information about databases

  • Database files, Database Client / Server
  • Relational database management systems (RDBMS)

 

SQL Server versions and the differences between them

  • Express, Standard, Enterprise
  • Workgroup, Mobile, Developer

 

SQL Server Tools

  • SQL Server Management Studio
  • SQL Server Agent

 

Services in SQL Server

  • Database Services
  • Analysis Services
  • Reporting Services
  • Integration Services

 

Base system

  • Master
  • Model
  • Msdb
  • Tempdb
  • Distribution
  • Resource      

Create a database

  • The database files and their location
  • File size and its growth
  • Partitioning tables

 

Data Modification Language (DML)

  • INSERT
  • UPDATE
  • DELETE

 

Data Definition Language (DDL)

 

Designing Tables

  • Columns and Attributes
  • Determine the type of data
  • Indexes and Keys

 

Indexes

  • Clustered Indexes
  • Non-Clustered Indexes
  • REBUILD vs. REORGANIZE 

 

Creating a database application

 

Server-side programming

  • Procedures
  • Views
  • Functions

 

Triggers

 

Models play

  • Simple
  • Full
  • Bulk logged

 

Backup

  • Full
  • Differential
  • Transaction Log

 

Backup Strategies

  • Strategy full copy of the database
  • Strategy of full backups and transaction log
  • The strategy of incremental database backup
  • Strategy copies of the database files

 

Basic security and administration of SQL Server

 

Automation

  • Maintenance Plan
  • Jobs

 

Basic security and administration of SQL Server

  • Server Roles
  • Database Roles
  • SA Account
  • Creating Accounts
  • Schemes

 

Replication

  • Snapshot Replication
  • Transactional Replication
  • Merge Replication

Activity Monitor SQL Server

  • SQL Server Profiler

 

Upgrade

  • In-Place vs. Side-By-Side
  • Service-Pack
  • Cluster
Inquire now

Best selling courses

This site uses cookies to offer you a better browsing experience. By browsing this website, you agree to our use of cookies.