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.
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.
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.
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
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.
This course will teach the basics of Microsoft’s dialect of the standard SQL language
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy