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

Requirements

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

Need help picking the right course?
Call us +971 4871 6715

Testimonials

the scope of material

Maciej Jonczyk

systematizing knowledge in the field of ML

Orange Polska

A lot of issues that can be explored after the training

Klaudia Kłębek

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

Mohamed Salama

Very tailored to needs.

Yashan Wang

I like the exercises done.

Nour Assaf

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

youssef chamoun

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

I thought that the information was interesting.

Allison May

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

Carol Wells Bazzichi

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

Trainer was enthusiastic.

Diane Lucas

I really liked the content / Instructor.

Craig Roberson

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

Lisa Comfort

I liked the examples.

Peter Coleman

I liked the examples.

Peter Coleman

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

Ronald Parrish

Example exercises; Practical work experience sharing

澳新银行

Cube and DV

Alan Xie

The teacher's knowledge of the data warehouse is comprehensive, and he praises it!

澳新银行

The teacher explained in detail and discussed the atmosphere

澳新银行

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

Teboho Makenete

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

Jamie Martin-Royle - NBrown Group

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

Krishan Mistry - NBrown Group

Practical application, help in explaining many different doubts

- SGB-Bank S.A.

The capacitance of the tool

Gerardo Avila - Reckitt Benckizer

Learning a new tool

MARIA ELENA DOMINGUEZ ESCUDERO - Reckitt Benckizer

I really enjoyed the all the best.

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

The trainer concentrated on the key topics.

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

Expertise and huge knowledge of the trainer.

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

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

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

I really enjoyed learning new and interesting things.

- SIVECO Romania SA

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

- Environmental and Climate Change Canada

I genuinely enjoyed the hands passed exercises.

Yunfa Zhu - Environmental and Climate Change Canada

The trainer was very concern about individual understanding.

Muhammad Surajo Sanusi - Birmingham City University

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

- Birmingham City University

Background knowledge and 'provenance' of trainer.

Francis McGonigal - Birmingham City University

Resources

Hafiz Rana - Birmingham City University

Good explanations on how we do things

- Birmingham City University

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

The Topic

Accenture Inc.

Very well transferred knowledge by the teacher. No unanswered questions.

Karolin Papaj - Mowi Poland SA

Intensity, Training materials and expertise, Clarity, Excellent communication with Alessandra

Marija Hornis Dmitrovic - Marija Hornis

Very useful in because it helps me understand what we can do with the data in our context. It will also help me

Nicolas NEMORIN - Adecco Groupe France

A lot of exercises, trainer was always helping us and giving the solution, he was always answering our questions & explaining our doubts. The trainer was also always checking with us about the break we would like to take etc.

GE Medical Systems Polska Sp. Z O.O.

open discussion with trainer

Tomek Danowski - GE Medical Systems Polska Sp. Z O.O.

The way it was conducted, the way trainer keeps contact with audience, materials, everything was really good!

Marcin Prewo - GE Medical Systems Polska Sp. Z O.O.

a lot of execises

GE Medical Systems Polska Sp. Z O.O.

Lots of practice during the training and quizzes were useful and made it more interactive

Valter Pinho - GE Medical Systems Polska Sp. Z O.O.

There was a lot of exercises - I like it.

GE Medical Systems Polska Sp. Z O.O.

Related Courses

From Data to Decision with Big Data and Predictive Analytics

 21 hours

Audience If you try to make sense out of the data you have access to or want to analyse unstructured data available on the net (like Twitter, Linked in, etc...) this course is for you. It is mostly aimed at decision makers and people who need to

Data Mining and Analysis

 28 hours

Objective: Delegates be able to analyse big data sets, extract patterns, choose the right variable impacting the results so that a new model is forecasted with predictive

Data Mining

 21 hours

Course can be provided with any tools, including free open-source data mining software and applications

Data Mining with R

 14 hours

R is an open-source free programming language for statistical computing, data analysis, and graphics. R is used by a growing number of managers and data analysts inside corporations and academia. R has a wide variety of packages for data

Oracle SQL Intermediate - Data Extraction

 14 hours

The objective of the course is to enable participants to gain a mastery of how to work with the SQL language in Oracle database for data extraction at intermediate level.

Introductory R for Biologists

 28 hours

R is an open-source free programming language for statistical computing, data analysis, and graphics. R is used by a growing number of managers and data analysts inside corporations and academia. R has also found followers among

Statistics with SPSS Predictive Analytics Software

 14 hours

Goal: Learning to work with SPSS at the level of independence The addressees: Analysts, researchers, scientists, students and all those who want to acquire the ability to use SPSS package and learn popular data mining

Data Vault: Building a Scalable Data Warehouse

 28 hours

Data Vault Modeling is a database modeling technique that provides long-term historical storage of data that originates from multiple sources. A data vault stores a single version of the facts, or "all the data, all the time". Its

Data Visualization

 28 hours

This course is intended for engineers and decision makers working in data mining and knoweldge discovery. You will learn how to create effective plots and ways to present and represent your data in a way that will appeal to the decision makers

Foundation R

 7 hours

The objective of the course is to enable participants to gain a mastery of the fundamentals of R and how to work with data.

Data Mining & Machine Learning with R

 14 hours

R is an open-source free programming language for statistical computing, data analysis, and graphics. R is used by a growing number of managers and data analysts inside corporations and academia. R has a wide variety of packages for data

Data Science for Big Data Analytics

 35 hours

Big data is data sets that are so voluminous and complex that traditional data processing application software are inadequate to deal with them. Big data challenges include capturing data, data storage, data analysis, search, sharing, transfer,

Knowledge Discovery in Databases (KDD)

 21 hours

Knowledge discovery in databases (KDD) is the process of discovering useful knowledge from a collection of data. Real-life applications for this data mining technique include marketing, fraud detection, telecommunication and manufacturing. In

KNIME Analytics Platform for BI

 21 hours

KNIME Analytics Platform is a leading open source option for data-driven innovation, helping you discover the potential hidden in your data, mine for fresh insights, or predict new futures. With more than 1000 modules, hundreds of ready-to-run

Process Mining

 21 hours

Process mining, or Automated Business Process Discovery (ABPD), is a technique that applies algorithms to event logs for the purpose of analyzing business processes. Process mining goes beyond data storage and data analysis; it bridges data with