Enquiry Form

Database Training Courses

Local, instructor-led live Database (DB) or Database Management System (DBMS) training courses are aimed at both system administrators as well as developers and demonstrate through hands-on practice how to administer Database systems as well as how to integrate a Database with software applications.

Database training is available as "onsite live training" or "remote live training". Onsite live Database training can be carried out locally on customer premises in Denmark or in NobleProg corporate training centers in Denmark. Remote live training is carried out by way of an interactive, remote desktop.

NobleProg -- Your Local Training Provider

Testimonials

★★★★★

★★★★★

Trainer was able to answer almost all questions during the training, has great subject knowledge..

AVL List GmbH

Course: MongoDB for Administrators

During 3 days we had an opportunity to learn about so many things.

SPOC S.A.

Course: React: Build Highly Interactive Web Applications

I mostly liked the many examples and use cases.

Mateusz Grześkowiak - SPOC S.A.

Course: React: Build Highly Interactive Web Applications

I mostly liked the real codding.

SPOC S.A.

Course: React: Build Highly Interactive Web Applications

Trainer was encouraging us to ask questions, atmosfere was quite nice :).

SPOC S.A.

Course: React: Build Highly Interactive Web Applications

Very informed trainer. I thought the test exam paper was very helpful. I think we could have learnt more with more exam questions / quizes each day..

Capita Business Services Ltd

Course: DCMS Course part 1

The quizzes on the final day. A good way to test our knowledge from the course in a fun an interactive way.

Capita Business Services Ltd

Course: DCMS Course part 1

1:1 very intensive but learnt a lot.

Karen Dyke - BT

Course: Python: Automate the Boring Stuff

I liked the interaction between the students and the trainer..

Synechron

Course: Bespoke Python course for Synechron

Covered a very broad range or items and useful real world examples. Very thorough, engaging and well presented..

Course: JMeter Fundamentals and JMeter Advanced

The information shared, and exercises we had.

Banco Millennium Atlântico SA

Course: RPA: Implementing Robotic Process Automation

Great trainer and he's ability to deliver good training.

Ilona Pawlowska - NIIT Limited

Course: MS Excel - Intermediate / Advanced level (customized)

I was benefit from the practical exercises, and easy to discuss with the instructor..

Kongsberg Maritime AS

Course: Object-Oriented Analysis and Design using UML

I really enjoyed the many practise.

Magdalena Chowaniec - UBS Business Solutions Poland Sp. z o.o.

Course: Excel Advanced

I actually think the pace was great, even though some people were asking to slow down, I found the pace to be very engaging and it was preventing everyone to get bored and helping to get focused:).

Benazir Kazhat - NIIT Limited

Course: MS Excel - Intermediate / Advanced level (customized)

The CIPP-style test and quiz on the last day. I also found the discussion on PECR rather informative..

Capita Business Services Ltd

Course: DCMS Course part 1

Very comprehensive, particularly understanding the history of data protection and the inter linkages of other international data protection frameworks..

Dominic Newman - Capita Business Services Ltd

Course: DCMS Course part 1

I generally liked the flexibility of coach.

Adrian Kossakowski - NIIT Limited

Course: MS Excel - Intermediate / Advanced level (customized)

Personalized one on one training. Trainer was really engaging and easy going. Got what I wanted to learn from the session..

CIBC

Course: Web Application Performance Testing with JMeter

Exercises were fun and it was good to see how quickly an application can be developed in Android Studio..

Sepura

Course: Android Fundamentals - Fast Track

I was benefit from the trainer knowledge, explanation and tips..

Kornel Tymcio - UBS Business Solutions Poland Sp. z o.o.

Course: Visual Basic for Applications (VBA) in Excel - Advanced

The Hands-on part where he ask us to focus and listen first, then giving time to practice what he just did..

Capgemini Philippines Corp.

Course: Node.js for JavaScript Developers

His lecturing style and how he speaks English fluently. I like the way he explained the lecture through slow phasing and we deeply understand it little by little..

John Edward Hernandez - Capgemini Philippines Corp.

Course: Node.js for JavaScript Developers

I mostly enjoyed all of it.

Raged Nueva España - Capgemini Philippines Corp.

