Plan Szkolenia
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
Wymagania
- Basic knowledge in database systems and SQL
- Programming experience with Java, C, PHP, or Python
Opinie uczestników (10)
Forma przekazania wiedzy poprzez dokładne wyjaśnienie zagadnienia.
Katarzyna Stańczak - Mowi Poland SA
Szkolenie - Data Mining and Analysis
Że trener miał mnóstwo cierpienia do nas, skoro przerywaliśmy go pytaniami co chwili.
Oleksandr Muliar - Bank Gospodarstwa Krajowego
Szkolenie - Pentaho Data Integration (PDI) - moduł do przetwarzania danych ETL (poziom zaawansowany)
Przykłady wzbogacane danymi rzeczywistymi i scenariuszami przydatnymi w codziennej praktyce
Krzysztof Świątczak
Szkolenie - Pentaho Business Intelligence (PBI) - moduły raportowe
The content, as I found it very interesting and think it would help me in my final year at University.
Krishan - NBrown Group
Szkolenie - From Data to Decision with Big Data and Predictive Analytics
very tailored to needs
Yashan Wang
Szkolenie - Data Mining with R
The trainer was so knowledgeable and included areas I was interested in
Mohamed Salama
Szkolenie - Data Mining & Machine Learning with R
Good real world examples, reviews of existing reports
Ronald Parrish
Szkolenie - Data Visualization
Intensity, Training materials and expertise, Clarity, Excellent communication with Alessandra
Marija Hornis Dmitrovic - Marija Hornis
Szkolenie - Data Science for Big Data Analytics
I learned a lot - not only in theoretical knowledge but I also applied that knowledge during the training and therefore I really understood what process mining is and how it works. Thanks a lot!
Julia Dörre - Techniker Krankenkasse
Szkolenie - Process Mining
how the trainor shows his knowledge in the subject he's teachign