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
Testimonials
I really enjoyed learning new and interesting things.
- SIVECO Romania SA
The content, as I found it very interesting and think it would help me in my final year at University.
Krishan Mistry - NBrown Group
Richard's training style kept it interesting, the real world examples used helped to drive the concepts home.
Jamie Martin-Royle - NBrown Group
very tailored to needs
Yashan Wang
I was benefit from the guidance and sharing life examples + answering all questions.
Marta Melloch - Amazon Development Center Poland Sp. z o.o.
Expertise and huge knowledge of the trainer.
- Amazon Development Center Poland Sp. z o.o.
The trainer concentrated on the key topics.
- Amazon Development Center Poland Sp. z o.o.
I really enjoyed the all the best.
Halil polat - Amazon Development Center Poland Sp. z o.o.
The information given was interesting and the best part was towards the end when we were provided with Data from Murex and worked on Data we are familiar with and perform operations to get results.
Jessica Chaar
The hands on exercise and the trainer capacity to explain complex topics in simple terms
youssef chamoun
I like the exercices done
Nour Assaf
The trainer was so knowledgeable and included areas I was interested in
Mohamed Salama
Good real world examples, reviews of existing reports
Ronald Parrish
The examples.
Peter Coleman
I liked the examples.
Peter Coleman
I am a hands-on learner and this was something that he did a lot of.
Lisa Comfort
Trainer was enthusiastic.
Diane Lucas
Learning about all the chart types and what they are used for. Learning the value of decluttering. Learning about the methods to show time data.
Susan Williams
I really appreciated that Jeff utilized data and examples that were applicable to education data. He made it interesting and interactive.
Carol Wells Bazzichi
I thought that the information was interesting.
Allison May
Intensity, Training materials and expertise, Clarity, Excellent communication with Alessandra
Marija Hornis Dmitrovic - Marija Hornis
The example and training material were sufficient and made it easy to understand what you are doing
Teboho Makenete
That we could do so many things by ourselves and really dive into the application of the theoretical knowledge
Techniker Krankenkasse
I learned a lot - not only in theoretical knowledge but I also applied that knowledge during the training and therefore I really understood what process mining is and how it works. Thanks a lot!
Julia Dörre - Techniker Krankenkasse
Exercises and quiz
Techniker Krankenkasse
There was a lot of exercises - I like it.
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.
A lot of execises
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.
Open discussion with trainer
Tomek Danowski - GE Medical Systems Polska Sp. Z O.O.
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.
how the trainor shows his knowledge in the subject he's teachign
john ernesto ii fernandez - Philippine AXA Life Insurance Corporation
The Topic
Accenture Inc.
There was a small group, Charlie was very knowledgeable and had a good rapport with us. She was responsive to our questions
Dr Alasdair Gordon-Finlayson, University of Northampton
Lots of signposting beyond the basic R foundations content, Charlie has given me a lot of good ideas for where I need to go next and what I need to engage with to continue to improve my R fluency.
Dr Alasdair Gordon-Finlayson, University of Northampton
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
Good explanations on how we do things
- Birmingham City University
Background knowledge and 'provenance' of trainer.
Francis McGonigal - Birmingham City University
Excellent presentation and it gives me confidence to build on knowledge gained.
- Birmingham City University
The trainer was very concern about individual understanding.
Muhammad Surajo Sanusi - Birmingham City University
I genuinely enjoyed the hands passed exercises.
Yunfa Zhu - Environmental and Climate Change Canada
I was benefit from the good examples and opportunity to follow along.
- Environmental and Climate Change Canada
Very useful in because it helps me understand what we can do with the data in our context. It will also help me