cart Cart
Your cart
Your cart is empty

Browse courses to find something that interests you.

Register search
Enter to search / ESC to close
loading
SHORT COURSE

NoSQL: Addressing data management challenges of modern applications

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

 

Any questions about the course or what to expect on the day? 

Looking for different dates or a similar course?

Who is this course for?

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.

$1,900.00

START DATE

20 October

MODE

On-campus

DURATION

2 days

Meet the Expert

Dr George Feuerlicht

Dr George Feuerlicht
Dr George Feuerlicht

Dr George Feuerlicht has been researching and publishing on cloud computing developments for over a decade, and has presented seminars and professional development courses in Australia, Europe, Asia and the USA. George is the author of over 100 publications across a range of topics in computer science and holds a PhD from Imperial College London.

More Less

Book a session

Tue 20 Oct 2020 -
Wed 21 Oct 2020
Expert: Dr George Feuerlicht
  • 20-21 October 2020, 9am-5:00pm | UTS City Campus
  • On-campus

Course added to your cart

close

Warning!

close
We use cookies

We use cookies to help personalise content, tailor and measure ads, plus provide a safer experience. By navigating the site, you agree to the use of cookies to collect information. Read our Cookie Policy to learn more.

loading