MonetDB Training Course

Course Code

monetdb

Duration

28 hours (usually 4 days including breaks)

Requirements

  • Basic knowledge in database systems and SQL
  • Programming experience with Java, C, PHP, or Python

Overview

MonetDB is an open-source database that pioneered the column-store technology approach.

In this instructor-led, live training, participants will learn how to use MonetDB and how to get the most value out of it.

By the end of this training, participants will be able to:

  • Understand MonetDB and its features
  • Install and get started with MonetDB
  • Explore and perform different functions and tasks in MonetDB
  • Accelerate the delivery of their project by maximizing MonetDB capabilities

Audience

  • Developers
  • Technical experts

Format of the course

  • Part lecture, part discussion, exercises and heavy hands-on practice

Course Outline

Introduction

Overview of MonetDB
    About MonetDB
    MonetDB Features

Installing MonetDB

Getting Started with MonetDB
    Learning the MonetDB SQL Reference Manual
        Understanding the Lexical Structure
        Exploring Data Types
        Implementing Data Definitions
        Performing Data Manipulation
        Programming SQL
        Executing Transactions
        Exploring Runtime Features
        Understanding Language Bindings
    Running through the MonetDB SQL System Catalog
        Schema, Table and Columns
        Functions, Arguments, Types
        Objects, Keys, Indices, Sequences
        Triggers, Dependencies
        Users, Roles, Privileges, Sessions
        QueryLog Catalog, Calls, History, Queue
        Optimizer Pipelines
        Environment Variables

Setting Up a MonetDB Database
    Creating a Database Using the MonetDB Daemon
    Starting and Stopping a Database Using the MonetDB Daemon
    Loading and Querying Data
    Performing Basic Configurations on a MonetDB Server
    
Interacting with a MonetDB Server
    Setting Up a Connection in SQuirrel SQL to a MonetDB Server
    Creating Database Schema
    Loading Database Data
    Browsing the Database
    Executing Analytical Queries
    Executing Updating Queries
    Backing Up and Restoring a Database
    
Using MonetDB from within an Application
    Setting Up a Connection to a MonetDB Server in Java
    Setting Up a Connection to a MonetDB Server in Python
    Setting Up a Connection to a MonetDB Server in PHP
    Using JDBC to Access the Database
    Using ODBC to Access the Database
    Understanding Optimistic Transaction Management

Using Client Interfaces in MonetDB

Implementing User-Defined Functions in MonetDB

Performing Cluster Management in MonetDB

Partitioning the Data in MonetDB

Performing Distributed Query Processing in MonetDB through Remote Tables

Sampling a Database in MonetDB

Migrating a Database in MonetDB

Inserting Bulk Data into an SQL Table in MonetDB

Exporting Bulk Data in MonetDB

Working with MonetDB/SQL Optimizer Pipelines

Timing Query Execution in MonetDB

Obtaining the Storage Footprint of a Database Schema in MonetDB

Monitoring the System in MonetDB

Working with Table Statistics in MonetDB

Using MonetDB's Date and Time Functionalities

Performing Transaction Replication in MonetDB

Using Lazy Logical Replication in MonetDB

Summary and Conclusion

Bookings, Prices and Enquiries

Guaranteed to run even with a single delegate!

Private Classroom

From £5000

Private Remote

From £4400 (98)

Public Classroom

Cannot find a suitable date? Choose Your Course Date >>Too expensive? Suggest your price

Course Discounts

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.