Relational databases have long been the technology of choice for storing, retrieving, and querying data. They allow users to organise their data using a structured, well-defined set of patterns (model). While this approach works well for standardised, well-understood data (think of a hospital check-in application holding patient records with consistent, pre-defined fields such as patient ID, first name, last name, date of last visit, etc.), it has limitations. For organisations whose incoming data is not well-defined (such as an online inquiry form for a startup still experimenting with different fields to collect visitor data, adding or removing fields as the business evolves), any established definitions of how data should fit into an existing database would need to be regularly redefined. This would require recreating the data model (schema) that dictates the structure of the data and its allowed data types to support various input types before any new data could be saved.
Enter NoSQL (Not Only SQL) databases. NoSQL databases free users from having 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 volumes of data with ease. They also scale better than relational databases, thanks to their ability to efficiently partition data across many servers (clusters) and load-balance access to this data. NoSQL databases integrate particularly well with applications supporting real-time analytics, site personalisation, IoT, and mobile apps.
In this instructor-led, live training, participants will explore the architecture, design principles, and functionality of the most popular NoSQL databases as they set up, operate, and assess a range 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 organisation.
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 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 a NoSQL database 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 into their applications
Format of the Course
- Part lecture, part discussion, exercises, and extensive hands-on practice
Note
- To request a customised training session for this course, please contact us to arrange.
Read more...