Tag: Administrators

Duration

14 hours (usually 2 days including breaks)

Requirements

• SQL
• JSON

Overview

SequoiaDB is a document-oriented NewSQL database that supports JSON transaction processing and SQL query. SequoiaDB can directly interface with applications to provide high performance and horizontally scalable data storage and processing functions, or serve as the frontend to Hadoop and Spark for both real-time query and data analysis.

Course Outline

Using SequoiaDB

• Starting SequoiaDB
• Connectors (Hadoop/Hive/Map Reduce)
• Basic Operators with reference

Administrating SequoiaDB

• Database Management
• Replication
• Cluster

Reference

• Operator
• SequoiaDB Shell
• SQL to SequoiaDB mapping list
• Error List

Duration

14 hours (usually 2 days including breaks)

Requirements

• An understanding of database concepts
• Linux command line experience

Audience

• Admins

Overview

ApsaraCache is a fork of Redis, the cloud-based in-memory data structure store that is commonly used as a database, cache and a message broker. ApsaraCache solves stability bottlenecks caused by frequent AOF Rewrite with time-based recovery to precision in seconds. It also solved the syncing problem when there’s a patchy connection.

This instructor-led, live training (online or onsite) is aimed at admins who wish to set up, deploy and manage a AsparaCache database.

By the end of this training, participants will be able to:

• Understand the differences between Redis and ApsaraCache and make the most of ApsaraCache’s unique features.
• Set up an ApsaraCache database for persistence, disaster tolerance, and backup recovery.
• Secure an ApsaraCache database.
• Monitor ApsaraCache using slow log auditing, information statistics and other maintenance features.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.
• To learn more about ApsaraCache, please visit: https://github.com/alibaba/ApsaraCache

Course Outline

Introduction

• Apsara as a key/value store

Overview of ApsaraCache Features and Architecture

Installing and Configuring ApsaraCache

Enabling Master-Slave Replication

Persisting Data (AOF, RDB Snapshotting, etc.)

Encrypting Data

Securing ApsaraCache

Enabling High Availability

Running Benchmarks to Test Performance

Optimizing Performance

Partitioning the Database

Deploying ApsaraCache

Monitoring ApsaraCache

Resolving Issues Involving Syncing, Latency, Stability

Troubleshooting

Summary and Conclusion

Duration

21 hours (usually 3 days including breaks)

Requirements

• Basic knowledge in database administration
• Familiarity with SQL language

Audience

• Database administrators
• System administrators

Overview

PostgreSQL (also known as Postgres) is an open source relational database management system or RDBMS. It is built to handle large data workloads while maintaining stability, reliability, and optimal performance.

This instructor-led, live training (online or onsite) is aimed at database admins and sysadmins who wish to use PostgreSQL to manage large-scale data while optimizing the database systems for high availability and performance.

By the end of this training, participants will be able to:

• Install and configure PostgreSQL.
• Understand the features and architecture of PostgreSQL.
• Learn how to perform database operations with SQL.
• Perform database backup and recovery to prevent data loss.
• Configure the server for high availability.
• Learn the tools and techniques for high performance tuning.
• Explore the external tools for monitoring and observability.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Course Outline

Introduction

• Overview of PostgreSQL features and architecture
• Basics of database administration

Getting Started

• Installing PostgreSQL
• Configuring a pgAdmin 4 client
• Creating a database user
• Creating a database

Database Operations

• SQL syntax, functions, and operators
• Data definition and data types
• User-defined data types
• Table schemas
• Creating and modifying tables
• Manipulating data in tables
• Querying and filtering data
• Exploring constraints
• Conversion functions
• Joining multiple tables
• Combining queries
• Indexes and full-text search
• Concurrency control
• Regular expressions

Database Server Administration

• Security and encryption
• Access roles and permissions
• Backup and restore
• Upgrading PostgreSQL
• High availability
• Load balancing and replication
• Statistics and monitoring

High Performance Tuning

• Resource management
• Monitoring query performance
• Parameter tuning
• Index optimization
• Query optimization
• Scalability and partitioning

External Tools for Monitoring and Observability

• pgAdmin
• pgBadger
• pgbench
• node-exporter Prometheus, Grafana
• Zabbix

Troubleshooting

Summary and Next Steps

Duration

21 hours (usually 3 days including breaks)

Requirements

• An understanding of RDBMS
• Experience with SQL

Audience

• System administrators
• Developers

Overview

PostgreSQL (also known as Postgres) is an open source relational database management system or RDBMS. It is built to handle large data workloads while maintaining stability, reliability, and optimal performance.

