Arich Infotech

Facebook Instagram Pinterest X-twitter Linkedin Youtube
Menu
Menu

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

  1. Data, Databases and RDBMS Software
  2. Database Types : OLTP, DWH, OLAP
  3. Microsoft SQL Server Advantages, Use
  4. Versions and Editions of SQL Server
  5. SQL : Purpose, Real-time Usage Options
  6. SQL Versus Microsoft T-SQL [MSSQL]
  7. Microsoft SQL DBA: Job Roles
  8. Routine SQL DBA Activities in Realtime
  9. Emergency SQL DBA Activities, Job Work
  10. Maintenance SQL DBA Activities
  11. SQL Server Components and Usage
  12. Database Engine Component and OLTP
  13. 24 x 7 Online Lab for Remote DB Access
  14. Software Installation Pre-Requisites
  1. System Configuration Checker Tool
  2. Versions and Editions of SQL Server
  3. SQL Server and SSMS Installation Plan
  4. SQL Server Pre-requisites : S/W, H/W
  5. SQL Server 2022 / 2019 Installation
  6. SQL Server 2017 Installation
  7. Instance Name and Server Features
  8. Instances : Types and Properties
  9. Default Instance, Named Instances
  10. Port Numbers, Instance Differences
  11. Service and Service Account Use
  12. Authentication Modes and Logins
  13. Windows Logins and SQL Logins
  14. FileStream and Collation Properties
  1. Restore Phases – COPY, REDO, UNDO
  2. RECOVERY, NORECOVERY Options
  3. STANDBY and REPLACE in Restores
  4. File, File Group & Metadata Restores
  5. Backup Verifications using GUI, Scripts
  6. VERIFYONLY : Backup Verification
  7. STATS, UNLOAD, STOPAT and INIT
  8. PARTIAL / PIECEMEAL Restores – Use
  9. Tail Log Backup Usage in Real-time
  10. Restores using GUI and T-SQL Scripts
  11. MOVE Options for File Level Restores
  12. Point-In-Time Restore, Checkpoint LSN
  13. Standby Restores and Read-Only State
  14. Common Backups Errors,Solutions
  1. SQL Server Agent Service & Agent XPs
  2. SQL Agent Jobs – GUI, Script Creations
  3. Job Steps – Creation, Edits and Parse
  4. Job Executions, Disable/Enable Options
  5. Job History Purge. Job Activity Monitor
  6. Database Maintenance – Backup Jobs
  7. Scheduling Database Maintenance Plans
  8. Backup Cleanup & History Cleanup Jobs
  9. Backup Strategies For Minimal Data Loss
  10. Backup Options: Block & Transfer Size
  11. DB Mail Configurations and Alert System
  12. DB Mail Profiles, SMTP Email Accounts
  13. Operators : Creation and Real-time Use
  14. Linking Jobs with Operators, Notifications
  1. Database Recovery Models, Logging
  2. Database Log File Architecture
  3. Full Recovery Mode, Real-time Usage
  4. Simple Recovery Mode, Real-time Use
  5. Bulk Logged Recovery Model, Imports
  6. Recovery Models & Selectivity
  7. Limitations with Simple Recovery Model
  8. Database Snapshots : Creation, Use
  9. Creating & Testing DB Snapshots
  10. Read and Write Operations
  11. Querying Database Snapshots
  12. DB Snapshots: Page Versioning
  13. Database Snapshots: Realtime Use
  14. Comparing DB Backups & Snapshots
  1. Authentication Types & Modifications
  2. Windows Logins : Creation and Usage
  3. SQL Server Logins : Creation, Usage
  4. Password Policies; User Creations
  5. Logins – Users Mapping, DB Access
  6. Server Roles & Database Roles – Usage
  7. Password Resets & Security Policies
  8. Server Logs – Security Management
  9. Log Archives: Login Failure Errors
  10. Object Security and Column Security
  11. Schema Security and Built-In Schemas
  12. GRANT, WITH GRANT, DENY, REVOKE
  13. CONTROL, OWNERSHIP, Authorization
  14. Execute, References, View Definition
Need Help? Call Here
+91 88699 88399
COURSE ENQUIRY   |