Course Outline
01. PREPARING THE DEVELOPMENT ENVIRONMENT
➡ SQL Server Configuration Manager.
➡ SQL Server Management Studio (SSMS).
➡ Configuring the database for this training session
➡ DBO and data initialization
02. DATA BACKUP
➡ Creating database archives (BACKUP)
➡ Restoring databases from archives
03. DATABASE SCHEMAS
➡ The default DBO schema
➡ Custom schema implementation
04. DYNAMIC QUERIES
➡ Dynamic query concepts
➡ EXEC / EXECUTE statements
➡ SQL Injection vulnerabilities
05. DATA HASHING AND CHECKSUMS
➡ HASHBYTES, CHECKSUM, BINARY_CHECKSUM functions
06. ADVANCED OPERATIONS
➡ NOCHECK, DISABLE, SET commands
07. DATABASE SECURITY
➡ Fundamental security concepts: identification, authentication, authorization
➡ Server users and user accounts
➡ Server-level accounts
➡ Database-level accounts
➡ Managing server accounts
➡ User administration
➡ Server roles
➡ Database roles
➡ User roles
➡ Role management strategies
➡ Permission commands: GRANT, DENY, REVOKE
08. CODE OBFUSCATION AND SMUDGING
➡ Configuration options: ENCRYPTION, VIEW_METADATA
09. DATABASE AND SERVER MONITORING
➡ Monitoring RAM, disk, processor, and network interface usage
➡ Auditing executed SQL queries
➡ Tracking active sessions
➡ Reviewing recent connections
➡ Identifying high-cost and blocked queries
➡ TEMPDB space utilization
➡ Sessions consuming the most TEMPDB space
➡ Resource allocation analysis
10. USEFUL TOOLS
➡ Activity Monitor
➡ Performance Monitor
Requirements
This training is tailored for individuals seeking to deepen their expertise in general database security and specifically within the Microsoft SQL Server ecosystem.
Participants are expected to possess foundational knowledge of the Windows operating system environment and prior familiarity with the Microsoft SQL Server platform.
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.
