SQL, NoSQL, Big Data and Hadoop

Introduction

Preview

Building a Data-driven Organization - Introduction

Preview

Data Engineering

Preview

Learning Environment & Course Material

Preview

Movielens Dataset

Preview

Relational Database Systems

Introduction to Relational Databases

SQL

Movielens Relational Model

Movielens Relational Model: Normalization vs Denormalization

MySQL

Movielens in MySQL: Database import

OLTP in RDBMS: CRUD Applications

Indexes

Data Warehousing

Analytical Processing

Transaction Logs

Relational Databases - Wrap Up

Database Classification

Distributed Databases

Introduction to KV Stores

Redis

Install Redis

Time Complexity of Algorithm

Data Structures in Redis : Key & String

Data Structures in Redis II : Hash & List

Data structures in Redis III : Set & Sorted Set

Data structures in Redis IV : Geo & HyperLogLog

Data structures in Redis V : Pubsub & Transaction

Modelling Movielens in Redis

Redis Example in Application

KV Stores: Wrap Up

Document-Oriented Databases

Introduction to Document-Oriented Databases

MongoDB

MongoDB installation

Movielens in MongoDB

Movielens in MongoDB: Normalization vs Denormalization

Movielens in MongoDB: Implementation

CRUD Operations in MongoDB

Indexes

MongoDB Aggregation Query - MapReduce function

MongoDB Aggregation Query - Aggregation Framework

Demo: MySQL vs MongoDB. Modeling with Spark

Document Stores: Wrap Up

Search Engine

Introduction to Search Engine Stores

Elasticsearch

Basic Terms Concepts and Description

Movielens in Elastisearch

CRUD in Elasticsearch

Search Queries in Elasticsearch

Aggregation Queries in Elasticsearch

The Elastic Stack (ELK)

Use case: UFO Sighting in ElasticSearch

Search Engines: Wrap Up

Wide Column Store

Introduction to Columnar databases

Movielens Data in HBase

Performing CRUD in HBase

SQL on HBase - Apache Phoenix

SQL on HBase - Apache Phoenix - Movielens

Demo : GeoLife GPS Trajectories

Wide Column Store: Wrap Up

Time Series Databases

Introduction to Time Series

InfluxDB

InfluxDB Installation

InfluxDB Data Model

Data manipulation in InfluxDB

TICK Stack I

TICK Stack II

Time Series Databases: Wrap Up

Graph Databases

Introduction to Graph Databases.

Modelling in Graph

Modelling Movielens as a Graph

Movielens in Neo4J: Data Import

Movielens in Neo4J: Spring Application

Data Analysis in Graph Databases

Examples of Graph Algorithms in Neo4J

Graph Databases: Wrap Up

Hadoop Platform

Introduction to Big Data With Apache Hadoop

Big Data Storage in Hadoop (HDFS)

Big Data Processing : YARN

Installation

Data Processing in Hadoop (MapReduce)

Examples in MapReduce

Data Processing in Hadoop (Pig)

Examples in Pig

Data Processing in Hadoop (Spark)

Examples in Spark

Data Analytics with Apache Spark

Data Compression

Data serialization and storage formats

Hadoop: Wrap Up

Big Data SQL Engines

Introduction Big Data SQL Engines

Apache Hive

Apache Hive : Demonstration

MPP SQL-on-Hadoop: Introduction

Impala

Impala : Demonstration

PrestoDB

PrestoDB : Demonstration

SQL-on-Hadoop: Wrap Up

Distributed Commit Log

Data Architectures

Introduction to Distributed Commit Logs

Apache Kafka

Confluent Platform Installation

Data Modeling in Kafka I

Data Modeling in Kafka II

Data Generation for Testing

Use case: Toll fee Collection

Stream processing

Stream Processing II with Stream + Connect APIs

Example: Kafka Streams

KSQL : Streaming Processing in SQL

KSQL: Example

Demonstration: NYC Taxi and Fares

Streaming: Wrap Up

Summary

Database Polyglot

Extending your knowledge

Data Visualization

Building a Data-driven Organization - Conclusion

Final Words

Analytical Processing

SQL, NoSQL, Big Data and Hadoop Relational Database Systems

By: Michael Enudi

16 minutes

Share the link to this page

Copied

Facebook

Twitter

Add the class to your calendar

Add to Google Calendar

Add to Apple Calendar

Add to Yahoo Calendar

Add to Outlook Calendar

Completed

You need to have access to the item to view this lesson.

One-time Fee

$69.99

List Price: $99.99

You save: $30

€59.88

List Price: €85.54

You save: €25.66

£51.87

List Price: £74.11

You save: £22.23

CA$96.83

List Price: CA$138.33

You save: CA$41.50

