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 set of patterns (model). While this approach is effective for standardized data that is clearly understood in advance (for example, a hospital check-in application managing patient records with consistent, pre-defined fields such as patient ID, first name, last name, and date of last visit), the relational model has certain limitations. Organizations dealing with incoming data that is not well-defined (such as an online inquiry form for a startup experimenting with different fields to collect visitor data, adding or removing fields as the business evolves) may find that established definitions for how data fits into an existing database require frequent redefinition. This would necessitate recreating the data model (schema), which dictates data structure and allowed data types, to support various data inputs before any new data can be saved to the database.
Enter NoSQL (Not Only SQL) databases. NoSQL databases free users from the need to predefine the structure of 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. They also scale better than relational databases due to their ability to efficiently partition data across many servers (cluster) and load balance 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 set up, operate, and assess 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 versus relational databases
- Understand the underlying data formats used by NoSQL databases and how these formats can be leveraged to an 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 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.
Read more...
