Database Training Courses

Database Training

Database Courses

Client Testimonials

A practical introduction to Data Analysis and Big Data

Overall the Content was good.

Sameer Rohadia - Continental AG / Abteilung: CF IT Finance

Beyond the relational database: neo4j

The trainer did bring some good insight and ways to approach developing a graph database. He used examples from the slides presented but also drew on his own experience which was good.

Autodata Ltd

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Attention to detail, knowledge and enthusiasm for the subject

Bristol City Council

SQL Fundamentals

I learned a LOOOOOT

Kamil Szmid - UBS Business Solutions Poland Sp. z o. o.

PostgreSQL for Administrators

Trainer Subject Knowledge

Julian Pirau - BMO Financials

Oracle SQL Intermediate

Trainer provided some topic and support it with plenty of exercises. We had a chance to apply knowledge by doing them on our own.

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

Redis for Developers and System Administrators

training knowledge and techinic

Sutiipong Bumlungvech - The Enterprise Resources Training Co., Ltd.

PostgreSQL for Administrators

I wish we could had a lab time, maybe the amount of time of training is tighten, we did not have lab time in class.

Gary Pan - Ryerson University

Cassandra for Developers

Very good explanations with in depth examples

Rui Magalhaes - Farfetch Portugal - Unipessoal, Lda

MongoDB for Developers

open mind and communication

Oleksiy Deliyev - Insight Enterprises

MongoDB for Administrators

Most of the hands on stuff was good.

Andrew Bauer - Availity

Introduction to SQL Server 2012 Integration Services (SSIS)

The thorough / hands-on knowledge the trainer has

Pieter Peirs - ING BE

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Attention to detail, knowledge and enthusiasm for the subject

Bristol City Council

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Attention to detail, knowledge and enthusiasm for the subject

Bristol City Council

MariaDB Database Administration

Training material was very informative. Learned a lot

Yaw Asamoah - FEDERAL AVIATION ADMINISTRATION

Oracle 11g - SQL language for developers - Workshop

good atmosphere during the training

clovis Nebouet - HSBC Service Delivery; ITEKNA POLSKA Sp. z o.o.

MongoDB for Administrators

The clear depth of knowledge the trainer had, which really shone when combined with his evident enthusiasm for the subject.

Joseph Brailsford - Egress Software Technologies

MongoDB for Administrators

Even though I have been using MongoDB for a while, there were still some new "basic" things that Kamil taught us - as well as teaching us the advanced topics we need to move our projects forwards.

Adam McKay - Egress Software Technologies

Data Analysis with Hive/HiveQL

The competence and knowledge of the trainer

Jonathan Puvilland - Proximus

Oracle Application Express Introduction

The format was really good, the exercises were not too difficult and helped us to fully understand the tool.

Juan Salvador Rios Hoyos- Oracle

MariaDB Database Administration

lessons and examples

Kelly Taylor - FEDERAL AVIATION ADMINISTRATION

Oracle SQL Intermediate

Access to trainers individual support in resolving exercises.

Tomasz Czornak - UBS Business Solutions Poland Sp. z o.o.

SQL in SQL Server

Lukasz (the trainer) was very knowlegable and importantly adaptable to the different levels of knoweldge in the room, tailoring help and teaching on an individual level which was great. Very open and apporachable, being informativite, clear and providing good mechanisms for genuine understanding of the material provided.

Thomas Houiellebecq- Ernst & Young AG

MongoDB for Administrators

monitoring

Ling Xiao - The Globe and Mail

MongoDB for Administrators

Relevant to need.

Damon Grube - Availity

Transact SQL Advanced

The ability to ask questions at any time and the more informal / less structured style. This allowed us to pursue the areas of knowledge we were most interested in.

Jim Lane - Bristol City Council

Beyond the relational database: neo4j

The trainer did bring some good insight and ways to approach developing a graph database. He used examples from the slides presented but also drew on his own experience which was good.

Autodata Ltd

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Attention to detail, knowledge and enthusiasm for the subject

Bristol City Council

Oracle 11g - SQL language for developers - Workshop

I like fact, that after each section we had exercises. It helps to remember discused topic.

Adam Bińczycki - HSBC Delivery; ALTEN Polska Sp. z o.o.; Mindbox S.A.; HSBC Delivery

MongoDB for Administrators

Adrian was knowledgeable in Linux and MongoDB. He was able to troubleshoot the labs on our computers very quickly when we had mistakes.

MInistry of Defence

Beyond the relational database: neo4j

Flexibility to blend in with Autodata related details to get more of a real world scenario as we went on.

Autodata Ltd

MariaDB Database Administration

Enjoyed the pace, delivery and technical knowhow of the trainer

Junaid Kalang - Capita CSL

Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012

I appreciated Fulvio's wide breadth of knowledge. Not only was he familiar with the course content, but he also knew of constructs in languages we were familiar with to make examples more meaningful to us. During intervals he shared his knowledge of technologies and solutions outside the training scope to provide insights into other solutions we could use in future (and future training).

Raphael Keymer - Markit Valuations Limited

Cassandra for Developers

There was a lot of knowledge and material shared that will help me to do my current tasks.

Miguel Fernandes - Farfetch Portugal - Unipessoal, Lda

A practical introduction to Data Analysis and Big Data

Willingness to share more

Balaram Chandra Paul - MOL Information Technology Asia Limited

Data Analysis with Hive/HiveQL

Liked very much the interactive way of learning.

Luigi Loiacono - Proximus

SQL Fundamentals

The trainer, he was knowledgeable, engaging, and easy to learn from. he encouraged a lot of hands on learning

Shawn McAndrew - Halifax Regional Municipality

PostgreSQL for Administrators

I liked everything he taught.

Emily Zhou - Ryerson University

MongoDB for Administrators

The explanations

Lowe's

MongoDB for Developers

super athmosphere, working with mongo shell

Jan Sturm - AVL List GmbH

A practical introduction to Data Analysis and Big Data

presentation of technologies

Continental AG / Abteilung: CF IT Finance

MongoDB for Administrators

The structure and pace of the class was great.

David Lacy - Availity

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Attention to detail, knowledge and enthusiasm for the subject

Bristol City Council

MongoDB for Administrators

tailored to cover our organisations questions.

Robin Bell - Egress Software Technologies

Cassandra for Developers

Topics approached. Very complete.

Carlos Eloi Barros - Farfetch Portugal - Unipessoal, Lda

Cassandra Administration

The 1:1 style meant the training was tailored to my individual needs.

Andy McGuigan - Axon Public Safety UK Limited

MariaDB Database Administration

he adapted to the experience of the group - gave us great value for a beginners course.

Rich Mickey - FEDERAL AVIATION ADMINISTRATION

Cassandra for Developers

The practical exercises and examples of implementing examples of real models and contexts

Leandro Gomes - Farfetch Portugal - Unipessoal, Lda

Cassandra for Developers

All technical explanation and theoretical introduction

André Santos - Farfetch Portugal - Unipessoal, Lda

A practical introduction to Data Analysis and Big Data

It covered a broad range of information.

Continental AG / Abteilung: CF IT Finance

Database Course Outlines

Code Name Duration Overview
gfsjeeint Administering GlassFish Server with Java EE applications introduction 21 hours
hadoopmapr Hadoop Administration on MapR 28 hours Audience: This course is intended to demystify big data/hadoop technology and to show it is not difficult to understand.
seqdb SequoiaDB for Developers 14 hours 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. Audience This course assumes prior knowledge of SQL and is targeted at engineers seeking to deploy and integrate SequoiaDB instances. After completing this course, delegates will: understand SequoiaDB’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 integration, migration and development
66437 Microsoft SQL Server 2008/2012 (MSSQL) 14 hours This course has been created for delegates already acquainted with SQL in Microsoft SQL Server Environment 2008/2012. The course focuses on set-based querying and query tuning, working with indexes and analyzing execution plans. The training also covers table expressions, ranking functions and how to deal with partitioned tables.
aerosdev Aerospike for Developers 14 hours This course covers everything a database developer needs to know to successfully develop applications using Aerospike.
teraintro Teradata Fundamentals 21 hours 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
kdbplusandq kdb+ and q: Analyze time series data 21 hours 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
orientdb OrientDB for Developers 14 hours 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
transsqladv Transact SQL Advanced 7 hours Delegates will gain an understanding of some of the more advanced features of Transact SQL as well as being able to do each of the following: Use queries to return complex result sets Manage database objects to aid query performance Tune queries to perform more efficiently This course is for anyone who currently uses Transact SQL to extract data from a Microsoft SQL Server database and wishes to expand their knowledge particularly in the areas of data analysis and improving query speed.
68962 MySQL Administration 32 hours Audience: Any IT professionals who aspire to become DBAs or database support professionals on MySql Database on linx/windows platforms. Format: 40% theoretical/lectures, 60%Practical/hands on lab
couch Apache CouchDB for Developers 14 hours 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.
3457 Oracle 11g - Application Tuning - Workshop 28 hours For who The workshop is intended for advanced programmers and Oracle users who seek knowledge and information on the efficient development of information systems in an Oracle database, and the tuning and testing of performance issues in existing applications. This course builds on knowledge often unavailable or incorrectly presented in the technical documentation, and collected during many years of practice leading them instructors. These workshops may be the end of the training path for developers, or a single step for people with extensive experience designing and programming in Oracle Purpose of training The workshop aims to provide mechanisms that occur in an Oracle database when performing SQL statements. Allows participants to avoid errors during software development, and explore, diagnose, and resolve performance problems in existing applications. Particular emphasis is placed on the workshops, where we show the methodology and the practical aspects of the application and tuning SQL statements. The content of the training Mechanics perform SQL commands Managing the process cost optimization Methods of data storage and indexing Monitoring database performance and processes based on dictionaries and track system applications Analysis of cases of the most common problems that cause performance Notes The workshops are based on the software version 11g XE
redisadev Redis for Developers and System Administrators 14 hours Redis is an open source (BSD licensed), in-memory data structure store, used as database, cache and message broker.
ApHadm1 Apache Hadoop: Manipulation and Transformation of Data Performance 21 hours This course is intended for developers, architects, data scientists or any profile that requires access to data either intensively or on a regular basis. The major focus of the course is data manipulation and transformation. Among the tools in the Hadoop ecosystem this course includes the use of Pig and Hive both of which are heavily used for data transformation and manipulation. This training also addresses performance metrics and performance optimisation. The course is entirely hands on and is punctuated by presentations of the theoretical aspects.
riak Riak: Build Applications with High Data Accuracy 14 hours 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
webdevonboarding Web Developer On-boarding Training 420 hours 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
transsqlbas Transact SQL Basic 14 hours 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 a 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.
cassdbfun Fundamentals of Cassandra DB 21 hours This course introduces the basics of Cassandra 2.0 including its installation & configuration, internal architecture, tools, Cassandra Query Language, and administration. Audience Administrators and developers seeking to use Cassandra. This course serves as a foundation and prerequisite for other advanced Cassandra courses.  
surveyp Research Survey Processing 28 hours This four day course walks you from the point you design your research surveys to the tme where you gather and collect the findings of the survey. The course is based on Excel and Matlab. You will learn how to design the survey form and what the suitable data fields should be, and how to process extra data information when needed. The course will show you the way the data is entered and how to validate and correct wrong data values. At the end the data analysis will be conducted in a variety of ways to ensure the effectiveness of the data gathered and to find out hidden trends and knowledge within this data. A number of case studies will be carried out during the course to make sure all the concepts have been well understood.
3419 Oracle 11g - Programming with PL / SQL II 21 hours For who This training is in addition to, and continuation of the 'Oracle 11g - Programming in PL / SQL and - workshops ", but can also be designed for practitioners, developers, PL / SQL who already have experience with the language, and who want to systematize their knowledge and learn advanced mechanisms and solutions developed in this language. The content of the training Objects, streams and complex data structures Advanced solutions based on PL / SQL Exams and Certificates The plan covers the training material required to pass the exam 1Z0-146 Oracle Advanced PL / SQL and obtain the title of Oracle Advanced PL / SQL Developer Certified Professional Purpose of training The training is designed to familiarize participants with the advanced aspects of programming in an Oracle database. The emphasis is on flexibility and performance solutions based on PL / SQL. Notes The workshops are based on the software version 11g XE
cassadmin Cassandra Administration 14 hours 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.
meanangular2 Angular 2: Building Web Apps using the MEAN stack 35 hours MEAN stack is a full-stack JavaScript solution that helps you write and deploy scalable, robust, and maintainable web applications quickly and easily using MongoDB, Express, Angular, and Node.js. By the end of this hands-on intensive training course, the students will be able to: Store the data in NoSQL, document-oriented MongoDB database that brings performance and scalability. Use Node.js, the server-side platform built on Google V8’s runtime for building fast, scalable network applications. Use Express, a simple yet powerful web application development HTTP server framework built on top of Node.js. Use Angular 2 framework that offers declarative, two-way data binding for web applications. Take advantage of the ‘full-stack JavaScript’ paradigm i.e. store documents in JSON-like format in MongoDB, author JSON queries in Node.js/Express.js, and forward these JSON documents back to an Angular-based frontend. Get acquainted with the latest web application development trends in the IT industry. Notes: Angular is available in different versions, for example: AngularJS ( a.k.a. Angular.js, AngularJS 1, and Angular 1) Angular 2 Angular 4 etc. This training covers Angular 2. For all other components (Node.js, Express, MongDB) we cover the latest stable version. If you wish to customize the versions taught in this training, please contact us to arrange.  
hypertable Hypertable: Deploy a BigTable like database 14 hours 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
bigdatabicriminal Big Data Business Intelligence for Criminal Intelligence Analysis 35 hours Advances in technologies and the increasing amount of information are transforming how law enforcement is conducted. The challenges that Big Data pose are nearly as daunting as Big Data's promise. Storing data efficiently is one of these challenges; effectively analyzing it is another. In this instructor-led, live training, participants will learn the mindset with which to approach Big Data technologies, assess their impact on existing processes and policies, and implement these technologies for the purpose of identifying criminal activity and preventing crime. Case studies from law enforcement organizations around the world will be examined to gain insights on their adoption approaches, challenges and results. By the end of this training, participants will be able to: Combine Big Data technology with traditional data gathering processes to piece together a story during an investigation Implement industrial big data storage and processing solutions for data analysis Prepare a proposal for the adoption of the most adequate tools and processes for enabling a data-driven approach to criminal investigation Audience Law Enforcement specialists with a technical background Format of the course Part lecture, part discussion, exercises and heavy hands-on practice
sqlfun SQL Fundamentals 14 hours This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn: how to write SQL queries what relational databases are and how we can use them what are relations and how to create them the structure of data differences between SQL dialects (Oracle, T-SQL, ANSI) practical skills for writing queries This SQL course deals with generic ANSI SQL. It can be used in any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL any other relational databases.
3134 Oracle Application Express Introduction 21 hours Audience Course aimed at developers Format of the course 35% lectures, 65% labs
mariadbgc MariaDB Galera Cluster Administration 21 hours This course is intended for database administrators. The course presents options for High-Availability solutions using Galera Cluster. You will learn the basics of Galera technology, as well as more advanced topics and practical knowledge related to configuring, optimizing and administering a Galera Cluster.
percsera Administrating Percona Server for MongoDB 7 hours 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
3410 Oracle 11g - Programming with PL / SQL I - Workshops 28 hours For who Workshops are dedicated to developers, end users and administrators, who until now have had no contact with the language PL / SQL, and the need to exploit its huge potential in working with a database, automate processes, and in building applications Exams and Certificates The plan covers the training material required to pass the exam 1Z0-144 Oracle Database 11g Program with PL / SQL and obtain the title of Oracle PL / SQL Developer Certified Associate Purpose of training The workshop aims to familiarize participants with the programming language PL / SQL, its capabilities and limitations. This workshop will include a full understanding of the mechanisms involved in the programming language PL / SQL needed to implement the logic of the free applications, automation of data processing and database management. The content of the training Introduction to PL / SQL architecture solutions based on this language, the organization of the working environment Create scripts and stored program units that operate on data Notes The workshops are based on the software version 11g XE
dbalogicmigration Database Logic Migration 7 hours 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.
storm Apache Storm 28 hours Apache Storm is a distributed, real-time computation engine used for enabling real-time business intelligence. It does so by enabling applications to reliably process unbounded streams of data (a.k.a. stream processing). "Storm is for real-time processing what Hadoop is for batch processing!" In this instructor-led live training, participants will learn how to install and configure Apache Storm, then develop and deploy an Apache Storm application for processing big data in real-time. Some of the topics included in this training include: Apache Storm in the context of Hadoop Working with unbounded data Continuous computation Real-time analytics Distributed RPC and ETL processing Request this course now! Audience Software and ETL developers Mainframe professionals Data scientists Big data analysts Hadoop professionals Format of the course     Part lecture, part discussion, exercises and heavy hands-on practice
globalsight Globalsight: Automate the localization process 7 hours Globalight 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: Undertand 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 Build and 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
mlfinancepython Machine Learning for Finance (with Python) 21 hours Machine learning is a branch of Artificial Intelligence wherein computers have the ability to learn without being explicitly programmed. In this instructor-led, live training, participants will learn how to apply machine learning techniques and tools for solving real-world problems in the finance industry. Python will be used as the programming language. Participants first learn the key principles, then put their knowledge into practice by building their own machine learning models and using them to complete a number of team projects. By the end of this training, participants will be able to: Understand the fundamental concepts in machine learning Learn the applications and uses of machine learning in finance Develop their own algorithmic trading strategy using machine learning with Python Audience Developers Data scientists Format of the course Part lecture, part discussion, exercises and heavy hands-on practice
sqlmysqladv SQL Advanced in MySQL 7 hours 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.
3119 Business Intelligence in MS SQL Server 2008 14 hours Training is dedicated to the basics of create a data warehouse environment based on MS SQL Server 2008. Course participant gain the basis for the design and construction of a data warehouse that runs on MS SQL Server 2008. Gain knowledge of how to build a simple ETL process based on the SSIS and then design and implement a data cube using SSAS. The participant will be able to manage OLAP database: create and delete database OLAP Processing a partition changes on-line. The participant will acquire knowledge of scripting XML / A and MDX.
osqlint Oracle SQL Intermediate 14 hours 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
couchad Apache CouchDB for Administrators 21 hours 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 administrators and developers seeking to maintain a CouchDB instance.
3358 Oracle 11g - SQL language for developers - Workshop 35 hours For who Workshops are dedicated as a first step for developers and designers of applications based on Oracle databases. Participants do not need to have any prior knowledge of the Oracle database, or other relational database systems, even though such knowledge may be useful. Exams and Certificates The plan covers the training material required to pass the exam 1Z0-047 Oracle Database SQL Expert and obtain the title of Oracle Database SQL Certified Expert Purpose of training The workshop aims to familiarize participants with the Oracle database techniques to build database structures and data manipulation. Particular emphasis is placed on the participant to see across the board, which offers opportunities to design and build applications Relational Database Management System, Oracle Database, and to be able to independently work with her. The content of the training Introduction to database technology and the organization of the work environment Acquisition and modification of data Construction of the repository application Safety and concurrency runtime Notes The workshops are based on the software version 11g XE
datapyth Data Analysis in Python using Pandas and Numpy 14 hours Pandas is a Python package that provides data structures for working with structured (tabular, multidimensional, potentially heterogeneous) and time series data.
kylin Apache Kylin: From classic OLAP to real-time data warehouse 14 hours Apache Kylin is an extreme, distributed analytics engine for big data. In this instructor-led live training, participants will learn how to use Apache Kylin to set up a real-time data warehouse. By the end of this training, participants will be able to: Consume real-time streaming data using Kylin Utilize Apache Kylin's powerful features, including snowflake schema support, a rich SQL interface, spark cubing and subsecond query latency Note We use the latest version of Kylin (as of this writing, Apache Kylin v2.0) Audience Big data engineers Big Data analysts Format of the course Part lecture, part discussion, exercises and heavy hands-on practice
flockdb Flockdb: A Simple Graph Database for Social Media 7 hours 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 setup 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
mysqladm MySQL Database Administration 14 hours 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.
ddavsvbsqls Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012 21 hours This course is divided into 3 main sections and is made up of a mixture of presentations and practical exercises. VB.NET Language in Visual Studio 2012 VB.NET Object Orientation VB.NET and Sql Server 2012
dnswebmaildb Top 4 Linux/Unix Servers - DNS,Web,Mail and Database 28 hours Created Linux/Unix Administrators and developers who are interested with getting involved in LInux/Unix Servers Even beginners, who have the basic skill and knowledge on Linux, can catch up with this course just if you follow the instructor's lab and explanation in detail. This course is intended to practice enough Managing Linux Servers and to show it is very easy to understand Linux/Unix servers. This course will be delivered to audience with 40% lectures, 50% labs and 10% Q&A. This five-day course strongly emphasizes lab-based activities. You'll learn how to deploy and manage Top 4 Linux Servers that provide highly useful network services to a mission-critical enterprise environment. It can be deliver on any distribution (Fedora, CentOS are commonly used)
seqdba SequoiaDB for Administrators 14 hours 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.
3331 Oracle 11g - Advanced data analysis - workshops 35 hours For who These workshops are a continuation and complement the training of Oracle 11g data-analysis - a workshop dedicated to end users, data analysts and software testers for execution of professional duties which require more advanced techniques for working with the database. As in the case of the training of Oracle 11g data-analysis - workshops, participants do not need to be computer scientists, but the people who need efficient, and above all efficiently use the Oracle database, processing and analyzing stored in the large amounts of data Purpose of training The workshop aims to broaden the knowledge of participants about programming using PL / SQL and issues related to the optimization commands. Particular emphasis in this training is the performance of the data collection to ensure a smooth operation for very large amounts of data. In addition, workshops supplement an understanding of the elements necessary to any advanced user of Oracle in their daily work, such as copying and downloading large amounts of information, data modeling, modification of an existing data model and reverse engineering techniques using Oracle tools. The content of the training Moving and loading Procedural language PL / SQL allows you to expand the analytical capabilities of a SELECT statement Improving the performance of SQL queries Data modeling and acquisition and modification of the existing data model based on Oracle SQL Modeler Notes The workshops are based on the software version 11g XE
neo4j Beyond the relational database: neo4j 21 hours 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 hands-on course, we will set up a live project and put into practice the skills to model, manage and access your data. 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. Audience Database administrators (DBAs) Data analysts Developers System Administrators DevOps engineers Business Analysts CTOs CIOs Format of the course Heavy emphasis on hands-on practice. Most of the concepts are learned through samples, exercises and hands-on development.
matlabdsandreporting MATLAB Fundamentals, Data Science & Report Generation 126 hours In the first part of this training, we cover the fundamentals of MATLAB and its function as both a language and a platform.  Included in this discussion is an introduction to MATLAB syntax, arrays and matrices, data visualization, script development, and object-oriented principles. In the second part, we demonstrate how to use MATLAB for data mining, machine learning and predictive analytics. To provide participants with a clear and practical perspective of MATLAB's approach and power, we draw comparisons between using MATLAB and using other tools such as spreadsheets, C, C++, and Visual Basic. In the third part of the training, participants learn how to streamline their work by automating their data processing and report generation. Throughout the course, participants will put into practice the ideas learned through hands-on exercises in a lab environment. By the end of the training, participants will have a thorough grasp of MATLAB's capabilities and will be able to employ it for solving real-world data science problems as well as for streamlining their work through automation. Assessments will be conducted throughout the course to gauge progress. Format of the course Course includes theoretical and practical exercises, including case discussions, sample code inspection, and hands-on implementation. Note Practice sessions will be based on pre-arranged sample data report templates. If you have specific requirements, please contact us to arrange.
fsharpfordatascience F# for Data Science 21 hours Data science is the application of statistical analysis, machine learning, data visualization and programming for the purpose of understanding and interpreting real-world data. F# is a well suited programming language for data science as it combines efficient execution, REPL-scripting, powerful libraries and scalable data integration. In this instructor-led, live training, participants will learn how to use F# to solve a series of real-world data science problems. By the end of this training, participants will be able to: Use F#'s integrated data science packages Use F# to interoperate with other languages and platforms, including Excel, R, Matlab, and Python Use the Deedle package to solve time series problems Carry out advanced analysis with minimal lines of production-quality code Understand how functional programming is a natural fit for scientific and big data computations Access and visualize data with F# Apply F# for machine learning Explore solutions for problems in domains such as business intelligence and social gaming Audience Developers Data scientists Format of the course Part lecture, part discussion, exercises and heavy hands-on practice
mongodbadmin MongoDB for Administrators 14 hours 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.
mariadbdev MariaDB 10 Developer Course 28 hours Created DBAs, Administrators and developers who are interested with getting involved in MariaDB 10 based on Linux system. Even beginners, who have the basic skill and knowledge on Linux, can catch up with this course just if you follow the instructor's lab and explanation in detail. This course is intended to practice enough Database Concept and SQL and to show it is very easy to understand how to use SQL and manage MariaDB on Linux system. This course will be delivered to audience with 40% lectures, 50% labs and 10% Q&A. This five-day course strongly emphasizes lab-based activities After this course, you can apply the knowledge, which you obtained through this course, to the other database systems such as MySQL, Oracle Database, MSSQL Server and PostgreSQL as well. It can be deliver on any distribution (Ubuntu, CentOS are commonly used)
postgresdev PostgreSQL for Developers 14 hours This course provides programmatic interaction with PostgreSQL databases and writing PostgreSQL extensions. Target audience includes developers who want to use or extend PostgreSQL, as well as database architects.
3319 Data Analysis with Oracle 11g - workshop 35 hours For who Workshops are dedicated to end users, data analysts and software testers. Workshop participants do not need to be computer scientists, but employees who need efficiently and effectively use the Oracle database, processing and analyzing information contained in it Exams and Certificates The training plan includes, among others 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 training is designed to familiarize participants with the Oracle database, the basic tools and techniques of data collection. Particular emphasis in this training is the acquisition of substantially correct and reliable data. The content of the training The organization of the working environment Introduction to the relational model of data storage Techniques for the collection, analysis and synthesis of information stored in the database Modify the information stored in the database Note The workshops are based on the software version 11g XE
kdd Knowledge Discover in Databases (KDD) 21 hours Knowledge discovery in databases (KDD) is the process of discovering useful knowledge from a collection of data. Real-life applications for this data mining technique include marketing, fraud detection, telecommunication and manufacturing. In this course, we introduce the processes involved in KDD and carry out a series of exercises to practice the implementation of those processes. Audience     Data analysts or anyone interested in learning how to interpret data to solve problems Format of the course     After a theoretical discussion of KDD, the instructor will present real-life cases which call for the application of KDD to solve a problem. Participants will prepare, select and cleanse sample data sets and use their prior knowledge about the data to propose solutions based on the results of their observations.
TalendDI Talend Open Studio for Data Integration 28 hours Talend Open Studio for Data Integration is an open-source data integration product used to combine, convert and update data in various locations across a business. In this instructor-led, live training, participants will learn how to use the Talend ETL tool to carry out data transformation, data extraction, and connectivity with Hadoop, Hive, and Pig.   By the end of this training, participants will be able to Explain the concepts behind ETL (Extract, Transform, Load) and propagation Define ETL methods and ETL tools to connect with Hadoop Efficiently amass, retrieve, digest, consume, transform and shape big data in accordance to business requirements Audience Business intelligence professionals Project managers Database professionals SQL Developers ETL Developers Solution architects Data architects Data warehousing professionals System administrators and integrators Format of the course Part lecture, part discussion, exercises and heavy hands-on practice
tidyverse Introduction to Data Visualization with Tidyverse and R 7 hours The Tidyverse is a collection of versatile R packages for cleaning, processing, modeling, and visualizing data. Some of the packages included are: ggplot2, dplyr, tidyr, readr, purrr, and tibble. In this instructor-led, live training, participants will learn how to manipulate and visualize data using the tools included in the Tidyverse. By the end of this training, participants will be able to: Perform data analysis and create appealing visualizations Draw useful conclusions from various datasets of sample data Filter, sort and summarize data to answer exploratory questions Turn processed data into informative line plots, bar plots, histograms Import and filter data from diverse data sources, including Excel, CSV, and SPSS files Audience Beginners to the R language Beginners to data analysis and data visualization Format of the course Part lecture, part discussion, exercises and heavy hands-on practice
mongodbdev MongoDB for Developers 14 hours This course covers everything a database developer needs to know to successfully develop applications using MongoDB.
mean1 Building Web Apps using the MEAN stack 35 hours Course Objective: MEAN stack is a full-stack JavaScript solution that helps you write scalable, robust, and maintainable web applications quickly and easily using MongoDB, express, AngularJS, and Node.js. By the end of this hands-on intensive training course, the students will be able to: Store the data in NoSQL, document-oriented MongoDB database that brings performance and scalability. Use Node.js, the server-side platform built on Google V8’s runtime for building fast, scalable network applications. Use Express, a simple yet powerful web application development HTTP server framework built on top of Node.js. Use AngularJS framework that offers declarative, two-way data binding for web applications. Take advantage of the ‘full-stack JavaScript’ paradigm i.e. store documents in JSON-like format in MongoDB, author JSON queries in Node.js/Express.js, and forward these JSON documents back to an Angular-based frontend. Get acquainted with the latest web application development trends in the IT industry.
postgresadmin PostgreSQL for Administrators 14 hours 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.
3308 Oracle 11g - SQL language for administrators - workshops 21 hours 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
scylladb Scylla database 21 hours 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.
pythonmultipurpose Advanced Python 28 hours In this instructor-led training, participants will learn advanced Python programming techniques, including how to apply this versatile language to solve problems in areas such as distributed applications, finance, data analysis and visualization, UI programming and maintenance scripting. Audience Developers Format of the course Part lecture, part discussion, exercises and heavy hands-on practice Notes If you wish to add, remove or customize any section or topic within this course, please contact us to arrange.
datastorageoverview Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems 7 hours This course helps customer to chose the write data storage depend on their needs. It covers almost all possible modern approaches.
sqlsqlsvr SQL in SQL Server 14 hours This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn: how to write SQL queries what relational databases are and how we can use them what are relations and how to create them the structure of data differences between T-SQL and other dialects practical skills for writing queries This SQL course deals with Microsoft T-SQL dialect. If you are interested in generic SQL, please see SQL Fundamentals course.
trafodionadm1 Administering Trafodion 14 hours
mssql2016 MS SQL Server 2016 14 hours As a core of the Microsoft data platform, SQL Server is a leading operational database management system.
3092 SQL language in MSSQL 14 hours The course answers questions How to build a query? What opportunities have SQL? What is a relational database? What is the structure and SQL commands?
berkeleydb Berkeley DB for developers 21 hours 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.[1] 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
PentahoDI Pentaho Data Integration Fundamentals 21 hours Pentaho Data Integration is an open-source data integration tool for defining jobs and data transformations. In this instructor-led, live training, participants will learn how to use Pentaho Data Integration's powerful ETL capabilities and rich GUI to manage an entire big data lifecycle, maximizing the value of data to the organization. By the end of this training, participants will be able to: Create, preview, and run basic data transformations containing steps and hops Configure and secure the Pentaho Enterprise Repository Harness disparate sources of data and generate a single, unified version of the truth in an analytics-ready format. Provide results to third-part applications for further processing Audience Data Analyst ETL developers Format of the course Part lecture, part discussion, exercises and heavy hands-on practice
matlabpredanalytics Matlab for Predictive Analytics 21 hours Predictive analytics is the process of using data analytics to make predictions about the future. This process uses data along with data mining, statistics, and machine learning techniques to create a predictive model for forecasting future events. In this instructor-led, live training, participants will learn how to use Matlab to build predictive models and apply them to large sample data sets to predict future events based on the data. By the end of this training, participants will be able to: Create predictive models to analyze patterns in historical and transactional data Use predictive modeling to identify risks and opportunities Build mathematical models that capture important trends Use data to from devices and business systems to reduce waste, save time, or cut costs Audience Developers Engineers Domain experts Format of the course Part lecture, part discussion, exercises and heavy hands-on practice
sqlmsa SQL in Microsoft Access 14 hours This SQL training course is for people who want to gain the necessary skills to extract and analyse data using Microsoft Access. Course members will learn: how to write SQL queries what relational databases are and how we can use them what are relations and how to create them the structure of data differences between SQL dialects (Oracle, T-SQL, ANSI) practical skills for writing queries This SQL course deals with Microsoft Access dialect of SQL.
sqlmysql SQL in MySQL 14 hours How to build a query? What opportunities has the SQL in a MySQL database? What is a relational database? What is the structure and SQL commands?
bigdatastore Big Data Storage Solution - NoSQL 14 hours When traditional storage technologies don't handle the amount of data you need to store there are hundereds of alternatives. This course try to guide the participants what are alternatives for storing and analyzing Big Data and what are theirs pros and cons. This course is mostly focused on discussion and presentation of solutions, though hands-on exercises are available on demand.
bigddbsysfun Big Data & Database Systems Fundamentals 14 hours The course is part of the Data Scientist skill set (Domain: Data and Technology).
3082 Microsoft Access - download the data 14 hours The course is designed for persons with pre-information databases using SQL queries or queries.
accumulo Apache Accumulo: Building highly scalable big data applications 21 hours Apache Accumulo is a sorted, distributed key/value store that provides robust, scalable data storage and retrieval. It is based on the design of Google's BigTable and is powered by Apache Hadoop, Apache Zookeeper, and Apache Thrift.   This courses covers the working principles behind Accumulo and walks participants through the development of a sample application on Apache Accumulo. Audience Application developers Software engineers Technical consultants Format of the course Part lecture, part discussion, hands-on development and implementation, occasional tests to gauge understanding
hdp Hortonworks Data Platform (HDP) for administrators 21 hours Hortonworks Data Platform is an open-source Apache Hadoop support platform that provides a stable foundation for developing big data solutions on the Apache Hadoop ecosystem. This instructor-led live training introduces Hortonworks and walks participants through the deployment of Spark + Hadoop solution. By the end of this training, participants will be able to: Use Hortonworks to reliably run Hadoop at a large scale Unify Hadoop's security, governance, and operations capabilities with Spark's agile analytic workflows. Use Hortonworks to investigate, validate, certify and support each of the components in a Spark project Process different types of data, including structured, unstructured, in-motion, and at-rest. Audience Hadoop administrators Format of the course Part lecture, part discussion, exercises and heavy hands-on practice
mariadbadv Advanced MariaDB for High Availability and Performance 28 hours 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. Audience Developers Database administrators System administrators Format of the course Part lecture, part discussion, exercises and heavy hands-on practice
osqlfun ORACLE SQL Fundamentals 21 hours 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.
3041 Access Advanced 21 hours The course participants will learn how to speed up the operation of the database, how to write advanced queries, create a convenient system of forms and reporting. The course introduces the participant to automate all operations using macros and VBA.
cassdev Cassandra for Developers 21 hours 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. Audience : Developers
SQL100 T-SQL Fundamentals with SQL Server Training Course 16 hours This SQL training course is for people who want to acquire basic skills to deal with SQL Server Databases. Course will help the members to learn: How to work with SQL Server and SQL Server Management Studio. Meaning of Databases, SQL and RDBMS etc. How to create tables, use DDL, DML and DAL. Which are the various RDBMS Packages in the market and how they compare with each other. An Introduction to NoSQL and how they are organizations are changing into hybrid databases.
838 Oracle Database 10g: Administration Workshop I Release 2 35 hours What you will learn This course is designed to give you a firm foundation in basic database administration. Expert instructors will teach you how to install and maintain an Oracle database. Learn To: Install the Database. Back up and recover data. Administer users and manage data. Transport data between databases. Configure the network. Understand the Oracle database architecture and how its components work and interact with one another. Use performance monitoring, database security, user management and backup/recovery techniques. Create an Operational Database This course will also teach you how to create an operational database and properly manage the various structures efficiently. The lesson topics are reinforced with structured, hands-on practices that solidify your understanding. Prepare for Oracle Certification Exams This course is designed to prepare you for the corresponding Oracle Certified Associate exam. It counts towards the hands-on course requirement for the Oracle Database 10g Administrator Certification Audience Database Administrators Database Designers Project Manager Sales Consultants Support Engineer Technical Consultant Course Objectives Install Oracle Database 10g and configure a database Manage the Oracle instance Manage the Database storage structures Create and administer user accounts Perform backup and recovery of a database Monitor, troubleshoot, and maintain a database Configure Oracle Net services Move data between databases and files
druid Druid: Build a fast, real-time data analysis system 21 hours Druid is an open-source, column-oriented, distributed data store written in Java. It was designed to quickly ingest massive quantities of event data and execute low-latency OLAP queries on that data. Druid is commonly used in business intelligence applications to analyze high volumes of real-time and historical data. It is also well suited for powering fast, interactive, analytic dashboards for end-users. Druid is used by companies such as Alibaba, Airbnb, Cisco, eBay, Netflix, Paypal, and Yahoo. In this course we explore some of the limitations of data warehouse solutions and discuss how Druid can compliment those technologies to form a flexible and scalable streaming analytics stack. We walk through many examples, offering participants the chance to implement and test Druid-based solutions in a lab environment. Audience     Application developers     Software engineers     Technical consultants     DevOps professionals     Architecture engineers Format of the course     Part lecture, part discussion, heavy hands-on practice, occasional tests to gauge understanding
zeppelin Zeppelin for interactive data analytics 14 hours Apache Zeppelin is a web-based notebook for capturing, exploring, visualizing and sharing Hadoop and Spark based data. This instructor-led, live training introduces the concepts behind interactive data analytics and walks participants through the deployment and usage of Zeppelin in a single-user or multi-user environment. By the end of this training, participants will be able to: Install and configure Zeppelin Develop, organize, execute and share data in a browser-based interface Visualize results without referring to the command line or cluster details Execute and collaborate on long workflows Work with any of a number of plug-in language/data-processing-backends, such as Scala ( with Apache Spark ), Python ( with Apache Spark ), Spark SQL, JDBC, Markdown and Shell. Integrate Zeppelin with Spark, Flink and Map Reduce Secure multi-user instances of Zeppelin with Apache Shiro Audience Data engineers Data analysts Data scientists Software developers Format of the course Part lecture, part discussion, exercises and heavy hands-on practice
powerbiforbiandanalytics Power BI for Business Analysts 21 hours Microsoft Power BI is a free Software as a Service (SaaS) suite for analyzing data and sharing insights. Power BI dashboards provide a 360-degree view of the most important metrics in one place, updated in real time, and available on all of their devices. In this instructor-led, live training, participants will learn how to use Microsoft Power Bi to analyze and visualize data using a series of sample data sets. By the end of this training, participants will be able to: Create visually compelling dashboards that provide valuable insights into data Obtain and integrate data from multiple data sources Build and share visualizations with team members Adjust data with Power BI Desktop Audience Business managers Business analystss Data analysts Business Intelligence (BI) and Data Warehouse (DW) teams Report developers Format of the course Part lecture, part discussion, exercises and heavy hands-on practice  
oplsqlfun ORACLE PL/SQL Fundamentals 21 hours 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.
3040 Access - Data Base Designing 21 hours The course participants will learn how to design a database and how to adapt it to work with the end user.
hbasedev HBase for Developers 21 hours This course introduces HBase – a NoSQL store on top of Hadoop.  The course is intended for developers who will be using HBase to develop applications,  and administrators who will manage HBase clusters. We will walk a developer through HBase architecture and data modelling and application development on HBase. It will also discuss using MapReduce with HBase, and some administration topics, related to performance optimization. The course  is very  hands-on with lots of lab exercises. Duration : 3 days Audience : Developers  & Administrators
osqldevdm Oracle SQL for development and database management 35 hours
564 Java SE 7 Programmer Certification Preparation 21 hours
nlpwithr NLP: Natural Language Processing with R 21 hours It is estimated that unstructured data accounts for more than 90 percent of all data, much of it in the form of text. Blog posts, tweets, social media, and other digital publications continuously add to this growing body of data. This course centers around extracting insights and meaning from this data. Utilizing the R Language and Natural Language Processing (NLP) libraries, we combine concepts and techniques from computer science, artificial intelligence, and computational linguistics to algorithmically understand the meaning behind text data. Data samples are available in various languages per customer requirements. By the end of this training participants will be able to prepare data sets (large and small) from disparate sources, then apply the right algorithms to analyze and report on its significance. Audience     Linguists and programmers Format of the course     Part lecture, part discussion, heavy hands-on practice, occasional tests to gauge understanding
meanangular4 Angular 4: Building Web Apps using the MEAN stack 35 hours Angular 4 (previous versions referred to as: Angular.js, AngularJS, AngularJS 1, Angular 1, Angular 2, etc.) is a JavaScript-based front-end web application framework for developing single-page applications. It boasts better performance over its predecessor, more APIs to tap into, and improved design and responsiveness on mobile devices. MEAN stack is a full-stack JavaScript solution for writing scalable, robust, and maintainable web applications quickly and easily using MongoDB, Express, Angular, and Node.js. In this instructor-led, live training, participants will learn how to use the MEAN stack, specifically using Angular 4, as they step through the creation and deployment of a sample web application. By the end of this training, participants will be able to: Create, build, debug and deploy a MEAN-based Angular 4 application Unit test their Angular 4 application Write Angular code using TypeScript Audience Developers Format of the course Part lecture, part discussion, exercises and heavy hands-on practice
mlbankingr Machine Learning for Banking (with R) 28 hours In this instructor-led, live training, participants will learn how to apply machine learning techniques and tools for solving real-world problems in the banking industry. R will be used as the programming language. Participants first learn the key principles, then put their knowledge into practice by building their own machine learning models and using them to complete a number of live projects. Audience Developers Data scientists Banking professionals with a technical background Format of the course Part lecture, part discussion, exercises and heavy hands-on practice
advsqlpt Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server 14 hours The aim of this course is to provide a clear understanding of the advanced use of (SQL) for Microsoft SQL Server and the advanced use of Transact-SQL. For more in depth coverage of the topics this course can be run as a three day course.
3033 Administering in Microsoft SQL Server 21 hours The course is designed for administrators, developers and database developers. The objectives of the training: acquire and strengthen the skills to create and manage databases knowledge of the syntax and use SQL to retrieve and modify data apply safety rules in the database the use of advanced elements (replication, automation, BI) the use of Microsoft SQL Server capabilities to create complex reports and solutions for developers
cpd200 CPD200: Developing Solutions on Google Cloud Platform 24 hours This 3 day instructor-led class introduces participants to Solution Development for Google Cloud Platform. Through a combination of instructor-led presentations, demonstrations, and hands-on labs, students learn how to develop cloud-based applications using Google App Engine, Google Cloud Datastore, and Google Cloud Endpoints. This class is intended for experienced application developers who want to learn how to develop solutions using Google Cloud Platform to create highly scalable backends for both web and mobile applications. At the end of this one­day course, participants will be able to: Manage Google Cloud Source Repositories using the Google Cloud Platform Console Test an App Engine application using the App Engine SDK Access the App Engine Development Server Console Create an API using Google Cloud Endpoints Test a Cloud Endpoint API using the API Explorer Deploy an application to App Engine using the App Engine SDK Design, structure and configure an App Engine application using multiple services Create Client IDs using the Google Cloud Platform Console Secure App Engine services and Cloud Endpoints APIs using authentication Configure and upload new versions of App Engine services Integrate Google Cloud Logging into App Engine applications Review quota usage in a Google Cloud Platform project Integrate different types of storage with App Engine applications Create and implement a data model for use with Google Cloud Datastore Implement a variety of queries in Google Cloud Datastore Update the index configuration in Google Cloud Datastore Implement transactions using Google Cloud Datastore Review Google Cloud Trace reports in the Google Cloud Platform Console Integrate the Memcache API into an App Engine application to increase performance Configure, run and review the output of Google Cloud Security Scanner Configure the scaling behaviour of individual App Engine Services Create App Engine handlers for Push Task Queues Send email from an App Engine application using the Mail API Schedule Tasks in App Engine using the Cron Service Update the configuration of the Cron Service Secure Task Push, and Cron Service handlers  Export Google Cloud Platform data from a project Delete Google Cloud Platform projects and resources  
mongodbau MongoDB for Advanced Users 14 hours This course covers the advanced areas in the use of programming languages related to MongoDB, the goal is for the participant to have the ability to completely master the tool.
453 Oracle: (1ZO-147) Program with PLSQL 28 hours
voldemort Voldemort: Setting up a key-value distributed data store 14 hours 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
ApacheIgnite Apache Ignite: Improve speed, scale and availability with in-memory computing 14 hours Apache Ignite is an in-memory computing platform that sits between the application and data layer to improve speed, scale and availability. In this instructor-led, live training, participants will learn the principles behind persistent and pure in-memory storage as they step through the creation of a sample in-memory computing project. By the end of this training, participants will be able to: Use Ignite for in-memory, on-disk persistence as well as a purely distributed in-memory database Achieve persistence without syncing data back to a relational database Use Ignite to carry out SQL and distributed joins Improve performance by moving data closer to the CPU, using RAM as a storage Spread data sets across a cluster to achieve horizontal scalability Integrate Ignite with RDBMS, NoSQL, Hadoop and machine learning processors Audience Developers Format of the course Part lecture, part discussion, exercises and heavy hands-on practice
mlbankingpython_ Machine Learning for Banking (with Python) 21 hours In this instructor-led, live training, participants will learn how to apply machine learning techniques and tools for solving real-world problems in the banking industry. Python will be used as the programming language. Participants first learn the key principles, then put their knowledge into practice by building their own machine learning models and using them to complete a number of team projects. Audience Developers Data scientists Format of the course Part lecture, part discussion, exercises and heavy hands-on practice
mariadbadmin MariaDB Database Administration 14 hours MariaDB Administration training course is for anyone who wants to administrate the MariaDB database server. It is a comprehensive course covering all administrator duties. The course explains how MariaDB Database works, what tools are available, how we can use them, how we can secure the MariaDB Database Server and configure it. During the training course you will learn how to manage user accounts and how the MariaDB Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery.
3044 Using and managing the database in MySQL 14 hours Participant will learn: Can I use MySQL for free? What do I offer a commercial license? How to install a MySQL database? How to perform basic operations on the installation? What are the available tools for managing and programming in a MySQL database?
hivehiveql Data Analysis with Hive/HiveQL 7 hours This course covers how to use Hive SQL language (AKA: Hive HQL, SQL on Hive, HiveQL) for people who extract data from Hive
osqlide Oracle SQL Intermediate - Data Extraction 14 hours
452 R12.x Extend Oracle Applications: Building OA Framework Applications 35 hours
meteor Meteor: Use JavaScript to develop cross-platform mobile applications 14 hours Meteor (aka MeteorJS) is an open-source JavaScript web framework written in Node.js. It integrates with MongoDB and enables rapid prototyping of Android and iOS applications. This course introduces the fundamentals of Meteor and walks participants through the creation of a real-time web applications for both desktop and mobile platforms. Audience     Front-end developers     Anyone interested in learning Meteor Format of the course     Overview of Meteor's features and capabilities along with step-by-step development of a mobile application for iOS and Android.
datameer Datameer for Data Analysts 14 hours Datameer is a business intelligence and analytics platform built on Hadoop. It allows end-users to access, explore and correlate large-scale, structured, semi-structured and unstructured data in an easy-to-use fashion. In this instructor-led, live training, participants will learn how to use Datameer to overcome Hadoop's steep learning curve as they step through the setup and analysis of a series of big data sources. By the end of this training, participants will be able to: Create, curate, and interactively explore an enterprise data lake Access business intelligence data warehouses, transactional databases and other analytic stores Use a spreadsheet user-interface to design end-to-end data processing pipelines Access pre-built functions to explore complex data relationships Use drag-and-drop wizards to visualize data and create dashboards Use tables, charts, graphs, and maps to analyze query results Audience Data analysts Format of the course Part lecture, part discussion, exercises and heavy hands-on practice
graphcomputing Introduction to Graph Computing 28 hours A large number of 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 mindset referred to as graph computing. In this instructor-led, live training, participants will learn about the various technology offerings and implementations 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 graph computing approaches. 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 Audience Developers Format of the course Part lecture, part discussion, exercises and heavy hands-on practice
416 Introduction to Firebird 14 hours
1126 Database Version Control (dbv) 7 hours This course show a solution for sharing and versioning your db schema. It contains exercises which cover: common scenarios in a software development with sharing database changes using the dbv to debug problems related to database schema changes
ADSQL SQL Advanced 14 hours Students will learn advanced queries and how to add, update, and delete data, tables, views, and indexes.
68403 Introduction to SQL Server 2012 Integration Services (SSIS) 28 hours
378 Oracle Service Bus 11g - Design and Integration 21 hours This course is targeted to SOA architects and developers. It consists of theory classes and hands-on sessions on each of the topics to cover all essential features of Oracle Service Bus 11g. This course will be delivered by industry experts with vast knowledge of Oracle SOA Suite, Web services, ESB, XML, SOA and related topics for example Java/J2EE.
BigData_ A practical introduction to Data Analysis and Big Data 35 hours Participants who complete this training will gain a practical, real-world understanding of Big Data and its related technologies, methodologies and tools. Participants will have the opportunity to put this knowledge into practice through hands-on exercises. Group interaction and instructor feedback make up an important component of the class. The course starts with an introduction to elemental concepts of Big Data, then progresses into the programming languages and methodologies used to perform Data Analysis. Finally, we discuss the tools and infrastructure that enable Big Data storage, Distributed Processing, and Scalability. Audience Developers / programmers IT consultants Format of the course Part lecture, part discussion, hands-on practice and implementation, occasional quizing to measure progress.
deckgl deck.gl: Visualizing Large-scale Geospatial Data 14 hours deck.gl is an open-source, WebGL-powered library for exploring and visualizing data assets at scale. Created by Uber, it is especially useful for gaining insights from geospatial data sources, such as data on maps. This instructor-led, live training introduces the concepts and functionality behind deck.gl and walks participants through the set up of a demonstration project. By the end of this training, participants will be able to: Take data from very large collections and turn it into compelling visual representations Visualize data collected from transportation and journey-related use cases, such as pick-up and drop-off experiences, network traffic, etc. Apply layering techniques to geospatial data to depict changes in data over time Integrate deck.gl with React (for Reactive programming) and Mapbox GL (for visualizations on Mapbox based maps). Understand and explore other use cases for deck.gl, including visualizing points collected from a 3D indoor scan, visualizing machine learning models in order to optimize their algorithms, etc. Audience Developers Data scientists Format of the course Part lecture, part discussion, exercises and heavy hands-on practice
pythonfinance Python Programming for Finance 35 hours Python is a programming language that has gained huge popularity in the financial industry. Used by the largest investment banks and hedge funds, it is being employed to build a wide range of financial applications ranging from core trading programs to risk management systems. In this instructor-led, live training, participants will learn how to use Python to develop practical applications for solving a number of specific finance related problems. By the end of this training, participants will be able to: Understand the fundamentals of the Python programming language Download, install and maintain the best development tools for creating financial applications in Python Select and utilize the most suitable Python packages and programming techniques to organize, visualize, and analyze financial data from various sources (CSV, Excel, databases, web, etc.) Build applications that solve problems related to asset allocation, risk analysis, investment performance and more Troubleshoot, integrate deploy and optimize a Python application Audience Developers Analysts Quants Format of the course Part lecture, part discussion, exercises and heavy hands-on practice Note This training aims to provide solutions for some of the principle problems faced by finance professionals. However, if you have a particular topic, tool or technique that you wish to append or elaborate further on, please please contact us to arrange.
pgsqladm PostgreSQL Administration and Development 28 hours 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.
3165 Visual Basic for Applications (VBA) and Databases 14 hours The training is designed for people using Excel and VBA for access to the databases.
Imp Impala for Business Intelligence 21 hours Cloudera Impala is an open source massively parallel processing (MPP) SQL query engine for Apache Hadoop clusters. Impala enables users to issue low-latency SQL queries to data stored in Hadoop Distributed File System and Apache Hbase without requiring data movement or transformation. Audience This course is aimed at analysts and data scientists performing analysis on data stored in Hadoop via Business Intelligence or SQL tools. After this course delegates will be able to Extract meaningful information from Hadoop clusters with Impala. Write specific programs to facilitate Business Intelligence in Impala SQL Dialect. Troubleshoot Impala.
67592 SQL Server 2008 Administration 28 hours This SQL Server Administration training course teaches students how to administer a SQL Server 2008. Objectives Install and configure Microsoft SQL Server Create databases and tables Implement indexes and partitions Take database snapshots Implement service broker for asynchronous processing of database requests Create and use full-text indexes Secure SQL Server and implement policy-based management Recover data Automate administrative tasks with the SQL Server Agent Use Dynamic Management Views to monitor the database and troubleshoot problems Configure a SQL Server for high availability using failover clustering, database mirroring, log shipping, and replication
373 Oracle Database 11g: New Features for Administrators DBA Release 2 28 hours
elasticsearchfordevs ElasticSearch for Developers: Building Search and Analytics Solutions with Elasticsearch 14 hours Elasticsearch is an open-source, distributed search engine. It is commonly used together with Logstash (data-collection and log-parsing engine) and Kibana (analytics and visualization platform) to make up the "ELK stack". This training is aimed at software developers who wish to build search and analytics solutions using Elasticsearch. The training starts with a discussion of the ElastickSearch architecture, including its distributed model and search API. This is followed by an explanation of ElasticSearch's functionality and how to best integrate it into an existing application. Hands-on exercises make up an important part of the training, and give participants a chance to put into practice their knowledge while receiving feedback on their implementation and progress. Audience Software developers Format of the course Heavy emphasis on live practice. Most of the concepts are learned through samples, exercises and hands-on development.
embeddingprojector Embedding Projector: Visualizing your Training Data 14 hours Embedding Projector is an open-source web application for visualizing the data used to train machine learning systems. Created by Google, it is part of TensorFlow. This instructor-led, live training introduces the concepts behind Embedding Projector and walks participants through the setup of a demo project. By the end of this training, participants will be able to: Explore how data is being interpreted by machine learning models Navigate through 3D and 2D views of data to understand how a machine learning algorithm interprets it Understand the concepts behind Embeddings and their role in representing mathematical vectors for images, words and numerals. Explore the properties of a specific embedding to understand the behavior of a model Apply Embedding Project to real-world use cases such building a song recommendation system for music lovers Audience Developers Data scientists Format of the course Part lecture, part discussion, exercises and heavy hands-on practice
rforfinance R Programming for Finance 28 hours R is a popular programming language in the financial industry. It is used in financial applications ranging from core trading programs to risk management systems. In this instructor-led, live training, participants will learn how to use R to develop practical applications for solving a number of specific finance related problems. By the end of this training, participants will be able to: Understand the fundamentals of the R programming language Select and utilize R packages and techniques to organize, visualize, and analyze financial data from various sources (CSV, Excel, databases, web, etc.) Build applications that solve problems related to asset allocation, risk analysis, investment performance and more Troubleshoot, integrate deploy and optimize an R application Audience Developers Analysts Quants Format of the course Part lecture, part discussion, exercises and heavy hands-on practice Note This training aims to provide solutions for some of the principle problems faced by finance professionals. However, if you have a particular topic, tool or technique that you wish to append or elaborate further on, please please contact us to arrange.
osqlbgn Oracle SQL for beginners 21 hours Listeners This training is addressed for people starting to work with the SQL language in Oracle database The course answer for questions: How to build a query? What possibilities have SQL? What is a relational database? What is the structure and SQL commands
osqladv Oracle SQL Advanced 14 hours Listeners This course is designed for people who want to use the advanced features of SQL in Oracle The course answers the questions How to build advanced queries? How to create advanced reports?
3057 Oracle SQL Language 14 hours The course answers questions How to build a query? What possibilities have SQL? What is a relational database? What is the structure and SQL commands

Other regions

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

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