DATA ANALYTICS

Course Instructor Talent Shine

₹450.00

Course Curriculum

1 Subject

Data Analytics

1 Exercises • 63 Learning Materials

Syllabus

Data Analytics

PDF

Introduction

Fundamentals of Data Analytics

Video

00:10:23

Python Programming

Keywords, Comments & Variables in Python

Video

00:20:22

Data Types in Python

Video

00:08:04

Sequence Data Types in Python

Video

00:06:56

Range Data Type in Python

Video

00:08:48

Operators in Python

Video

00:24:44

Identity Operators

Video

00:10:28

Set & Boolean

Video

00:10:27

Input Function in Python

Video

00:07:18

List Operators in Python

Video

00:26:27

Type Conversion

Video

00:16:04

Tuple Operations in Python

Video

00:09:44

Set Operations in Python

Video

00:06:59

Dictionary Operations in Python

Video

00:09:59

Functions in Python

Video

00:11:17

Types of Function Arguments

Video

00:05:04

SQL

SQL - 1

Video

00:10:16

SQL - 2

Video

00:11:54

Constraints

Video

00:07:33

DQL Statements - 1

Video

00:08:22

DQL Statements - 2

Video

00:11:06

DQL Statements - 3

Video

00:09:47

Alias & Distinct Clause

Video

00:09:51

Operators

Video

00:11:12

Special Operators

Video

00:16:42

Multi Row Functions

Video

00:12:14

Grouping Clause

Video

00:12:34

Grouping & Filtering Clause

Video

00:12:32

Sub Queries

Video

00:13:41

Nested Sub Queries

Video

00:10:51

Joins in SQL

Video

00:15:23

Outer Join

Video

00:08:43

Self Join & Natural Join

Video

00:11:38

Co-Related Sub Query

Video

00:08:27

Single Row Function

Video

00:21:40

Data Definition Language (DDL)

Video

00:16:16

Truncate & Drop

Video

00:08:50

Data Manipulation Language (DML)

Video

00:13:17

Numpy

Introduction

Video

00:05:27

Installation, Creation of Array

Video

00:08:00

Dimensions of Array

Video

00:09:39

Functions

Video

00:11:08

Indexing

Video

00:11:08

Operations on Arrays

Video

00:14:49

Pandas

Introduction

Video

00:09:30

Data Frame, Series

Video

00:07:59

Creating a DataSet From Dictionary

Video

00:07:59

Loading CSV File

Video

00:10:30

JSON File

Video

00:07:22

Data Cleaning

Video

00:11:32

Matplotlib

Video

00:38:48

Excel

Introduction

Video

00:07:02

Interface

Video

00:06:40

Home Tab

Video

00:11:15

Conditional Formatting

Video

00:13:37

Operators

Video

00:07:46

Basic Functions

Video

00:12:57

IF Functions

Video

00:10:38

Introduction to Tables

Video

00:10:49

Dash Board in Excel

Video

00:22:34

Certificate

Profile Update

PDF

Profile Update

External Link

Assessment

Exercise

DATA ANALYTICS

Course Overview

Schedule of Classes

Course Curriculum

Data Analytics

Syllabus

Data Analytics

Introduction

Fundamentals of Data Analytics

Python Programming

Keywords, Comments & Variables in Python

Data Types in Python

Sequence Data Types in Python

Range Data Type in Python

Operators in Python

Identity Operators

Set & Boolean

Input Function in Python

List Operators in Python

Type Conversion

Tuple Operations in Python

Set Operations in Python

Dictionary Operations in Python

Functions in Python

Types of Function Arguments

SQL

SQL - 1

SQL - 2

Constraints

DQL Statements - 1

DQL Statements - 2

DQL Statements - 3

Alias & Distinct Clause

Operators

Special Operators

Multi Row Functions

Grouping Clause

Grouping & Filtering Clause

Sub Queries

Nested Sub Queries

Joins in SQL

Outer Join

Self Join & Natural Join

Co-Related Sub Query

Single Row Function

Data Definition Language (DDL)

Truncate & Drop

Data Manipulation Language (DML)

Numpy

Introduction

Installation, Creation of Array

Dimensions of Array

Functions

Indexing

Operations on Arrays

Pandas

Introduction

Data Frame, Series

Creating a DataSet From Dictionary

Loading CSV File

JSON File

Data Cleaning

Matplotlib

Matplotlib

Excel

Introduction

Interface

Home Tab

Conditional Formatting

Operators

Basic Functions

IF Functions

Introduction to Tables

Dash Board in Excel

Certificate

Profile Update

Profile Update

Assessment

Course Instructor

Talent Shine