Curated Video
Oracle Database Administration from Zero to Hero - Practice - Creating PDBs
In this practice video, you will gain hands-on experience creating PDB databases from the seed using two different methods. You will create PDBs using SQL*Plus and the DBCA, allowing you to practice multiple approaches to PDB creation....
Curated Video
Oracle Database Administration from Zero to Hero - Creating PDBs (Part 1 of 2)
In this video, we will cover the process of creating Pluggable Databases (PDBs). You will understand the prerequisites for PDB creation and explore methods such as using DBCA and SQL Developer to create PDBs. This clip is from the...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Creating a CDB Database
In this practice video, you will gain hands-on experience by dropping the database in srv1 and creating a Container Database (CDB) in its place. You will learn the practical steps involved in setting up a CDB environment. This clip is...
Curated Video
Oracle Database Administration from Zero to Hero - Oracle Database Multitenant Architecture (part 1 of 2)
In this video, we will explore the Oracle Database Multitenant architecture. You will learn about the differences between the Container Database (CDB) and Pluggable Databases (PDB), as well as gain an understanding of the components...
Curated Video
Oracle Database Administration from Zero to Hero - Introducing the Section-5
In this video, we will take a sneak peek into the learning objectives of this section. We will provide an overview of the topics covered and highlight the key concepts related to Oracle Database Multitenancy. This clip is from the...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Querying Data Dictionary
In this Practice video, you will learn how to retrieve specific information about an Oracle database by querying dynamic performance views and data dictionary views. You will gain hands-on experience in extracting meaningful insights...
Curated Video
Oracle Database Administration from Zero to Hero - Introducing Data Dictionary
In this video, we will introduce the concept of the data dictionary in Oracle Database. You will learn about dynamic performance views and data dictionary views, and how to query them to retrieve valuable information about the database....
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Managing Initialization Parameters, SPFILE, and PFILE
In this Practice video, you will perform hands-on tasks related to managing Oracle database initialization parameters, SPFILE, and PFILE. You will gain practical experience in configuring and manipulating these components effectively....
Curated Video
Oracle Database Administration from Zero to Hero - Database Initialization Parameters (Part 2 of 2)
In this video, we will dive deeper into database initialization parameters. We will explore the attributes associated with these parameters and cover topics such as creating PFILE (parameter file) and SPFILE (server parameter file). This...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Starting Up and Shutting Down DB Instances
In this Practice video, you will gain hands-on experience with starting up and shutting down Oracle database instances. We will explore different startup and shutdown modes commonly used in Oracle databases. This clip is from the chapter...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Using SQL Developer
In this practice video, we will download and install SQL Developer, a graphical tool provided by Oracle, which enhances the database administration and development experience on the hosting PC. This clip is from the chapter "Installing...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Creating Oracle Databases (Part 2 of 2)
In this Practice video, we will create an Oracle database in the Windows platform (winsrv) by applying the concepts and techniques learned earlier. This clip is from the chapter "Installing and Creating Oracle Databases" of the series...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Creating Oracle Databases (Part 1 of 2)
In this Practice video, we will create an Oracle database in the Linux platform (srv1) using the knowledge and skills acquired in the previous videos. This clip is from the chapter "Installing and Creating Oracle Databases" of the series...
Curated Video
Oracle Database Administration from Zero to Hero - Creating an Oracle Database (Part 3 of 3)
In this video, we will continue the process of creating an Oracle database by exploring topics such as responding to the DBCA window, working with sample schemas, dropping Oracle databases, and following guidelines for creating Oracle...
Curated Video
Oracle Database Administration from Zero to Hero - Creating an Oracle Database (Part 1 of 3)
In this video, you will learn how to create an Oracle database using the 19c software. We will cover the necessary steps for preparing the software installation and perform the installation itself. This clip is from the chapter...
Curated Video
Oracle Database Administration from Zero to Hero - Oracle DB Software Installation (Part 2 of 2)
In this video, we will perform the actual database software installation on both Linux and Windows platforms. We will also discuss the Oracle Inventory Directory and its significance. This clip is from the chapter "Installing and...
Curated Video
Oracle Database Administration from Zero to Hero - Oracle DB Software Installation (Part 1 of 2)
In this video, you will learn how to prepare the systems for Oracle database software installation, including the necessary prerequisites and considerations. This clip is from the chapter "Installing and Creating Oracle Databases" of the...
Curated Video
Oracle Database Administration from Zero to Hero - Introducing Database Tablespaces and Data Files
In this video, you will learn about database tablespaces and data files, including their structure, types, and usage in Oracle database architecture. This clip is from the chapter "Database Architecture" of the series "Oracle Database...
Curated Video
Oracle Database Administration from Zero to Hero - Introducing Oracle Database Architecture (Part 2 of 2)
In this video, you will learn about the major Oracle database files, including their purpose, types, and locations. This clip is from the chapter "Database Architecture" of the series "Oracle Database Administration from Zero to Hero".In...
Curated Video
Oracle Database Administration from Zero to Hero - Introducing Oracle Database Architecture (Part 1 of 2)
In this video, you will learn about the major components of the database instance in Oracle database architecture, including their functions and how they work together. This clip is from the chapter "Database Architecture" of the series...
Curated Video
Oracle Database Administration from Zero to Hero - About Oracle Database Administrator (DBA)
In this video, we will understand the role of an Oracle Database Administrator (DBA), the DBA duties and responsibilities, the different DBA role types, the learning path for becoming a DBA, and the demand for DBAs in the job market....
Curated Video
Oracle Database Administration from Zero to Hero - Overview on Oracle Database Technologies
In this video, we will describe the different Oracle database technologies, options, and management packs. This clip is from the chapter "Introduction to RDBMS" of the series "Oracle Database Administration from Zero to Hero".In this...
Curated Video
Oracle Database Administration from Zero to Hero - Overview on Oracle Database (Part 2 of 2)
In this video, you will learn about the different Oracle database editions and license options available. This clip is from the chapter "Introduction to RDBMS" of the series "Oracle Database Administration from Zero to Hero".In this...
Curated Video
Oracle Database Administration from Zero to Hero - Overview on Oracle Database (Part 1 of 2)
In this video, we will explore the different Oracle database releases, the difference between Long Term Support Releases and Innovation Releases, and the Oracle Database Cloud Services. This clip is from the chapter "Introduction to...