MonetDB Treningskurs

Last updated

Kurskode

monetdb

Varighet

28 timer (vanligvis 4 dag inkludert pauser)

Krav

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

Oversikt

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

Kursplan

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

★★★★★
★★★★★

Related Categories

Relaterte kurs

Kursrabatter

Kursrabatter Nyhetsbrev

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.

Some of our clients

is growing fast!

We are looking to expand our presence in Norway!

As a Business Development Manager you will:

  • expand business in Norway
  • 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!

This site in other countries/regions