Database Training Courses

Database Training Courses

Το μάθημα κατάρτισης βασισμένο σε βάσεις δεδομένων (DB) ή στο Σύστημα Διαχείρισης Βάσεων Δεδομένων (DBMS) κατευθύνεται τόσο σε διαχειριστές συστημάτων όσο και σε προγραμματιστές και επιδεικνύει μέσω πρακτικής άσκησης πώς να διαχειρίζεται συστήματα βάσεων δεδομένων καθώς και πώς να ενσωματώνει μια βάση δεδομένων εφαρμογών λογισμικού. Η κατάρτιση σε βάσεις δεδομένων είναι διαθέσιμη ως "ζωντανή εκπαίδευση στο χώρο" ή "μακρινή ζωντανή εκπαίδευση". Η επιτόπια κατάρτιση σε πραγματικό χρόνο μπορεί να πραγματοποιηθεί σε τοπικό επίπεδο στις εγκαταστάσεις του πελάτη Ελλάδα ή σε εταιρικά κέντρα κατάρτισης NobleProg στο Ελλάδα . Η απομακρυσμένη ζωντανή προπόνηση πραγματοποιείται μέσω μιας διαδραστικής, απομακρυσμένης επιφάνειας εργασίας. NobleProg - Ο τοπικός παροχέας εκπαίδευσης

Testimonials

★★★★★
★★★★★

Database Course Outlines

Title
Duration
Overview
Title
Duration
Overview
14 hours
Overview
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.
14 hours
Overview
Voldemort is an open-source distributed data store that is designed as a key-value store. It is used at LinkedIn by numerous critical services powering a large portion of the site.

This course will introduce the architecture and capabilities of Voldomort and walk participants through the setup and application of a key-value distributed data store.

Audience

- Software developers
- System administrators
- DevOps engineers

Format of the course

- Part lecture, part discussion, heavy hands-on practice, occasional tests to gauge understanding
28 hours
Overview
MariaDB is a fork of MySQL and one of the most popular database servers.

In this instructor-led, live training, participants will learn how to install, configure and manage MariaDB for high availability and performance. Other topics include backup and recovery, security and clustering.

Format of the course

- Part lecture, part discussion, exercises and heavy hands-on practice
7 hours
Overview
This course helps customer to chose the write data storage depend on their needs. It covers almost all possible modern approaches.
7 hours
Overview
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
14 hours
Overview
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

Part lecture, part discussion, exercises and heavy hands-on practice
14 hours
Overview
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
21 hours
Overview
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
21 hours
Overview
The aim of this course is to provide a clear understanding of the use of SQL for different
databases (Oracle, SQL Server, MS Access...). Understanding of analytic functions and the
way how to join different tables in a database will help delegates to move data analysis
operations to the database side, instead of doing this in MS Excel application. This can also
help in creating any IT system, which uses any relational database.
14 hours
Overview
Percona Server for MySQL is optimized for cloud computing, NoSQL access, containers and modern hardware such as SSD and Flash storage.

-

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

-

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

-

Vertical scalability and server consolidation
Scales 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 instrumentation
Detailed 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 ready
Percona 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
21 hours
Overview
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.

Duration : 3 days

Audience : Developers
21 hours
Overview
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.

This course introduces the delegates to Teradata.
21 hours
Overview
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
28 hours
Overview
Many real world problems can be described in terms of graphs. For example, the Web graph, the social network graph, the train network graph and the language graph. These graphs tend to be extremely large; processing them requires a specialized set of tools and processes -- these tools and processes can be referred to as Graph Computing (also known as Graph Analytics).

In this instructor-led, live training, participants will learn about the technology offerings and implementation approaches for processing graph data. The aim is to identify real-world objects, their characteristics and relationships, then model these relationships and process them as data using a Graph Computing (also known as Graph Analytics) approach. We start with a broad overview and narrow in on specific tools as we step through a series of case studies, hands-on exercises and live deployments.

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

- Understand how graph data is persisted and traversed.
- Select the best framework for a given task (from graph databases to batch processing frameworks.)
- Implement Hadoop, Spark, GraphX and Pregel to carry out graph computing across many machines in parallel.
- View real-world big data problems in terms of graphs, processes and traversals.

Format of the course

- Part lecture, part discussion, exercises and heavy hands-on practice
14 hours
Overview
Microsoft Access is a pseudo-relational database engine from Microsoft.
21 hours
Overview
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.
21 hours
Overview
Οι

σχεσιακές βάσεις δεδομένων που βασίζονται σε πίνακες, όπως η Oracle και η MySQL, είναι από καιρό το πρότυπο για την οργάνωση και την αποθήκευση δεδομένων. Ωστόσο, το αυξανόμενο μέγεθος και η ρευστότητα των δεδομένων έχουν καταστήσει δύσκολο για αυτά τα παραδοσιακά συστήματα να εκτελέσουν αποτελεσματικά εξαιρετικά πολύπλοκα ερωτήματα στα δεδομένα. Φανταστείτε την αντικατάσταση της αποθήκευσης δεδομένων με βάση τις σειρές και τις στήλες με την αποθήκευση δεδομένων βάσει αντικειμένου, σύμφωνα με την οποία οι οντότητες (π.χ. ένα άτομο) θα μπορούσαν να αποθηκευτούν ως κόμβοι δεδομένων και, στη συνέχεια, να ερωτηθούν εύκολα με βάση την απέραντη, πολυγραμμική σχέση τους με άλλους κόμβους. Και φανταστείτε να υποβάλλετε ερώτημα σε αυτές τις συνδέσεις και τα συσχετισμένα αντικείμενα και ιδιότητές τους χρησιμοποιώντας μια συμπαγή σύνταξη, έως και 20 φορές ελαφρύτερο από το SQL. Αυτές είναι οι βάσεις δεδομένων γραφημάτων, όπως η προσφορά neo4j.