Course: Node.js for JavaScript Developers

I really enjoy the training. Huge and practical! knowledge of the trainer combined with his skill to conduct the training made the training time very efficient.
The trainer recognized the level of participant's experience in VBA and provided exercises relevant to that experience which made the training very useful..

Barbara Peek - UBS Business Solutions Poland Sp. z o.o.

Course: Visual Basic for Applications (VBA) in Excel - Advanced

I mostly enjoyed the very good and knowledgeable trainer.

sensus

Course: Introduction to Ansible Automation

the matter was well presented and in an orderly manner.

Marylin Houle - Ivanhoe Cambridge

Course: Introduction to R with Time Series Analysis

I liked the overall scope, presentation style and organization.

Marek Dudka - UBS Business Solutions Poland Sp. z o.o.

Course: Excel Advanced

UBS Business Solutions Poland Sp. z o.o.

Course: Excel Advanced

I was benefit from the trainer is enquiring if we are following and if he could help all the time..

Advanzia Bank S.A.

Course: R - Introduction

I genuinely liked the hands-on sections.

ERCOT

Course: Introduction to Ansible Automation

The trainer was an expert on his subject and was able to answer every single question.

Ioannis Bitros - BYTE Computer

Course: RabbitMQ

The teacher is extremely knowledgeable..

Advanzia Bank S.A.

Course: R - Introduction

n/d

Artur Bryś - Centrum Innowacji ProLearning

Course: SQL Fundamentals

I was benefit from the good Explanation and ability to Switch Topics when requested by the trainee.

McArthurGlen

Course: Power BI

I generally liked the fernando's knowledge.

Valentin de Dianous - Informatique ProContact INC.

Course: Big Data Architect

I mostly enjoyed the very lively and ease..

Rey Jasper Matias - Sykes Asia, Inc.

Course: Power BI

I mostly enjoyed the knowledge about replication database.

Suparman - Universitas Terbuka

Course: Advanced MariaDB for High Availability and Performance

The fact that we had the time to cover some useful extras..

Alina Vishniakova - TUI Business Services GmbH

Course: Statistics Level 1

Steve was very enthusiastic and we covered a very large about of material. He answered questions as we went along. There was only me on the course, so I got a lot out of it. Steve was very generous with his time..

Ozo Innovations Ltd

Course: Social Media Marketing

The best in this training was very good approach of trainer for listeners.

Wojciech Furman - MTU Aero Engines Polska Sp. z o.o.

Course: Perl Programming

I was benefit from the passion to teach and focusing on making thing sensible.

Zaher Sharifi - GOSI

Course: Advanced Deep Learning

He really explained everything well and used examples.

royal bank of Canada

Course: R

Visual Studio Code

Advatech Sp. z o.o.

Course: Building Microservices with Go

I liked the exercises to use and practice the performance tools..

GENERAL ORGANIZATION FOR SOCIAL INSURANCE (GOSI)

Course: Agile Software Testing

The knowledge of the trainer and how he patiently answered all of our questions..

Ron Jeremy Torres - Temic Automotive Philippines, Inc

Course: Docker and Kubernetes

I genuinely liked the hands-on training.

John Carl Landrito - Temic Automotive Philippines, Inc

Course: Docker and Kubernetes

I mostly was benefit from the kubernetes!!.

Temic Automotive Philippines, Inc

Course: Docker and Kubernetes

I mostly liked the hands-on exercises..

Mark Anthony Daban - Temic Automotive Philippines, Inc

Course: Docker and Kubernetes

I really was benefit from the exercises.

Department of National Defence

Course: Test automation with HP UFT

Covered a very broad range or items and useful real world examples. Very thorough, engaging and well presented..

Database Course Outlines

MySQL Administration training course is for anyone who wants to administrate the MySQL database server. It is a comprehensive course covering all administrator duties.

The course explains how MySQL Database works, what tools are available, how we can use them, how we can secure the MySQL Database Server and configure it. During the training course you will learn how to manage user accounts and how the MySQL Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery.

Hypertable is an open-source software database management system based on the design of Google's Bigtable.

In this instructor-led, live training, participants will learn how to set up and manage a Hypertable database system.

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

