Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
01. PREPARING THE DEVELOPMENT ENVIRONMENT
➡ SQL Server Configuration Manager.
➡ SQL Server Management Studio (SSMS).
➡ Setting up the database for this training course
➡ DBO and data preparation
02. DATA BACKUP
➡ Creating an archiving (BACKUP) of the database
➡ Restoring databases from the archive: BACKUP
03. DATABASE SCHEMAS
➡ 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 basics: identification, authentication, authorization
➡ Server users and user accounts
➡ Server accounts
➡ Database accounts
➡ Server account management
➡ User management
➡ 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
➡ Use of RAM, disks, processors, network interfaces
➡ Checking executed SQL queries
➡ Active sessions
➡ Recent connections
➡ Most expensive and blocked queries
➡ TEMPDB space
➡ Sessions using the most space in TEMPDB
➡ Resource allocation
10. USEFUL TOOLS
➡ Activity Monitor
➡ Performance Monitor
Requirements
The training is designed for all those who want to acquire knowledge about database security in general and Microsoft SQL Server.
Trainees are required to have knowledge of the Windows environment and familiarity with Microsoft SQL Server environment.
14 Hours
Testimonials (5)
Being human and talking to us as understandable possible
Sorin
Course - Database Administration Fundamentals for MS SQL Server
It allowed us to have an applied hands on sproc to our company database.
Corneliu Buculei - Standard Building Supplies Ltd
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
the in depth knowledge and customize approach
Julius Mapili - SYKES Asia, Inc.
Course - Administering in Microsoft SQL Server
I appreciated Folio's wide breadth of knowledge. Not only was he familiar with the course content, but he also knew of constructs in languages we were familiar with to make examples more meaningful to us. During intervals he shared his knowledge of technologies and solutions outside the training scope to provide insights into other solutions we could use in future (and future training).
Raphael - Markit Valuations Limited
Course - Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012
The thorough / hands-on knowledge the trainer has.
