Curated Video
CompTIA A+ Certification Core 1 (220-1101) - Optical Media
Shiny optical discs are an excellent media for transporting data and are still a very common tool for delivering drivers and configuration utilities for hardware. There's several different optical standards and it's critical to know that...
Curated Video
PowerShell for Automating Administration - Report Consolidation – Script Overview
This video explains the report consolidation script. Here, you will be looking at implementing the script using PowerShell. This clip is from the chapter "Report Consolidation and Code Enhancement" of the series "PowerShell for...
Curated Video
PowerShell for Automating Administration - Validation Functions Discussion – Part 1
This is the first of the two-part video that focuses on the validation functions. Here, you will be studying these functions: Validate-SysInfo, Validate-URL, Validate-TopMemoryConsumingProcesses, Validate-DisktHealth, and...
Curated Video
Python Bootcamp in a Day - Python Programming for Beginners - Using Our Modules
This video explains how to use modules in Python. This clip is from the chapter "Breaking Up Larger Programs, Part 2" of the series "Python Bootcamp in a Day - Python Programming for Beginners".This section explains part 2 of breaking up...
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 - Virtual Tables (Views)
In this lesson, we will look at creating virtual tables to look at tables in a different way than their existing database structures. This clip is from the chapter "SQL – Simplify Queries (Views, CTEs)" of the series "Master SQL for Data...
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 - 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 – Multiple Rows
The second type of subquery used to filter data based on conditional logic is the subquery that may return multiple rows of data. This clip is from the chapter "SQL – Subqueries" of the series "Master SQL for Data Analysis".This section...
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 - What Is Subquery?
This video explains in detail what a subquery is all about, the types of subqueries, and how to create a subquery to extract more value from data. This clip is from the chapter "SQL – Subqueries" of the series "Master SQL for Data...
Curated Video
Master SQL for Data Analysis - Overview-4
In this video, we will talk about a powerful tool, the subquery, which extracts much more value and valuable insights by combining multiple tables and querying with subqueries. This clip is from the chapter "SQL – Subqueries" of the...
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 - Union, Intersect, Except
In this video, you will learn more about the UNION, INTERSECT, JOIN, and EXCEPT operators while combining datasets and tables. 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 - Loading the eCommerce Datasets
In this video, we will look at the different store datasets of eCommerce that we will use in the eCommerce training project. This clip is from the chapter "Getting Started with Level 2" of the series "Master SQL for Data Analysis".This...
Curated Video
Master SQL for Data Analysis - Loading the Books Datasets
This video discusses the PostgreSQL database management system and loading the required datasets for training purposes. This clip is from the chapter "Getting Started with Level 2" of the series "Master SQL for Data Analysis".This video...
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 - Database Dictionary
We will explore the data-storing area called the dictionary, which stores constraints, filters, functions, lists, and so on. 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 - 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 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...