Performing Data Aggregation using SQL Aggregate Functions

Introduction to EDA in R

SQL CASE Statements

Hypothesis Testing in R

Tidy Messy Data using tidyr in R

Using DAX throughout PowerBI to create robust data scenarios

Introduction to Regular Expressions in SQL

SQL Window Functions for Analytics

Joining Data in R using dplyr

Data Manipulation with dplyr in R

Decision Tree Classifier for Beginners in R

Get Started with R Markdown

Getting Started with Version Control in RStudio

Performing Data Definition and Manipulation in SQL

SQL Date Time Functions

Mastering SQL Joins

Introduction to SQL Window Functions

Performing Confirmatory Data Analysis in R

Manipulate R data frames using SQL in RStudio

Calculating Descriptive Statistics in R

Prepare, Clean, Transform, and Load Data using Power BI

Using SQL String Functions to Clean Data

Working with SQL Stored Procedures using MySQL Workbench

Data Visualization using dplyr and ggplot2 in R

Customer Segmentation using K-Means Clustering in R

Querying Databases Using SQL SELECT statement

Working with Subqueries in SQL

SQL Mathematical Functions

Handling Missing Values in R using tidyr

Getting Started with R

Building Statistical Models in R: Linear Regression