Let's learn to query data using the SELECT option that determines the columns to include in the result set.
<
br/>
This clip is from the chapter "SQL - Retrieving Data with Queries" of the series "Master SQL for Data Analysis".This...

In this lesson, we will look at inserting data into tables and learn to use commands to insert single and multiple rows of data.
<
br/>
This clip is from the chapter "SQL - Creating Databases, Schemas, and Tables" of the series...

Here, we will understand predefined datatypes and how to convert one data type to another.
<
br/>
This clip is from the chapter "SQL - Retrieving Data with Queries" of the series "Master SQL for Data Analysis".This section focuses...

This video outlines creating entire databases and building schemas and tables in detail.
<
br/>
This clip is from the chapter "SQL - Creating Databases, Schemas, and Tables" of the series "Master SQL for Data Analysis".This section...

In this lesson, we will explore partitions, a popular strategy to handle growing amounts of data, and break tables into smaller parts called partitions.
<
br/>
This clip is from the chapter "Databases - Terminology" of the series...

Let's learn more about indexes, which will help optimize queries. You will learn how to create an index and structure data using indexes.
<
br/>
This clip is from the chapter "Databases - Terminology" of the series "Master SQL for...

In this video, the author discusses the key terms used when talking about SQL and relational databases.
<
br/>
This clip is from the chapter "Databases - Terminology" of the series "Master SQL for Data Analysis".This section focuses...

This video looks at the learning objectives from this course and the general training roadmap.
<
br/>
This clip is from the chapter "Getting Started!" of the series "Master SQL for Data Analysis".This section focuses on a general...

In this lecture, you will learn to develop our model and create a query tower to perform retrieval tasks.
<
br/>
This clip is from the chapter "Project Amazon Product Recommendation System" of the series "Recommender Systems: An...

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...

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.
<
br/>
This clip is from the chapter "Installing and Creating Oracle Databases"...

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,...

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...

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...

In this video, we will explore the configuration of Block Change Tracking (BCT) for incremental backups. You will understand how BCT improves the efficiency of backup operations.
<
br/>
This clip is from the chapter "Taking Backups...

In this practice video, you will gain hands-on experience with taking database and tablespace backups online using RMAN.
<
br/>
This clip is from the chapter "Taking Backups in Oracle Databases" of the series "Oracle Database...

In this video, we will focus on the management of redo log groups and members. You will learn how to effectively manage these components to ensure reliable data recovery.
<
br/>
This clip is from the chapter "Managing Fast Recovery...

In this practice video, you will have hands-on experience examining the Fast Recovery Area (FRA) configured in the srv1 database. You will gain practical insights into the FRA management techniques discussed in the previous video.
<
br/>...

In this practice video, we will reinforce our understanding of using database links. You will create and use a database link to the SOE schema in PDB1.
<
br/>
This clip is from the chapter "Managing Database Connectivity" of the...

In this practice video, we will continue our hands-on practice with managing local and common users. You will grant privileges as common or local and enable common users to view information about specific PDBs.
<
br/>
This clip is...

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...

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.
<
br/>...

In this video, we will continue exploring the management of undo data. You will learn how to tune undo data and leverage the undo advisor for performance optimization.
<
br/>
This clip is from the chapter "Managing Oracle Database...

In this video, we will continue our discussion on managing resumable space allocation. You will learn about operations that can be made resumable, setting the resumable space allocation timeout interval, using triggers to control...