Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
Administration and Security
Understand user logins, database security, permissions, and rolesPreview the first lesson free — get full access to all 4 lessons.
Beginner Provider : Daniel Hanks 4 Lessons · 8m in Arabic, German, English, Spanish, French, Portuguese, Urdu, Chinese
Course Description
This course will introduce you to database administration and security. You’ll learn why it’s so important to secure your databases. You’ll learn about user and user logins. You’ll also learn how permissions and roles can help secure your database. Finally, you’ll backup and restore a database.
Using the downloaded software with the sample database already created, you’ll add users that can access the database, and learn what permissions they can have and what those permissions allow them to do. You’ll gain a better understanding of what permissions you can use to allow or restrict a given user to do within the database while learning the importance of securing the data being stored. Finally, you’ll learn how to backup and restore a given database to ensure critical data is always available.
What You'll Learn
- Understand the importance of securing your database and the data being stored
- Create and manage users and user logins that can access the database
- Configure permissions and roles to allow or restrict what a given user can do
- Back up and restore a database to ensure critical data is always available
Key Takeaways
- Securing databases is important to protect the data being stored.
- Users and user logins control who can access the database.
- Permissions and roles can be used to allow or restrict what a given user is able to do within the database.
- Backing up and restoring a database helps ensure critical data is always available.
Frequently Asked Questions
What does this course cover?
It introduces database administration and security, covering why securing databases matters, users and user logins, permissions and roles, and backing up and restoring a database.
What skills will I gain from this course?
The course covers Database Administration, Database Management, Database Permissions, Database Security, Oracle Database Administration (DBA), and Web Administration.
Will I get hands-on practice?
Yes. Using the downloaded software with the sample database already created, you'll add users that can access the database and learn what permissions they can have and what those permissions allow them to do.
What will I learn about permissions?
You'll gain a better understanding of what permissions you can use to allow or restrict a given user within the database, while learning the importance of securing the data being stored.