This instructor-led, live training (online or onsite) is aimed at sysadmins and developers who wish to use PostgreSQL 13 to set up, build, and manage databases for high-performance applications.

By the end of this training, participants will be able to:

• Install and configure PostgreSQL 13.
• Understand the features, architecture, and fundamentals of operating, managing, and maintaining databases with PostgreSQL 13.
• Learn how to configure Postgres database tables and schemas.
• Learn how to perform data manipulations and queries.
• Explore the different programming interfaces (client and server) to fully utilize and extend functionalities in PostgreSQL 13.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Course Outline

Introduction

• PostgreSQL vs MySQL vs Oracle
• Overview of PostgreSQL 13 features and architecture

Getting Started

• Setting up a database server
• Installing PostgreSQL 13
• Creating and accessing a database
• SQL syntax, commands, and functions

Configuring a Postgres Database

• Data definition, default values, and constraints
• Setting up and modifying tables
• Managing privileges and security policies
• Creating database schemas
• Implementing table inheritance and partitioning
• Adding, updating, and querying data
• Data types, functions, and operators
• Using indexes and running full-text search
• Understanding concurrency control

Managing a Database Server

• Upgrading a PostgreSQL cluster
• Securing the server and encrypting data
• Configuring server parameters
• Enabling client authentication
• Setting up access roles and permissions
• Managing multiple databases
• Performing database maintenance tasks
• Backing up and restoring data
• Optimizing database performance and reliability
• Monitoring database activity and disk usage
• Implementing logical replication
• Running regression tests

Client-Side Programming

• Using the libpq C library   and large object interface
• Executing embedded SQL statements
• Exploring the information schema
• Other PostgreSQL client applications

Server-Side Programming

• Extending the SQL query language
• Writing event trigger functions
• Implementing rule systems
• Using procedural languages (PLs)
• Exploring TCL, Perl, and Python PLs
• Executing server programming interfaces
• Examples of logical decoding
• Tracking replication progress

Troubleshooting

Summary and Next Steps

Duration

21 hours (usually 3 days including breaks)

Overview

For who

The workshop is intended for beginners, starting to work with the Oracle database, future administrators and users of systems based on this database need able to use the SQL language for the extraction and modification of the information contained in the systems.

Exams and Certificates

The training plan coincides with the material required to pass the exam: 1Z0-051 Oracle Database 11g: SQL Fundamentals I, the first step to getting most certifications Oracle’s Database

Purpose of training

The workshop aims to introduce participants to work with the Oracle database, making them familiar with the SQL language to the extent required for the efficient operation of the system and to take in the future obligations of database applications and Oracle databases.

The content of the training

• The organization of the working environment
• Introduction to relational databases
• Extraction of the data using the SELECT statement
• Modifying data using INSERT, UPDATE, DELETE
• Overview of schema objects

Remarks

The workshops are based on 11g XE software

Course Outline

Introduction to Oracle

• Database Architecture
• Relational model database
• Users diagrams sessions
• Tools

Introduction to the SELECT statement

• Screening and selection (WHERE clause)
• sorting
• Data types, operators, and service NULL
• Built-in scalar functions
• Actions to date
• National and regional settings in SQL

Regular expressions

The analysis of aggregated data

• Grouping functions
• DISTINCT clause
• Clauses GROUP BY and HAVING

Retrieving data from multiple tables

• Inner and outer joins (INNER JOIN, OUTER JOIN)
• ANSI SQL syntax, and other methods connectors (SELF JOIN, NATURAL JOIN)
• Collective operators (UNION, UNION ALL, INTERSECT, MINUS)

Subqueries

• Subqueries simple
• Correlated subqueries
• Operators EXISTS and NOT EXISTS
• Other types of subqueries

Inquiries hierarchical and samples

• Construction of the tree (CONNECT BY PRIOR clause and START WITH)
• The SYS_CONNECT_BY_PATH
• Data samples (SAMPLE clause)

Data manipulation (DML)

• INSERT, UPDATE, DELETE
• Operations on a large set of (INSERT FIRST INSERT ALL, MERGE)

Concurrent users work

• Transactions
• Locks
• FLASHBACK

Overview of schema objects

• Vistas
• Sequences
• Synonyms private and public
• Indexes

Duration

14 hours (usually 2 days including breaks)

Requirements

A basic working knowledge of SQL

Overview

This course covers the administration and performance tuning of PostgreSQL databases. 

Target audience includes system administrators and database architects. Attendees will learn the use of specialised PostgreSQL (AKA Postgres) modules such as replication, connection pooling and full text searching.