A$107.84

List Price: A$154.06

You save: A$46.22

S$89.84

List Price: S$128.36

You save: S$38.51

HK$546.69

List Price: HK$781.02

You save: HK$234.33

CHF 56.18

List Price: CHF 80.26

You save: CHF 24.08

NOK kr708.18

List Price: NOK kr1,011.73

You save: NOK kr303.55

DKK kr446.97

List Price: DKK kr638.55

You save: DKK kr191.58

NZ$119.44

List Price: NZ$170.64

You save: NZ$51.19

د.إ257.03

List Price: د.إ367.21

You save: د.إ110.17

৳8,436.55

List Price: ৳12,052.73

You save: ৳3,616.18

₹6,129.56

List Price: ₹8,756.89

You save: ₹2,627.33

RM294.40

List Price: RM420.59

You save: RM126.19

₦106,745.24

List Price: ₦152,499.74

You save: ₦45,754.50

₨19,682.22

List Price: ₨28,118.67

You save: ₨8,436.44

฿2,271.49

List Price: ฿3,245.12

You save: ฿973.63

₺2,869.71

List Price: ₺4,099.77

You save: ₺1,230.05

B$381.17

List Price: B$544.56

You save: B$163.38

R1,227.71

List Price: R1,753.95

You save: R526.23

Лв117.05

List Price: Лв167.23

You save: Лв50.17

₩97,133.49

List Price: ₩138,768.09

You save: ₩41,634.59

₪236.59

List Price: ₪338

You save: ₪101.41

₱3,971.26

List Price: ₱5,673.48

You save: ₱1,702.21

¥10,319.29

List Price: ¥14,742.47

You save: ¥4,423.18

MX$1,305.31

List Price: MX$1,864.80

You save: MX$559.49

QR252.88

List Price: QR361.27

You save: QR108.39

P932.91

List Price: P1,332.78

You save: P399.87

KSh9,039.20

List Price: KSh12,913.70

You save: KSh3,874.50

E£3,396.67

List Price: E£4,852.59

You save: E£1,455.92

ብር9,839.46

List Price: ብር14,056.98

You save: ብር4,217.51

Kz63,827.73

List Price: Kz91,186.38

You save: Kz27,358.65

CLP$67,147.70

List Price: CLP$95,929.40

You save: CLP$28,781.70

CN¥500.89

List Price: CN¥715.58

You save: CN¥214.69

RD$4,328.02

List Price: RD$6,183.16

You save: RD$1,855.13

DA9,073.30

List Price: DA12,962.42

You save: DA3,889.11

FJ$158.38

List Price: FJ$226.27

You save: FJ$67.89

Q532

List Price: Q760.03

You save: Q228.03

GY$14,508.64

List Price: GY$20,727.51

You save: GY$6,218.87

ISK kr8,587.07

List Price: ISK kr12,267.77

You save: ISK kr3,680.70

DH627.89

List Price: DH897.02

You save: DH269.13

L1,170.21

List Price: L1,671.80

You save: L501.59

ден3,680

List Price: ден5,257.37

You save: ден1,577.36

MOP$558.78

List Price: MOP$798.29

You save: MOP$239.51

N$1,224.02

List Price: N$1,748.68

You save: N$524.65

C$2,552.90

List Price: C$3,647.15

You save: C$1,094.25

रु9,707.60

List Price: रु13,868.60

You save: रु4,160.99

S/243.59

List Price: S/348

You save: S/104.41

K293.22

List Price: K418.90

You save: K125.68

SAR262.60

List Price: SAR375.15

You save: SAR112.55

ZK1,604.31

List Price: ZK2,291.97

You save: ZK687.66

L302.67

List Price: L432.41

You save: L129.73

Kč1,470

List Price: Kč2,100.09

You save: Kč630.09

Ft23,809.45

List Price: Ft34,014.95

You save: Ft10,205.50

SEK kr666.96

List Price: SEK kr952.84

You save: SEK kr285.88

ARS$92,452.04

List Price: ARS$132,080.01

You save: ARS$39,627.96

Bs479.41

List Price: Bs684.90

You save: Bs205.49

COP$279,908.06

List Price: COP$399,885.80

You save: COP$119,977.73

₡34,993.92

List Price: ₡49,993.45

You save: ₡14,999.53

L1,814.91

List Price: L2,592.84

You save: L777.93

₲502,799.13

List Price: ₲718,315.27

You save: ₲215,516.13

$U2,804.51

List Price: $U4,006.62

You save: $U1,202.10

zł255.30

List Price: zł364.73

You save: zł109.43

Already have an account? Log In

SQL, NoSQL, Big Data and Hadoop

Analytical Processing

Sign Up

Sign Up

Share