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