دورة ادارة قواعد البيانات من نوع Microsoft SQL server
تفاصيل الدورة :
Section 1 – Download, Install and Configure MS SQL Server
Prerequisites for MSSQL Installation
Download MSSQL and SQL Server Management Studio
Install and Configure MSSQL
Install SQL Server Management Studio
Download and Install Adventure Works Database
Section 2 – Database Fundamentals and Design
What is Data and Database?
How is data stored?
What is a Table, COLUMN and ROW ?
What is a key? primary, foreign, unique keys etc.
What is Relational Database and Relational Database Management System (RDBMS)?
What are Transaction and ACID properties?
Database Normalization AND Different forms of Database Normalization
Create your first Database, Table and Populate table with data…
Section 3 – Introduction to SQL Commands
Welcome to Basic SQL Commands
What is a SQL Statement and types of SQL statements
DML Statement with examples
DDL Statements with examples
DCL Statement with examples
TCL Statement with examples
Section 4 – Query and Manipulation of Data using SQL
Create TABLE(s) and Temp Table(s)
What Is a View?
SELECT Statement in detail
Operators, Expressions and Conditions
WHERE Clause, ORDER BY, HAVING BY, GROUP BY Clause
Select from two tables – JOINS
Different Types of JOINS
What is a Subquery?
INSERT, UPDATE, DELETE and Truncate Statements
What is a Stored Procedure?
Function, Trigger and INDEX
Clustered ,Non-clustered Indexes and Index Design considerations
Index Fragmentation and Lab for Index
Section 5 – MSSQL Backup and Restore
Backup of a Database, Importance for DBA and Different Media used for Backups
Recovery Models in MSSQL and how that impact backups and restore
Full and differential backups
Transaction Log Backups, Log Backup Chain and Tail-log Backup
Lab for Full, Differential and Transaction Log Backups
Restore and Recovery Overview
Full, Differential and Transaction Log database restore
Point in time restore of a database
Complete Backup , Restore and Restore in Time Lab
MS SQL Server DBCC CHECKDB command
Page Level Restore / Recovery using Full Backups
Section 6 – MSSQL User Management
MSSQL Security Model
MSSQL Server Authentication Modes
Server Logins
Server Roles
Database Users
Database Roles
Permissions (GRANT , DENY, and REVOKE)
