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

Testimonials

★★★★★

Ο Κάμιλ ήταν εξαιρετικός στην εξήγησή του ακόμα και στα δύσκολα θέματα με τρόπο που τα κατάλαβα αμέσως. Η παρουσίαση και η παράδοση ήταν σαφείς και μεθοδικές και ο δάσκαλος πάσχει από το θέμα.

Mark Novak - Kiloo

Course: MongoDB for Advanced Users

Translated by

Καλή γνώση του βασικού θέματος, ευχαριστώ. Καθαρή παρουσίαση.

AXWAY INC

Course: Cassandra Administration

Translated by

Η εκπαίδευση ξεπέρασε τις προσδοκίες μου για αυτό που ήλπιζα να μάθω.

Ian Matthews - Cision

Course: MySQL Database Administration

Translated by

Κατά τη γνώμη μου, το καλύτερο σε αυτή την εκπαίδευση ήταν το μέρος της εφαρμογής.

Oberthur Technologies SRL

Course: Fundamentals of Cassandra DB

Translated by

Η εμπειρία πρακτικής + εκπαιδευτή με αυτή τη βάση δεδομένων

Iorga Alexandru - Oberthur Technologies SRL

Course: Fundamentals of Cassandra DB

Translated by

την πρακτική άσκηση

Oberthur Technologies SRL

Course: Fundamentals of Cassandra DB

Translated by

Κάναμε πολλές ασκήσεις.

Oberthur Technologies SRL

Course: Fundamentals of Cassandra DB

Translated by

Καλό να έχουν περισσότερες ασκήσεις από τις διαλέξεις.

DXC Technology via SCC

Course: MongoDB for Administrators

Translated by

Mongod / Mongos / Mongodump / Mongorestore / MongoDB

DXC Technology via SCC

Course: MongoDB for Administrators

Translated by

Μικρή, πολύ εστιασμένη ομάδα μας επέτρεψε σε όλους να μείνουμε άμεσα εμπλεκόμενοι με τον εκπαιδευτή καθ 'όλη τη διάρκεια του χρόνου που γίνεται λιγότερο ευνοϊκός καθώς αυξάνεται το μέγεθος της ομάδας.

Leading Edge Marketing Inc

Course: MySQL Administration

Translated by

Χειμερινές ασκήσεις

Palawan Pawnshop - Palawan Express Pera Padala

Course: MySQL Administration

Translated by

όλη την άσκηση

Palawan Pawnshop - Palawan Express Pera Padala

Course: MySQL Administration

Translated by

Πρακτικό μέρος

Axway

Course: Cassandra Administration

Translated by

Ο πάθος των εκπαιδευτών και η βαθιά γνώση της Κασσάνδρας.

Axway

Course: Cassandra Administration

Translated by

Εκπαιδευτική αίθουσα και αρκετά τοποθεσία και όλα τα πράγματα.

Abdullah Adelyar - USAID - Kabul Afghanistan

Course: Access VBA

Translated by

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

Steve McPhail - Alberta Health Services - Information Technology

Course: Data Analysis with Hive/HiveQL

Translated by

Η Γνωστική Θεματολογία του Εκπαιδευτή

Rares Serea - eMAG IT Research

Course: Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems

Translated by

Μου άρεσε ότι είχε πραγματική τεχνογνωσία για το πότε να χρησιμοποιήσει κάθε τεχνολογία, αυτό είναι πολύτιμο.

Radu Mazilu - eMAG IT Research

Course: Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems

Translated by

Οι αρχές υψηλού επιπέδου για την κυψέλη, το HDFS ...

Geert Suys - Proximus Group

Course: Data Analysis with Hive/HiveQL

Translated by

Ο χειροτέχνης. Η πρακτική mix / theroy

Proximus Group

Course: Data Analysis with Hive/HiveQL

Translated by

Ο Fulvio μπόρεσε να καταλάβει την επιχειρηματική περίπτωση των εταιρειών μας και ήταν σε θέση να συσχετιστεί με το υλικό του μαθήματος σχεδόν αμέσως.

Samuel Peeters - Proximus Group

Course: Data Analysis with Hive/HiveQL

Translated by

πολύ λογικό και βήμα προς βήμα, αλλά όχι πάρα πολύ

