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

Data Analysis in R: Predictive Analysis with Regression

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