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...
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 - 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 - 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
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 - 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 - 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
Oracle Database Administration from Zero to Hero - Practice - Querying Data Dictionary
In this Practice video, you will learn how to retrieve specific information about an Oracle database by querying dynamic performance views and data dictionary views. You will gain hands-on experience in extracting meaningful insights...
Curated Video
Oracle Database Administration from Zero to Hero - Introducing Database Tablespaces and Data Files
In this video, you will learn about database tablespaces and data files, including their structure, types, and usage in Oracle database architecture. This clip is from the chapter "Database Architecture" of the series "Oracle Database...
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 - Other Excel VBA Variable Types
This video explains the other Excel VBA variable types such as As long, As Single, As Double, and As Currency. The difference between all these data types is how many digits they can hold. This clip is from the chapter "Mastering...
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) - 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
Oracle Database Administration from Zero to Hero - Querying Container Data Objects
In this video, we will focus on querying container data objects. You will learn how to query container data objects, set CONTAINER_DATA attributes for a common user, obtain information about CONTAINER_DATA attributes in a multitenant...
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
Oracle Database Administration from Zero to Hero - Using Deferred Segment Creation
In this video, we will delve into the concept of deferred segment creation. You will understand how to leverage deferred segment creation to optimize space utilization and materialize database segments efficiently. This clip is from the...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Shrinking Segments
In this practice video, you will learn by doing. You will create a testing table, intentionally make it fragmented, and then practice shrinking the segments to reclaim unused space. This clip is from the chapter "Managing Database...
Curated Video
Oracle Database Administration from Zero to Hero - Shrinking Segments (Part 2 of 2)
In this video, we will continue our exploration of shrinking segments. You will learn how to shrink database segments, deallocate unused space, and move a table from its current location to improve segment utilization. This clip is from...
Curated Video
Oracle Database Administration from Zero to Hero - Shrinking Segments (Part 1 of 2)
In this video, you will learn about shrinking segments. You will understand the ROWID pseudocolumn and segment defragmentation, which are essential for optimizing storage space utilization. This clip is from the chapter "Managing...
Curated Video
Oracle Database Administration from Zero to Hero - Managing Undo Data (Part 1 of 3)
In this video, we will dive into managing undo data within an Oracle Database. You will learn about the benefits of undo, tasks involved in undo space management, and setting undo management parameters and retention. This clip is from...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Managing Tablespaces (Part 1 of 2)
In this practice video, you will gain hands-on experience managing Oracle database storage structures, specifically tablespaces. You will examine segments, extents, and data blocks and practice managing tablespaces. This clip is from the...
Curated Video
Oracle Database Administration from Zero to Hero - Database Storage Structures
In this video, we will focus on database storage structures. You will learn how to describe different database storage structures and specify the database standard block size. This clip is from the chapter "Managing Oracle Database...
Curated Video
Alteryx Advanced - Cleaning
In this video, you will learn about a necessary step, “cleaningâ€, where data is transformed to get meaningful results. You will learn about uncleansed fields and the causes of null data. We will explore the imputation tool, which...
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.