课程编码

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

实例演习; 实际工作经验分享

澳新银行

课程:Data Vault：构建可扩展的数据仓库

老师对数据仓库的知识很全面，赞！

澳新银行

课程:Data Vault：构建可扩展的数据仓库

老师讲解细致, 讨论气氛融洽

澳新银行

课程:Data Vault：构建可扩展的数据仓库

示例和培训材料足以让您轻松了解自己在做什么。

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

课程分类

我们的客户

is growing fast!

We are looking to expand our presence in China!

As a Business Development Manager you will:

expand business in China
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培训

课程编码

课程时长

要求

课程概览

课程大纲

客户评论

课程分类

相关课程

促销课程

Docker管理与开发集成

Automation Anywhere for End Users

Automation Anywhere for End Users

Docker和Kubernetes：构建和缩放容器化应用程序

Kubernetes：基础到高级

Docker (introducing Kubernetes)

我们的客户

is growing fast!

As a Business Development Manager you will:

We offer:

MonetDB培训

课程编码

课程时长

要求

课程概览

课程大纲

客户评论

课程分类

相关课程

促销课程

Docker管理与开发集成

Automation Anywhere for End Users

Automation Anywhere for End Users

Docker和Kubernetes：构建和缩放容器化应用程序

Kubernetes：基础到高级

Docker (introducing Kubernetes)

订阅促销课程

我们的客户

is growing fast!

As a Business Development Manager you will:

We offer: