SQL NoSQL Big Data and Hadoop

SQL NoSQL Big Data and Hadoop

get Access To All 3500+ One Education Courses For Just £49/Year!
Claim Offer

Overview

Are you struggling with maintaining all your data? Or feeling like you are falling apart? The database management system can help you to organize and maintain all your data without any worries. Learn SQL and big data from this SQL NoSQL Big Data and Hadoop course and manage all data of your business efficiently.

In this SQL NoSQL Big Data and Hadoop course, you will learn what is data-driven organisation and data engineering and how you can use it. You will learn how you can use a relational database, document-oriented database and other functions. You will be able to understand the function of the search engine, big data and graphs in your database. This course will teach you different advanced techniques of database management to maintain and organize your data in an efficient way.

This course will teach you how you can use simple database functions for your daily data management. You will also be able to understand and related different data tables for calculating and evaluating large data sets from this course.

Course design

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

Certificate of Achievement

Endorsed Certificate of Achievement from the Quality Licence Scheme

After successfully completing the course, learners will be able to order an endorsed certificate as proof of their new achievement. Endorsed certificates can be ordered and get delivered to your home by post for only £129.00. There is an additional £10 postage charge for international students.

CPD Certification from One Education

After successfully completing the assessment of this course, you will qualify for the CPD Certificate from One Education as proof of your continued expert development. Certificate is available in PDF format, at the cost of £9, or a hard copy can be sent to you via post, at the cost of £15.

Endorsement

This course has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an acknowledged lesson. One Education will be able to advise you on any further recognition, for example, progression routes into further and/or higher education. For further information, please visit the Learner FAQs on the Quality Licence Scheme website.

Method of Assessment

To assess your learning, you have to complete the assignment questions provided at the end of the course. You have to score at least 60% to pass the exam and to qualify for Quality Licence Scheme endorsed, and CPD acknowledged certificates. 

After submitting the assignment, our expert tutor will assess your assignment and will give you feedback on your performance.

After passing the assignment exam, you will be able to apply for a certificate.

Why Study This Course

It doesn’t matter if you are an aspiring expert or absolute beginner; this course will enhance your expertise and boost your CV with critical skills and an acknowledged certificate attesting to your knowledge.

The SQL NoSQL Big Data and Hadoop is fully available to anyone, and no previous lessons are needed to enrol. All One Education needs to know is that you are eager to learn and are over 16.

Course Curriculum

