Curated Video
Recommender Systems with Machine Learning - Item-Based Filtering Data Preparation
This video explains and demonstrates item-based filtering data preparation. This clip is from the chapter "Machine Learning for Recommender System" of the series "Recommender Systems with Machine Learning".This section focuses on the use...
Curated Video
Recommender Systems with Machine Learning - Item-Based Collaborative Filtering
This video demonstrates item-based collaborative filtering. This clip is from the chapter "Machine Learning for Recommender System" of the series "Recommender Systems with Machine Learning".This section focuses on the use of machine...
Curated Video
Recommender Systems with Machine Learning - Data Manipulation for Content-Based Filtering
This video explains data manipulation for content-based filtering with machine learning. This clip is from the chapter "Machine Learning for Recommender System" of the series "Recommender Systems with Machine Learning".This section...
Curated Video
Recommender Systems with Machine Learning - ICM
This video talks about the ICM (Item Content Matrix) that is used to store the data of recommender systems. This clip is from the chapter "Basic of Recommender Systems" of the series "Recommender Systems with Machine Learning".This...
Curated Video
Master SQL for Data Analysis - Virtual Tables (Views)
In this lesson, we will look at creating virtual tables to look at tables in a different way than their existing database structures. This clip is from the chapter "SQL – Simplify Queries (Views, CTEs)" of the series "Master SQL for Data...
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 - Let's Recap!
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...
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 - Grouping Rows (GROUP BY and HAVING)
Let's learn how to group rows based on values in specific columns and then apply different actions on the groups, such as applying filters using GROUP BY and HAVING. This clip is from the chapter "SQL - Retrieving Data with Queries" of...
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 - Query Data (SELECT)
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...
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 - Constraints
Here, we will look at the different constraints that can be added to update or limit data stored in a specific column in a table. 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 - 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 - Cross-Join
In this lesson, you will learn about combining datasets and tables with very little or no common factors among them. 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 - Sorting Rows (ORDER BY)
In this lesson, you will learn about the options for sorting the output result of a query in some specific order to save time and keep data better organized. This clip is from the chapter "SQL - Retrieving Data with Queries" of the...
Curated Video
Master SQL for Data Analysis - Partitions
In this lesson, we will explore partitions, a popular strategy to handle growing amounts of data, and break tables into smaller parts called partitions. This clip is from the chapter "Databases - Terminology" of the series "Master SQL...
Curated Video
Master SQL for Data Analysis - Indexes
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...
Curated Video
Master SQL for Data Analysis - Relational Model, ER Diagram
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...
Curated Video
Master SQL for Data Analysis - Primary and Foreign Keys
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...