Anne Homer - States of Jersey

Course: SQL Fundamentals

Translated by

Ήταν πολύ φιλικός και δημιούργησε ένα πολύ καλό περιβάλλον.

European Commision, Joint Research Centre

Course: SQL Advanced in MySQL

Translated by

τη στάση, τα παραδείγματα και τον καταπληκτικό εκπαιδευτή

Groupon Shared Service Polska

Course: SQL Advanced

Translated by

Παρόλο που είχα ήδη αρκετά καλή γνώση του θέματος, ανακάλυψα πολλά χρήσιμα πράγματα κατά τη διάρκεια του μαθήματος ..

Stefan-Lucian Bucur - Cegeka NV

Course: Building Interactive Applications with React, Redux and GraphQL

Translated by

* Η πρακτική προσέγγιση, η οποία μας βοήθησε να κατανοήσουμε καλύτερα το θέμα. * Η ευελιξία του καθηγητή στην κάλυψη των θεμάτων που σχετίζονται με τις περιπτώσεις χρήσης μας.

Juan Rial - Cegeka NV

Course: Building Interactive Applications with React, Redux and GraphQL

Translated by

ο εκπαιδευτής είναι αρκετά καλά ενημερωμένος.

Balwinder Bal - Bank of Montreal

Course: MongoDB for Administrators

Translated by

Έχω πραγματικά απολαύσει τα πολλά εργαστήρια και πρακτικές.

Vivian Feng - Destination Canada

Course: Data Analysis with SQL, Python and Spotfire

Translated by

Οι ασκήσεις / εργαστήρια προσαρμόστηκαν στις δικές μας οργανωτικές ανάγκες.

Destination Canada

Course: Data Analysis with SQL, Python and Spotfire

Translated by

Μου άρεσε γενικά το θέμα.

Destination Canada

Course: Data Analysis with SQL, Python and Spotfire

Translated by

Μου άρεσε η ευελιξία να εξερευνήσω διαφορετικές περιοχές έξω από τα καθορισμένα εκπαιδευτικά υλικά.

BMW Group

Course: SQL Fundamentals

Translated by

Μην αφήνετε τα σπασίματα. Τουλάχιστον ο χρόνος δεν σπαταλάται σε διαλείμματα ..

ST Electronics (Info-Software Systems) Pte Ltd

Course: MongoDB for Developers

Translated by

ο εκπαιδευτής έχει εκτενή γνώση της πληροφορικής.

Iwan Susanto - Universitas Terbuka

Course: Advanced MariaDB for High Availability and Performance

Translated by

Μου άρεσε περισσότερο οι πρακτικές συνεδρίες.

AVL List GmbH

Course: MongoDB for Administrators

Translated by

Ο εκπαιδευτής μπόρεσε να απαντήσει σχεδόν σε όλες τις ερωτήσεις κατά τη διάρκεια της εκπαίδευσης, έχει μεγάλη γνώση θεμάτων.

AVL List GmbH

Course: MongoDB for Administrators

Translated by

n / d

Artur Bryś - Centrum Innowacji ProLearning

Course: SQL Fundamentals

Translated by

Απόλαυσα κυρίως τη γνώση σχετικά με τη βάση δεδομένων αναπαραγωγής.

Suparman - Universitas Terbuka

Course: Advanced MariaDB for High Availability and Performance

Translated by

Ήταν εξαιρετικό. Εξαιρετική ενημέρωση και έμπειρος εκπαιδευτής. Πολύ καλή μάθηση. Πραγματικά πήρα πολλά από αυτό.

University of Victoria

Course: PostgreSQL for Administrators

Translated by

* πολύ ξεκάθαρο * μεγάλη χρήση του μαυροπίνακα σε συνδυασμό με PP διαφάνειες.

University of Victoria

Course: PostgreSQL for Administrators

Translated by

Οι διαλέξεις ήταν πολύ ενδιαφέρουσες και τα θέματα εξηγήθηκαν καλά.

Maciej Szarski - Finder.com Poland Sp. z o. o.

Course: Redis for Developers and System Administrators

Translated by

