دوره SQL Server 2022 Pack – Admin & Design

• Administration

Overview of SQL Server

Installing MS SQL Server

Understanding SQL Server Services

Database Architecture

System and Database Catalogs

Creating/Configuring User Databases

In-Memory OLTP (In Memory Optimization)

Importing and Exporting Data

Backup/Restoration Strategy

Working with Database Snapshots

Managing SQL Server Security

Data Partitioning

Automating Administrative Tasks

Monitoring SQL Server Activities

Maintaining High Availability

Using SQL Server Replication

Applying RAID Technology

Policy Base management

Data Storage and Compression

Resource Governor

• Design

Database Logical Modeling

Database Physical Modeling

Creating and Maintaining Tables

Implementing Data Integrity

Accessing Data

Creating and Maintaining Indexes

Columnstore indexes

Creating Database Objects

Modifying Data

Importing and Exporting Data

Using XML in SQL Server

Locking in Multi User Applications

Developing a Security Plan

Transparent Data Encryption

Using DML/DDL Triggers

Event Notification

Views

Stored Procedures

New DataTypes

FILESTREAM

File Table

Change Tracking

Change Data Capture

Table-Valued Parameters

Development GIS in SQL server

Full Text Search

Semantic search