No SQL Databases intensive course

Course in InSIS – 4IT370
Date: 22-24 May 2023, exam – 26 May
3 ECTS
Registrations: are open from March 2 to April 30

Dr George Feuerlicht is an Associate Professor at the Department of Information Technologies at the Unicorn University and a visiting lecturer at the Prague University of Economics and Business. George has been involved in database research and teaching for over three decades. He has presented seminars and professional development courses in Australia, Europe, Asia and USA. He is the author of over 100 publications across a range of topics in computer science. He holds a PhD in Electrical Engineering from the Imperial College, London University, U.K.

Large volumes and complexity of data that organizations manage today is challenging traditional approaches to data management. To address such challenges relational databases have introduced a range of advanced features that support the management of complex data objects at scale. More recently, a new generation of non-relational databases known as NoSQL have emerged. NoSQL databases include a diverse range of products designed to manage large volumes of different types of data using cloud infrastructure. In this 3-day course we discuss the motivation for NoSQL and then cover a range of advanced database techniques with practical demonstrations and hands-on exercises using leading NoSQL databases, including MongoDB and Neo4J.

Course Content

• Introduction: Data management challenges, benefits and limitations of relational databases
• Advanced SQL features: User Defined Types, Collections, Object types and methods, etc.
• Management of semi-structured data: XML and JSON data types, XQuery
• Overview of NoSQL databases: Document databases, Column databases, Graph databases, Data Lakes, In-memory databases, etc.
• NoSQL concepts and techniques: horizontal scalability and sharding, schema-less data, CAP theorem, data replication and BASE consistency
• NoSQL databases: MongoDB, Neo4j, , etc.
• AWS database services: Amazon DynamoDB, AWS Athena, etc.
• Summary: SQL vs NoSQL- benefits and drawbacks, future developments
• Practical hand-on exercises using a selection of NoSQL database