- Install, configure and upgrade a Hypertable instance- Set up and administer a Hypertable cluster- Monitor and optimize the performance of the database- Design a Hypertable schema- Work with Hypertable's API- Troubleshoot operational issues

Audience

- Developers- Operations engineers

Format of the course

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

Riak is an Erlang based open-source document database, similar to CouchDB. It is created and maintained by Basho.

In this instructor-led, live training, participants will learn how to build, run and operate a Riak based web application.

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

- Extend the number of hardware nodes and partition data across multiple servers- Use bucket/key/values to organize and retrieve documents- Use full-text search like query syntax- Understand other Riak related technologies, such as Riak KV and Riak TS- Test, secure, optimize and deploy a sample web application

Audience

- Developers- Database engineers- Operations staff

Format of the course

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

kdb+ is an in-memory, column-oriented database and q is its built-in, interpreted vector-based language. In kdb+, tables are columns of vectors and q is used to perform operations on the table data as if it was a list. kdb+ and q are commonly used in high frequency trading and are popular with the major financial institutions, including Goldman Sachs, Morgan Stanley, Merrill Lynch, JP Morgan, etc.

In this instructor-led, live training, participants will learn how to create a time series data application using kdb+ and q.

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

- Understand the difference between a row-oriented database and a column-oriented database- Select data, write scripts and create functions to carry out advanced analytics- Analyze time series data such as stock and commodity exchange data- Use kdb+'s in-memory capabilities to store, analyze, process and retrieve large data sets at high speed- Think of functions and data at a higher level than the standard function(arguments) approach common in non-vector languages- Explore other time-sensitive applications for kdb+, including energy trading, telecommunications, sensor data, log data, and machine and network usage monitoring

Audience

- Developers- Database engineers- Data scientists- Data analysts

Format of the course

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

The aim of this course is to provide a clear understanding of the use of SQL for differentdatabases (Oracle, SQL Server, MS Access...). Understanding of analytic functions and theway how to join different tables in a database will help delegates to move data analysisoperations to the database side, instead of doing this in MS Excel application. This can alsohelp in creating any IT system, which uses any relational database.

Percona Server for MySQL is optimized for cloud computing, NoSQL access, containers and modern hardware such as SSD and Flash storage.

-

Cloud readyDramatically reduces downtime on servers with slow disks and large memory, such as 4XL EC2 servers on EBS volumes

-

SaaS deployableIncreases flexibility for architectures such as co-located databases with hundreds of thousands of tables and heterogeneous backup and retention policies

-

Vertical scalability and server consolidationScales to over 48 CPU cores, with the ability to achieve hundreds of thousands of I/O operations per second on high-end solid-state hardware

-

Query, object and user level instrumentationDetailed query logging with per-query statistics about locking, I/O, and query plan, as well as performance and access counters per-table, per-index, per-user, and per-host

-

Enterprise readyPercona Server for MySQL includes advanced, full-enabled external authentication, audit logging and threadpool scalability features that are only available in Oracle’s commercial MySQL Enterprise Edition

This course will introduce Cassandra – a popular NoSQL database. It will cover Cassandra principles, architecture and data model. Students will learn data modeling in CQL (Cassandra Query Language) in hands-on, interactive labs. This session also discusses Cassandra internals and some admin topics.

Teradata is one of the popular Relational Database Management System. It is mainly suitable for building large scale data warehousing applications. Teradata achieves this by the concept of parallelism.

Berkeley DB (BDB) is a software library intended to provide a high-performance embedded database for key/value data. Berkeley DB is written in C with API bindings for C++, C#, Java, Perl, PHP, Python, Ruby, Smalltalk, Tcl, and many other programming languages. Berkeley DB is not a relational database.

This course will introduce the architecture and capabilities of Berkeley DB and walk participants through the development of their own sample application using Berkeley DB.

Audience

- Application developers- Software engineers- Technical consultants

Format of the course

- Part lecture, part discussion, hands-on development and implementation, tests to gauge understanding

Scylla is an open-source distributed NoSQL data store. It is compatible with Apache Cassandra but performs at significantly higher throughputs and lower latencies.

