Curated Video
Master SQL for Data Analysis - Tables, Columns, Rows
In this lesson, we will explore tables in a database, and the two-dimensional rows and columns of a table. 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 - Our Learning Objectives-1
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...
Curated Video
Recommender Systems: An Applied Approach using Deep Learning - Make Tensors from DataFrame
In this video, we will continue to check our dataset using a single username. We will use a part of the DataFrame to do so. This clip is from the chapter "Project Amazon Product Recommendation System" of the series "Recommender Systems:...
Curated Video
Data Science Prerequisites - Numpy, Matplotlib, and Pandas in Python - Regression in Code
In this video, we will practice all that we have learnt in the previous video about regression. This clip is from the chapter "Machine Learning Basics" of the series "Data Science Prerequisites - NumPy, Matplotlib, and Pandas in...
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 - Pandas Exercise
In this video, we will have a look at the Pandas exercise that needs to be resolved on our own. This clip is from the chapter "Pandas" of the series "Data Science Prerequisites - NumPy, Matplotlib, and Pandas in Python".In this section,...
Curated Video
Data Science Prerequisites - Numpy, Matplotlib, and Pandas in Python - Loading in Data
In this video, you will learn how to load in data using Pandas. 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 about Pandas.
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Multidimensional Arrays
This video explains multidimensional arrays, which are made by adding a comma after the first number between round brackets of your array name, then adding another number. This clip is from the chapter "Arrays" of the series "The...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Resize Property
This video explains the resize property that is available in VBA to change or resize the range of cells from the active cell as needed. This clip is from the chapter "Introduction" of the series "The Ultimate Excel VBA Course - Learn and...
Curated Video
Power BI Tips and Tricks (Includes Time-Saving ChatGPT Prompts) - Efficiently Extract Data from Multiple Folders in Power BI
This lesson explores the challenge of extracting data from multiple folders in Power BI and provides solutions for doing so efficiently. The video offers a step-by-step guide to identifying and connecting to data from multiple folders,...
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
Power BI Tips and Tricks (Includes Time-Saving ChatGPT Prompts) - Circular Dependency Errors and How to Fix Them
This video addresses circular dependency errors in Power BI, occurring with interdependent table relationships. The video provides a step-by-step guide to identifying and resolving circular dependency errors to maintain the integrity of...
Curated Video
Power BI Tips and Tricks (Includes Time-Saving ChatGPT Prompts) - Power BI Trouble with Combining Excel Files with a Different Structure
This video addresses a common challenge faced by Power BI users, combining Excel files with different structures. The video provides solutions for handling this issue and offers tips on structuring data effectively to avoid problems when...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Using Table Compression
In this practice video, we will deepen our understanding of table compression by examining scenarios where basic compression and advanced compression techniques are effective. You will gain practical experience in applying compression to...
Curated Video
Oracle Database Administration from Zero to Hero - Using Table Compression (Part 1 of 2)
In this video, we will explore the usage of table compression techniques. You will learn about basic compression and how to describe and apply it to optimize storage space. This clip is from the chapter "Managing Database Segments" of...
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
Alteryx Advanced - Exercise 5
In this exercise, we will use the ex5-kchousedata.csv file to create a regression model that predicts the house price through assisted modeling. This clip is from the chapter "Exercises and Course" of the series "Alteryx Advanced".null
Curated Video
Alteryx Advanced - Exercise 3
In this exercise, we will use online retail.csv, output files according to country, and create a batch macro to simplify the creation of files. This clip is from the chapter "Exercises and Course" of the series "Alteryx Advanced".null
Curated Video
Alteryx Advanced - Exercise 1
In exercise 1, we will autofield the ex1-academicperf.csv file, then use Regex to add a tag if the nationality column is not clean and save the output to the Calgary database. We will use the Calgary input and create a new field that...
Curated Video
Design Microservices Architecture with Patterns and Principles - Cassandra NoSQL Database - Peer-to-Peer Distributed Wide Column Database
The video introduces Cassandra, a popular NoSQL database known for its ability to handle massive amounts of data across distributed clusters, the features of Cassandra, peer-to-peer architecture and wide column data model, a suitable...
Curated Video
Getting Started with Scrum - Step 7: Create a Sprint Board
You will learn to create a Sprint board for the team throughout the entire product lifetime.
Curated Video
Design Microservices Architecture with Patterns and Principles - Data Partitioning: Horizontal, Vertical, and Functional Data Partitioning
This video explores different types of data partitioning techniques; horizontal partitioning, dividing data based on rows or ranges; vertical partitioning, splitting data based on columns or attributes; and functional partitioning,...
Curated Video
Design Microservices Architecture with Patterns and Principles - NoSQL Databases Types - Document, Key-Value, Graph-Based, Column-Based Databases
This video explores different types of NoSQL databases, including document databases, key-value stores, graph databases, and columnar databases, their characteristics, data models, and typical use cases, providing insights into when to...
Curated Video
Dividing by 8 and 9
Mr. Addit reviews the multiplication and division facts of 8 and 9, and explains how to use an array to solve division problems.