dots bg

Batch ID-MS0224011

Course Instructor Meritshot

FREE

dots bg

Course Overview

Schedule of Classes

Course Curriculum

1 Subject

Batch ID-MS0224011

2 Exercises166 Learning Materials

Examination

Excel Proficiency Exam

Exercise

Tableau Proficiency Assessment

Exercise

PYTHON TUTORIALS

ANONYMOUS FUNCTION

PDF

BREAK, CONTINUE MAP FILTER REDUCE

PDF

CONDITIONAL

PDF

data-structure

PDF

data-type

PDF

functions

PDF

ListOfContents

PDF

loops

PDF

OOPS

PDF

operators

PDF

parameters-and-arguments

PDF

Space&time

PDF

strings

PDF

variables-done

PDF

vertopal.com_REGULAR EXP

PDF

SQL TUTORIAL

List Of Contents

PDF

1(i)_SQL_Intro

Audio

1(ii) SQL Syntax

Audio

1(iii) SQL SELECT Statement

Audio

1(iv) SQL SELECT DISTINCT

Audio

1(v) SQL WHERE Clause

Audio

1(vi) SQL ORDER BY Clause

Audio

1(vii) SQL Logical Operators

Audio

2(i) SQL INSERT INTO

Audio

2(ii) SQL NULL Values

Audio

2(iii) SQL UPDATE Statement

Audio

2(iv) SQL DELETE Statement

Audio

3(i) SQL SELECT TOP

Audio

3(ii) SQL Aggregate Functions

Audio

3(iii) SQL LIKE and Wildcards

Audio

3(iv) SQL IN and SQL BETWEEN

Audio

4 Sql Joins

Audio

5(i) SQL GROUP BY

Audio

5(ii) SQL HAVING

Audio

5(iii) SQL EXISTS

Audio

5(iv) SQL ANY and ALL

Audio

6(i) SQL SELECT INTO

Audio

6(ii) SQL INSERT INTO SELECT

Audio

6(iii) SQL CASE Statement

Audio

6(iv) SQL NULL Functions

Audio

7(i) SQL Stored Procedures

Audio

7(ii)SQL User Defined Functions

Audio

7(iii) SQL Comments

Audio

7(iv) SQL Operators

Audio

8(i) SQL Database Creation and Management

Audio

8(ii) SQL CREATE DATABASE Statement

Audio

8(iii) SQL DROP DATABASE Statement

Audio

8(iv) SQL CREATE TABLE Statement

Audio

8(v) SQL DROP TABLE Statement

Audio

8(vi) SQL ALTER TABLE Statement

Audio

9(i) SQL NOT NULL Constraint

Audio

9(ii) SQL UNIQUE Constraint

Audio

9(iii) SQL PRIMARY KEY Constraint

Audio

9(iv) SQL FOREIGN KEY Constraint

Audio

9(v) SQL CHECK Constraint

Audio

9(vi) SQL DEFAULT Constraint

Audio

10(i) SQL Indexes

Audio

10(ii) SQL AUTO INCREMENT

Audio

11(i) SQL Date Functions

Audio

11(ii) SQL Views

Audio

12(i) SQL Injection

Audio

13(i) SQL Data Types Overview

Audio

14(i) SQL Keywords Reference

Audio

15 Accessing and Loading Databases

Audio

16 Introduction to PySpark in Python

Audio

17 Spark for Big Data Analysis

Audio

R PROGRAMMING TUTORIALS

Table of Contents_R

PDF

Module1 Module 2_R-Programming

PDF

Module 3 R-Basic Syntax

PDF

4th Module_R programming

PDF

5th Module Data Structures in R

PDF

6_th Module_R Variables

PDF

7th_Module_R-Operators

PDF

8th 9th module

PDF

10th 11th Module

PDF

12th 13th Module_R programming

PDF

14th Module_R programming

PDF

15th_R-CSV Files

PDF

16th_Statistics in R

PDF

17th Module Probability in R

PDF

18ThModule_Hypothesis testing in R

PDF

19thModule_Confidence intervals in R

PDF

20th Module Correlation And Covariance in R

PDF

21st Probability Plots and Diagnostics in R

PDF

22th Module_Error Metrices in R

PDF

23th_Curves in R

PDF

Cybersecurity Tutorials

Introduction of PGP Cyber Security Program

PDF

Module 2

PDF

Module 3

PDF

Module 4Text ProcessingusingGREPSEDandAWK

PDF

Module 5 Introduction to Ethical Hacking

PDF

Module 6

PDF

Module 7

PDF

Module 8 Enumeration

PDF

Module 9

PDF

Module 10 System Hacking

PDF

Module 11

PDF

Module 12

PDF

Module 13

PDF

Module 14Denial-of-Service

PDF

Module 15 Session Hijacking

PDF

Module 16

PDF

Module 17 Hacking Web Servers

PDF

Module 18 Hacking Web Applications

PDF

Module 19

PDF

Module 20HackingWirelessNetworks

PDF

Module 21 Hacking Mobile Platforms

PDF

Module 22 IoTHacking

PDF

Module 23

PDF

Module 24

PDF

Tableau Tutorials

1-1 Overview of Tableau

Audio

1-2 Key Features and Benefits of Tableau

Audio

1-3 Tableau Desktop vs Tableau Online vs Tableau Server

Audio

1-4 Navigating the Tableau Interface

Audio

2-1 Intro to Charts in Tableau

Audio

2-1-1 Creating Simple Calculated Fields

Audio

2-1-2 Common Calculations

Audio

2-1-3 Best Practices for Calculated Fields

Audio

2-2 Bar Chart

Audio

2-2-1 Overview of Table Calculations

Audio

2-2-2 Common Table Calculations

Audio

2-2-3 Customizing Table Calculations

Audio

2-3 Line Chart

Audio

2-3-1 Aggregations in Tableau

Audio

2-3-2 Applying Aggregations to Data

Audio

2-3-3 Best Practices for Aggregation

Audio

2-4 Pie Chart

Audio

2-4-1 Granularity in Tableau

Audio

2-4-2 Adjusting Granularity in Your Visualizations

Audio

2-4-3 Examples of Granularity in Different Scenarios

Audio

2-5 Scatter Plots

Audio

2-5-1 Level of Detail(LOD)

Audio

2-5-2 Different Types of LOD Expressions

Audio

2-5-3 Practical Use Cases and Examples

Audio

2-6 Histograms

Audio

2-7 Customizing Charts

Audio

3-1 Introduction to Geographic Data

Audio

3-1-1 Understanding Data Extracts

Audio

3-1-2 Creating and Refreshing Extracts in Tableau

Audio

3-1-3 Benefits of Using Extracts vs

Audio

3-2 Creating Basic Maps

Audio

3-2-1 Filters in Tableau

Audio

3-2-2 Creating Interactive Filters

Audio

3-2-3 Using Filter Actions in Dashboards

Audio

3-3 Customizing Maps

Audio

3-3-1 Introduction to Dashboards

Audio

3-3-2 Designing and Building Dashboards

Audio

3-3-3 Adding Interactivity

Audio

3-4 Using Map Filters

Audio

3-4-1 Tableau Storyboards

Audio

3-4-2 Creating a Tableau Story

Audio

3-4-3 Designing Storyboards for Effective Communication

Audio

3-5-1 Formatting in Tableau

Audio

3-5-2 Customizing Appearance

Audio

3-5-3 Best Practices for Dashboard Formatting

Audio

4-1 Principles of Effective Data Visualization

Audio

4-2 Understanding Data Types and Data Structure

Audio

4-3 Choosing the Right Visualization for Your Data

Audio

5-1 Creating and Formatting Reports

Audio

5-2 Adding Filters and Parameters to Reports

Audio

5-3 Publishing and Sharing Reports

Audio

Statistics and hypothesis testing Tutorials

Basic Concepts of Statistics

PDF

Descriptive Statistics

PDF

PROBABILITY And Its Basics

PDF

Inferential Statistics

PDF

Statistics and Hypothesis Testing

PDF

Course Instructor

tutor image

Meritshot

71 Courses   •   15529 Students