NoSQL Addressing Data Management Challenges of Modern Applications

University of Technology Sydney

University of Technology Sydney

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Who should attend

This course is particularly relevant for IT professionals wishing to enhance their knowledge of database technology, in particular database developers and administrators involved in projects dealing with complex data.

About the course

This 2-day practical course covers advanced SQL features and NoSQL databases with particular focus on document databases. The course includes practical demonstrations and hands-on exercises using the Oracle DBMS and MongoDB.

About this course

Increases in the volume and complexity of data that organizations need to manage are challenging traditional approaches to data management. To address such challenges relational database implementations (e.g. Oracle, SQL Server) have been extended to include a range of advanced SQL features that support the management of complex data objects. More recently, a new generation of non-relational databases have emerged known under the umbrella term NoSQL. NoSQL databases include a diverse range of products designed to manage different types of data, in particular large-scale cloud databases. This practical course introduces key features of advanced SQL and NoSQL.

Course structure

Introduction

  • Challenges of managing complex data
  • Limitations of relational database technology

Advanced SQL

  • Large Objects
  • User Defined Types
  • Object Identifiers and References
  • Collections: Variable Arrays and Nested Tables
  • Object types and methods

Management of semi-structured data

  • XML and JSON data types

Overview of NoSQL databases

  • Document databases
  • Column databases
  • Graph databases
  • In-memory databases, etc.
  • NoSQL examples: MongoDB, Amazon DynamoDB, etc.

NoSQL concepts and techniques

  • Horizontal scalability and sharding
  • Schema-less data
  • CAP theorem
  • Data replication and BASE consistency

MongoDB architecture, features and tools

  • Instances,
  • Databases,
  • Collections
  • Documents and indexing,
  • CRUD operations
  • Tunable consistency
  • MongoDB on AWS
  • MongoDB Compass

Summary

  • SQL vs NoSQL- benefits and drawbacks
  • Future developments

Learning outcomes

  • Understand the requirements of modern database applications and the challenges of managing large volumes of semi-structured data
  • Apply advanced SQL features as implemented in Oracle DBMS
  • Understand the characteristics of different types of NoSQL databases and basic NoSQL concepts and techniques
  • Understand key MongoDB architecture and features
  • Understand the benefits and drawbacks of NoSQL and its suitability for specific application scenarios

Experts

George Feuerlicht

I am an Honorary Associate at the School of Software, Faculty of Engineering and Information Technology, UTS. I have been a senior lecturer at the School of Software specializing on database management and enterprise computing. I am the author of over 100 publications across a range of topics in ...

NoSQL Addressing Data Management Challenges of Modern Applications at University of Technology Sydney

This course has no confirmed dates in the future. Subscribe to be notified when it is offered.


Something went wrong. We're trying to fix this error.

Thank you

Someone from the Coursalytics team will be in touch with you soon.

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.

We are happy to help you find a suitable online alternative.