Get in Touch
 Duration 14 hours

Course Outline

01. Establishing the Development Environment
➔ SQL Server Configuration Manager.
➔ SQL Server Management Studio (SSMS).
➔ Configuring the database infrastructure for this training program
➔ DBO administration and data readiness

02. Data Archiving
➔ Creating a database archive (BACKUP)
➔ Restoring databases from archive: BACKUP

03. Database Schemas
➔ Standard DBO schema.
➔ Custom schema structures

04. Dynamic Query Execution
➔ Dynamic Query Construction
➔ EXEC / EXECUTE commands
➔ SQL Injection vulnerabilities

05. Data Integrity Hashing and Checksums
➔ HASHBYTES, CHECKSUM, BINARY_CHECKSUM functions

06. Advanced Operational Controls
➔ NOCHECK, DISABLE, SET directives

07. Database Security Framework
➔ Core security concepts: identity verification, authentication, and authorization
➔ Server-level users and account management
➔ Server account administration
➔ Database-level account administration
➔ Governance of server accounts
➔ User access control and management
➔ Server-level roles
➔ Database-level roles
➔ User-specific roles
➔ Role-based access control administration
➔ Permission directives: GRANT, DENY, REVOKE

08. Code Obfuscation and Data Masking
➔ Configuration options: ENCRYPTION, VIEW_METADATA

09. Database and Server Performance Monitoring
➔ Utilization of memory, storage, processing, and network resources
➔ Auditing executed SQL queries
➔ Analysis of active sessions
➔ Review of recent connection logs
➔ Identification of high-cost and blocked queries
➔ TEMPDB capacity management
➔ Sessions with highest TEMPDB consumption
➔ Resource allocation oversight

10. Operational Diagnostic Tools
➔ Activity Monitor
➔ Performance Monitor

Requirements

This program is intended for government staff and public sector personnel seeking to enhance their competence in database security, with a specific focus on Microsoft SQL Server environments.

Participants are expected to possess fundamental knowledge of the Windows operating system and demonstrate prior familiarity with the Microsoft SQL Server environment.

Number of participants


Price per participant

Testimonials (4)

Upcoming Courses

Related Categories