σε αυτή την εκπαιδεύτρια, ζωντανή εκπαίδευση, θα δημιουργήσει ένα ζωντανό έργο και να θέσει σε εφαρμογή τις δεξιότητες για να μοντελοάσει, τη διαχείριση και την πρόσβαση στα δεδομένα σας χρησιμοποιώντας neo4j. Αντιπαραβλέπουμε και συγκρίνουμε τις βάσεις δεδομένων γραφημάτων με βάσεις δεδομένων που βασίζονται σε SQL, καθώς και άλλες βάσεις δεδομένων NoSQL και αποσαφηνίσουμε πότε και πού έχει νόημα να εφαρμόσουμε το καθένα μέσα στην υποδομή σας.

μορφή του μαθήματος

- βαριά έμφαση στην πρακτική εξάσκηση. Οι περισσότερες από τις έννοιες διδαχθήκαμε μέσα από δείγματα, ασκήσεις και ανάπτυξη των χεριών.
21 hours
Overview
Audience

- Beginner or intermediate database developers
- Beginner or intermediate database administrators
- Programmers

Format of the course

- Heavy emphasis on hands-on practice.
- Most of the concepts are learned through samples, exercises, and hands-on development.
7 hours
Overview
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.
14 hours
Overview
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.
14 hours
Overview
Redis is an open source (BSD licensed), in-memory data structure store, used as database, cache and message broker.
14 hours
Overview
This course covers everything a database developer needs to know to successfully develop applications using Aerospike.
7 hours
Overview
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
14 hours
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.
420 hours
Overview
In this instructor-led, live training, participants will learn the foundations of web development as they step through the creation and deployment of a sample application.

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

- Design and implement new user facing features
- Optimize web applications to maximize speed and scale
- Write client-side code for web-based applications
- Create fast, easy to use, high volume production applications and develop prototypes quickly

Audience

- Beginner web developers

Format of the course

- Part lecture, part discussion, exercises and heavy hands-on practice
14 hours
Overview
OrientDB is a NoSQL Multi-Model Database that works with Graph, Document, Key-Value, GeoSpatial, and Reactive models. Its flexibility allows users to manage different kinds of data under one centralized database.

In this instructor-led, live training, participants will learn how to start using OrientDB and utilize its flexibility to manage data.

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

- Install OrientDB
- Learn how to create and manage a database with OrientDB
- Explore the different features and functionalities of OrientDB
- Learn how to work with different APIs on OrientDB
- Deploy OrientDB using Distributed Architecture

Audience

- Software engineers and technicians
- Technical people in all industries
- IT people
- Developers

Format of the course

- Part lecture, part discussion, exercises and heavy hands-on practice
14 hours
Overview
This course provides programmatic interaction with PostgreSQL databases. Learn techniques, syntaxes and structures needed to develop quality applications using PostgreSQL backend. This training also covers SQL Tuning covering best practices for writing efficient SQL.

Target audience includes developers who want to use or extend PostgreSQL, as well as database architects.
14 hours
Overview
This training is designed for Database Administrators and Architects who want to learn PostgreSQL from basics.

You will learn PostgreSQL architecture, installation, designing as well as how to perform backup and recovery databases in PostgreSQL.
14 hours
Overview
This instructor-led, live training (onsite or remote) is aimed at engineers who wish to migrate from Oracle Forms to Oracle Web Forms.

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

- Understand the major feature and architectural changes in Oracle Web Forms.
- Migrate to Oracle Web Forms from a previous Forms version.
- Deploy a Oracle Web Application.
- Leverage Oracle Web Forms to enhance user services and experience.

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.
14 hours
Overview
Oracle Database 18c is the next iteration of Oracle Database 12c Release 2, or "the first patch".

This instructor-led, live training (onsite or remote) is aimed at engineers who wish to set up, deploy, migrate to and manage an Oracle 18c Database.

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

- Understand the major feature and architectural changes from previous Oracle versions.
- Migrate to Oracle 18c from a previous version.
- Deploy Oracle 18c in cloud or on premise.
- Understand Oracle 18c's new yearly release cycle and plan maintenance around it.

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.

Upcoming Database Courses

Weekend Database courses, Evening Database training, Database boot camp, Database instructor-led, Weekend Database training, Evening Database courses, Database coaching, Database instructor, Database trainer, Database training courses, Database classes, Database on-site, Database private courses, Database one on one training

Course Discounts

Course Discounts Newsletter

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 Greece!

As a Business Development Manager you will:

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