MemSQL培训

课程编码

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

客户评论

★★★★★
★★★★★

课程分类

相关课程

促销课程

订阅促销课程

为尊重您的隐私,我公司不会把您的邮箱地址提供给任何人。您可以享有优先权和随时取消订阅的权利。

我们的客户

is growing fast!

We are looking to expand our presence in China!

As a Business Development Manager you will:

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

该网站在其他国家/地区