Arich Infotech
Facebook
Instagram
Pinterest
X-twitter
Linkedin
Youtube
Menu
Home
About
Services
Careers
Courses
Mainframe
Infra
Data Science
Cloud
Open System
Blog
Events
Gallery
Contact
Home
About
Services
Careers
Courses
Blog
Events
Gallery
Contact
01
01
01
Menu
Home
About
Services
Careers
Courses
Mainframe
Infra
Data Science
Cloud
Open System
Blog
Events
Gallery
Contact
MS SQL Database Admin - Advanced
Home
Courses
Infra
MS SQL Database Admin - Advanced
MS SQL Database Admin - Advanced
Duration in Hours (4 Hours session) : 60
Duration in Days: 15
MS SQL Server Database Admin – Advanced
Course Code: IDBA51
40 Hours of Theory
20 Hours of Lab
Ch 1: DATABASE INTRO & SQL DBA
Data, Databases and RDBMS Software
Database Types : OLTP, DWH, OLAP
Microsoft SQL Server Advantages, Use
Versions and Editions of SQL Server
SQL : Purpose, Real-time Usage Options
SQL Versus Microsoft T-SQL [MSSQL]
Microsoft SQL DBA: Job Roles
Routine SQL DBA Activities in Realtime
Emergency SQL DBA Activities, Job Work
Maintenance SQL DBA Activities
SQL Server Components and Usage
Database Engine Component and OLTP
24 x 7 Online Lab for Remote DB Access
Software Installation Pre-Requisites
Ch 2: SQL SERVER INSTALLATIONS
System Configuration Checker Tool
Versions and Editions of SQL Server
SQL Server and SSMS Installation Plan
SQL Server Pre-requisites : S/W, H/W
SQL Server 2022 / 2019 Installation
SQL Server 2017 Installation
Instance Name and Server Features
Instances : Types and Properties
Default Instance, Named Instances
Port Numbers, Instance Differences
Service and Service Account Use
Authentication Modes and Logins
Windows Logins and SQL Logins
FileStream and Collation Properties
Ch 3: RESTORES & DB RECOVERY
Restore Phases – COPY, REDO, UNDO
RECOVERY, NORECOVERY Options
STANDBY and REPLACE in Restores
File, File Group & Metadata Restores
Backup Verifications using GUI, Scripts
VERIFYONLY : Backup Verification
STATS, UNLOAD, STOPAT and INIT
PARTIAL / PIECEMEAL Restores – Use
Tail Log Backup Usage in Real-time
Restores using GUI and T-SQL Scripts
MOVE Options for File Level Restores
Point-In-Time Restore, Checkpoint LSN
Standby Restores and Read-Only State
Common Backups Errors,Solutions
Ch 4: JOBS, MAINTENENCE PLANS
SQL Server Agent Service & Agent XPs
SQL Agent Jobs – GUI, Script Creations
Job Steps – Creation, Edits and Parse
Job Executions, Disable/Enable Options
Job History Purge. Job Activity Monitor
Database Maintenance – Backup Jobs
Scheduling Database Maintenance Plans
Backup Cleanup & History Cleanup Jobs
Backup Strategies For Minimal Data Loss
Backup Options: Block & Transfer Size
DB Mail Configurations and Alert System
DB Mail Profiles, SMTP Email Accounts
Operators : Creation and Real-time Use
Linking Jobs with Operators, Notifications
Ch 5: RECOVERY, DB SNAPSHOTS
Database Recovery Models, Logging
Database Log File Architecture
Full Recovery Mode, Real-time Usage
Simple Recovery Mode, Real-time Use
Bulk Logged Recovery Model, Imports
Recovery Models & Selectivity
Limitations with Simple Recovery Model
Database Snapshots : Creation, Use
Creating & Testing DB Snapshots
Read and Write Operations
Querying Database Snapshots
DB Snapshots: Page Versioning
Database Snapshots: Realtime Use
Comparing DB Backups & Snapshots
Ch 6: SECURITY MANAGEMENT
Authentication Types & Modifications
Windows Logins : Creation and Usage
SQL Server Logins : Creation, Usage
Password Policies; User Creations
Logins – Users Mapping, DB Access
Server Roles & Database Roles – Usage
Password Resets & Security Policies
Server Logs – Security Management
Log Archives: Login Failure Errors
Object Security and Column Security
Schema Security and Built-In Schemas
GRANT, WITH GRANT, DENY, REVOKE
CONTROL, OWNERSHIP, Authorization
Execute, References, View Definition
Need Help? Call Here
+91 88699 88399
COURSE ENQUIRY |
WhatsApp us