Curated Video
Master SQL for Data Analysis - Outer-Join
In this lesson, we will look at a situation where there are tables with unmatched rows from one table to another. This clip is from the chapter "SQL - Combining Data from Multiple Tables" of the series "Master SQL for Data Analysis".This...
Curated Video
Master SQL for Data Analysis - Inner-Join
In this lecture, we will look at the most common types of joins, called the inner-join type, for various use cases. This clip is from the chapter "SQL - Combining Data from Multiple Tables" of the series "Master SQL for Data...
Curated Video
Master SQL for Data Analysis - Union, Intersect, Except
In this video, you will learn more about the UNION, INTERSECT, JOIN, and EXCEPT operators while combining datasets and tables. This clip is from the chapter "SQL - Combining Data from Multiple Tables" of the series "Master SQL for Data...
Curated Video
Master SQL for Data Analysis - Loading the eCommerce Datasets
In this video, we will look at the different store datasets of eCommerce that we will use in the eCommerce training project. This clip is from the chapter "Getting Started with Level 2" of the series "Master SQL for Data Analysis".This...
Curated Video
Master SQL for Data Analysis - Loading the Books Datasets
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...
Curated Video
Master SQL for Data Analysis - Database Dictionary
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...
Curated Video
Master SQL for Data Analysis - Distinct Values (DISTINCT)
Let's explore the way to find distinct values among multiple rows of data as part of a preliminary preparation process. This clip is from the chapter "SQL - Retrieving Data with Queries" of the series "Master SQL for Data Analysis".This...
Curated Video
Master SQL for Data Analysis - Filtering Conditions (WHERE) – Part 1
In this lesson, you will learn to use filtering conditions to filter data based on conditions. Here, we will explore the WHERE condition. This clip is from the chapter "SQL - Retrieving Data with Queries" of the series "Master SQL for...
Curated Video
Master SQL for Data Analysis - Inserting Data
In this lesson, we will look at inserting data into tables and learn to use commands to insert single and multiple rows of data. This clip is from the chapter "SQL - Creating Databases, Schemas, and Tables" of the series "Master SQL for...
Curated Video
Master SQL for Data Analysis - Creating Tables - Introduction
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...
Curated Video
Master SQL for Data Analysis - Creating - Database and Schema
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...
Curated Video
Master SQL for Data Analysis - Schema, Metadata, Data Dictionary
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...
Curated Video
Master SQL for Data Analysis - Overview-1
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...
Curated Video
Master SQL for Data Analysis - Overview - Database, DBMS, SQL
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...
Curated Video
Master SQL for Data Analysis - DB Installation
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...
Curated Video
Recommender Systems: An Applied Approach using Deep Learning - Rating Our Data
In this video, you will learn about the next part of the project, which is rating our data. This clip is from the chapter "Project Amazon Product Recommendation System" of the series "Recommender Systems: An Applied Approach Using Deep...
Curated Video
Master SQL for Data Analysis - Overview
This video briefly outlines the window functions, a powerful tool used to work on the most complex structures in SQL and data analysis in complex projects. This clip is from the chapter "SQL - Window Functions" of the series "Master SQL...
Curated Video
Data Science Prerequisites - Numpy, Matplotlib, and Pandas in Python - What Is a Feature Vector?
In this video, you will learn about a feature vector. This clip is from the chapter "Machine Learning Basics" of the series "Data Science Prerequisites - NumPy, Matplotlib, and Pandas in Python".In this section, we will cover machine...
Curated Video
Data Science Prerequisites - Numpy, Matplotlib, and Pandas in Python - Selecting Rows and Columns
In this video, you will learn how to select rows and columns from a data frame. This clip is from the chapter "Pandas" of the series "Data Science Prerequisites - NumPy, Matplotlib, and Pandas in Python".In this section, we will talk...
Curated Video
Data Science Prerequisites - Numpy, Matplotlib, and Pandas in Python - Matrices
In this video, you will learn about matrices. This clip is from the chapter "NumPy" of the series "Data Science Prerequisites - NumPy, Matplotlib, and Pandas in Python".In this section of the course, we will dive into the world of NumPy,...
Curated Video
Data Science Prerequisites - Numpy, Matplotlib, and Pandas in Python - Arrays Versus Lists
In this video, we will be comparing NumPy array to Python list. This clip is from the chapter "NumPy" of the series "Data Science Prerequisites - NumPy, Matplotlib, and Pandas in Python".In this section of the course, we will dive into...
Curated Video
Getting Started with HashiCorp Nomad - Demo - Rotating the Gossip Encryption Key
In this demonstration, we will practically work on rotating the gossip encryption key. You will learn to generate a new gossip key. You will learn to install the key, create a list of keys, instruct Nomad to use the new key, and replace...
Curated Video
HashiCorp Certified - Vault Associate Course - Working with KV Secrets Engine
In this video, you will be working with KV Secrets Engine. We will go even deeper into KV while comparing KV version 1 and KV version 2. This clip is from the chapter "Compare and Configure Secrets Engines" of the series "HashiCorp...
Curated Video
HashiCorp Certified - Vault Associate Course - Exam Tips for Objective 2
In this video, we will provide some exam tips for Objective 2 of the HashiCorp Certified Vault Associate certification exam. You will see some exam tips for Objective 2 to ensure that you are ready to tackle the questions related to this...