Course Outline

What is PostgreSQL?

• A Brief History of PostgreSQL
• Conventions
• Further Information
• Bug Reporting Guidelines

Introduction to PostgreSQL

• Installation and Creating Database
• The SQL Language
• Advanced Features

The SQL Language

• SQL Syntax
• Data Definition
• Data Manipulation
• Queries
• Data Types
• Functions and Operators
• Foreign Data Wrappers
• Type Conversion
• Indexes
• Triggers
• Full Text Search
• The Information Schema
• PL/pgSQL – SQL Procedural Language
• Concurrency Control
• Performance Tips
• How the Planner Uses Statistics

Server Administration

• Source Code vs Distribution-Provided Packages
• Installation from Source Code
• Installation from Source Code on Windows
• Deployment of Binaries Obtained by Compiling Source Code
• Server Setup, Operation
• Database Physical Storage
• Filesystem Durability Requirements and Required Mount Options
• Server Configuration
• Special Considerations for Container-Based Deployments
• Client Authentication
• Database Roles
• Managing Databases
• Localization
• Routine Database Maintenance Tasks
• Backup and Restore
• Recovery Configuration
• Monitoring Database Activity
• Monitoring Disk Usage
• Reliability and the Write-Ahead Log
• Regression Tests
• Installation of Third-Party Server Extensions

High Availability, Load Balancing, and Replication

• Brewer’s CAP Theorem
• Synchronous vs Asynchronous Replication
• Log Shipping (Warm Standby)
• Streaming Master-Slave Replication (Hot Standby)
• Trigger-Based Master-Slave Replication with Slony
• Trigger-Based Multi-Master Replication with Bucardo
• Connection Pooling and Synchronous Replication with Pgpool
• Failover Configurations using DRBD
• Replacing a Failed Server
• Recovering from Network Partition

Duration

14 hours (usually 2 days including breaks)

Requirements

Basics of an operating system administration.

Overview

This course covers everything a database administrator needs to know to successfully deploy and maintain MongoDB databases.

Diagnosing performance issues, importing and exporting data, and establishing the proper backup and restore routines, overview of the MongoDB CRUD API, the command shell, and the drivers are also covered.

The audience of this course include people who want to:

• Understand MongoDB from a developer’s perspective, including its command shell, query API, and driver tools.
• Deploy MongoDB in all its configurations – as a single server, with master/slave replication, as a replica set, and as a sharded cluster.
• Evaluate applications and choose hardware appropriately.
• Monitor MongoDB instances and integrate with standard monitoring software (Munin, Nagios, etc.)
• Plan for backups and manage large data imports and exports.
• Troubleshoot the most common developer issues and failure scenarios.

Each delegate will need to perform a series of practical exercises.

Course Outline

MongoDB Architectural Overview

• Origin, design goals, key features
• Process structure (mongos, mongod, config servers)
• Directory / file structure

Working with the MongoDB Shell

• Documents and data types
• CRUD (Inserts, queries, updates, deletes)
• System commands

Single-server Configuration and Deployment

• Configuration files
• Data files and allocation
• Log files
• Hardware and file-system recommendations

Security

• Built-in authentication
• Recommendations for secure deployment

Monitoring MongoDB

• mongostat
• Analyzing memory and IO performance
• Integration with monitoring tools: Munin / Cacti / Nagios
• MongoDB’s web console

Indexing and Query Optimization

• Managing indexes and MongoDB indexing internals
• Single / Compound / Geo indexes
• Identifying sub-optimal queries. Using the query profiler.

Introduction to drivers (Java/Python/Ruby/PHP/Perl)

• How the drivers and shell communicate with MongoDB
• BSON and the MongoDB Wire Protocol
• Troubleshooting application connections

Intro to Read and Write scalability

Replication and Durability

• Master-slave replication
• Replica sets
• Using write concern for durability
• Handling replication failures

Auto-Sharding

• How sharding works
• Setting up a MongoDB shard cluster

Choosing a shard key

Sharding and indexes

• Sharding and Replica Set Topologies
• Administering a sharded cluster

Shard / Chunk Migration

Backup and Restore Plans

• Filesystem-based strategies
• mongodump / mongorestore
• rsync
• mongoimport / mongoexport

Duration

35 hours (usually 5 days including breaks)

Requirements

• An understanding of container concepts
• System administration or devops experience

Audience

• System administrators
• Architects
• Devops engineers
• Developers

Overview

