Curated Video
Oracle Database Administration from Zero to Hero - Oracle Database Multitenant Architecture (Part 2 of 2)
In this video, we will dive deeper into the Oracle Database Multitenant architecture. You will learn how to utilize Data Dictionary Views and V$ Views in CDBs, understand the common files in CDBs, differentiate between local users and...
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 - 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 - Practice - Installing Oracle Database Software in Windows
In this Practice video, you will learn the process of installing Oracle database software on the Windows platform, specifically focusing on the winsrv environment. This clip is from the chapter "Installing and Creating Oracle Databases"...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Installing Oracle Database Software in Linux
In this Practice video, you will learn how to install Oracle database 19c software into the srv1 Linux platform. You will create a response file and then use it to install the software. This clip is from the chapter "Installing and...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Preparing Course Practice Environment (Part 2 of 2)
In this video, we will continue our practice of setting up the course environment by demonstrating how to create a Windows-based virtual machine. If you already have a Windows-based VirtualBox appliance that you can use for this course,...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Preparing Course Practice Environment (Part 1 of 2)
In this video, you will learn how to install the required software on your hosting PC, create an Oracle Linux 7 64-bit virtual machine, configure its network settings, and clone the seed virtual machine. Additionally, we will demonstrate...
Curated Video
Power BI Tips and Tricks (Includes Time-Saving ChatGPT Prompts) - Dealing with File Location Changes in Power BI
This lecture addresses another common issue Power BI users face: file location changes. The video explains how to manage file location changes in Power BI and maintain data connections to ensure that reports continue functioning as...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Upgrading Oracle Grid Infrastructure
In this practice video, you will focus on upgrading the Oracle Grid Infrastructure configured on the server named srv1-asm from version 19c to version 21c. By following the provided instructions, you will gain practical experience in...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Upgrading Oracle Database
In this practice video, you will perform a practical exercise in upgrading an Oracle CDB database from version 19c to version 21c on the server named srv1. By following the step-by-step instructions, you will gain hands-on experience in...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Applying RU Patches on Oracle Restart
In this practice video, you will learn how to apply a Release Update (RU) patch on an Oracle database that utilizes Automatic Storage Management (ASM). By following the step-by-step instructions, you will gain hands-on experience in...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Creating Oracle Database with ASM (Part 4 of 4)
In this practice video, you will focus on practical tasks related to Oracle Restart and ASM. You will check the Oracle Restart components and their functionality, retrieve information about ASM, get started with asmcmd for ASM management...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Creating Oracle Database with ASM (Part 3 of 4)
In this practice video, you will progress further in creating an Oracle database with ASM. You will create an ASM Disk Group, install Oracle database software, and create an ASM-based database. These exercises will provide you with...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Creating Oracle Database with ASM (Part 2 of 4)
In this practice video, you will continue working on creating an Oracle database with ASM. You will set up the required environment variables for the OS accounts, install the necessary ASM packages, create ASM disk volumes, and adjust...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Creating Oracle Database with ASM (Part 1 of 4)
In this practice video, you will gain hands-on experience in creating an Oracle database with ASM. You will perform tasks such as downloading Oracle Grid Infrastructure 19c software, setting up an Oracle VirtualBox appliance, and...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Using ADR Command Interpreter
In this practice video, you will apply your knowledge by executing common tasks involved in using the ADR command interpreter. Through hands-on exercises, you will gain practical experience in utilizing the ADR infrastructure to diagnose...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Automating Tasks with the Scheduler
In this practice video, you will gain hands-on experience by implementing common tasks involved in using the Scheduler in Oracle databases. Through practical exercises, you will apply your knowledge to set up and manage scheduled jobs,...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Using External Tables
In this practice video, you will apply your knowledge by creating external tables using the ORACLE_LOADER and ORACLE_DATAPUMP access drivers. Through hands-on exercises, you will gain practical experience in utilizing External Tables to...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Using SQL Loader
In this practice video, you will gain hands-on experience by implementing multiple data load scenarios using SQL Loader. Through practical exercises, you will learn how to efficiently load data files into your Oracle database using SQL...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Performing Flashback Database
In this practice video, you will gain hands-on experience by performing routine tasks involved in managing Flashback Database. Through practical exercises, you will strengthen your skills in utilizing Flashback Database for data recovery...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Using Data Recovery Advisor
In this practice video, you will gain hands-on experience in using the Data Recovery Advisor. You will learn how to utilize the advisor to detect and repair the loss of data files, ensuring the integrity and recoverability of your...