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 - Simple CASE - Data Transformation
In this video, we will look at the first option to create a use case, which is the simple case used to compare an input expression using the = operator. This clip is from the chapter "SQL - Conditional Logic (CASE)" of the series "Master...
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 - 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 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
The Complete Vue.js Course for Beginners - If Else Condition
In this video, we will discuss the if-else condition using a code. This clip is from the chapter "Getting Started with Basic Code" of the series "The Complete Vue.js Course for Beginners".This section gets you started with the basic code...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Logical Operators
This video explains logical operators in VBA such as AND, OR, NOT. This clip is from the chapter "VBA Conditional Statements" of the series "The Ultimate Excel VBA Course - Learn and Master VBA Fast".This section explains the various...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Do Loop
This video explains the Do Loop that allows the user to repeat a certain process in a macro. This clip is from the chapter "Loops with VBA" of the series "The Ultimate Excel VBA Course - Learn and Master VBA Fast".This section explains...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - For Loop
This video explains the For loop that enables you to loop through a range of cells with just a few codes lines until the condition is met, and the code moves onto the next line of code. This clip is from the chapter "Loops with VBA" of...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Select Case
This video explains select case statements, which is an alternative way to write If and Else if statements and help you have a more understandable code. This clip is from the chapter "VBA Conditional Statements" of the series "The...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Conditional Operators
This video explains the various conditional operators such as =, <, >, <=, >=, <>, and so on. This clip is from the chapter "VBA Conditional Statements" of the series "The Ultimate Excel VBA Course - Learn and Master VBA Fast".This...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Else and ElseIf
This video explains Else and ElseIf variables in Excel VBA using an example where you can add an Else part that tells VBA what happens if the opening line returns False. This clip is from the chapter "VBA Conditional Statements" of the...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - If Statements
This video explains If statements in Excel VBA using an example where if the input is less than 10, the condition will be satisfied or else it won't show an output. This clip is from the chapter "VBA Conditional Statements" of the series...
Curated Video
Power BI Tips and Tricks (Includes Time-Saving ChatGPT Prompts) - Circular Dependency Errors, Another Way to Fix It
In this video, we will discover an alternative method for resolving circular dependency errors in Power BI. The video demonstrates calculating columns to break the dependency cycle and maintain data integrity. This clip is from the...
Curated Video
JavaScript Masterclass - Zero to Job-Ready with Hands-On Projects - Firestore Queries / 259
This video explains queries and how to give a particular condition to fetch data. This clip is from the chapter "Firebase" of the series "JavaScript Masterclass - Zero to Job-Ready with Hands-On Projects".In this section, you will learn...
Curated Video
JavaScript Masterclass - Zero to Job-Ready with Hands-On Projects - Backup Data / 247
This video explains how to back up data for future use. This clip is from the chapter "Project: News Portal" of the series "JavaScript Masterclass - Zero to Job-Ready with Hands-On Projects".This section explains how to create a custom...
Curated Video
JavaScript Masterclass - Zero to Job-Ready with Hands-On Projects - Get Task / 286
This video explains the get task functionality of the project. This clip is from the chapter "Project: Kanban Application" of the series "JavaScript Masterclass - Zero to Job-Ready with Hands-On Projects".This section explains a...
Curated Video
JavaScript Masterclass - Zero to Job-Ready with Hands-On Projects - Class and Function / 285
This video explains class and function used in the project. This clip is from the chapter "Project: Kanban Application" of the series "JavaScript Masterclass - Zero to Job-Ready with Hands-On Projects".This section explains a web-based...
Curated Video
JavaScript Masterclass - Zero to Job-Ready with Hands-On Projects - Exceptions / 202
This video explains exceptions in JavaScript. This clip is from the chapter "Error Handling and Exceptions" of the series "JavaScript Masterclass - Zero to Job-Ready with Hands-On Projects".This section explains error handling and...
Curated Video
JavaScript Masterclass - Zero to Job-Ready with Hands-On Projects - Methods / 119
This video explains methods in OOP with an example. This clip is from the chapter "Object-Oriented Programming" of the series "JavaScript Masterclass - Zero to Job-Ready with Hands-On Projects".This section explains object-oriented...
Curated Video
JavaScript Masterclass - Zero to Job-Ready with Hands-On Projects - Chaining Methods / 076
This video explains changing methods in arrays. This clip is from the chapter "Array Methods" of the series "JavaScript Masterclass - Zero to Job-Ready with Hands-On Projects".This section explains methods related to arrays.