Database Training Courses

Database Training

A Database (DB), or Database Management System (DBMS), is a system for storing data. The term usually refers to Relational Databases, which store data in a tabular format. Popular Databases include MySQL, Oracle, and MS SQL.

NobleProg onsite live Database training courses are aimed at both system administrators as well as developers and demonstrate through hands-on practice how to administer Database systems as well as how to integrate a Database with software applications.

Database training is available in various formats, including onsite live training and live instructor-led training using an interactive, remote desktop setup. Local Database training can be carried out live on customer premises or in NobleProg local training centers.

Client Testimonials

Database Course Outlines

Code Name Duration Overview
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.
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
osqlide Oracle SQL Intermediate - Data Extraction 14 hours
DM7 Getting started with DM7 21 hours Audience Beginner or intermediate database developers Beginner or intermediate database administrators Programmers Format of the course Heavy emphasis on hands-on practice. Most of the concepts are learned through samples, exercises and hands-on development
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.
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
gfsjeeint Administering GlassFish Server with Java EE applications introduction 21 hours GlassFish is an open-source application server. This three-day course provides an introduction to administering GlassFish Server with Java EE applications.
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.  
osqlbgnde Oracle SQL for Beginners - Data Extraction 14 hours Audience 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 This course DOES NOT COVER inserting, modifying or removing rows, it coveres only data extraction.
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
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.  
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
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.
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.
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
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.
scilab Scilab 14 hours Scilab is a well-developed, free, and open-source high-level language for scientific data manipulation. Used for statistics, graphics and animation, simulation, signal processing, physics, optimization, and more, its central data structure is the matrix, simplifying many types of problems compared to alternatives such as FORTRAN and C derivatives. It is compatible with languages such as C, Java, and Python, making it suitable as for use as a supplement to existing systems. In this instructor-led training, participants will learn the advantages of Scilab compared to alternatives like Matlab, the basics of the Scilab syntax as well as some advanced functions, and interface with other widely used languages, depending on demand. The course will conclude with a brief project focusing on image processing. By the end of this training, participants will have a grasp of the basic functions and some advanced functions of Scilab, and have the resources to continue expanding their knowledge. Audience Data scientists and engineers, especially with interest in image processing and facial recognition Format of the course Part lecture, part discussion, exercises and intensive hands-on practice, with a final project
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.
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.
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
mssql2016 MS SQL Server 2016 14 hours As a core of the Microsoft data platform, SQL Server is a leading operational database management system.
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.
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.
3134 Oracle Application Express Introduction 21 hours Audience Course aimed at developers Format of the course 35% lectures, 65% labs
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)
bigddbsysfun Big Data & Database Systems Fundamentals 14 hours The course is part of the Data Scientist skill set (Domain: Data and Technology).
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.
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
memsql MemSQL 28 hours MemSQL is an in-memory, distributed, SQL database management system for cloud and on-premises. It's a real-time data warehouse that immediately delivers insights from live and historical data. In this instructor-led, live training, participants will learn the essentials of MemSQL for development and administration. By the end of this training, participants will be able to: Understand the key concepts and characteristics of MemSQL Install, design, maintain, and operate MemSQL Optimize schemas in MemSQL Improve queries in MemSQL Benchmark performance in MemSQL Build real-time data applications using MemSQL Audience Developers Administrators Operation 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.
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.
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)
ADSQL SQL Advanced 14 hours Students will learn advanced queries and how to add, update, and delete data, tables, views, and indexes.
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.
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
apachedrill Apache Drill for On-the-Fly Analysis of Multiple Big Data Formats 21 hours Apache Drill is a schema-free, distributed, in-memory columnar SQL query engine for Hadoop, NoSQL and and other Cloud and file storage systems. Apache Drill's power lies in its ability to join data from multiple data stores using a single query. Apache Drill supports numerous NoSQL databases and file systems, including HBase, MongoDB, MapR-DB, HDFS, MapR-FS, Amazon S3, Azure Blob Storage, Google Cloud Storage, Swift, NAS and local files. In this instructor-led, live training, participants will learn the fundamentals of Apache Drill, then leverage the power and convenience of SQL to interactively query big data without writing code. Participants will also learn how to optimize their Drill queries for distributed SQL execution. By the end of this training, participants will be able to: Perform "self-service" exploration on structured and semi-structured data on Hadoop Query known as well as unknown data using SQL queries Understand how Apache Drills receives and executes queries Write SQL queries to analyze different types of data, including structured data in Hive, semi-structured data in HBase or MapR-DB tables, and data saved in files such as Parquet and JSON. Use Apache Drill to perform on-the-fly schema discovery, bypassing the need for complex ETL and schema operations Integrate Apache Drill with BI (Business Intelligence) tools such as Tableau, Qlikview, MicroStrategy and Excel Audience Data analysts Data scientists SQL programmers 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.
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
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.
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.
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.
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 Upload to and extract large records from Hadoop, Hive, and NoSQL databases 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
sqladvals SQL Advanced level for Analysts 21 hours The aim of this course is to provide a clear understanding of the use of SQL for different databases (Oracle, SQL Server, MS Access...). Understanding of analytic functions and the way how to join different tables in a database will help delegates to move data analysis operations to the database side, instead of doing this in MS Excel application. This can also help in creating any IT system, which uses any relational database.
mongodbdev MongoDB for Developers 14 hours This course covers everything a database developer needs to know to successfully develop applications using MongoDB.
trafodionadm1 Administering Trafodion 14 hours
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
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
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.
danagr Data and Analytics - from the ground up 42 hours Data analytics is a crucial tool in business today. We will focus throughout on developing skills for practical hands on data analysis. The aim is to help delegates to give evidence-based answers to questions:  What has happened? processing and analyzing data producing informative data visualizations What will happen? forecasting future performance evaluating forecasts What should happen? turning data into evidence-based business decisions optimizing processes The course itself can be delivered either as a 6 day classroom course or remotely over a period of weeks if preferred. We can work with you to deliver the course to best suit your needs.
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.
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.
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.
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
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
cassdev1 Cassandra for Developers - Bespoke 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. Duration : 3 days Audience : Developers
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.
redis01 Redis for Developers 14 hours This courses uses by default PHP API, but any other language can be used. Please make sure you put this remark in your enquiry of booking form.
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.
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
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
aifortelecom AI Awareness for Telecom 14 hours AI is a collection of technologies for building intelligent systems capable of understanding data and the activities surrounding the data to make "intelligent decisions". For Telecom providers, building applications and services that make use of AI could open the door for improved operations and servicing in areas such as maintenance and network optimization. In this course we examine the various technologies that make up AI and the skill sets required to put them to use. Throughout the course, we examine AI's specific applications within the Telecom industry. Audience Network engineers Network operations personnel Telecom technical managers Format of the course     Part lecture, part discussion, hands-on exercises
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.
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?
redisadm01 Redis for Administrators 14 hours Installation Configuration Master-slave replication. Persistence Security Encryption Signals Handling Connections Handling: High Availability Latency monitoring Benchmarks Redis Releases
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.
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
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  
mongoana MongoDB for Analysts 14 hours After the training, you will be able to write extract and modify the data in MongoDB database. You will also learn about powerful Aggregation Pipeline that is a flexible and fast tool for data analytics, and if it's not enough for you, how to connect your current BI tools like Tableau or Excel to data stored in Mongo.
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.
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
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
aerosdev Aerospike for Developers 14 hours This course covers everything a database developer needs to know to successfully develop applications using Aerospike.
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
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.
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?
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
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.
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.
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
oracleperftun Oracle Database 11g: Performance Tuning 28 hours Oracle is a multi-model database management system.
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
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.
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.
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.
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
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.
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.
osqldevdm Oracle SQL for development and database management 35 hours
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.
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.
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.
416 Introduction to Firebird 14 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.
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.
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.
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
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

Consulting

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

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

Outlines Extract
Machine-generated

Database and install and managing data components and covers the serialization and customers of people interacting requirements statement of a main management class the control programming from the. Data framework of user security solutions and testers security the system and team controller component to create and regression and properties control development virtual statistic. Records service and lesson-server of a concepts and delivery of the instructor preparing a measure of the process of a communication execution application and controller and component of t. Gives a sub queries the content types of the business design creating the core conditional processes to develop so complexity of service between the selection of the server of the soap requ. In manage and process attributes and order increasing the web applications variables the content management interfaces with a relationship of a site technology for windows server in the of.