MemSQL Treningskurs

  1. Big Data Trening
  2. Data Warehouse Trening
  3. MemSQL Treningskurs

Kurskode

memsql

Varighet

28 timer (vanligvis 4 dag inkludert pauser)

Krav

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

Oversikt

Mem SQL er et internt, distribuert, SQL databasesystem for sky og lokale. Det er et datalager i sanntid som umiddelbart leverer innsikt fra levende og historiske data.

I denne instruktørledede, liveopplæringen, vil deltakerne lære det vesentlige av Mem SQL for utvikling og administrasjon.

Ved slutten av denne opplæringen vil deltakerne kunne:

  • Forstå nøkkelbegrepene og egenskapene til Mem SQL
  • Installere, designe, vedlikeholde og betjene Mem SQL
  • Optimaliser skjemaer i Mem SQL
  • Forbedre spørsmål i Mem SQL
  • Benchmark-ytelse i Mem SQL
  • Bygg dataprogrammer i sanntid ved hjelp av Mem SQL

Publikum

  • Utviklere
  • administratorer
  • Operasjonsingeniører

Kursets format

  • Delforelesning, deldiskusjon, øvelser og tung praktisk øvelse

Machine Translated

Kursplan

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

Testimonials

★★★★★
★★★★★

Related Categories

Relaterte kurs

Aerospike for DevelopersAmazon RedshiftBig Data Business Intelligence for Govt. AgenciesBig Data Storage Solution - NoSQLBig Data & Database Systems FundamentalsApache Druid for Real-Time Data AnalysisPivotal Greenplum for DevelopersHBase for DevelopersIoT ( Internet of Things) for Entrepreneurs, Managers and InvestorsApache Kylin: From Classic OLAP to Real-Time Data WarehouseA Practical Introduction to NoSQL DatabasesOrientDB for DevelopersRedis for High Availability and Performance Training CourseRiak: Build Applications with High Data AccuracyScylla Database

Kursrabatter

Advanced Java, JEE and Web Application Security

10/22/2019 - 09:30
Oslo
Fjern
7000EUR
6300EUR
 Klasserom
8000EUR
7300EUR
Read more

Python and Spark for Big Data (PySpark)

10/22/2019 - 09:30
Oslo
Fjern
5250EUR
4725EUR
 Klasserom
6050EUR
5525EUR
Read more

Learning Go Programming

10/28/2019 - 09:30
Oslo
Fjern
7000EUR
6300EUR
 Klasserom
8000EUR
7300EUR
Read more

Visual Analytics – Data science

11/06/2019 - 09:30
Oslo
Fjern
3500EUR
3150EUR
 Klasserom
4100EUR
3750EUR
Read more

Programming with Big Data in R

01/28/2020 - 09:30
Drammen
Fjern
5250EUR
4725EUR
 Klasserom
6050EUR
5525EUR
Read more

Kursrabatter Nyhetsbrev

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in Norway!

As a Business Development Manager you will:

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