Duration: 1 days
Course Learning Skills: SQL Server Data Security
This course will enable delegates to work with data security issues. They can then secure their data stores. Practical examples and exercises will be provided using Microsoft SQL Server, but the principle will apply to other database platforms. Data security is a vital issue today. There are regular breaches reported in the media.
Before attending this course, students must have:
- Understanding of relational database concepts
Module 1: What is cyber security?
- What is cyber crime?
- How can we protect?
- Securing databases
- Safety tips …
Module 2: Data Security Overview
- The Threats
- Security Design Philosophy
- Securable Objects
- Data Encryption
Module 3: Design and Administer Security Levels
- Design security plan
- Administer authentication
- Administer authorization
- Administer permissions
- Administer users, groups and roles