課程代碼

monetdb

課程時長

28 時間：同常來說包括休息是 4天

最低要求

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

概觀

MonetDB是一個開源數據庫，是列存儲技術方法的先驅。

在這個由講師指導的實時培訓中，參與者將學習如何使用MonetDB以及如何從中獲取最大價值。

在培訓結束時，參與者將能夠：

了解MonetDB及其功能
安裝並開始使用MonetDB
在MonetDB中探索並執行不同的功能和任務
通過最大化MonetDB功能來加速項目的交付

聽眾

開發商
技術專家

課程形式

部分講座，部分討論，練習和繁重的實踐練習

Machine Translated

課程簡介

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

客戶評論

★★★★★

培訓師知識淵博，包括我感興趣的領域。

Mohamed Salama

課程:Data Mining & Machine Learning with R

Machine Translated

非常適合需求。

Yashan Wang

課程:Data Mining with R

Machine Translated

我喜歡做的練習。

Nour Assaf

課程:Data Mining and Analysis

Machine Translated

動手練習和培訓師能夠用簡單的術語解釋複雜的主題。

youssef chamoun

課程:Data Mining and Analysis

Machine Translated

所提供的信息很有意思，最好的部分是在我們從Durex獲得數據並且處理我們熟悉的數據並執行操作以獲得結果時。

Jessica Chaar

課程:Data Mining and Analysis

Machine Translated

我認為這些信息很有趣。

Allison May

課程:Data Visualization

Machine Translated

我非常感謝Jeff使用了適用於教育數據的數據和示例。他使它變得有趣和互動。

Carol Wells Bazzichi

課程:Data Visualization

Machine Translated

了解所有圖表類型及其用途。學習混亂的價值。了解顯示時間數據的方法。

Susan Williams

課程:Data Visualization

Machine Translated

培訓師很熱情。

Diane Lucas

課程:Data Visualization

Machine Translated

我真的很喜歡內容/講師。

Craig Roberson

課程:Data Visualization

Machine Translated

我是一名實踐學習者，這是他做了很多的事情。

Lisa Comfort

課程:Data Visualization

Machine Translated

我喜歡這些例子。

Peter Coleman

課程:Data Visualization

Machine Translated

我通常從這些例子中受益。

Peter Coleman

課程:Data Visualization

Machine Translated

我喜歡現實世界的好例子，對現有報導的評論。

Ronald Parrish

課程:Data Visualization

Machine Translated

示例和培訓材料足以讓您輕鬆了解自己在做什麼。

Teboho Makenete

課程:Data Science for Big Data Analytics

Machine Translated

理查德的訓練風格讓它變得有趣，所使用的真實世界的例子有助於將概念帶回家。

Jamie Martin-Royle - NBrown Group

課程:From Data to Decision with Big Data and Predictive Analytics

Machine Translated

內容，因為我覺得非常有趣，並認為這將有助於我在大學的最後一年。

Krishan Mistry - NBrown Group

課程:From Data to Decision with Big Data and Predictive Analytics

Machine Translated

我真的很享受所有最好的。

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

課程:Data Mining and Analysis

Machine Translated

培訓師集中討論了關鍵的話題。

Amazon Development Center Poland Sp. z o.o.

課程:Data Mining and Analysis

Machine Translated

培訓師的專業知識和豐富的知識。

Amazon Development Center Poland Sp. z o.o.

課程:Data Mining and Analysis

Machine Translated

我從指導和分享生活例子 + 回答所有問題中受益。

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

課程:Data Mining and Analysis

Machine Translated

我真的很喜歡學習新的和有趣的東西。

SIVECO Romania SA

課程:Data Mining

Machine Translated

我從良好的榜樣和效仿的機會中受益。

Environmental and Climate Change Canada

課程:Foundation R

Machine Translated

我真的很喜歡通過練習的手。

Yunfa Zhu - Environmental and Climate Change Canada

課程:Foundation R

Machine Translated

教練員非常關心個人的理解。

Muhammad Surajo Sanusi - Birmingham City University

課程:Foundation R

Machine Translated

Excel借出演示文稿，它讓我有信心在所獲得的知識基礎上進行。

Birmingham City University

課程:Foundation R

Machine Translated

背景知識和培訓師的“出處”。

Francis McGonigal - Birmingham City University

課程:Foundation R

Machine Translated

資源

Hafiz Rana - Birmingham City University

課程:Foundation R

Machine Translated

Go對我們如何做的事情OD解釋

Birmingham City University

課程:Foundation R

Machine Translated

我現在對編碼更有信心。我以前從未這樣做過，但現在我明白這不是火箭科學，我可以在必要的時候做到。

Anna Yartseva - Birmingham City University

課程:Foundation R

Machine Translated

課程分類

￥22030

is growing fast!

We are looking to expand our presence in Taiwan!

As a Business Development Manager you will:

expand business in Taiwan
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培訓

課程代碼

課程時長

最低要求

概觀

課程簡介

客戶評論

課程分類

相關課程

促銷課程

ELK: Elasticsearch, Logstash and Kibana for Administrators

Artificial Intelligence Overview

Blockchain Development with Coinbase

Zeppelin for Interactive Data Analytics

Signavio Process Manager

我們的客戶

is growing fast!

As a Business Development Manager you will:

We offer:

MonetDB培訓

課程代碼

課程時長

最低要求

概觀

課程簡介

客戶評論

課程分類

相關課程

促銷課程

ELK: Elasticsearch, Logstash and Kibana for Administrators

Artificial Intelligence Overview

Blockchain Development with Coinbase

Zeppelin for Interactive Data Analytics

Signavio Process Manager

訂閱促銷課程

我們的客戶

is growing fast!

As a Business Development Manager you will:

We offer: