Batch ID-MS0524018

Course Instructor: Meritshot

FREE

To enroll in this course, please contact the Admin

Course Overview

Schedule of Classes

Course Curriculum

1 Subject

Batch ID-MS0524018

1 Exercises • 168 Learning Materials

Examination

Excel Proficiency Exam

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

DOC

1(ii) SQL Syntax

DOC

1(iii) SQL SELECT Statement

DOC

1(iv) SQL SELECT DISTINCT

DOC

1(v) SQL WHERE Clause

DOC

1(vi) SQL ORDER BY Clause

DOC

1(vii) SQL Logical Operators

DOC

2(i) SQL INSERT INTO

DOC

2(ii) SQL NULL Values

DOC

2(iii) SQL UPDATE Statement

DOC

2(iv) SQL DELETE Statement

DOC

3(i) SQL SELECT TOP

DOC

3(ii) SQL Aggregate Functions

DOC

3(iii) SQL LIKE and Wildcards

DOC

3(iv) SQL IN and SQL BETWEEN

DOC

4 Sql Joins

DOC

5(i) SQL GROUP BY

DOC

5(ii) SQL HAVING

DOC

5(iii) SQL EXISTS

DOC

5(iv) SQL ANY and ALL

DOC

6(i) SQL SELECT INTO

DOC

6(ii) SQL INSERT INTO SELECT

DOC

6(iii) SQL CASE Statement

DOC

6(iv) SQL NULL Functions

DOC

7(i) SQL Stored Procedures

DOC

7(ii)SQL User Defined Functions

DOC

7(iii) SQL Comments

DOC

7(iv) SQL Operators

DOC

8(i) SQL Database Creation and Management

DOC

8(ii) SQL CREATE DATABASE Statement

DOC

8(iii) SQL DROP DATABASE Statement

DOC

8(iv) SQL CREATE TABLE Statement

DOC

8(v) SQL DROP TABLE Statement

DOC

8(vi) SQL ALTER TABLE Statement

DOC

9(i) SQL NOT NULL Constraint

DOC

9(ii) SQL UNIQUE Constraint

DOC

9(iii) SQL PRIMARY KEY Constraint

DOC

9(iv) SQL FOREIGN KEY Constraint

DOC

9(v) SQL CHECK Constraint

DOC

9(vi) SQL DEFAULT Constraint

DOC

10(i) SQL Indexes

DOC

10(ii) SQL AUTO INCREMENT

DOC

11(i) SQL Date Functions

DOC

11(ii) SQL Views

DOC

12(i) SQL Injection

DOC

13(i) SQL Data Types Overview

DOC

14(i) SQL Keywords Reference

DOC

15 Accessing and Loading Databases

DOC

16 Introduction to PySpark in Python

DOC

17 Spark for Big Data Analysis

DOC

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

DOC

1-2 Key Features and Benefits of Tableau

DOC

1-3 Tableau Desktop vs Tableau Online vs Tableau Server

DOC

1-4 Navigating the Tableau Interface

DOC

2-1 Intro to Charts in Tableau

DOC

2-1-1 Creating Simple Calculated Fields

DOC

2-1-2 Common Calculations

DOC

2-1-3 Best Practices for Calculated Fields

DOC

2-2 Bar Chart

DOC

2-2-1 Overview of Table Calculations

DOC

2-2-2 Common Table Calculations

DOC

2-2-3 Customizing Table Calculations

DOC

2-3 Line Chart

DOC

2-3-1 Aggregations in Tableau

DOC

2-3-2 Applying Aggregations to Data

DOC

2-3-3 Best Practices for Aggregation

DOC

2-4 Pie Chart

DOC

2-4-1 Granularity in Tableau

DOC

2-4-2 Adjusting Granularity in Your Visualizations

DOC

2-4-3 Examples of Granularity in Different Scenarios

DOC

2-5 Scatter Plots

DOC

2-5-1 Level of Detail(LOD)

DOC

2-5-2 Different Types of LOD Expressions

DOC

2-5-3 Practical Use Cases and Examples

DOC

2-6 Histograms

DOC

2-7 Customizing Charts

DOC

3-1 Introduction to Geographic Data

DOC

3-1-1 Understanding Data Extracts

DOC

3-1-2 Creating and Refreshing Extracts in Tableau

DOC

3-1-3 Benefits of Using Extracts vs

DOC

3-2 Creating Basic Maps

DOC

3-2-1 Filters in Tableau

DOC

3-2-2 Creating Interactive Filters

DOC

3-2-3 Using Filter Actions in Dashboards

DOC

3-3 Customizing Maps

DOC

3-3-1 Introduction to Dashboards

DOC

3-3-2 Designing and Building Dashboards

DOC

3-3-3 Adding Interactivity

DOC

3-4 Using Map Filters

DOC

3-4-1 Tableau Storyboards

DOC

3-4-2 Creating a Tableau Story

DOC

3-4-3 Designing Storyboards for Effective Communication

DOC

3-5-1 Formatting in Tableau

DOC

3-5-2 Customizing Appearance

DOC

3-5-3 Best Practices for Dashboard Formatting

DOC

4-1 Principles of Effective Data Visualization

DOC

4-2 Understanding Data Types and Data Structure

DOC

4-3 Choosing the Right Visualization for Your Data

DOC

5-1 Creating and Formatting Reports

DOC

5-2 Adding Filters and Parameters to Reports

DOC

5-3 Publishing and Sharing Reports

DOC

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

Cybersecurity MCQs

PDF

Test Series

MCQ Test 1

PDF

excel live test

Power BI live exam

Tableau live exam

SQL Live test

Data Science live test

Data Science live test 2

Course Instructor

Meritshot

126 Courses • 2078 Students