The growing complex applications and databases require a strong IT. Especially in the field of healthcare, the importance of IT has increased considerably in recent years. The demand for databases, communication between the different applications and the IT infrastructure becomes increasingly complex. For IT employees, we offer seminars that introduce system and database administration and deepen existing knowledge. By arrangement, we also address specific areas. The offer includes 5 different areas: Linux, Apache, MySQL, Puppet and git.

All trainings are also offered in German.

LINUX System Administration

In this module we provide the knowledge for the administration of the Linux system.Basic knowledge of a Linux or Unix system or very good knowledge of another system is an advantage.

Program

The Bash Shell and its mechanisms
  • What are Shell mechanisms?
  • Bash configuration
  • Wildcards, quoting, output redirection, pipes, variables, command substitution
Local user administration
  • User concept
  • User files
  • Commands and tools for administration
  • PAM
Hard drives and file systems
  • File systems under Linux
  • Device files
  • Partitioning and setting up file systems
  • Commands for administration and troubleshooting
The boot process and init process
  • Bootloader
  • Runlevel and init
  • Configuration and adjustment of the boot process
  • Start and stop services
data backup
Emergency system
Software installation and package administration
  • Installation of packages
  • Installation from the source code
  • System maintenance
The Kernel
System security
Linux installation
  • Partitions and file systems
  • What packages are needed?
  • Bootloader

Cost

3 days with 5 participants 598 CHF per person and day

Included in the price are training materials and lunch, as well as the coffee breaks in the morning and afternoon.

Further days or a different number of participants are possible. The prices are adjusted individually to the desired options. Please contact us.

Apache Webserver

This seminar is intended for administrators and includes the installation, configuration and administration of Apache Webervers under Linux. Linux knowledge is necessary.

Program

  • Overview
  • Installation and configuration of the Apache web server
  • Operation of the Apache Web server
  • Embedding and loading of modules
  • Set up and analyzing log files
  • Data security
    • Rights and user administration
    • Access restriction
    • Setting up TLS / SSL
    • Create your own certificates
    • Chroot jail for Apache
  • Virtual web servers
    • IP – and name based (DNS)
  • URL-Redirection
  • Server Side Includes (SSI)
  • Monitoring and surveillance
  • Apache as Proxy-Server
  • Apache as Fileserver with WebDAV
  • Interactive websites in interaction with Perl, PHP, MySQL (Overview)


Cost

3 days with 5 participants 598 CHF per person and day

Included in the price are training materials and lunch, as well as the coffee breaks in the morning and afternoon.

Further days or a different number of participants are possible. The prices are adjusted individually to the desired options. Please contact us.

MySQL Administration

This course is intended for anyone who are new to the topic „Administration of MySQL Servers“. The participants will get an in-depth overview of the architecture of the MySQL server, how it works and how it is installed, and the routine tasks involved in administering a MySQL server.

This course places great emphasis on high practical content. Basic topics and work steps, such as installing and configuring a MySQL server, are performed and discussed in a number of different ways. Other standard tasks from the life of the database administrator, e.g. Security and rights management, monitoring and performance optimization as well as backup and restore are treated virtually and practically. Advanced topics such as point-in-time recovery and master-slave replication with MySQL complete the training.

The training is carried out with the current version of the MySQL community server, which is released for productive operation (Generally Available Release, GA). On request, earlier versions, or not yet released newer versions can be considered.
Newcomers and users of MySQL with little or no prior knowledge of a relational database management system are addressed with this training.

Program

MySQL Server Architecture

  • Basics of the MySQL server architecture
  • Overview of query processing in the MySQL server
  • The Query-Cache
  • Storage Engines

Installation

  • Available installation procedures
  • Installation scope
  • The most important tools of the database management system
  • Starting and stopping the server

Configuration

  • Overview of MySQL-Configuration
  • Configuration levels
  • Basic configuration after installation
  • Configuration of memory management

Information Schema

  • Functionality of Information Schema
  • Basic information categories
  • Query of meta-information
  • Environment variables
  • Status information

