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 - Data-Type Conversions (CAST)
Here, we will understand predefined datatypes and how to convert one data type to another. This clip is from the chapter "SQL - Retrieving Data with Queries" of the series "Master SQL for Data Analysis".This section focuses on the...
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 - Alias for Tables and Columns
Let's learn how to create labels for columns generated by expressions or built-in functions to make column names more visible. 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 - Overview-1
This video outlines creating entire databases and building schemas and tables in detail. This clip is from the chapter "SQL - Creating Databases, Schemas, and Tables" of the series "Master SQL for Data Analysis".This section delves deep...
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 - Null Values
In this video, you will learn what a null value is, how it affects the functioning of a table, and how to be careful when analyzing null values. 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...
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...
Great Big Story
Arabbers, Baltimore's Horse-Drawn vendors sustain a historic tradition
Explore the enduring tradition of Arabbers, who bring fresh produce to Baltimore's neighborhoods using horse-drawn carts, supporting community access and local history.
Curated Video
Data Science Prerequisites - Numpy, Matplotlib, and Pandas in Python - What Is a Feature Vector?
In this video, you will learn about a feature vector. This clip is from the chapter "Machine Learning Basics" of the series "Data Science Prerequisites - NumPy, Matplotlib, and Pandas in Python".In this section, we will cover machine...
Curated Video
Data Science Prerequisites - Numpy, Matplotlib, and Pandas in Python - Arrays Versus Lists
In this video, we will be comparing NumPy array to Python list. This clip is from the chapter "NumPy" of the series "Data Science Prerequisites - NumPy, Matplotlib, and Pandas in Python".In this section of the course, we will dive into...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Starting Up and Shutting Down DB Instances
In this Practice video, you will gain hands-on experience with starting up and shutting down Oracle database instances. We will explore different startup and shutdown modes commonly used in Oracle databases. This clip is from the chapter...
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 Complete Vue.js Course for Beginners - Sending API Data
In this video, you will learn how to send API data using an example. This clip is from the chapter "Routing and API" of the series "The Complete Vue.js Course for Beginners".This section explains routing, dynamic routing, and API.
Curated Video
The Complete Vue.js Course for Beginners - Complete Form Validation
In this video, we will discuss form validations and how to remove an error if it occurs. This clip is from the chapter "Form and Validation" of the series "The Complete Vue.js Course for Beginners".In this section, we will look at forms...
Curated Video
Power BI Tips and Tricks (Includes Time-Saving ChatGPT Prompts) - Deep Dive into the New DAX Functions
This video will take a deep dive into the new DAX functions in Power BI. The video provides a comprehensive overview of the latest DAX functions and demonstrates how these can be used to enhance data modeling and analysis in Power BI....