Μου άρεσε περισσότερο να είμαι από το REDIS-μόνο θέματα και να έχω ευρύτερη άποψη και επεξήγηση του τρόπου με τον οποίο λειτουργούν τα κατανεμημένα μοτίβα.

Finder.com Poland Sp. z o. o.

Course: Redis for Developers and System Administrators

Translated by

Μου άρεσε η πρακτική και άμεση εφαρμογή των εννοιών στις διαλέξεις.

Nordex Energy GmbH

Course: MS SQL Server 2016

Translated by

Υπήρξε μια καλή ποσότητα πρακτικών ασκήσεων που βοήθησαν στην παγίωση της μάθησης και μας κράτησαν απασχολείς σε όλη τη διάρκεια.

Samuel Reeve - Capita Business Services Ltd

Course: PostgreSQL Administration, Optimization and Replication

Translated by

Η ίδια η εκπαίδευση υποστηρίζεται πλήρως από τα διαθέσιμα υλικά, αλλά η ικανότητα του εκπαιδευτή να προσαρμοστεί σε αυτό που ο πελάτης θέλει να μάθει είναι πραγματικά κάτι. Kudos!.

Roi Magboo - Infomax Systems Solutions and Services Inc.

Course: MongoDB for Administrators

Translated by

Νόμιζα ότι έκανε καλή δουλειά στην προσαρμογή της εμπειρίας στο κοινό. Αυτή η κλάση σχεδιάστηκε κυρίως για να καλύψει την ανάλυση δεδομένων με την ΚΥΨΈΛΗ, αλλά εγώ και ο συμεργάτης μου κάνουμε διαχείριση ΚΥΨΈΛΗς χωρίς πραγματικές ευθύνες ανάλυσης δεδομένων.

ian reif - Franchise Tax Board

Course: Data Analysis with Hive/HiveQL

Translated by

αλληλεπίδραση με τον δάσκαλο. Είχαμε πολλές συζητήσεις για τα διάφορα θέματα.

arno bongenaar - KLM Accounts Payable SPL/AP

Course: Redis for Developers and System Administrators

Translated by

Σε βάθος γνώση του εκπαιδευτή και την αμερόληπτη γνώμη του. Αισθάνθηκε σαν να μας δίδασκε πραγματικά για το θέμα (REDIS), του επαγγελματία και con, και δεν το πωλούν.

KLM Accounts Payable SPL/AP

Course: Redis for Developers and System Administrators

Translated by

Μου άρεσε η μικρή ομάδα, καλή αλληλεπίδραση και δυνατότητα να προσαρμόσετε.

Erik de Ruiter - KLM Accounts Payable SPL/AP

Course: Redis for Developers and System Administrators

Translated by

Το ποσό της γνώσης που έχουμε.

Course: Beyond the Relational Database: Neo4j

Translated by

Εκτεταμένη γνώση των περιοχών NoSQL, όχι μόνο της Κασσάνδρας (ex: HAΝΤΟΥΠ)

Stefan Marcoci - Vidéotron ltée

Course: Cassandra Administration

Translated by

Το ποσό της γνώσης που έχουμε.

Course: Beyond the Relational Database: Neo4j

Translated by

Database Course Outlines

Title

Duration

Overview

Title

Duration

Overview

Access Intermediate

14 hours

Overview

The course participants will learn the terminology of relational databases, acquire the skills to design database applications, know the basic principles of creating forms and reports.

Oracle SQL Intermediate - Data Extraction

14 hours

Overview

The objective of the course is to enable participants to gain a mastery of how to work with the SQL language in Oracle database for data extraction at intermediate level.

PostgreSQL Performance Tuning

7 hours

Overview

This training is designed for Database Administrators and Architects who want to tune PostgreSQL Database for Performance. Learn how to log slow workload and find the possible pain points in a query. This topic also covers the most important parameters that must be tuned for optimal performance.

Implementing High Availability in PostgreSQL

7 hours

Overview

This training is designed for Database Administrators and Architects who want to learn Streaming Replication in PostgreSQL and how pgpool-II can be used to achieve automatic failovers and setup a highly available PostgreSQL Database Cluster.

PostgreSQL Advanced DBA

14 hours

Overview

This training is designed for Database Administrators and Architects who want to learn the tools and techniques for implementing High Availability and Database Security in PostgreSQL.