OpenShift Container Platform (formerly OpenShift Enterprise) v. 4 is a collection of software put together by Red Hat for deploying containers and Kubernetes in the enterprise. New features in version 4 include Operators, machine sets, and CoreOS — all of which enable clusters to self-manage some functions previously performed by administrators.

In this instructor-led, live training (online or onsite), participants will learn how to install, configure, and manage OpenShift Container Platform v4.

By the end of this training, participants will be able to:

• Undersand OCI (Open Containers Initiative) and its implications for using container enginees such as Docker in OpenShift.
• Understand the relationship between the different versions of OpenShift (OKP, OpenShift Container Platform, Red Hat OpenShift, etc.).
• Create, configure, manage, and troubleshoot an OpenShift Container Platform cluster.
• Implement OpenShift Container Platform’s self-manage capabilities to improve platform stability and consistency.
• Secure OpenShift Container Platform.
• Monitor and gather metrics.
• Manage storage.
• Upgrade an OpenShift Container Platform 3 cluster to OpenShift Container Platform 4.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• This course focuses on OpenShift Container Platform, version 4. If you wish to use a different version of OpenShift (e.g. OpenShift Container Platform 3 or OKD), please contact us to arrange.
• To request a customized training for this course, please contact us to arrange.

Course Outline

Introduction

Overview of New Features in OpenShift Container Platform 4

Installing an Openshift Cluster

Configuring and Managing Masters and Nodes

Securing OpenShift

Monitoring Openshift

Deploying Applications on Openshift using Source-to-Image (S2I)

Managing Storage on Openshift

Upgrading an OpenShift 3 Cluster to OpenShift 4

Summary and Next Steps

Duration

21 hours (usually 3 days including breaks)

Requirements

• A general understanding of containers and orchestration
• System administration or devops experience

Audience

• System administrators
• Architects

Overview

OKD is an application development platform for deploying containerized applications using Kubernetes. OKD is the upstream code base upon which Red Hat OpenShift Online and Red Hat OpenShift Container Platform are built.

In this instructor-led, live training (onsite or remote), participants will learn how to install, configure, and manage OKD on-premise or in the cloud.

By the end of this training, participants will be able to:

• Create, configure, manage, and troubleshoot an OKD cluster.
• Secure OKD.
• Deploy containerized applications on OKD.
• Monitor the performance of an application running in OKD.
• Manage data storage.
• Quickly deploy applications on-premise or on a public cloud such as AWS.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• This course is based on OKD (Origin Kubernetes Distribution).
• To customize the course or request training on a different version of OpenShift (e.g., OpenShift Container Platform 3 or OpenShift Container Platform 4), please contact us to arrange.

Course Outline

Introduction

Installing an OKD Cluster

Configuring and Managing Masters and Nodes

Working with Container Registries

Managing Users and Groups

Networking Using Cluster Network Operator

Managing Storage on OKD

Working with Operators

Monitoring an OKD Cluster

Managing an OKD Control Plane

Scaling an Application on OKD

Customizing OKD

Summary and Conclusion

Duration

35 hours (usually 5 days including breaks)

Requirements

• An understanding of container concepts
• System administration or DevOps experience
• Experience with the Linux command line

Audience

• System administrators
• Architects
• Developers

Overview

Red Hat OpenShift Container Platform (formerly OpenShift Enterprise) is an on-premises platform-as-a-service used for developing and deploying containerized applications on Kubernetes. Red Hat OpenShift Container Platform runs on Red Hat Enterprise Linux.

In this instructor-led, live training, participants will learn how to manage Red Hat OpenShift Container Platform.

By the end of this training, participants will be able to:

• Create, configure, manage, and troubleshoot OpenShift clusters.
• Deploy containerized applications on-premise, in public cloud or on a hosted cloud.
• Secure OpenShift Container Platform.
• Monitor and gather metrics.
• Manage storage.

Format of the Course

• Part lecture, part discussion, exercises and heavy hands-on practice.

Course Customization Options

• This course is based on OpenShift Container Platform version 3.x.
• To customize the course or request training on a different version of OpenShift (e.g., OpenShift Container Platform 4 or OKD), please contact us to arrange.

Course Outline

Introduction

Overview of Docker and Kubernetes

Overview of OpenShift Container Platform Architecture

Creating Containerized Services

Managing Containers

Creating and Managing Container Images

Deploying Multi-container Applications

Setting up an OpenShift Cluster

Securing OpenShift Container Platform

Monitoring OpenShift Container Platform

Deploying Applications on OpenShift Container Platform using Source-to-Image (S2I)

Managing Storage

Closing remarks