This video discusses the PostgreSQL database management system and loading the required datasets for training purposes. This clip is from the chapter "Getting Started with Level 2" of the series "Master SQL for Data Analysis".This video...

The author briefly recapitulates the topics learned in this level during this training program, level 1. This clip is from the chapter "Course Summary – Level 1" of the series "Master SQL for Data Analysis".This section focuses on the...

We will explore the data-storing area called the dictionary, which stores constraints, filters, functions, lists, and so on. This clip is from the chapter "SQL - Retrieving Data with Queries" of the series "Master SQL for Data...

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

Let's explore how to organize data better by building tables in a database. This clip is from the chapter "SQL - Creating Databases, Schemas, and Tables" of the series "Master SQL for Data Analysis".This section delves deep into creating...

This lesson will teach us how to create a database and schema using the PostgreSQL software. This clip is from the chapter "SQL - Creating Databases, Schemas, and Tables" of the series "Master SQL for Data Analysis".This section delves...

Let's learn how to create multiple relational database instances and define the needed table for each entity type. This clip is from the chapter "Databases - Terminology" of the series "Master SQL for Data Analysis".This section focuses...

In this video, the author briefly outlines data analysis and then explains, in brief, the advanced concepts to be covered in the second half (level 2) of this course. This clip is from the chapter "Introduction to Level 2" of the series...

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

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

Here, we will explore the three main building blocks of a relational database: entity, attribute, and relationship. This clip is from the chapter "Databases - Terminology" of the series "Master SQL for Data Analysis".This section focuses...

In this video, we will look at a primary key used to identify a row in a table and a foreign key used to navigate from one table to another. This clip is from the chapter "Databases - Terminology" of the series "Master SQL for Data...

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

This video demonstrates how to install PostgreSQL, the most advanced RDBMS that we have currently. This clip is from the chapter "Getting Started!" of the series "Master SQL for Data Analysis".This section focuses on a general...

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

This clip is from the chapter "Course Introduction" of the series "Master SQL for Data Analysis".This section introduces the course content in general and outlines the need for learning sequential query language.

In this video, we will discuss the concepts covered in this module, including Amazon Web Services, the web services that Amazon provides, how we can use these services, and the benefits of AWS, apart from the salient features of AWS....

This is a lab video on Database Secrets Engine. This clip is from the chapter "Compare and Configure Secrets Engines" of the series "HashiCorp Certified - Vault Associate Course".null

In this video, we will explore the capabilities component of HashiCorp Vault policies and how to use it to control what actions users and applications can perform on Vault resources. Learn the capabilities available in Vault to create...

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

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

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

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

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