|
MonetDB培训 |
|
班级规模及环境--热线:4008699035 手机:15921673576( 微信同号) |
坚持小班授课,为保证培训效果,增加互动环节,每期人数限3到5人。 |
上课时间和地点 |
开课地址:【上海】同济大学(沪西)/新城金郡商务楼(11号线白银路站)【深圳分部】:电影大厦(地铁一号线大剧院站) 【武汉分部】:佳源大厦【成都分部】:领馆区1号【沈阳分部】:沈阳理工大学【郑州分部】:锦华大厦【石家庄分部】:瑞景大厦【北京分部】:北京中山 【南京分部】:金港大厦
新开班 (连续班 、周末班、晚班):2024年12月30日......(欢迎您垂询,视教育质量为生命!) |
实验设备 |
☆资深工程师授课
☆注重质量
☆边讲边练
☆合格学员免费推荐工作
★实验设备请点击这儿查看★ |
质量保障 |
1、培训过程中,如有部分内容理解不透或消化不好,可免费在以后培训班中重听;
2、课程完成后,授课老师留给学员手机和Email,保障培训效果,免费提供半年的技术支持。
3、培训合格学员可享受免费推荐就业机会。 |
课程大纲 |
|
- 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
|
|
|
|
|
|