Course Outline
01. PREPARING THE DEVELOPMENT ENVIRONMENT
➡ SQL Server Configuration Manager.
➡ SQL Server Management Studio (SSMS).
➡ Configuring the database for this course
➡ DBO setup and data preparation
02. DATA BACKUP
➡ Creating database archives (BACKUP)
➡ Restoring databases from archives: BACKUP
03. DATABASE SCHEMAS
➡ The default DBO schema.
➡ Custom schemas
04. DYNAMIC QUERIES
➡ DYNAMIC QUERY
➡ EXEC / EXECUTE
➡ SQL INJECTION
05. DATA HASHING AND CHECKSUMS
➡ HASHBYTES, CHECKSUM, BINARY_CHECKSUM
06. ADVANCED OPERATIONS
➡ NOCHECK, DISABLE, SET
07. DATABASE SECURITY
➡ Security fundamentals: identification, authentication, authorization
➡ Server users and user accounts
➡ Server accounts
➡ Database accounts
➡ Server account administration
➡ User administration
➡ Server roles
➡ Database roles
➡ User roles
➡ Role management
➡ Commands: GRANT, DENY, REVOKE
08. SMUDGE, OBFUSCATE CODE
➡ Options: ENCRYPTION, VIEW_METADATA
09. DATABASE AND SERVER MONITORING
➡ Monitoring RAM, disk, processor, and network interface usage
➡ Reviewing executed SQL queries
➡ Active sessions
➡ Recent connections
➡ Most resource-intensive and blocked queries
➡ TEMPDB space
➡ Sessions consuming the most TEMPDB space
➡ Resource allocation
10. USEFUL TOOLS
➡ Activity Monitor
➡ Performance Monitor
Requirements
This program is intended for individuals seeking to enhance their understanding of database security in general, with a specific focus on Microsoft SQL Server.
Participants should possess a solid working knowledge of the Windows environment and be familiar with the Microsoft SQL Server ecosystem.
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.