Security and User Rights

  • The 2-phase model of MySQL: authentication and authorization
  • Administration of users
  • Grant and revoke permissions
  • User and authorization concepts in practice

Locking

  • Implicit and Explicit Locking
  • Advisory Locking
  • Find Locks

Database Objects

  • Databases
  • Tables and Views
  • Stored Procedures
  • Trigger
  • Events

Monitoring

  • Overview of methodology and tools
  • To make good use of Information Schema

Performance-Optimization

  • Methods and tools for performance measurement
  • Use data types correctly
  • Identify performance bottlenecks
  • Profiling with MySQL
  • Analyze execution plans with EXPLAIN
  • Optimize performance with indexes
  • Improve performance by rewriting statements

Data Backup

  • Import and export of tabular data
  • Method for logical data backup
  • Method for physical backup
  • Binlog archiving
  • To-Last-Log-Recovery
  • Point-In-Time-Recovery (PITR)

Replication

  • Basics of replication
  • Cluster topologies
  • Implement master-slave replication with MySQL virtually

Cost

3 days with 5 participants 598 CHF per person and day

Included in the price are training materials and lunch, as well as the coffee breaks in the morning and afternoon.

Further days or a different number of participants are possible. The prices are adjusted individually to the desired options. Please contact us.

MySQL Performance Enhancement and Optimization

The volume of data that a database server has to master and manage in practice today is getting bigger and bigger. MySQL databases can store enormous amounts of data as well. It is therefore important to be able to recognize possible performance problems early and to correct them with the right tools.

 

This training is aimed at database administrators as well as developers. The participants learn about methods and tools for the performance measurement and to implement them appropriately. The basics for the diagnosis of performance bottlenecks are presented in different areas, e.g. Configuration and storage management, cache settings, table structure and indexes, or the correct use of the data types. On this basis, the optimization is demonstrated in practical examples.

 

The training is carried out with the current version of the MySQL community server, which is released for productive operation (Generally Available Release, GA). On request, earlier versions, or not yet released newer versions can be considered.

 

This seminar is designed for developers and database administrators who want to optimize and monitor their MySQL database. Basic knowledge in the administration of MySQL or basic knowledge in the database development with MySQL are necessary for this.

 

Program

Performance-relevant Aspects of the MySQL Architecturer
  • Query processing
  • Query-Cache
  • Memory management and caching
  • Storage Engines
Care and Maintenance of Tables
  • Technical background: why tables „become slower“
  • Necessary optimization measures
  • Individual measures for different storage engines
General Performance Measurement and Diagnosis
  • Performance-relevant information from the information schema
  • Evaluate status information correctly
  • Benchmarking approaches
  • Profiling with MySQL resources
Performance and Optimization of SQL Statements
  • Optimal use of MySQL data types
  • Analyze execution plans with EXPLAIN
  • Execution plans
  • SELECT- and JOIN-Types
  • Rephrase performance critical statements
  • Optimizer-Hints
Optimal use of Indexes
  • Index-Types
  • Use indexes correctly in complex scenarios
  • Diagnosis of optimal or suboptimal indexing
  • Indexing strategies for high-performance
Further Optimization Measures
  • Approaches to operating system level
  • Opportunities and limits of optimization at hardware level
  • Performance optimization through replication

Cost

3 days with 5 participants 598 CHF per person and day

Included in the price are training materials and lunch, as well as the coffee breaks in the morning and afternoon.

Further days or a different number of participants are possible. The prices are adjusted individually to the desired options. Please contact us.

Puppet Configuration Management

Changes to a server configuration, whether on servers in data centers or in office infrastructures, must be made regularly. With manual adjustments, there are often errors. A further disadvantage is the different configuration settings, which make the setting up of a new server into a force act in the event of a total failure. The software Puppet offers a way out. It is considered the top dog in the field of configuration management software from Puppet Labs. Participants of the seminar will get to know the Puppets configuration language intensively and practice-oriented. This allows you to define the configurations of the servers, and to determine which packages have to be installed. It does not matter on how many servers the configuration is executed – it could be thousands of computers. According to reports also Google, Oracle, and Wikimedia Foundation intensively use Puppet.

