OAKCC-CIS1610.AA1
Database Security
Self-paced · 1 year access
35 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
11 Interactive Lessons · 112 topics01 Security Policies 10 topics · 1 LiveLab +
- Introduction
- What Is a Policy?
- Defining User Policies
- Defining System Administration Policies
- Defining Access Control
- Development Policies
- Standards, Guidelines, and Procedures
- Disaster Recovery
- Important Laws
- Summary
1 LiveLab in this lesson — see the labs panel →
02 Securing Resources 15 topics · 3 LiveLab +
- TCP/IP Security Vulnerabilities
- Implementing Security
- Resources and Services
- Protecting TCP/IP Services
- Simple Mail Transfer Protocol (SMTP)
- Bring Your Own Device (BYOD)
- Internet of Things (IoT)
- Communication Systems
- Physical Security
- Testing Systems
- Security Testing Software
- Security Assessments
- Security and Repetition
- Lesson Summary
- Optional Lab
3 LiveLab in this lesson — see the labs panel →
03 Security Threats 14 topics · 2 LiveLab +
- Who Is the Threat?
- Security Threats from Trusted Users
- Anonymous Downloads and Indiscriminate Link-Clicking
- Security Standards
- Wireless Networking Modes
- Wireless Application Protocol (WAP)
- Site Surveys
- Web Technologies
- Greynet Applications
- Sensitive Data and Data Classifications
- Vulnerabilities with Data at Rest
- Data and Drive Sanitizing
- Lesson Summary
- Optional Lab
2 LiveLab in this lesson — see the labs panel →
04 Administer a Database 3 topics · 3 LiveLab +
- Understand Database Security Concepts
- Understand Database Backups and Restore
- Summary
3 LiveLab in this lesson — see the labs panel →
05 Database Security 14 topics · 1 LiveLab +
- Introduction to Database Security Issues
- Discretionary Access Control Based on Granting and Revoking Privileges
- Mandatory Access Control and Role-Based Access Control for Multilevel Security
- SQL Injection
- Introduction to Statistical Database Security
- Introduction to Flow Control
- Encryption and Public Key Infrastructures
- Privacy Issues and Preservation
- Challenges to Maintaining Database Security
- Oracle Label-Based Security
- Summary
- Review Questions
- Exercises
- Selected Bibliography
1 LiveLab in this lesson — see the labs panel →
06 Transactions and Database Security 6 topics +
- Introduction to Database Transactions and Security
- Transactions
- Concurrency Control
- Transaction Support in SQL
- Database Security
- Lesson Summary
07 Applications, Data, and Cloud Security 13 topics +
- It’s a Data-Driven World…At the Endpoint
- Software as Appliances
- Applications Lifecycles and Security
- CIANA and Applications Software Requirements
- Application Vulnerabilities
- “Shadow IT:” The Dilemma of the User as Builder
- Information Quality and Information Assurance
- Protecting Data in Motion, in Use, and at Rest
- Into the Clouds: Endpoint App and Data Security Considerations
- Legal and Regulatory Issues
- Countermeasures: Keeping Your Apps and Data Safe and Secure
- Summary
- Exam Essentials
08 Securing hosts and data 4 topics · 5 LiveLab +
- Module A: Malware
- Module B: Securing data
- Module C: Securing hosts
- Summary
5 LiveLab in this lesson — see the labs panel →
09 Understanding Authentication, Authorization, and Accounting 14 topics · 18 LiveLab +
- Starting Security with Authentication
- Introducing Directory Services with Active Directory
- Comparing Rights and Permissions
- Understanding NTFS
- Sharing Drives and Folders
- Introducing the Registry
- Using Encryption to Protect Data
- Understanding IPsec
- Introducing Smart Cards
- Configuring Biometrics, Windows Hello, and Microsoft Passport
- Using Auditing to Complete the Security Picture
- Skill Summary
- Business Case Scenarios
- Workplace Ready
18 LiveLab in this lesson — see the labs panel →
10 Protecting Security of Assets 8 topics · 1 LiveLab +
- Identifying and Classifying Information and Assets
- Establishing Information and Asset Handling Requirements
- Data Protection Methods
- Understanding Data Roles
- Using Security Baselines
- Summary
- Exam Essentials
- Written Lab
1 LiveLab in this lesson — see the labs panel →
11 Database Recovery Techniques 11 topics · 1 LiveLab +
- Recovery Concepts
- NO-UNDO/REDO Recovery Based on Deferred Update
- Recovery Techniques Based on Immediate Update
- Shadow Paging
- The ARIES Recovery Algorithm
- Recovery in Multidatabase Systems
- Database Backup and Recovery from Catastrophic Failures
- Summary
- Review Questions
- Exercises
- Selected Bibliography
1 LiveLab in this lesson — see the labs panel →
Hands-On Labs Our edge
35 LiveLabs- Creating a Policy for Restricting Installations
- Scanning Systems in Ubuntu Linux
- Securing the FTP Service
- Securing an Apache Web Server
- Analyzing Traffic Captured from Site Survey Software
- Installing a Wardriving Application and Analyzing a Site Survey Capture
- Adding a New Login
- Accessing the Database Roles
- Creating a Backup
- Identifying database attacks
- Using an Anti-Spyware Tool
- Managing NTFS Permissions
- Configuring Lockout Policies
- Using the chmod Command
- Creating a Security Template
- Creating OUs in a Domain
- Using a Hashing Algorithm
- Moving Objects into an OU
- Creating a GPO
- Changing NTFS Permissions on a Folder
- Copying Files
- Moving Files
- Understanding Permission Inheritance
- Using Groups to Assign Permissions
- Sharing a Folder
- Encrypting a Folder with the EFS
- Encrypting the Drive Using BitLocker
- Performing Symmetric Encryption
- Performing Asymmetric Encryption
- Creating a VPN Connection
- Configuring an IPsec Policy
- Changing the Audit Policy
- Modifying Kerberos Security Settings
- Understanding Data Loss Prevention System
- Creating a backup
Labs run in your browser — nothing to install.
Prepare for Database Security
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 35 LiveLab included
- Certificate of completion
No credit card required