MonetDB는 컬럼 스토어 기술 접근법을 개척 한 오픈 소스 데이터베이스입니다 강사진이 진행되는이 교육 과정에서 참가자들은 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
.png "aeronautical radio, incorporated (arinc)")
_ireland.gif "environmental protection agency (epa) ireland")
.jpg "european southern observatory (eso)")
