Becoming a Data Scientist

How to Use the Aggregate Function in R

How to Filter Data Frames in R

Subsetting Data Frames + Adding and Removing Columns in R

Basic Data Frame Exploration Functions in R

How to Import CSV Files as Data Frames into R

How to Subset (Navigate) and Add to Lists in R

How to Create and Name Lists in R

How to Create Custom Functions in R

Matrix Subsets in R

matplot Function in R

Arithmetic Operations of Matrices in R (+, -, *, /)

How to Create and Name Matrices in R

Beginner Git and GitHub #5 - Undo Changes (checkout, revert, reset)

Beginner Git and GitHub #4 - Commit Files to Local Repository

Beginner Git and GitHub #9 - .gitignore files

How to Load a Sample PostgreSQL Database in pgAdmin 4 (Pagila and Northwind)

3 Ways to Write and Execute Python Code on Your Computer

Beginner Git and GitHub #1 - What is Git and how does it work?

Beginner Git and GitHub #8 - Create and Push to a Remote Repository on GitHub

Combine SQL Queries With UNION, INTERSECT, EXCEPT

The ORDER BY and LIMIT Clauses in SQL to Help With Sorting

Advanced Aggregate Functions in SQL (GROUP BY, HAVING vs. WHERE)

SQL String Functions Tutorial (LEFT, RIGHT, POSITION, CONCAT, LOWER, REPLACE)

5 Basic SELECT Statement Queries in SQL

Beginner Git and GitHub #2 - Make a Local Repository

How to do Subqueries in SQL with Examples

How to Install R and R Studio on Windows 10

Beginner Python #7 - Create Custom Functions

Beginner Python #6.3 - Loops - break and continue

How to Filter with the WHERE clause in SQL

Beginner Python #3.1 - String Basics - Format Function

Pandas Dataframes #4 - Data Aggregation and Column Manipulation

Pandas Dataframes #3 - Viewing, Sorting, and Filtering Data

Basic Aggregate Functions in SQL (COUNT, SUM, AVG, MAX, and MIN)

Tutorial - While Loops in R

Tutorial - For Loops in R

How to Install Git Bash on Windows 10

Using the TO_CHAR function in SQL Change Timestamp Output

SQL WITH Statements (Common Table Expressions - CTE)

Beginner Python #4.2 - Data Structures - Tuples

Beginner Python - The Zip Function

Beginner Git and GitHub #3 - Staging Your Files

How to Install PostgreSQL 12 and pgAdmin 4 on Windows 10

How to Install Packages in R Studio and Handling Installation Errors

Pandas Dataframes #2 - Create A Dataframe

Conditional Statements in R (If, Else If, and Else)

Beginner Python #5 - Conditional Statements (if, elif, and else)

Beginner Git and GitHub #6 - Branches

How to ROUND in SQL (includes up CEILING and down FLOOR)

Beginner Python #4.5 - Data Structures - Compound or Nested Structures

Writing CASE WHEN Statements in SQL (IF/THEN)

Beginner Python #6.1 - Loops - for

Beginner Python #3.2 - String Basics - The Split Method

How to Create and Use Vectors in R

How to install Python with Anaconda on Windows 10

Pandas Dataframes #1 - Intro - Excel vs. Pandas