Section 01: Introduction
Introduction 00:07:00
Building a Data-driven Organization – Introduction 00:04:00
Data Engineering 00:06:00
Learning Environment & Course Material 00:04:00
Movielens Dataset 00:03:00
Section 02: Relational Database Systems
Introduction to Relational Databases 00:09:00
SQL 00:05:00
Movielens Relational Model 00:15:00
Movielens Relational Model: Normalization vs Denormalization 00:16:00
MySQL 00:05:00
Movielens in MySQL: Database import 00:06:00
OLTP in RDBMS: CRUD Applications 00:17:00
Indexes 00:16:00
Data Warehousing 00:15:00
Analytical Processing 00:17:00
Transaction Logs 00:06:00
Relational Databases – Wrap Up 00:03:00
Section 03: Database Classification
Distributed Databases 00:07:00
CAP Theorem 00:10:00
BASE 00:07:00
Other Classifications 00:07:00
Section 04: Key-Value Store
Introduction to KV Stores 00:02:00
Redis 00:04:00
Install Redis 00:07:00
Time Complexity of Algorithm 00:05:00
Data Structures in Redis : Key & String 00:20:00
Data Structures in Redis II : Hash & List 00:18:00
Data structures in Redis III : Set & Sorted Set 00:21:00
Data structures in Redis IV : Geo & HyperLogLog 00:11:00
Data structures in Redis V : Pubsub & Transaction 00:08:00
Modelling Movielens in Redis 00:11:00
Redis Example in Application 00:29:00
KV Stores: Wrap Up 00:02:00
Section 05: Document-Oriented Databases
Introduction to Document-Oriented Databases 00:05:00
MongoDB 00:04:00
MongoDB Installation 00:02:00
Movielens in MongoDB 00:13:00
Movielens in MongoDB: Normalization vs Denormalization 00:11:00
Movielens in MongoDB: Implementation 00:10:00
CRUD Operations in MongoDB 00:13:00
Indexes 00:16:00
MongoDB Aggregation Query – MapReduce function 00:09:00
MongoDB Aggregation Query – Aggregation Framework 00:16:00
Demo: MySQL vs MongoDB. Modeling with Spark 00:02:00
Document Stores: Wrap Up 00:03:00
Section 06: Search Engines
Introduction to Search Engine Stores 00:05:00
Elasticsearch 00:09:00
Basic Terms Concepts and Description 00:13:00
Movielens in Elastisearch 00:12:00
CRUD in Elasticsearch 00:15:00
Search Queries in Elasticsearch 00:23:00
Aggregation Queries in Elasticsearch 00:23:00
The Elastic Stack (ELK) 00:12:00
Use case: UFO Sighting in ElasticSearch 00:29:00
Search Engines: Wrap Up 00:04:00
Section 07: Wide Column Store
Introduction to Columnar databases 00:06:00
HBase 00:07:00
HBase Architecture 00:09:00
HBase Installation 00:09:00
Apache Zookeeper 00:06:00
Movielens Data in HBase 00:17:00
Performing CRUD in HBase 00:24:00
SQL on HBase – Apache Phoenix 00:14:00
SQL on HBase – Apache Phoenix – Movielens 00:10:00
Demo : GeoLife GPS Trajectories 00:02:00
Wide Column Store: Wrap Up 00:04:00
Section 08: Time Series Databases
Introduction to Time Series 00:09:00
InfluxDB 00:03:00
InfluxDB Installation 00:07:00
InfluxDB Data Model 00:07:00
Data manipulation in InfluxDB 00:17:00
TICK Stack I 00:12:00
TICK Stack II 00:23:00
Time Series Databases: Wrap Up 00:04:00
Section 09: Graph Databases
Introduction to Graph Databases 00:05:00
Modelling in Graph 00:14:00
Modelling Movielens as a Graph 00:10:00
Neo4J 00:04:00
Neo4J installation 00:08:00
Cypher 00:12:00
Cypher II 00:19:00
Movielens in Neo4J: Data Import 00:17:00
Movielens in Neo4J: Spring Application 00:12:00
Data Analysis in Graph Databases 00:05:00
Examples of Graph Algorithms in Neo4J 00:18:00
Graph Databases: Wrap Up 00:07:00
Section 10: Hadoop Platform
Introduction to Big Data With Apache Hadoop 00:06:00
Big Data Storage in Hadoop (HDFS) 00:16:00
Big Data Processing : YARN 00:11:00
Installation 00:13:00
Data Processing in Hadoop (MapReduce) 00:14:00
Examples in MapReduce 00:25:00
Data Processing in Hadoop (Pig) 00:12:00
Examples in Pig 00:21:00
Data Processing in Hadoop (Spark) 00:23:00
Examples in Spark 00:23:00
Data Analytics with Apache Spark 00:09:00
Data Compression 00:06:00
Data serialization and storage formats 00:20:00
Hadoop: Wrap Up 00:07:00
Section 11: Big Data SQL Engines
Introduction Big Data SQL Engines 00:03:00
Apache Hive 00:10:00
Apache Hive : Demonstration 00:20:00
MPP SQL-on-Hadoop: Introduction 00:03:00
Impala 00:06:00
Impala : Demonstration 00:18:00
PrestoDB 00:13:00
PrestoDB : Demonstration 00:14:00
SQL-on-Hadoop: Wrap Up 00:02:00
Section 12: Distributed Commit Log
Data Architectures 00:05:00
Introduction to Distributed Commit Logs 00:07:00
Apache Kafka 00:03:00
Confluent Platform Installation 00:10:00
Data Modeling in Kafka I 00:13:00
Data Modeling in Kafka II 00:15:00
Data Generation for Testing 00:09:00
Use case: Toll fee Collection 00:04:00
Stream processing 00:11:00
Stream Processing II with Stream + Connect APIs 00:19:00
Example: Kafka Streams 00:15:00
KSQL : Streaming Processing in SQL 00:04:00
KSQL: Example 00:14:00
Demonstration: NYC Taxi and Fares 00:01:00
Streaming: Wrap Up 00:02:00
Section 13: Summary
Database Polyglot 00:04:00
Extending your knowledge 00:08:00
Data Visualization 00:11:00
Building a Data-driven Organization – Conclusion 00:07:00
Conclusion 00:03:00
Resources
Resources – SQL NoSQL Big Data and Hadoop 00:00:00
Assignment
Assignment -SQL NoSQL Big Data and Hadoop 3 weeks, 3 days
Order Your Certificate
Order Your Certificate QLS 00:00:00
sidemoneyBack

COPYRIGHT © 2022 One Education

Home Search Cart
0
    0
    Your Cart
    Your cart is emptyBrowse Courses

    Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year

    Claim Offer & Upgrade

    Membership renews after 12 months. You can cancel anytime from your account.

    Other Students Also Buy
      Apply Coupon