Relational databases have long been the preferred technology for storing, retrieving, and querying data. They enable users to organize information using a structured, well-defined pattern (model). While this approach is effective for standardized data that is clearly understood beforehand (such as a hospital check-in system maintaining patient records with consistent, pre-defined fields like patient ID, first name, last name, and date of last visit), it has limitations. For organizations dealing with loosely defined incoming data (such as an online inquiry form for a startup experimenting with different fields to collect visitor data, constantly adding or removing fields to adapt to business needs), establishing rigid definitions for how data fits into an existing database becomes problematic. This would necessitate frequent redefinition of the data model (schema) that governs the data structure and allowed data types to support various data inputs, among other issues, before any new data could be saved.
Enter NoSQL (Not Only SQL) databases. NoSQL databases liberate users from the need to predefine the structure of incoming data, allowing them to insert and update new data dynamically. NoSQL databases are typically faster than relational databases and can manage vast amounts of data effortlessly. They also scale more effectively than relational databases due to their ability to efficiently partition data across multiple servers (clusters) and balance the load of data access. NoSQL databases integrate particularly well with applications supporting real-time analytics, site personalization, IoT, and mobile apps.
In this instructor-led live training, participants will gain an understanding of the architecture, design principles, and functionality of the most popular NoSQL databases as they set up, operate, and assess various NoSQL databases in a live lab environment. The goal of this training is to equip participants with the ability 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 compared to relational databases
- Understand the underlying data formats used by NoSQL databases and how these formats can be leveraged to advantage when developing modern applications (desktop, mobile, cloud, IoT)
- Perform create, insert, update, and delete operations in a NoSQL database
- Set up a mixed environment with both a relational database and NoSQL working in tandem
- Configure a cluster of NoSQL databases 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.
Read more...