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.
Testimonials (4)
data was personalised to our organisations
Vincent Long - ASSMANG PTY LTD
Course - T-SQL Fundamentals with SQL Server Training Course
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training was well structured and interactive
kgotla Moncho - Martin Engineering Africa
Course - MS 20761 : Querying Data with Transact SQL
The instructor brought his A game again as he superbly took my staff through the customized training with expert timing, knowledge, support, and rapport with my staff.