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
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
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.
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.
ADSQL SQL Advanced 14 hours Students will learn advanced queries and how to add, update, and delete data, tables, views, and indexes.
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
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
3134 Oracle Application Express Introduction 21 hours Audience Course aimed at developers Format of the course 35% lectures, 65% labs
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
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)
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.
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.
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
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.
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
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.
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.
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.
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?
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.  
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.
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
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.
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.
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
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
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
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.
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
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.
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
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.
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.
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?
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.
osqlide Oracle SQL Intermediate - Data Extraction 14 hours
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
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
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
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.
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?
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.
osqldevdm Oracle SQL for development and database management 35 hours
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.
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
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
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.
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.
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.
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.
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.
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
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.
AccIntr 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.
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
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.
aerosdev Aerospike for Developers 14 hours This course covers everything a database developer needs to know to successfully develop applications using Aerospike.
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.
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
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.
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
68403 Introduction to SQL Server 2012 Integration Services (SSIS) 28 hours
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
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.
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.
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.
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
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
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.
DatSci7 Data Science Programme 245 hours The explosion of information and data in today’s world is un-paralleled, our ability to innovate and push the boundaries of the possible is growing faster than it ever has. The role of Data Scientist is one of the highest in-demand skills across industry today. We offer much more than learning through theory; we deliver practical, marketable skills that bridge the gap between the world of academia and the demands of industry. This 7 week curriculum  can be tailored to your specific Industry requirements, please contact us for further information or visit the Nobleprog Institute website www.inobleprog.co.uk Audience: This programme is aimed post level graduates as well as anyone with the required pre-requisite skills which will be determined by an assessment and interview.  Delivery: Delivery of the course will be a mixture of Instructor Led Classroom and Instructor Led Online; typically the 1st week will be 'classroom led', weeks 2 - 6 'virtual classroom' and week 7  back to 'classroom led'.     
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
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.
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
bigddbsysfun Big Data & Database Systems Fundamentals 14 hours The course is part of the Data Scientist skill set (Domain: Data and Technology).
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.
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.
mongodbdev MongoDB for Developers 14 hours This course covers everything a database developer needs to know to successfully develop applications using MongoDB.
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.
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
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.
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.
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.
416 Introduction to Firebird 14 hours
3082 Microsoft Access - download the data 14 hours The course is designed for persons with pre-information databases using SQL queries or queries.
mssql2016 MS SQL Server 2016 14 hours As a core of the Microsoft data platform, SQL Server is a leading operational database management system.
advsql Advantage Digital – Getting Started with SQL 7 hours This course enables delegates to understand the relationship between the data input on the front end of the Advantage system and extracting and manipulating that data using SQL (a data query language). Its focus is the practical application of SQL. Delegates will learn how to extract Housing Benefit related data very quickly, answer requests for information and learn how to harness the database in an efficient way. The focus is on the Housing Benefit database but what is learned can also be used to extract data from any other database within the Advantage system. 
sqldba MySQL for Database Administrators 28 hours This "MySQL for Database Administrators" course is designed to provide practical experience in: Setting up and maintaining a MySQL database server including: backing up  recovery configuration tuning Who should attend: Anyone with experience of a relational database management system who need the skills to be able to administer, monitor and support MySQL databases and servers.
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.
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
oracleperftun Oracle Database 11g: Performance Tuning 28 hours Oracle is a multi-model database management system.
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.
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.
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
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?
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
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
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
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
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

Upcoming Courses

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

Course Discounts

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

Outlines Extract
Machine-generated

Database design parameters and information of the concepts of comparison of a design the operations and control and extend the course validating the broad container configuration reports in the serve. Systems and path course participants will learn how to use process to interfaces testing and files the model of the layout component of the roles of the continuous installation install the. Code the process of the security and control concepts and techniques and the container to a reporting systems that have a service strategy the control creating the context for business co. Services experience for multiple of the management control to know the specification of the resources and heavy hands-on testing security products to create a sub-line and includes, program. Module 6: access and configure a technologies working with the streaming and service and installation and managers what is the model constraints in the resource management setting of the co.