In this course, participants will learn about Scylla's features and architecture while obtaining practical experience with setting up, administering, monitoring, and troubleshooting Scylla.

Audience

- Database administrators- Developers- System Engineers

Format of the course

- The course is interactive and includes discussions of the principles and approaches for deploying and managing Scylla distributed databases and clusters.- The course includes a heavy component of hands-on exercises and practice.

FlockDB is an open source distributed, fault-tolerant graph database for managing wide but shallow network graphs. It was initially used by Twitter to store relationships among users.

In this instructor-led, live training, participants will learn how to set up and use a FlockDB database to help answer social media questions such as who follows whom, who blocks whom, etc.

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

- Install and configure FlockDB- Understand the unique features of FlockDB, relative to other graph databases such Neo4j- Use FlockDB to maintain a large graph dataset- Use FlockDB together with MySQL to provide provide distributed storage capabilities- Query, create and update extremely fast graph edges- Scale FlockDB horizontally for use in on-line, low-latency, high throughput web environments

Audience

- Developers- Database engineers

Format of the course

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

In this instructor-led, live hands-on training, we will set up a live project and put into practice the skills to model, manage and access your data using neo4j. We contrast and compare graph databases with SQL-based databases as well as other NoSQL databases and clarify when and where it makes sense to implement each within your infrastructure.

Format of the course

- Heavy emphasis on hands-on practice. Most of the concepts are learned through samples, exercises and hands-on development.

When migrating databases there are common ways of dealing with logic put either in SQL queries specific to the database or database procedural language (e.g. PL/SQL). This course covers techniques and strategies of making migration smooth. Also, it deals with possible performance and scalability problems.

This course is usually deliver with following databases: DB2, Oracle, MySQL, MariaDB, SQL Server, etc... but can be tailored to a specific migration project.

This course will introduce Cassandra – a popular NoSQL database. It will cover Cassandra principles, architecture and data model. Students will learn data modeling in CQL (Cassandra Query Language) in hands-on, interactive labs. This session also discusses Cassandra internals and some admin topics.

Percona Server for MongoDB is a free, enhanced, fully compatible, open source, drop-in replacement for MongoDB 3.2 Community Edition with enterprise-grade features. It requires no changes to MongoDB applications or code.

Audience

This course is suitable for sysadmins and engineers seeking to switch to Percona Server from preexisting MongoDB instances, or deploy and administrate new Percona Server for MongoDB instances.

After completing this course, delegates will:

- understand Percona Server’s structure and deployment mechanisms- be able to carry out installation / production environment / architecture tasks and configuration- be able to assess code quality, perform debugging, monitoring- be able to implement advanced production like replication, performance tuning and logging

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.

Adobe CouchDB is a scalable, fault-tolerant, and schema-free document-oriented database written in Erlang. It's used in large and small organizations for a variety of applications where a traditional SQL database isn't the best solution for the problem at hand.

Audience

This course is directed at engineers and developers seeking to deploy and develop with a CouchDB instance.

GlobalSight is an open-source, Java based application server for automating, streamlining, and managing the localization process.

In this instructor-led, live training, participants will learn about GlobalSight's architecture and functionality as they install, configure and deploy a demonstration server.

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

- Understand the benefits of GlobalSight relative to other Translation Management Systems- Install GlobalSight server and related components- Set up GlobalSight to work behind a reverse proxy- Deploy GlobalSight to a production environment- Troubleshoot and optimize GlobalSight- Use GlobalSight's APIs to integrate it with third party applications, including JBPM, etc.

Audience

- System administrators

Format of the course

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

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

Course Customization Options

- This training is based on MongoDB Enterprise Server, which includes Ops Manager. Please consult with us to arrange license requirements.- To request a customized training for this course, please contact us to arrange.

SSAS (SQL Server Analysis Services), is a Microsoft SQL Server transactional processing (OLAP) and data mining tool for analyzing data across multiple databases, tables or files. The semantic data models provided by SSAS are used by client applications such as Power BI, Excel, Reporting Services, and other data visualization tools.

In this instructor-led, live training (onsite or remote), participants will learn how to use SSAS to analyze large volumes of data in databases and data warehouses.