|
This course shows learners how to control access to data and how to create a database. It also provides best practices for safeguarding data.
Objectives:
After completing this course, students will be able to:
- Use authentication types to determine where and how user identities are verified
- Modify the authentication level for an instance
- Grant database access authorities and privileges
- Decide what data to store in the database
- Define relationships between tables
- Identify constraints and foreign keys
Topics:
- Types of authentication
- Access to DB2
- Access within DB2
- Security for Windows
- Deciding what to store in the database
- Defining relationships, keys, and constraints for a table
- Normalizing the table
- Creating a simple database
- Adding data to tables
|
