Curated Video
Oracle Database Administration from Zero to Hero - Using External Tables
In this video, we will introduce External Tables, a powerful feature for accessing data in external files as if they were database tables. You will learn how to describe External Tables, use them with the ORACLE_LOADER driver for data...
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 - Using SQL Loader (Part 4 of 4)
In this video, we will delve into more advanced topics of SQL Loader. You will learn how to specify the field list contents, utilize the POSITION keyword for precise data loading, understand the differences between SQL Loader loading...
Curated Video
Oracle Database Administration from Zero to Hero - Using SQL Loader (Part 3 of 4)
In this video, we will further enhance your knowledge of SQL Loader by exploring additional control file configuration options. You will also learn how to use multiple INTO TABLE clauses to load data into multiple tables simultaneously....
Curated Video
Oracle Database Administration from Zero to Hero - Using SQL Loader (Part 2 of 4)
In this video, we will continue exploring SQL Loader. You will learn how to create SQL Loader control files and configure them for different loading scenarios. Understanding these techniques will enable you to effectively load data into...
Curated Video
Oracle Database Administration from Zero to Hero - Using SQL Loader (Part 1 of 4)
In this video, we will introduce SQL Loader, a versatile utility for loading data into Oracle databases. You will learn about the target, components, and features of SQL Loader. Additionally, we will cover how to start SQL Loader and use...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Using Oracle Data Pump
In this practice video, you will apply your knowledge by implementing common tasks involved in using Oracle Data Pump utilities. Through hands-on exercises, you will gain practical experience in effectively utilizing Data Pump for data...
Curated Video
Oracle Database Administration from Zero to Hero - Using Oracle Data Pump (Part 3 of 3)
In this video, we will continue our exploration of Oracle Data Pump. You will discover the essential parameters for importing data using Data Pump and learn how to implement parallelism to enhance the performance of your Data Pump...
Curated Video
Oracle Database Administration from Zero to Hero - Using Oracle Data Pump (Part 2 of 3)
In this video, you will delve deeper into the practical usage of Oracle Data Pump. You will learn how to invoke Data Pump utilities from the command-line, understand Data Pump modes, and explore the basic parameters for exporting data....
Curated Video
Oracle Database Administration from Zero to Hero - Using Oracle Data Pump (Part 1 of 3)
In this video, you will discover Oracle Data Pump, a powerful data movement utility. We will discuss the various data movement methods offered by Data Pump and how to use directory objects to enhance your data pump operations. This clip...
Curated Video
Oracle Database Administration from Zero to Hero - Introducing the Section-16
In this video, we will provide an introduction to the “Using Oracle Database Utilities†section. You will get a glimpse of the learning objectives and topics covered in this section, setting the foundation for what you will explore in...
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 - Flashback Database
In this video, we will dive into the details of Flashback Database. You will learn how to describe and configure Flashback Database, enabling you to perform point-in-time recoveries. Additionally, you will discover how to execute...
Curated Video
Oracle Database Administration from Zero to Hero - Introducing the Section-15
In this video, we will provide an overview of the Flashback Database section. You will get a sneak peek into the learning objectives and topics covered in this section, giving you an overview of what to expect. This clip is from the...
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...
Curated Video
Oracle Database Administration from Zero to Hero - Using Data Recovery Advisor (Part 2 of 2)
In this video, we will dive deeper into the practical usage of the Data Recovery Advisor. You will learn how to utilize the Data Recovery Advisor to list data failures, check for corruption in datafiles, obtain recommendations for...
Curated Video
Oracle Database Administration from Zero to Hero - Using Data Recovery Advisor (Part 1 of 2)
In this video, we will introduce the Data Recovery Advisor and its role in the backup and recovery lifecycle. You will learn about the various stages of the Data Recovery Advisor and its significance in detecting and resolving data...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Using RMAN Recovery Catalog
In this practice video, you will apply your knowledge by performing general tasks involved in using the RMAN recovery catalog. Through practical exercises, you will gain hands-on experience in utilizing the recovery catalog effectively....
Curated Video
Oracle Database Administration from Zero to Hero - Using RMAN Recovery Catalog (Part 3 of 3)
In this video, we will focus on creating and managing stored scripts within the RMAN Recovery Catalog. You will discover how to leverage stored scripts to streamline and automate common RMAN tasks, enhancing the efficiency of your backup...
Curated Video
Oracle Database Administration from Zero to Hero - Using RMAN Recovery Catalog (Part 2 of 3)
In this video, we will continue our exploration of the RMAN Recovery Catalog. You will learn how to manually resynchronize recovery catalogs and catalog files into the RMAN repository. These techniques will help ensure the integrity and...
Curated Video
Oracle Database Administration from Zero to Hero - Using RMAN Recovery Catalog (Part 1 of 3)
In this video, we will explore the usage of the RMAN Recovery Catalog. You will learn about the differences between using the control file and Recovery Catalog as the RMAN repository. Additionally, you will discover how to create and...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Duplicating Databases and PDBs Using RMAN
In this practice video, you will apply your knowledge by performing multiple techniques to duplicate the database “oradb†in srv1 to another database on the same host. You will gain hands-on experience with duplicating databases and...
Curated Video
Oracle Database Administration from Zero to Hero - Duplicating a Database Using RMAN - Part II (2 of 2)
In this video, we will continue exploring database duplication using RMAN. You will learn about backup-based duplication with a connection to a recovery catalog, backup-based duplication without a connection to a target or recovery...
Curated Video
Oracle Database Administration from Zero to Hero - Duplicating a Database Using RMAN - Part II (1 of 2)
In this video, we will delve deeper into database duplication using RMAN. You will learn how to perform active database duplication and backup-based database duplication with a connection to a target database. This clip is from the...