The seminar is designed for experienced Linux system administrators.

Program

Installation and Configuration of Client / Server Servicese

Ressourcen anlegen und verwalten
  • Resource-Types
  • Resource Abstraction Layer
  • Manifests
  • Variables
  • Terms
  • Resource dependencies and events (notify und subscribe)
  • Virtual Resources
Puppet-Commands
  • puppetca
  • Puppet Subcommands: dry-run; Triggers from the server; Triggers from the client
Classes and Defines
  • Simple classes
  • Parameterized classes
  • Defines
Stages
  • Default Run-Stage
  • Run-Stage
  • Connection of classes to stages
Tags
  • Use of tags
  • Automatic Tagging
  • Tagging of resources and classes
Environments
  • Expand Production- and Development Environments
  • Using of Git to manage the Puppet configuration
Inventory with Facter
  • CLI and Environment-Variables
  • Custom Facts and Auto Sync through puppet
In-File Editing Augeas
Templating Mechanism with erb
Puppet Dashboard
  • Installation and connection to Puppet Master

Cost

3 days with 5 participants 598 CHF per person and day

Included in the price are training materials and lunch, as well as the coffee breaks in the morning and afternoon.

Further days or a different number of participants are possible. The prices are adjusted individually to the desired options. Please contact us.

Version Management with Git

The distributed version management Git is increasingly replacing traditional local and central systems for managing source code and resource files. It is especially suitable for development in teams and is becoming increasingly important in the company environment as well. The strength of Git lies in the independent software evolution since every developer works with a complete version – which in turn is combined into a complete overall system.

The seminar shows the development cycle in practice-oriented exercises both on the shell, in the independent application Source Tree, as well as in Eclipse with EGit. In addition to everyday tasks, the seminar offers best practices with (distributed) version control as well as from the open source software development. In addition, the Git course is devoted to the administration of the system and also includes an overview of how an effective release management looks like and how subversion repositories are converted to Git.

Program

Overview of (distributed) Version Management
  • Local, central and distributed version management as well as their advantages and disadvantages
  • Software development process and release management
  • History of Git related to the Linux kernel
  • Further project examples for the different systems
Basic Concepts
  • Structure of Git Repositories
  • Best practices for structuring
  • Revisions and version numbers
  • Local and remote (bare) repositories
  • The Staging Area
  • Commit and Stash
  • Commit Messages
  • Branches in detail
  • Workflow in Git
  • Tools and licensing
Git on the Shell
  • Installation and configuration on the shell under Windows, Linux and Mac
  • Import or initialize repositories
  • Basic commands such as status checks, commits, view history, undo, etc.
  • Tags
  • Interaction with other repositories
  • Local and remote branches
  • Diff and merge (merge, cherry-pick and rebase)
  • Patches and Pull-Requests
  • Aliases
Git with SourceTree
  • Installation and configuration of SourceTree
  • Implementing of shell commands in SourceTree
Git in Eclipse
  • Installation and configuration of EGit Plugins
  • Implementing of shell commands in EGit
  • Features of EGit
Git-Server-Administration
  • Git daemon and web interface
  • Secure remote connection over SSL including key generation
  • Public repositories
Open Source Software-Development
  • GitHub  for collaborative version management
  • Workflow in Open Source projects
  • Discussion: Forks as an opportunity?
  • Project examples
Outlook and Best Practices
  • Migration of SVN repositories
  • Effective release management
  • Effective version-management
  • Branching vs. Feature Flags
  • The Git Extension git-flow in detail
  • Git Alternatives Mercurial and Bazaar


Cost

1 day with 15 participants 598 CHF per person and day

Included in the price are training materials and lunch, as well as the coffee breaks in the morning and afternoon.

Further days or a different number of participants are possible. The prices are adjusted individually to the desired options. Please contact us.


LINUX SystemadministrationApache WebserverMySQL AdministrationMySQL Performance Enhancement and OptimizationPuppet Configuration ManagementVersion Management with Git