You will also learn how to find slow queries, monitor database performance and tune PostgreSQL for Performance.

PostgreSQL Essentials

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.

PostgreSQL for Administrators

14 hours

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.

Administration with Powershell

35 hours

Overview

This intensive training provides the fundamental knowledge and skills to use Windows PowerShell for automating administration of Windows based computers. The skills taught in this course are applicable to all Microsoft products that use Windows PowerShell for daily administration.

Training focuses mainly on using Windows PowerShell as an interactive command line interface however it also includes some coverage of scripting and programming topics.

PostgreSQL Administration and Development

28 hours

Overview

This course handles the administration and performance tuning of PostgreSQL databases. Attendees will learn the use of specialised PostgreSQL (AKA Postgres) modules such as replication, connection pooling and full text searching.

Administrating Percona Server for MongoDB

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

Oracle SQL Intermediate

14 hours

Overview

Audience

All who want to improve their basic skills in Oracle SQL and also systematize already gained knowledge.

Format of the course

25% lectures, 75% labs

ORACLE SQL Fundamentals

14 hours

Overview

This 3 day course gives an introduction to SQL Developer, SQL*Plus and to SQL, the Structured Query Language used to access a Relational Database and includes the new features of the latest version of ORACLE. The principles learnt may also be applied to databases as diverse as Microsoft SQL Server, MySQL, Access, Informix and DB2.

The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core elements.

Full course notes are provided along with sample database files, example SQL files and free software tools for use in accessing an ORACLE database.

PostgreSQL for Developers

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.

Oracle SQL for development and database management

35 hours

Overview

This 5-day course demonstrates how to use Oracle SQL for database development and database management.

OrientDB for Developers

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

Migrating to Oracle Web Forms

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.

Oracle 18c Migration Strategy

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.

ORACLE PL/SQL Fundamentals

21 hours

Overview

This 3 day course gives an introduction to ORACLE PL/SQL, an application development environment that enables the writing of stored procedures, functions and triggers using both SQL and PL/SQL commands.

The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core elements.

Full course notes are provided along with sample database files, example SQL files and free software tools for use in accessing an ORACLE database.

A Practical Introduction to NoSQL Databases

28 hours

Overview

Relational databases have been the technology of choice for storing, retrieving and querying data. Relational databases allow users to organize their data using a structured, well-defined set of patterns (model). While this approach works well for storing data that is standardized and well-understood in advance (think of a hospital check-in application that holds patient records with the same consistent set of pre-defined fields...patient id, first name, last name, date of last visit, etc.), there are limitations to this model. For organizations whose incoming data is not well-defined (think of an online inquiry form for a startup whose still in the process of experimenting with different fields for collecting visitor data, removing and adding fields as they go to accommodate for the changing nature of the business), any established definitions for how the data should fit into an existing database would need to be re-defined regularly. This would require recreating the data model (schema) that dictates the structure of the data and its allowed data types to support different types of data inputs, etc., before any new data could be saved to the database.

Enter NoSQL (Not Only SQL) databases. NoSQL databases free users from having to predefine the structure of the incoming data, allowing them to insert and update new data on the fly. NoSQL databases are often faster than relational databases and can handle very large amounts of data with ease. NoSQL databases also scale better than relational databases, due to their ability to efficiently partition data across many servers (cluster) and load balancing the access to this data. NoSQL databases integrate particularly well with applications that support real-time analytics, site personalization, IoT, and mobile apps

In this instructor-led, live training , participants will understand the architecture, design principles and functionality of the most popular NoSQL databases on the market as they setup, operate and asses a number of NoSQL databases in a live lab environment. The goal of this training is to equip participants with the ability to intelligently evaluate, propose and implement a suitable NoSQL database solution within their organization.

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

- Install and configure different types of NoSQL databases, including MongoDB, Cassandra, Redis and Neo4j
- Understand the benefits and disadvantages of NoSQL databases vs relational databases
- Understand the underlying data formats used by NoSQL databases and how these formats can be used to an advantage when developing modern applications (desktop, mobile, cloud, IoT)
- Perform create, insert, update, delete operations in a NoSQL database
- Setup a mixed environment with both a relational database and NoSQL working in tandem
- Configure a cluster of NoSQL database for distributed processing of very large datasets
- Understand the security implications of using a NoSQL database
- Deploy and scale a NoSQL database in a production environment

Audience

- Database professionals
- Data architects
- Data strategists
- Project managers
- Application developers wishing to integrate a flexible database solution in their application

Format of the Course

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

Note

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

Beyond the Relational Database: Neo4j

21 hours

Overview

Relational, table-based databases such as Oracle and MySQL have long been the standard for organizing and storing data. However, the growing size and fluidity of data have made it difficult for these traditional systems to efficiently execute highly complex queries on the data. Imagine replacing rows-and-columns-based data storage with object-based data storage, whereby entities (e.g., a person) could be stored as data nodes, then easily queried on the basis of their vast, multi-linear relationship with other nodes. And imagine querying these connections and their associated objects and properties using a compact syntax, up to 20 times lighter than SQL. This is what graph databases, such as neo4j offer.

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.

MySQL Database Administration

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.

MS SQL Server 2016

14 hours

Overview

As a core of the Microsoft data platform, SQL Server is a leading operational database management system.

MongoDB for Python Developers

14 hours

Overview

This instructor-led, live training (onsite or remote) is aimed at developers wishing to learn how to use MongoDB as the database for Python their applications.

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

- Install and configure MongoDB
- Understand the difference between accessing a NoSQL document database and a traditional relational databases' (e.g., MySQL)
- Query a MongoDB database from within Python
- Create and write data to a MongoDB databasse
- Understand MongoDB's "data processing pipeline"
- Perform real-time analytics and statistical analysis
- Generate reports for dashboarding
- Implement exception handling in Python application

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.

PostgreSQL Administration, Optimization and Replication

35 hours

Overview

PostgreSQL (or Postgres) is one of the most popular open-source relational databases.

In this instructor-led, live training (onsite or remote), participants will learn the general and advanced aspects of PostgreSQL, including administration, performance turning, advanced development, and replication as they step through a series of hands-on, live-lab exercises involving setup, configuration, testing, deployment and troubleshooting.

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

- Use advanced administration techniques to configure and manage a PostgreSQL server.
- Optimize the database and queries for maximum performance.
- Replicate and scale a PostgreSQL server.

Format of the Course

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

Note

- This course is based PostreSQL 9 but can be adapted for a different version.
- To request a customized training for this course, please contact us to arrange.

Percona Server for MySQL

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

Access VBA

21 hours

Overview

SQL Advanced in MySQL

7 hours

Overview

This course has been created for people already acquainted with SQL. The course introduces you into secrets common to all SQL databases as well as MySQL specific syntax, functions and features.

Voldemort: Setting Up A Key-Value Distributed Data Store

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

VBA For Access & Excel

21 hours

Overview

The objective of the course is to enable participants to gain a mastery of the fundamentals and usages of VBA for Access & Excel.

Transact SQL Basic

14 hours

Overview

Delegates will gain an understanding of the basic principles of Structured Query Language as well as being able to do each of the following:

- Construct queries to extract and filter data from an SQL Server database
- Create summarised results
- Change, derive and format data to suit the required output
- Change data and maintain database components and definitions

This course is for anybody who needs information from a Microsoft SQL Server database. It is suitable for either system developers or people from other areas who need to use SQL to extract and analyse data.

Upcoming Database Courses

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2019-05-20 09:30:00

Nicosia, Jacovides Tower

Remote

3000EUR

Classroom

3600EUR

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2019-07-01 09:30:00

Θεσσαλονίκη (Thessaloniki)

Remote

3000EUR

Classroom

3600EUR

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2019-07-29 09:30:00

Nicosia, Jacovides Tower

Remote

3000EUR

Classroom

3600EUR

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2019-09-26 09:30:00

Θεσσαλονίκη (Thessaloniki)

Remote

3000EUR

Classroom

3600EUR

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2019-10-28 09:30:00

Nicosia, Jacovides Tower

Remote

3000EUR

Classroom

3600EUR

Other regions

Κύπρος Λευκωσία Αθήνα Πάτρα Θεσσαλονίκη

Other countries

These courses are also available in other countries ››

Consulting

Database Consulting

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