A Practical Introduction To NoSQL Databases Training Course

by NobleProg (Australia) Claim Listing

NoSQL databases also scale better than relational databases, due to their ability to efficiently partition data across many servers (cluster) and load balance the access to this data. NoSQL databases integrate particularly well with applications that support real-time analytics, site personalization

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

NobleProg (Australia) Logo

img Duration

4 Days

Course Details

Overview

Relational databases have been the technology of choice for storing, retrieving and querying data. Relational databases allow users to organize their data using a structured, well-defined set of patterns (model).

While this approach works well for storing data that is standardized and well-understood in advance (think of a hospital check-in application that holds patient records with the same consistent set of pre-defined fields...patient id, first name, last name, date of last visit, etc.), there are limitations to this model.

For organizations whose incoming data is not well-defined (think of an online inquiry form for a startup whose still in the process of experimenting with different fields for collecting visitor data, removing and adding fields as they go to accommodate for the changing nature of the business), any established definitions for how the data should fit into an existing database would need to be re-defined regularly.

This would require recreating the data model (schema) that dictates the structure of the data and its allowed data types to support different types of data inputs, etc., before any new data could be saved to the database.

Enter NoSQL (Not Only SQL) databases. NoSQL databases free users from having to predefine the structure of the incoming data, allowing them to insert and update new data on the fly. NoSQL databases are often faster than relational databases and can handle very large amounts of data with ease.

NoSQL databases also scale better than relational databases, due to their ability to efficiently partition data across many servers (cluster) and load balance the access to this data. NoSQL databases integrate particularly well with applications that support real-time analytics, site personalization, IoT, and mobile apps

In this instructor-led, live training, participants will understand the architecture, design principles and functionality of the most popular NoSQL databases as they setup, operate and asses a number of NoSQL databases in a live lab environment.

The goal of this training is to enable participants to intelligently evaluate, propose and implement a suitable NoSQL database solution within their organization.

By the end of this training, participants will be able to:

  • Install and configure different types of NoSQL databases, including MongoDB, Cassandra, Redis and Neo4j

  • Understand the benefits and disadvantages of NoSQL databases vs relational databases

  • Understand the underlying data formats used by NoSQL databases and how these formats can be used to an advantage when developing modern applications (desktop, mobile, cloud, IoT)

  • Perform create, insert, update, delete operations in a NoSQL database

  • Setup a mixed environment with both a relational database and NoSQL working in tandem

  • Configure a cluster of NoSQL database to distribute the processing of very large datasets

  • Understand the security implications of using a NoSQL database

  • Deploy and scale a NoSQL database in a production environment

 

Audience

  • Database professionals

  • Data architects

  • Data strategists

  • Project managers

  • Application developers wishing to integrate a flexible database solution in their application

 

Format Of The Course

  • Part lecture, part discussion, exercises and heavy hands-on practice

Note

  • To request a customized training for this course, please contact us to arrange.

 

Course Outline
Introduction

Overview of the Most Popular NoSQL Databases

  • MongoDB (document), Cassandra (columnar), Redis (key-value), Neo4J (graph)

Overview of MongoDB Features and Architecture

  • Mapping between a relational database and MongoDB

  • Indexing, replication, load balancing, ad hoc querying, etc.

MongoDB vs MySQL

Installing and Configuring MongoDB

Creating a Database

Reading, Writing and Querying MongoDB

Application Development with MongoDB

Security in MongoDB

Availability in MongoDB

Integrating relational and NoSQL (non-relational) data storage

Integrating MongoDB with Data Processing Frameworks

  • Hadoop MapReduce, Apache Spark, etc.

When to use MongoDB

  • Ideal workloads for NoSQL in an enterprise

When not to use MongoDB

  • Disadvantages of NoSQL

Deploying MongoDB to Production

  • On-premise or public cloud

Scaling MongoDB

Troubleshooting MongoDB

Closing Remarks


Introduction

  • Columnar (tabular) vs document database

Overview of Cassandra Features and Architecture

Installing and Configuring Cassandra

Creating a Database

Reading, Writing and Querying Cassandra

Application Development with Cassandra

Security in Cassandra

Availability in Cassandra

Integrating relational and NoSQL (non-relational) data storage

Integrating Cassandra with Data Processing Frameworks

  • Hadoop MapReduce, Apache Spark, etc.

When to use Cassandra

Deploying Cassandra to Production

  • On-premise and public cloud

  • Melbourne Branch

    Suite 51/Level 4, 80 Market Street, Melbourne

Check out more NoSQL courses in Australia

Australian Graduate School of Management Logo

Developing Data Strategy

Optimising for today, preparing for tomorrow. Understanding and making use of your data is critical to making informed decisions, building competitive advantage, and achieving business outcomes. This course will help you use your organisation’s data to its full advantage.

by Australian Graduate School of Management [Claim Listing ]
Intersect Logo

Databases And SQL

In this introductory course you will learn the basics of databases and SQL using the researcher-focused training modules from the highly regarded Software Carpentry Foundation.

by Intersect [Claim Listing ]
Skill Finder Logo

Advanced Database Administration

Develop queries in SQL to create databases, tables and indexesDevelop queries in SQL that create views.Develop queries in SQL that create stored proceduresUnderstand concurrent database processing through the use of transactions and locking.Develop queries in SQL that create functions

by Skill Finder [Claim Listing ]
Dynamic Web Training Logo

PHP and MySQL Course (Intro)

During this 3 day course, participants will step through how to build an entire dynamic website, ensuring that they have the necessary experience, skills and confidence to build a dynamic website later on.

by Dynamic Web Training
Academy IT Logo

Querying Data with Microsoft Transact-SQL

This course will teach the basics of Microsoft’s dialect of the standard SQL language

by Academy IT [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy