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

Testimonials

★★★★★

The trainer was so knowledgeable and included areas I was interested in.

Mohamed Salama

Course:Data Mining & Machine Learning with R

Very tailored to needs.

Yashan Wang

Course:Data Mining with R

I like the exercises done.

Nour Assaf

Course:Data Mining and Analysis

The hands-on exercise and the trainer capacity to explain complex topics in simple terms.

youssef chamoun

Course:Data Mining and Analysis

The information given was interesting and the best part was towards the end when we were provided with Data from Durex and worked on Data we are familiar with and perform operations to get results.

Jessica Chaar

Course:Data Mining and Analysis

I thought that the information was interesting.

Allison May

Course:Data Visualization

I really appreciated that Jeff utilized data and examples that were applicable to education data. He made it interesting and interactive.

Carol Wells Bazzichi

Course:Data Visualization

Learning about all the chart types and what they are used for. Learning the value of cluttering. Learning about the methods to show time data.

Susan Williams

Course:Data Visualization

Trainer was enthusiastic.

Diane Lucas

Course:Data Visualization

I really liked the content / Instructor.

Craig Roberson

Course:Data Visualization

I am a hands-on learner and this was something that he did a lot of.

Lisa Comfort

Course:Data Visualization

I liked the examples.

Peter Coleman

Course:Data Visualization

I liked the examples.

Peter Coleman

Course:Data Visualization

I enjoyed the good real world examples, reviews of existing reports.

Ronald Parrish

Course:Data Visualization

The example and training material were sufficient and made it easy to understand what you are doing.

Teboho Makenete

Course:Data Science for Big Data Analytics

Richard's training style kept it interesting, the real world examples used helped to drive the concepts home.

Jamie Martin-Royle - NBrown Group

Course:From Data to Decision with Big Data and Predictive Analytics

The content, as I found it very interesting and think it would help me in my final year at University.

Krishan Mistry - NBrown Group

Course:From Data to Decision with Big Data and Predictive Analytics

I really enjoyed the all the best.

Halil polat - Amazon Development Center Poland Sp. z o.o.

Course:Data Mining and Analysis

The trainer concentrated on the key topics.

Amazon Development Center Poland Sp. z o.o.

Course:Data Mining and Analysis

Expertise and huge knowledge of the trainer.

Amazon Development Center Poland Sp. z o.o.

Course:Data Mining and Analysis

I was benefit from the guidance and sharing life examples + answering all questions.

Marta Melloch - Amazon Development Center Poland Sp. z o.o.

Course:Data Mining and Analysis

I really enjoyed learning new and interesting things.

SIVECO Romania SA

Course:Data Mining

I was benefit from the good examples and opportunity to follow along.

Environmental and Climate Change Canada

Course:Foundation R

I genuinely enjoyed the hands passed exercises.

Yunfa Zhu - Environmental and Climate Change Canada

Course:Foundation R

The trainer was very concern about individual understanding.

Muhammad Surajo Sanusi - Birmingham City University

Course:Foundation R

Excellent presentation and it gives me confidence to build on knowledge gained.

Birmingham City University

Course:Foundation R

Background knowledge and 'provenance' of trainer.

Francis McGonigal - Birmingham City University

Course:Foundation R

Resources

Hafiz Rana - Birmingham City University

Course:Foundation R

Good explanations on how we do things

Birmingham City University

Course:Foundation R

I feel more confident with coding now. I've never done it before but now I understand that it's not rocket science and I can do it when necessary.

Anna Yartseva - Birmingham City University

Course:Foundation R

Related Categories

Related Courses

1980USD

is growing fast!

We are looking to expand our presence in Malaysia!

As a Business Development Manager you will:

expand business in Malaysia
recruit local talent (sales, agents, trainers, consultants)
recruit local trainers and consultants

We offer:

Artificial Intelligence and Big Data systems to support your local operation
high-tech automation
continuously upgraded course catalogue and content
good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!

MonetDB Training Course

Course Code

Duration

Requirements

Overview

Course Outline

Testimonials

Related Categories

Related Courses

Course Discounts

WorkFusion RPA Express for Intelligent Automation

Cyber Defence (SOC) Analyst Foundation

Big Data Business Intelligence for Criminal Intelligence Analysis

Digital Marketing

Chain Core: Issue Financial Assets on Permissioned Blockchain Infrastructure

Some of our clients

is growing fast!

As a Business Development Manager you will:

We offer:

MonetDB Training Course

Course Code

Duration

Requirements

Overview

Course Outline

Testimonials

Related Categories

Related Courses

Course Discounts

WorkFusion RPA Express for Intelligent Automation

Cyber Defence (SOC) Analyst Foundation

Big Data Business Intelligence for Criminal Intelligence Analysis

Digital Marketing

Chain Core: Issue Financial Assets on Permissioned Blockchain Infrastructure

Course Discounts Newsletter

Some of our clients

is growing fast!

As a Business Development Manager you will:

We offer: