課程代碼

memsql

課程時長

28 時間：同常來說包括休息是 4天

最低要求

Experience with Linux, relational database systems, and SQL platforms
Experience with Scala, Java, or Python programming

概觀

Mem SQL是一個用於雲和內部部署的內存中分佈式SQL數據庫管理系統。它是一個實時數據倉庫，可立即提供實時和歷史數據的洞察力。

在這個由講師指導的實時培訓中，參與者將學習Mem SQL的基本知識，以便進行開發和管理。

在培訓結束時，參與者將能夠：

了解Mem SQL的關鍵概念和特徵
安裝，設計，維護和操作Mem SQL
優化Mem SQL模式
改進Mem SQL查詢
Mem SQL基準性能
使用Mem SQL構建實時數據應用程序

聽眾

開發商
管理員
運營工程師

課程形式

部分講座，部分討論，練習和繁重的實踐練習

Machine Translated

課程簡介

Introduction

Overview of MemSQL

Understanding the MemSQL Architecture

Quick Start with MemSQL Using MemSQL Ops

Understanding Essential MemSQL Concepts

Overview of MemSQL Commands
Working with Rowstore and Columnstore
Implementing Data Distribution
Using Shard Keys
Implementing Distributed Joins
Using Reference Tables
Understanding Application Cluster Topologies

Installing and Upgrading MemSQL

Designing a Cluster
Doing Manual Installation
Expanding a Cluster
Implementing an Upgrade
Securing MemSQL

Working with Schema Design and Query Optimization

Working with Transactions
Working with Geospatial Data
Understanding Index Types
Using Sparsity and Normalized Forms
Hands-on: Using a Reference Table to Query JSON with Variant Array Lengths
Working with Shard Key Strategies
Identifying a Sharding Strategy
Understanding Analyze, Explain, and Profile
Implementing Schema Optimization for Query Performance
Using Query Hints

Diving Deep into Administering MemSQL Operations

Using the MemSQL Ops Command Line Interface
Administering a Cluster
Understanding Administrator Key Concepts
Backing Up and Restoring Data
Scaling Cluster Size
Dealing with Cluster Failures
Managing High Availability
Monitoring MemSQL
Working with the Trace Log
Using Durability and Recovery
Running Diagnostics

Working with MemSQL Procedural SQL (MPSQL)

Using Table-Valued Functions
Using User-Defined Functions
Using User-Defined Aggregate Functions
Using Stored Procedures

Implementing Performance Benchmarking and Fine-Tuning

Using Experimental Metrics
Performance Testing with dbbench
Hands-on: Working with a Database Workload Generator
Using Management Views
Implementing Workload Profiling
Hands-on: MemSQL Top

Working with MemSQL Pipelines and Real-Time Data Ingestion

Using the MemSQL Connector for Apache Spark
Using MemSQL Pipelines with Apache Kafka and AWS S3

Creating Real-Time Applications

Working with Business Intelligence Dashboards
Using MemSQL Pipelines for Machine Learning
Implementing a Real-Time Dashboard
Implementing Predictive Analytics

Troubleshooting MemSQL

Summary and Conclusion

客戶評論

★★★★★

我真的受益於培訓師願意分享更多。

Balaram Chandra Paul

課程:A Practical Introduction to Data Analysis and Big Data

Machine Translated

我從一些新的有趣的想法中受益。與其他與會者會面並互動。

TECTERRA

課程:IoT ( Internet of Things) for Entrepreneurs, Managers and Investors

Machine Translated

它涵蓋了廣泛的信息。

Continental AG / Abteilung: CF IT Finance

課程:A Practical Introduction to Data Analysis and Big Data

Machine Translated

我通常從技術的介紹中受益。

Continental AG / Abteilung: CF IT Finance

課程:A Practical Introduction to Data Analysis and Big Data

Machine Translated

整體而言，內容很好。

Sameer Rohadia

課程:A Practical Introduction to Data Analysis and Big Data

Machine Translated

Hadoop生態系統

Adnan Rafiq

課程:Big Data Business Intelligence for Govt. Agencies

Machine Translated

邁克爾培訓師對大數據和R的主題非常了解和熟練。他非常靈活，能夠快速定制滿足客戶需求的培訓。他也非常有能力在旅途中解決技術和主題問題。神奇而專業的訓練！

Xiaoyuan Geng - Ottawa Research and Development Center, Science Technology Branch, Agriculture and Agri-Food Canada

課程:Programming with Big Data in R

Machine Translated

我非常喜歡推出新包裝。

Ottawa Research and Development Center, Science Technology Branch, Agriculture and Agri-Food Canada

課程:Programming with Big Data in R

Machine Translated

導師Michael Yan先生很好地與觀眾互動，指導很明確。導師還可以根據培訓期間學生的要求添加更多信息。

Ottawa Research and Development Center, Science Technology Branch, Agriculture and Agri-Food Canada

課程:Programming with Big Data in R

Machine Translated

主題和節奏是完美的。

Tim - Ottawa Research and Development Center, Science Technology Branch, Agriculture and Agri-Food Canada

課程:Programming with Big Data in R

Machine Translated

示例和培訓材料足以讓您輕鬆了解自己在做什麼。

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

動手練習有利於我們欣賞Talent的能力和特徵。

Iverson Associates Sdn Bhd

課程:Talend Open Studio for Data Integration

Machine Translated

我最喜歡動手訓練。

Muraly Muniandy - Iverson Associates Sdn Bhd

課程:Talend Open Studio for Data Integration

Machine Translated

我喜歡教練的知識和靈活性，稍微偏離課程主題。

Iverson Associates Sdn Bhd

課程:Talend Open Studio for Data Integration

Machine Translated

我喜歡關於主題的豐富知識和經驗。

Iverson Associates Sdn Bhd

課程:Talend Open Studio for Data Integration

Machine Translated

我一般都喜歡費爾南多的知識。

Valentin de Dianous - Informatique ProContact INC.

課程:Big Data Architect

Machine Translated

有關全域變數和使用自己函數的功能的資訊。

EduBroker Sp. z o.o.

課程:Talend Open Studio for Data Integration

Machine Translated

實際任務

EduBroker

課程:Talend Open Studio for Data Integration

Machine Translated

練習

EduBroker

課程:Talend Open Studio for Data Integration

Machine Translated

實際做的事情，理論也得到了Ajay的好評

Dominik Mazur - Capgemini Polska Sp. z o.o.

課程:Hadoop Administration on MapR

Machine Translated

演習

Capgemini Polska Sp. z o.o.

課程:Hadoop Administration on MapR

Machine Translated

受試者的廣泛報導

Roche

課程:Big Data Storage Solution - NoSQL

Machine Translated

課程分類

￥22030

is growing fast!

We are looking to expand our presence in Taiwan!

As a Business Development Manager you will:

expand business in Taiwan
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!

MemSQL培訓

課程代碼

課程時長

最低要求

概觀

課程簡介

客戶評論

課程分類

相關課程

促銷課程

ELK: Elasticsearch, Logstash and Kibana for Administrators

Artificial Intelligence Overview

Blockchain Development with Coinbase

Zeppelin for Interactive Data Analytics

Signavio Process Manager

我們的客戶

is growing fast!

As a Business Development Manager you will:

We offer:

MemSQL培訓

課程代碼

課程時長

最低要求

概觀

課程簡介

客戶評論

課程分類

相關課程

促銷課程

ELK: Elasticsearch, Logstash and Kibana for Administrators

Artificial Intelligence Overview

Blockchain Development with Coinbase

Zeppelin for Interactive Data Analytics

Signavio Process Manager

訂閱促銷課程

我們的客戶

is growing fast!

As a Business Development Manager you will:

We offer: