Curated Video
Recommender Systems with Machine Learning - tf-idf (Term Frequency-Inverse Document Frequency) Implementation
This video demonstrates the implementation of tf-idf (Term Frequency-Inverse Document Frequency). This clip is from the chapter "Project 1: Song Recommendation System Using Content-Based Filtering" of the series "Recommender Systems with...
Curated Video
Recommender Systems with Machine Learning - Collaborative Filtering Using KNN
This video helps you with collaborative filtering using KNN. 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 Preparation for Content-Based Filtering
This video explains data preparation 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 - Offline Evaluation Techniques
This video talks about offline evaluation techniques of recommender systems. This clip is from the chapter "Basic of Recommender Systems" of the series "Recommender Systems with Machine Learning".This section focuses on the basics of...
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 - Let's Recap
In this final video, the author succinctly recapitulates the course content with explanations of key terminologies and topics covered thus far. This clip is from the chapter "Course Summary – Level 2" of the series "Master SQL for Data...
Curated Video
Master SQL for Data Analysis - Ranking
After learning how to divide the table into partitions, order rows inside a partition based on logic, and then add a sequential number to each row; you will learn to rank rows that share two or more same values. This clip is from the...
Curated Video
Master SQL for Data Analysis - Sequential Numbers
Let's look at another typical use case of a window function: to create a sequential integer number inside a group of rows while deciding how this group will be ordered. This clip is from the chapter "SQL - Window Functions" of the series...
Curated Video
Master SQL for Data Analysis - Creating a Window Function
This is an illustrative video on creating a simple window function using the OVER and PARTITION BY functions. This clip is from the chapter "SQL - Window Functions" of the series "Master SQL for Data Analysis".This section focuses on one...
Curated Video
Master SQL for Data Analysis - Searched CASE – Classification and Binning
Here, we will explore the second type of case statement, the searched case expression, which is more flexible than the previous simple case structure. This clip is from the chapter "SQL - Conditional Logic (CASE)" of the series "Master...
Curated Video
Master SQL for Data Analysis - As Inline Views (FROM)
After learning how to use a subquery to filter rows, we will now look at using forms in the form section, such as regular tables, which are useful in simplifying complex queries. This clip is from the chapter "SQL – Subqueries" of the...
Curated Video
Master SQL for Data Analysis - Conditional Logic – Single Row
Here, we will look at the first type of subquery used to filter data with conditional logic, the results of which can be a single row or multiple rows of subqueries, depending on how we build it. This clip is from the chapter "SQL –...
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 - 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 - 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 - Filtering Conditions (WHERE) – Part 2
Here, you will learn to combine and filter data based on multiple conditions in the same query using operators. 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 - 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 - Update and Delete
Here, you will learn to update a table's fields and delete erroneous or redundant information. 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 - 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 - 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 - 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...