MonetDB är en opensource-databas som pionjerar kolumnteknologin I denna instruktionsledda, levande träning kommer deltagarna att lära sig hur man använder MonetDB och hur man får mest ut av det Vid slutet av denna utbildning kommer deltagarna att kunna: Förstå MonetDB och dess funktioner Installera och börja med MonetDB Utforska och utför olika funktioner och uppgifter i MonetDB Accelerera leveransen av sitt projekt genom att maximera MonetDB-kapacitet Publik utvecklare Tekniska experter Kursens format Delföreläsning, diskussion, övningar och tung handson-övning .
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
.jpg "procter & gamble (p&g)")
.png "european central bank (ecb)")
.png "european space agency (esa)")
.jpg "international air transport association (iata)")
.jpg "european southern observatory (eso)")
