Skip to content

SQL NoSQL Big Data and Hadoop

FREE PDF Certificate | Audio Visual Learning | 20 CPD Points | Tutor Support | 1 Year Access

Janets

Summary

Price
£319 inc VAT
Or £53.17/mo. for 6 months...
Study method
Online
Duration
23 hours · Self-paced
Access to content
Lifetime access
Qualification
No formal qualification
CPD
20 CPD hours / points
CPD What's this?
Additional info
  • Exam(s) / assessment(s) is included in price
  • Tutor is available to students

Overview

Follow your dreams by enrolling on the SQL NoSQL Big Data and Hadoop course today and develop the experience, skills and knowledge you need to enhance your professional development. SQL NoSQL Big Data and Hadoop will help you arm yourself with the qualities you need to work towards your dream job.

Study the SQL NoSQL Big Data and Hadoop training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The SQL NoSQL Big Data and Hadoop course will allow you to enhance your CV, impress potential employers, and stand out from the crowd.

This SQL NoSQL Big Data and Hadoop course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the SQL NoSQL Big Data and Hadoop course through a mixture of instructional video lessons and online study materials.

Receive online tutor support as you study the SQL NoSQL Big Data and Hadoop course, to ensure you are supported every step of the way. Get a free e-certificate as proof of your SQL NoSQL Big Data and Hadoop course completion.

Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the SQL NoSQL Big Data and Hadoop course. The SQL NoSQL Big Data and Hadoop course is designed by industry experts and is tailored to help you learn new skills with ease.

The SQL NoSQL Big Data and Hadoop is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the SQL NoSQL Big Data and Hadoop when it suits you. Access the SQL NoSQL Big Data and Hadoop course modules from any internet-enabled device, including computers, tablets, and smartphones.

The SQL NoSQL Big Data and Hadoop course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the SQL NoSQL Big Data and Hadoop now and start learning instantly!

What You Get Out Of Studying SQL NoSQL Big Data and Hadoop With Janets

  • Free PDF certificate upon successful completion of the course
  • Full one-year access to course materials
  • Instant assessment results
  • Full tutor support available from Monday to Friday
  • Study the course at your own pace
  • Accessible, informative modules taught by expert instructors
  • Get 24/7 help or advice from our email and live chat teams with the training
  • Study at your own time through your computer, tablet or mobile device
  • Improve your chance of gaining valuable skills and better earning potential by completing course

CPD

20 CPD hours / points
Accredited by CPD QS

Course media

Description

The SQL NoSQL Big Data and Hadoop training course is delivered through Janets’ online learning platform. Access the SQL NoSQL Big Data and Hadoop content from any internet-enabled device whenever or wherever you want to. The SQL NoSQL Big Data and Hadoop course has no formal teaching deadlines, meaning you are free to complete the course at your own pace.

SQL NoSQL Big Data and Hadoop Course Curriculum:

Section 01: Introduction

  • Introduction
  • Building a Data-driven Organization – Introduction
  • Data Engineering
  • Learning Environment & Course Material
  • Movielens Dataset

Section 02: 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

Section 03: Database Classification

  • Distributed Databases
  • CAP Theorem
  • BASE
  • Other Classifications

Section 04: Key-Value Store

  • 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

Section 05: 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

Section 06: Search Engines

  • 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

Section 07: Wide Column Store

  • Introduction to Columnar databases
  • HBase
  • HBase Architecture
  • HBase Installation
  • Apache Zookeeper
  • 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

Section 08: 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

Section 09: Graph Databases

  • Introduction to Graph Databases
  • Modelling in Graph
  • Modelling Movielens as a Graph
  • Neo4J
  • Neo4J installation
  • Cypher
  • Cypher II
  • 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

Section 10: 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

Section 11: 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

Section 12: 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

Certification

All students who successfully complete the SQL NoSQL Big Data and Hadoop course can instantly download their free e-certificate. You can also purchase a hard copy of the SQL NoSQL Big Data and Hadoop course certificate, which will be delivered by post for £9.99.

Who is this course for?

The SQL NoSQL Big Data and Hadoop is ideal for those who already work in this sector or are an aspiring professional. This SQL NoSQL Big Data and Hadoop course is designed to enhance your expertise and boost your CV.

Requirements

The SQL NoSQL Big Data and Hadoop is open to all students and has no formal entry requirements. To study the SQL NoSQL Big Data and Hadoop course, all you need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16.

Career path

This SQL NoSQL Big Data and Hadoop course will assist you to get your desired job in the relevant field. The course will also progress your career, regardless of your present job status. You could explore a number of job roles for you to fill as you complete this SQL NoSQL Big Data and Hadoop course.

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Ask a question

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Similar subjects: Big data, MySQL, SQL, IT, Coding
Related searches: Online courses

Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2024. All rights reserved.