CPD-accredited courses from £39 · Instant e-certificates · 2,700+ courses
CPD-accredited certificates 020 4618 6402 Team training
Home / Courses / Data Science and Machine Learning / SQL NoSQL Big Data and Hadoop
CPD course All Levels

SQL NoSQL Big Data and Hadoop

4 enrolled 22h 33m of learning Updated Nov 2026
CertificateOn completion
22h 33mSelf-paced
80 lessonsOn the UISC learning portal
All LevelsNo prior training needed

Course curriculum

1 modules 80 lessons 22h 33m total
01 SQL NoSQL Big Data and Hadoop 80 lessons
  1. Introduction
  2. Building a Data-driven Organization – Introduction
  3. Data Engineering
  4. Learning Environment & Course Material
  5. Movielens Dataset
  6. Introduction to Relational Databases
  7. SQL
  8. Movielens Relational Model
  9. Movielens Relational Model: Normalization vs Denormalization
  10. MySQL
  11. Movielens in MySQL: Database import
  12. OLTP in RDBMS: CRUD Applications
  13. Indexes
  14. Data Warehousing
  15. Analytical Processing
  16. Transaction Logs
  17. Relational Databases – Wrap Up
  18. Distributed Databases
  19. CAP Theorem
  20. BASE
  21. Other Classifications
  22. Introduction to KV Stores
  23. Redis
  24. Install Redis
  25. Time Complexity of Algorithm
  26. Data Structures in Redis : Key & String
  27. Data Structures in Redis II : Hash & List
  28. Data structures in Redis III : Set & Sorted Set
  29. Data structures in Redis IV : Geo & HyperLogLog
  30. Data structures in Redis V : Pubsub & Transaction
  31. Modelling Movielens in Redis
  32. Redis Example in Application
  33. KV Stores: Wrap Up
  34. Introduction to Document-Oriented Databases
  35. MongoDB
  36. MongoDB Installation
  37. Movielens in MongoDB
  38. Movielens in MongoDB: Normalization vs Denormalization
  39. Movielens in MongoDB: Implementation
  40. CRUD Operations in MongoDB
  41. MongoDB Aggregation Query – MapReduce function
  42. MongoDB Aggregation Query – Aggregation Framework
  43. Demo: MySQL vs MongoDB. Modeling with Spark
  44. Document Stores: Wrap Up
  45. Introduction to Search Engine Stores
  46. Elasticsearch
  47. Basic Terms Concepts and Description
  48. Movielens in Elastisearch
  49. CRUD in Elasticsearch
  50. Search Queries in Elasticsearch
  51. Aggregation Queries in Elasticsearch
  52. The Elastic Stack (ELK)
  53. Use case: UFO Sighting in ElasticSearch
  54. Search Engines: Wrap Up
  55. Introduction to Columnar databases
  56. HBase
  57. HBase Architecture
  58. HBase Installation
  59. Apache Zookeeper
  60. Movielens Data in HBase
  61. Performing CRUD in HBase
  62. SQL on HBase – Apache Phoenix
  63. SQL on HBase – Apache Phoenix – Movielens
  64. Demo : GeoLife GPS Trajectories
  65. Wide Column Store: Wrap Up
  66. Introduction to Time Series
  67. InfluxDB
  68. InfluxDB Installation
  69. InfluxDB Data Model
  70. Data manipulation in InfluxDB
  71. TICK Stack I
  72. TICK Stack II
  73. Time Series Databases: Wrap Up
  74. Introduction to Graph Databases
  75. Modelling in Graph
  76. Modelling Movielens as a Graph
  77. Neo4J
  78. Neo4J installation
  79. Cypher
  80. Cypher II

About this course

Overview:

Welcome to "SQL, NoSQL, Big Data, and Hadoop!" This comprehensive course is designed to provide you with a thorough understanding of various data storage and processing technologies, including SQL, NoSQL, Big Data, and Hadoop. In today's data-driven world, it's essential to be familiar with a range of data technologies to handle diverse data types and volumes effectively. In this course, you'll learn how to work with relational and non-relational databases, manage big data, and utilize Hadoop for distributed data processing.

  • Interactive video lectures by industry experts
  • Instant e-certificate
  • Fully online, interactive course with Professional voice-over
  • Developed by qualified first aid professionals
  • Self paced learning and laptop, tablet, smartphone friendly
  • 24/7 Learning Assistance
  • Discounts on bulk purchases

Main Course Features:

  • Comprehensive coverage of SQL fundamentals for relational database management
  • Exploration of NoSQL databases such as MongoDB and Cassandra for handling unstructured data
  • Introduction to Big Data concepts and technologies, including Hadoop and MapReduce
  • Hands-on projects and exercises for practical application of SQL, NoSQL, and Big Data concepts
  • Implementation of data processing workflows using Hadoop ecosystem tools like Hive and Pig
  • Real-world case studies and examples demonstrating the application of SQL, NoSQL, and Hadoop
  • Access to datasets and resources for practicing SQL and Big Data processing
  • Supportive online community for collaboration and assistance throughout the course

Who Should Take This Course:

  • Data engineers and analysts seeking to expand their knowledge of data storage and processing technologies
  • Software developers interested in understanding how different data technologies work together in modern applications
  • Business intelligence professionals aiming to leverage Big Data and Hadoop for data analysis and insights
  • Students and professionals looking to enhance their skills in SQL, NoSQL, and Big Data technologies

Learning Outcomes:

  • Master SQL fundamentals for relational database management and querying
  • Understand the principles and use cases of NoSQL databases for handling diverse data types
  • Gain insights into Big Data concepts and technologies, including Hadoop and MapReduce
  • Learn how to manage and process large-scale data using Hadoop ecosystem tools
  • Develop practical skills through hands-on projects and exercises in SQL, NoSQL, and Hadoop
  • Build a portfolio of projects showcasing proficiency in SQL, NoSQL, and Big Data processing
  • Apply data storage and processing techniques to real-world scenarios effectively
  • Stay updated with the latest advancements and best practices in SQL, NoSQL, Big Data, and Hadoop technologies.

Certification

Once you’ve successfully completed your course, you will immediately be sent a digital certificate. All of our courses are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Assessment

At the end of the Course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven’t, there’s no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself.

Your certificate

CPD certificate — download it when you finish

Issued the moment you complete the final module. Every certificate lists the course aims and objectives, anticipated learning outcomes, the quality-assurance process — the elements required for verifiable CPD. Non-registrants can use it as CQC training evidence and for appraisals.

Aims & objectives Learning outcomes Unique certificate number

Common questions

Where do I take the course?

On the UISC learning portal. "Enrol now" takes you to this course there, where you pay securely, get your login and study at your own pace. Your certificate is issued there when you finish.

When can I start?

Immediately. Access opens the moment your order is confirmed and you can learn from any device, in any order, as many times as you like.

How is the course assessed?

A short multiple-choice or scenario-based assessment at the end of the course with instant results. You can retake it as many times as you need at no extra cost.

Can I enrol my whole team?

Yes. Organisations can buy multiple places on one invoice and receive a training record for every learner. Contact us for team pricing.

Keep learning

Related courses

More in Data Science and Machine Learning
Machine Learning Basics
Save 86%
47 lessons
Data Science and Machine Learning 11h 17m

Machine Learning Basics

16 others bought this course in the last 24 hours! Machine Learning Basics teaches you everything on the topic thoroughly from scratch so you can achieve a prof...

4.9 (8) 5 enrolled
£39.00 £279.00
Enrol now
£39.00 22h 33m · All Levels
Enrol now