Cursos de MemSQL

Nossos Clientes

Código do Curso

memsql

Duration

28 hours (usually 4 days including breaks)

Requisitos

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

Overview

,

Machine Translated

Programa do Curso

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

Declaração de Clientes

★★★★★
★★★★★

Categorias Relacionadas

Descontos em Cursos

Boletim Informativo de Descontos

Nós respeitamos a privacidade dos seus dados. Nós não vamos repassar ou vender o seu email para outras empresas.
Você sempre poderá editar as suas preferências ou cancelar a sua inscriçāo.

is growing fast!

We are looking to expand our presence in Brazil!

As a Business Development Manager you will:

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