R, SQL, Tableau Bundle

Programming in R

1. Introduction to programming in R

2. Working with Variables

3. Loops

4. Conditional Statements

5. Working with Vectors

6. Functions

7. Packages

8. Working with Matrices

9. Using Data Frames

10. Creating Visualizations

SQL (Structured Query Language) using Oracle

1. Overview of relational database concepts

2. SQL Development environment

3. Introduction to SQL

4. Writing queries for data extraction

5. Restricted and sorted data

6. Usage of single-row functions to customize output

7. Conversion functions and Conditional expressions

8. Aggregated data using Group functions

9. Display data from multiple tables

10. Sub Queries

11. Set Operators

12. DDL statements to create and manage tables

Tableau

1. Overview of Business Intelligence and star schema

2. Connecting to multiple data sources

3. Data analysis using Tableau

4. Data transformation

5. Creating visualizations such as various charts and Maps

6. Securing your application

7. Overview of Tableau server

1. Basic knowledge of computer systems

2. Basic knowledge of MS excel

After the completion of the course and the exam, you will be awarded with the course completion certificate.

44 hours