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
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
NobleProg is an international training and consultancy group, delivering high quality courses to every sector, covering: Cyber Security, Artificial Intelligence, IT, Management, Applied Statistics.
Over the last 17 years, we have trained more than 50,000 people from over 6000 companies and organisations.
Our courses include classroom (both public and closed) and instructor-led online giving you choice and flexibility to suit your time, budget and level of expertise.
We practice what we preach – we use a great deal of the technologies and methods that we teach, and continuously upgrade and improve our courses, keeping up to date with all the latest developments.
Our trainers are hand picked and have been through rigorous checks and interviews, and all courses are evaluated by delegates ensuring continuous feedback and improvement.
Enroll for 2-day Querying Data with Microsoft Transact-SQL - DP-080T00 training course from Koenig Solutions accredited by Microsoft. In this course you will learn about the basics of Microsoft's dialect of the standard SQL language
Introduction to SQL Databases course is offered by Wardy IT Solutions. As a Microsoft Partner we’ve been awarded with the Silver Learning competency. Every training session we run is taught by a Microsoft Certified Trainer.
SQL (Database) course is offered by Victorian Institute of Technology for all skill level. VIT provides you with a smart start to your education and gives you a better and brighter future.
Oracle Purchasing Fundamentals R12.x course is designed to give learners an overview of Oracle e-Business Suite Purchasing, including the basic functionality for requisitioning and purchasing.
To mastering MySQL, the world's most popular open source database, it is recommended to learn MySQL fundamentals before. Develop a solid understanding and practical experience using relational databases, SQL and the MySQL Server and tools. In this course. you will be introduced to the MySQL Cloud S...
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy