Curated Video
Oracle Database Administration from Zero to Hero - Practice - Managing Local and Common Users (Part 1 of 2)
In this practice video, we will deepen our understanding of managing local and common users in CDB and PDBs. You will perform tasks such as managing common users, local users, and common and local roles. This clip is from the chapter...
Curated Video
Oracle Database Administration from Zero to Hero - Querying Container Data Objects
In this video, we will focus on querying container data objects. You will learn how to query container data objects, set CONTAINER_DATA attributes for a common user, obtain information about CONTAINER_DATA attributes in a multitenant...
Curated Video
Oracle Database Administration from Zero to Hero - Managing Local and Common Users
In this video, we will explore the concepts of local and common users. You will understand the difference between these user types, learn how to create common and local users, grant privileges commonly and locally, and differentiate...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Managing Users and User Security (Part 2 of 2)
In this practice video, we will continue our hands-on practice with managing users and user security. You will check the user account tablespace quota and manage user password settings using user profiles. This clip is from the chapter...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Managing Users and User Security (Part 1 of 2)
In this practice video, we will apply the knowledge gained in managing database users and user security. You will perform common tasks involved in managing database users and roles, with a focus on implementing a simple example. This...
Curated Video
Oracle Database Administration from Zero to Hero - Managing User Profiles (Part 2 of 2)
In this video, we will continue our exploration of managing user profiles. You will learn how to enable password complexity verification functions, obtain information about user passwords and profiles, implement gradual password rollover...
Curated Video
Oracle Database Administration from Zero to Hero - Managing User Profiles (Part 1 of 2)
In this video, we will focus on managing user profiles. You will learn about the benefits of user profiles, explore password parameters and the password change lifecycle, understand resource limit parameters in user profiles, and learn...
Curated Video
Oracle Database Administration from Zero to Hero - Managing Roles (Part 2 of 2)
In this video, we will continue our discussion on managing roles. You will learn how to use password-protected roles, understand the usage of the PUBLIC role, drop roles, obtain information about granted privileges and roles, and follow...
Curated Video
Oracle Database Administration from Zero to Hero - Managing Roles (Part 1 of 2)
In this video, we will explore the usage of roles in managing database users. You will understand the purpose of using roles, list predefined roles, and learn how to create and use roles. This clip is from the chapter "Managing Database...
Curated Video
Oracle Database Administration from Zero to Hero - Managing User Privileges (Part 2 of 2)
In this video, we will continue our discussion on managing user privileges. You will learn how to manage object privileges and understand the cascading effects in system and object privileges. This clip is from the chapter "Managing...
Curated Video
Oracle Database Administration from Zero to Hero - Managing User Privileges (Part 1 of 2)
In this video, we will delve into managing user privileges. You will understand the difference between system and user privileges and learn how to manage system privileges. This clip is from the chapter "Managing Database Users and...
Curated Video
Oracle Database Administration from Zero to Hero - Managing Database Users (Part 2 of 2)
In this video, we will continue our exploration of managing database users. You will learn how to create a database user with database authentication, convert a user to a schema-only account, manage tablespace quotas for users, and...
Curated Video
Oracle Database Administration from Zero to Hero - Managing Database Users (Part 1 of 2)
In this video, you will learn about managing database users. You will understand the concepts of database users and schemas and explore predefined accounts in Oracle. This clip is from the chapter "Managing Database Users and Security"...
Curated Video
Oracle Database Administration from Zero to Hero - Introducing the Section-8
In this video, we will provide an overview of the topics covered in this section. You will get a sneak peek into the learning objectives related to managing database users and security. This clip is from the chapter "Managing Database...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Using Table Compression
In this practice video, we will deepen our understanding of table compression by examining scenarios where basic compression and advanced compression techniques are effective. You will gain practical experience in applying compression to...
Curated Video
Oracle Database Administration from Zero to Hero - Using Table Compression (Part 2 of 2)
In this video, we will continue our discussion on table compression. You will learn about advanced compression techniques, obtain information about compression used in a database, and understand the Oracle Hybrid Columnar Compression...
Curated Video
Oracle Database Administration from Zero to Hero - Using Table Compression (Part 1 of 2)
In this video, we will explore the usage of table compression techniques. You will learn about basic compression and how to describe and apply it to optimize storage space. This clip is from the chapter "Managing Database Segments" of...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Using Deferred Segment Creation
In this practice video, we will gain hands-on experience with deferred segment creation in an Oracle database. You will examine the behavior of deferred segment creation and understand its impact on segment management. This clip is from...
Curated Video
Oracle Database Administration from Zero to Hero - Using Deferred Segment Creation
In this video, we will delve into the concept of deferred segment creation. You will understand how to leverage deferred segment creation to optimize space utilization and materialize database segments efficiently. This clip is from the...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Shrinking Segments
In this practice video, you will learn by doing. You will create a testing table, intentionally make it fragmented, and then practice shrinking the segments to reclaim unused space. This clip is from the chapter "Managing Database...
Curated Video
Oracle Database Administration from Zero to Hero - Shrinking Segments (Part 2 of 2)
In this video, we will continue our exploration of shrinking segments. You will learn how to shrink database segments, deallocate unused space, and move a table from its current location to improve segment utilization. This clip is from...
Curated Video
Oracle Database Administration from Zero to Hero - Shrinking Segments (Part 1 of 2)
In this video, you will learn about shrinking segments. You will understand the ROWID pseudocolumn and segment defragmentation, which are essential for optimizing storage space utilization. This clip is from the chapter "Managing...
Curated Video
Oracle Database Administration from Zero to Hero - Introducing the Section-7
In this video, we will provide an overview of the topics covered in this section. You will get a sneak peek into the learning objectives related to managing database segments. This clip is from the chapter "Managing Database Segments" of...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Managing Undo Data
In this practice video, you will gain hands-on experience performing common tasks involved in managing undo data within an Oracle database. You will examine and analyze undo statistics, activate the Undo Advisor, and calculate the...