Online or onsite, instructor-led live Database (DB) or Database Management System (DBMS) 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 as "online live training" or "onsite live training". Online live training (aka "remote live training") is carried out by way of an interactive, remote desktop. The UK onsite live Database trainings can be carried out locally on customer premises or in NobleProg corporate training centres.
NobleProg -- Your Local Training Provider
Testimonials
I mostly liked the good content and exercises.
Richard Smallwood
Course: MongoDB for Administrators
Enjoyed the pace, delivery and technical know how of the trainer.
Junaid Kalang
Course: MariaDB Database Administration
I liked that the course was tailored to cover our organisations questions.
Robin Bell
Course: MongoDB for Administrators
The clear depth of knowledge the trainer had, which really shone when combined with his evident enthusiasm for the subject.
Joseph Brailsford
Course: MongoDB for Administrators
Even though I have been using MongoDB for a while, there were still some new “basic” things that Tamil taught us - as well as teaching us the advanced topics we need to move our projects forwards.
Adam McKay
Course: MongoDB for Administrators
I enjoyed the attention to detail, knowledge and enthusiasm for the subject.
Bristol City Council
Course: Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
The 1:1 style meant the training was tailored to my individual needs.
Andy McGuigan
Course: Cassandra Administration
The ability to ask questions at any time and the more informal / less structured style. This allowed us to pursue the areas of knowledge we were most interested in.
Jim Lane
Course: Transact SQL Advanced
Flexibility to blend in with Automata related details to get more of a real world scenario as we went on.
Autodata Ltd
Course: Beyond the relational database: neo4j
I liked the examples and the way he explained.
Sandeep Parashar
Course: VBA For Access & Excel
The explanation way and including tips on the best practices in VBA/Access, encouraging via exercise to think more by ourselves on how to solve the problem rather than giving ready solutions.
Daria Rudin
Course: VBA For Access & Excel
Tamil was exceptionally patient and very helpful in figuring out solutions to real needs. He was also very honest about if he didn't know something from the top of his head, which enabled us to quickly jump on in the training and we didn't lose time.
Christine Weiler
Course: VBA For Access & Excel
I really liked the monitoring.
Ling Xiao
Course: MongoDB for Administrators
Very high competence of the trainer!!.
Heino Eilers
Course: Oracle 11g - Programming with PL / SQL I - Workshops
I generally was benefit from the open mind and communication.
Oleksiy Deliyev
Course: MongoDB for Developers
I genuinely enjoyed the trainer Subject Knowledge.
Julian Pirau
Course: PostgreSQL for Administrators
Trainer provided some topic and support it with plenty of exercises. We had a chance to apply knowledge by doing them on our own.
UBS Business Solutions Poland Sp. z o.o.
Course: Oracle SQL Intermediate
I enjoyed the access to trainers individual support in resolving exercises.
Tomasz Czornak
Course: Oracle SQL Intermediate
I enjoyed learning how to maintain the database, and how is the orgenazition of the data.
Jiang Chang
Course: PostgreSQL for Administrators
Trainer had good practical knowledge about using Cassandra day-to-day at least for development purposes. Catering (snacks, coffee hour) were great 3 days length was good.
Mika Linnanoja
Course: Fundamentals of Cassandra DB
Good atmosphere during the training.
clovis Nebouet
Course: Oracle 11g - SQL language for developers - Workshop
I liked the super atmosphere, working with Congo shell.
Jan Sturm
Course: MongoDB for Developers
Training material was very informative. Learned a lot.
Yaw Asamoah
Course: MariaDB Database Administration
I really enjoyed the lessons and examples.
Kelly Taylor
Course: MariaDB Database Administration
He adapted to the experience of the group, gave us great value for a beginners course.
Rich Mickey
Course: MariaDB Database Administration
The structure and pace of the class was great.
David Lacy
Course: MongoDB for Administrators
The depth of the Congo db training was explored from basic to advanced, I felt it was a little too much to squeeze into 2 days but I did get exposure to all aspects of Congo db.
Bay Sayarath
Course: MongoDB for Administrators
I liked that the course was relevant to our need.
Damon Grube
Course: MongoDB for Administrators
Most of the hands-on stuff was good.
Andrew Bauer
Course: MongoDB for Administrators
I genuinely liked that there was no pressure.
Eyal Wirsansky
Course: MongoDB for Administrators
The training started for the early beginners, so everybody could get to know what all is about.
Amanda Dzida
Course: Access - podstawy
I liked everything he taught.
Emily Zhou
Course: PostgreSQL for Administrators
The thorough / hands-on knowledge the trainer has.
Pieter Peirs
Course: Introduction to SQL Server 2012 Integration Services (SSIS)
IF ANYBODY HAD A PROBLEM, TRAINER ALWAYS HELPED.
ANNA JAGIEŁKA
Course: Access Basics
Very in depth knowledge on the subject matter. No “I'll have to look into that and get back to you, just new it all”.
David Marshall
Course: PostgreSQL Administration and Development
The trainer, he was knowledgeable, engaging, and easy to learn from. He encouraged a lot of hands-on learning.
Shawn McAndrew
Course: SQL Fundamentals
I like fact, that after each section we had exercises. It helps to remember discussed topic.
Adam Bińczycki
Course: Oracle 11g - SQL language for developers - Workshop
I learned a LOOOOOT.
Kamil Szmid
Course: SQL Fundamentals
Topics approached. Very complete.
Carlos Eloi Barros
Course: Cassandra for Developers
The last exercise was very good.
José Monteiro
Course: Cassandra for Developers
I really was benefit from the exercises.
Fabrice Limbourg
Course: Introduction to SQL Server 2012 Integration Services (SSIS)
Database Course Outlines
Course Name
Duration
Overview
Course Name
Duration
Overview
14 hours
Overview
MySQL Administration training course is for anyone who wants to administrate the MySQL database server. It is a comprehensive course covering all administrator duties.
The course explains how MySQL Database works, what tools are available, how we can use them, how we can secure the MySQL Database Server and configure it. During the training course you will learn how to manage user accounts and how the MySQL Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery.
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.
28 hours
Overview
In this instructor-led, live training in the UK, participants will learn how to install, configure and manage MariaDB for high availability and performance. Other topics include backup and recovery, security and clustering.
21 hours
Overview
Blazegraph is an open source, Java-based RDF graph database for storing and representing data with complex relationships. It supports Blueprints and RDF/SPARQL 1.1.
In this instructor-led, live training, participants will learn how to use Blazegraph to capture complex data in graph format for retrieval from a number of sample applications. All exercises will be carried out hands-on in a live-lab environment.
By the end of this training, participants will be able to:
- Install and configure Blazegraph in standalone mode, clustered mode (optional) or embedded mode (optional)
- Create, test and deploy a sample application to query complex data in a Blazegraph data store
- Understand how to leverage GPU (graphics processing unit) to accelerate computations
Audience
- Developers
Format of the Course
- Part lecture, part discussion, exercises and heavy hands-on practice
Note
- To request a customized training for this course, please contact us to arrange.
In this instructor-led, live training, participants will learn how to use Blazegraph to capture complex data in graph format for retrieval from a number of sample applications. All exercises will be carried out hands-on in a live-lab environment.
By the end of this training, participants will be able to:
- Install and configure Blazegraph in standalone mode, clustered mode (optional) or embedded mode (optional)
- Create, test and deploy a sample application to query complex data in a Blazegraph data store
- Understand how to leverage GPU (graphics processing unit) to accelerate computations
Audience
- Developers
Format of the Course
- Part lecture, part discussion, exercises and heavy hands-on practice
Note
- To request a customized training for this course, please contact us to arrange.
35 hours
Overview
In this instructor-led, live training in the UK (onsite or remote), participants will learn the general and advanced aspects of PostgreSQL, including administration, performance turning, advanced development, and replication as they step through a series of hands-on, live-lab exercises involving setup, configuration, testing, deployment and troubleshooting.
By the end of this training, participants will be able to:
- Use advanced administration techniques to configure and manage a PostgreSQL server.
- Optimize the database and queries for maximum performance.
- Replicate and scale a PostgreSQL server.
By the end of this training, participants will be able to:
- Use advanced administration techniques to configure and manage a PostgreSQL server.
- Optimize the database and queries for maximum performance.
- Replicate and scale a PostgreSQL server.
28 hours
Overview
Relational databases have been the technology of choice for storing, retrieving and querying data. Relational databases allow users to organize their data using a structured, well-defined set of patterns (model). While this approach works well for storing data that is standardized and well-understood in advance (think of a hospital check-in application that holds patient records with the same consistent set of pre-defined fields...patient id, first name, last name, date of last visit, etc.), there are limitations to this model. For organizations whose incoming data is not well-defined (think of an online inquiry form for a startup whose still in the process of experimenting with different fields for collecting visitor data, removing and adding fields as they go to accommodate for the changing nature of the business), any established definitions for how the data should fit into an existing database would need to be re-defined regularly. This would require recreating the data model (schema) that dictates the structure of the data and its allowed data types to support different types of data inputs, etc., before any new data could be saved to the database.
Enter NoSQL (Not Only SQL) databases. NoSQL databases free users from having to predefine the structure of the incoming data, allowing them to insert and update new data on the fly. NoSQL databases are often faster than relational databases and can handle very large amounts of data with ease. NoSQL databases also scale better than relational databases, due to their ability to efficiently partition data across many servers (cluster) and load balance the access to this data. NoSQL databases integrate particularly well with applications that support real-time analytics, site personalization, IoT, and mobile apps
In this instructor-led, live training , participants will understand the architecture, design principles and functionality of the most popular NoSQL databases as they setup, operate and asses a number of NoSQL databases in a live lab environment. The goal of this training is to enable participants to intelligently evaluate, propose and implement a suitable NoSQL database solution within their organization.
By the end of this training, participants will be able to:
- Install and configure different types of NoSQL databases, including MongoDB, Cassandra, Redis and Neo4j
- Understand the benefits and disadvantages of NoSQL databases vs relational databases
- Understand the underlying data formats used by NoSQL databases and how these formats can be used to an advantage when developing modern applications (desktop, mobile, cloud, IoT)
- Perform create, insert, update, delete operations in a NoSQL database
- Setup a mixed environment with both a relational database and NoSQL working in tandem
- Configure a cluster of NoSQL database to distribute the processing of very large datasets
- Understand the security implications of using a NoSQL database
- Deploy and scale a NoSQL database in a production environment
Audience
- Database professionals
- Data architects
- Data strategists
- Project managers
- Application developers wishing to integrate a flexible database solution in their application
Format of the Course
- Part lecture, part discussion, exercises and heavy hands-on practice
Note
- To request a customized training for this course, please contact us to arrange.
Enter NoSQL (Not Only SQL) databases. NoSQL databases free users from having to predefine the structure of the incoming data, allowing them to insert and update new data on the fly. NoSQL databases are often faster than relational databases and can handle very large amounts of data with ease. NoSQL databases also scale better than relational databases, due to their ability to efficiently partition data across many servers (cluster) and load balance the access to this data. NoSQL databases integrate particularly well with applications that support real-time analytics, site personalization, IoT, and mobile apps
In this instructor-led, live training , participants will understand the architecture, design principles and functionality of the most popular NoSQL databases as they setup, operate and asses a number of NoSQL databases in a live lab environment. The goal of this training is to enable participants to intelligently evaluate, propose and implement a suitable NoSQL database solution within their organization.
By the end of this training, participants will be able to:
- Install and configure different types of NoSQL databases, including MongoDB, Cassandra, Redis and Neo4j
- Understand the benefits and disadvantages of NoSQL databases vs relational databases
- Understand the underlying data formats used by NoSQL databases and how these formats can be used to an advantage when developing modern applications (desktop, mobile, cloud, IoT)
- Perform create, insert, update, delete operations in a NoSQL database
- Setup a mixed environment with both a relational database and NoSQL working in tandem
- Configure a cluster of NoSQL database to distribute the processing of very large datasets
- Understand the security implications of using a NoSQL database
- Deploy and scale a NoSQL database in a production environment
Audience
- Database professionals
- Data architects
- Data strategists
- Project managers
- Application developers wishing to integrate a flexible database solution in their application
Format of the Course
- Part lecture, part discussion, exercises and heavy hands-on practice
Note
- To request a customized training for this course, please contact us to arrange.
28 hours
Overview
The training is intended not only for Oracle database administrators both who are just starting to work with Oracle servers and who are already working on such one and want to learn about the new futures in 12c version. This training can be also useful for programmers who - thanks to the understanding of server architecture and its mechanisms rules - will be able to create effective applications working with the Oracle 12c database.
21 hours
Overview
This bespoke course has been designed specifically against the requirements provided by Now Managed Learning Services
7 hours
Overview
In this instructor-led, live training in the UK, participants will learn the fundamentals of GraphQL as they step through the creation of a simple API with GraphQL.
By the end of this training, participants will be able to:
- Understand what GraphQL is and what distinguishes it from REST.
- Understand top-level GraphQL terms.
- Set up a GraphQL coding environment.
- Build and improve a GraphQL API.
By the end of this training, participants will be able to:
- Understand what GraphQL is and what distinguishes it from REST.
- Understand top-level GraphQL terms.
- Set up a GraphQL coding environment.
- Build and improve a GraphQL API.
28 hours
Overview
In this instructor-led, live training in the UK, participants will learn how to build React applications using Flux and GraphQL. The course covers installation, setup, integration, testing, deployment and best practices as it walks participants through the creation of a series of sample applications that demonstrate how to add additional levels of complexity and "coolness" to an application using the most advanced toolkits and techniques.
Developing applications with React requires a different kind of thinking, compared to what some developers are accustomed to, especially when coming from the mindset of other MVC frameworks such as AngularJS and Bootstrap.
This training covers the fundamentals behind of the technologies used each step of the way so that participants are not only able to build a functional application, but also understand why a particular approach is used. This lays the groundwork for thinking independently and creatively about the design and the desired results for building their own applications in the future.
Developing applications with React requires a different kind of thinking, compared to what some developers are accustomed to, especially when coming from the mindset of other MVC frameworks such as AngularJS and Bootstrap.
This training covers the fundamentals behind of the technologies used each step of the way so that participants are not only able to build a functional application, but also understand why a particular approach is used. This lays the groundwork for thinking independently and creatively about the design and the desired results for building their own applications in the future.
14 hours
Overview
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.
28 hours
Overview
In this instructor-led, live training in the UK, participants will learn the fundamentals of SAP ASE (SAP Adaptive Server Enterprise) Database Administration as they step through the creation and deployment of a sample SAP ASE Database System.
By the end of this training, participants will be able to:
- Install and configure SAP ASE for data storage as well as transactional operations.
- Understand and use SAP ASE components, tools, and utilities.
- Integrate SAP ASE with non-SAP ASE applications.
By the end of this training, participants will be able to:
- Install and configure SAP ASE for data storage as well as transactional operations.
- Understand and use SAP ASE components, tools, and utilities.
- Integrate SAP ASE with non-SAP ASE applications.
28 hours
Overview
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
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
14 hours
Overview
OrientDB is a NoSQL Multi-Model Database that works with Graph, Document, Key-Value, GeoSpatial, and Reactive models. Its flexibility allows users to manage different kinds of data under one centralized database.
In this instructor-led, live training, participants will learn how to start using OrientDB and utilize its flexibility to manage data.
By the end of this training, participants will be able to:
- Install OrientDB
- Learn how to create and manage a database with OrientDB
- Explore the different features and functionalities of OrientDB
- Learn how to work with different APIs on OrientDB
- Deploy OrientDB using Distributed Architecture
Audience
- Software engineers and technicians
- Technical people in all industries
- IT people
- Developers
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
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
28 hours
Overview
In this instructor-led, live training in the UK, participants will learn about the technology offerings and implementation approaches for processing graph data. The aim is to identify real-world objects, their characteristics and relationships, then model these relationships and process them as data using a Graph Computing (also known as Graph Analytics) approach. We start with a broad overview and narrow in on specific tools as we step through a series of case studies, hands-on exercises and live deployments.
By the end of this training, participants will be able to:
- Understand how graph data is persisted and traversed.
- Select the best framework for a given task (from graph databases to batch processing frameworks.)
- Implement Hadoop, Spark, GraphX and Pregel to carry out graph computing across many machines in parallel.
- View real-world big data problems in terms of graphs, processes and traversals.
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.
7 hours
Overview
This course helps customer to chose the write data storage depend on their needs. It covers almost all possible modern approaches.
35 hours
Overview
Developers, analysts and business users need to quickly analyse large amounts of data, get insight into that data, retrieve hidden knowledge inside it, and report against various data sources professionally and effectively. This course will enable them to do this with SQL Server Business Intelligence. The 5 day course will cover the SQL Server components and tools used for B.I. projects.
The course will also include the new features in SQL Server B.I. 2016. Reporting Services, Analysis Services and Integration Services will be explored and worked with. Components of Business Intelligence in SQL Server are completely independent from the SQL Server databases, so they can be used over any data sources. Therefore, it is not necessary to know the SQL Server itself.
4 Top Takeaways from the Course
- Make your existing data work harder for you
- Integrate diverse data stores to a single repository
- Transform raw data to business intelligence
- Create eloquent reports from raw data
The course will also include the new features in SQL Server B.I. 2016. Reporting Services, Analysis Services and Integration Services will be explored and worked with. Components of Business Intelligence in SQL Server are completely independent from the SQL Server databases, so they can be used over any data sources. Therefore, it is not necessary to know the SQL Server itself.
4 Top Takeaways from the Course
- Make your existing data work harder for you
- Integrate diverse data stores to a single repository
- Transform raw data to business intelligence
- Create eloquent reports from raw data
7 hours
Overview
FlockDB is an open source distributed, fault-tolerant graph database for managing wide but shallow network graphs. It was initially used by Twitter to store relationships among users.
In this instructor-led, live training, participants will learn how to set up and use a FlockDB database to help answer social media questions such as who follows whom, who blocks whom, etc.
By the end of this training, participants will be able to:
- Install and configure FlockDB
- Understand the unique features of FlockDB, relative to other graph databases such Neo4j
- Use FlockDB to maintain a large graph dataset
- Use FlockDB together with MySQL to provide provide distributed storage capabilities
- Query, create and update extremely fast graph edges
- Scale FlockDB horizontally for use in on-line, low-latency, high throughput web environments
Audience
- Developers
- Database engineers
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
In this instructor-led, live training, participants will learn how to set up and use a FlockDB database to help answer social media questions such as who follows whom, who blocks whom, etc.
By the end of this training, participants will be able to:
- Install and configure FlockDB
- Understand the unique features of FlockDB, relative to other graph databases such Neo4j
- Use FlockDB to maintain a large graph dataset
- Use FlockDB together with MySQL to provide provide distributed storage capabilities
- Query, create and update extremely fast graph edges
- Scale FlockDB horizontally for use in on-line, low-latency, high throughput web environments
Audience
- Developers
- Database engineers
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
14 hours
Overview
Hypertable is an open-source software database management system based on the design of Google's Bigtable.
In this instructor-led, live training, participants will learn how to set up and manage a Hypertable database system.
By the end of this training, participants will be able to:
- Install, configure and upgrade a Hypertable instance
- Set up and administer a Hypertable cluster
- Monitor and optimize the performance of the database
- Design a Hypertable schema
- Work with Hypertable's API
- Troubleshoot operational issues
Audience
- Developers
- Operations engineers
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
Part lecture, part discussion, exercises and heavy hands-on practice
In this instructor-led, live training, participants will learn how to set up and manage a Hypertable database system.
By the end of this training, participants will be able to:
- Install, configure and upgrade a Hypertable instance
- Set up and administer a Hypertable cluster
- Monitor and optimize the performance of the database
- Design a Hypertable schema
- Work with Hypertable's API
- Troubleshoot operational issues
Audience
- Developers
- Operations engineers
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
Part lecture, part discussion, exercises and heavy hands-on practice
14 hours
Overview
Riak is an Erlang based open-source document database, similar to CouchDB. It is created and maintained by Basho.
In this instructor-led, live training, participants will learn how to build, run and operate a Riak based web application.
By the end of this training, participants will be able to:
- Extend the number of hardware nodes and partition data across multiple servers
- Use bucket/key/values to organize and retrieve documents
- Use full-text search like query syntax
- Understand other Riak related technologies, such as Riak KV and Riak TS
- Test, secure, optimize and deploy a sample web application
Audience
- Developers
- Database engineers
- Operations staff
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
In this instructor-led, live training, participants will learn how to build, run and operate a Riak based web application.
By the end of this training, participants will be able to:
- Extend the number of hardware nodes and partition data across multiple servers
- Use bucket/key/values to organize and retrieve documents
- Use full-text search like query syntax
- Understand other Riak related technologies, such as Riak KV and Riak TS
- Test, secure, optimize and deploy a sample web application
Audience
- Developers
- Database engineers
- Operations staff
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
21 hours
Overview
kdb+ is an in-memory, column-oriented database and q is its built-in, interpreted vector-based language. In kdb+, tables are columns of vectors and q is used to perform operations on the table data as if it was a list. kdb+ and q are commonly used in high frequency trading and are popular with the major financial institutions, including Goldman Sachs, Morgan Stanley, Merrill Lynch, JP Morgan, etc.
In this instructor-led, live training, participants will learn how to create a time series data application using kdb+ and q.
By the end of this training, participants will be able to:
- Understand the difference between a row-oriented database and a column-oriented database
- Select data, write scripts and create functions to carry out advanced analytics
- Analyze time series data such as stock and commodity exchange data
- Use kdb+'s in-memory capabilities to store, analyze, process and retrieve large data sets at high speed
- Think of functions and data at a higher level than the standard function(arguments) approach common in non-vector languages
- Explore other time-sensitive applications for kdb+, including energy trading, telecommunications, sensor data, log data, and machine and network usage monitoring
Audience
- Developers
- Database engineers
- Data scientists
- Data analysts
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
In this instructor-led, live training, participants will learn how to create a time series data application using kdb+ and q.
By the end of this training, participants will be able to:
- Understand the difference between a row-oriented database and a column-oriented database
- Select data, write scripts and create functions to carry out advanced analytics
- Analyze time series data such as stock and commodity exchange data
- Use kdb+'s in-memory capabilities to store, analyze, process and retrieve large data sets at high speed
- Think of functions and data at a higher level than the standard function(arguments) approach common in non-vector languages
- Explore other time-sensitive applications for kdb+, including energy trading, telecommunications, sensor data, log data, and machine and network usage monitoring
Audience
- Developers
- Database engineers
- Data scientists
- Data analysts
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
21 hours
Overview
The aim of this course is to provide a clear understanding of the use of SQL for different
databases (Oracle, SQL Server, MS Access...). Understanding of analytic functions and the
way how to join different tables in a database will help delegates to move data analysis
operations to the database side, instead of doing this in MS Excel application. This can also
help in creating any IT system, which uses any relational database.
databases (Oracle, SQL Server, MS Access...). Understanding of analytic functions and the
way how to join different tables in a database will help delegates to move data analysis
operations to the database side, instead of doing this in MS Excel application. This can also
help in creating any IT system, which uses any relational database.
14 hours
Overview
Percona Server for MySQL is optimized for cloud computing, NoSQL access, containers and modern hardware such as SSD and Flash storage.
-
Cloud ready
Dramatically reduces downtime on servers with slow disks and large memory, such as 4XL EC2 servers on EBS volumes
-
SaaS deployable
Increases flexibility for architectures such as co-located databases with hundreds of thousands of tables and heterogeneous backup and retention policies
-
Vertical scalability and server consolidation
Scales to over 48 CPU cores, with the ability to achieve hundreds of thousands of I/O operations per second on high-end solid-state hardware
-
Query, object and user level instrumentation
Detailed query logging with per-query statistics about locking, I/O, and query plan, as well as performance and access counters per-table, per-index, per-user, and per-host
-
Enterprise ready
Percona Server for MySQL includes advanced, full-enabled external authentication, audit logging and threadpool scalability features that are only available in Oracle’s commercial MySQL Enterprise Edition
-
Cloud ready
Dramatically reduces downtime on servers with slow disks and large memory, such as 4XL EC2 servers on EBS volumes
-
SaaS deployable
Increases flexibility for architectures such as co-located databases with hundreds of thousands of tables and heterogeneous backup and retention policies
-
Vertical scalability and server consolidation
Scales to over 48 CPU cores, with the ability to achieve hundreds of thousands of I/O operations per second on high-end solid-state hardware
-
Query, object and user level instrumentation
Detailed query logging with per-query statistics about locking, I/O, and query plan, as well as performance and access counters per-table, per-index, per-user, and per-host
-
Enterprise ready
Percona Server for MySQL includes advanced, full-enabled external authentication, audit logging and threadpool scalability features that are only available in Oracle’s commercial MySQL Enterprise Edition
21 hours
Overview
This course will introduce Cassandra – a popular NoSQL database. It will cover Cassandra principles, architecture and data model. Students will learn data modeling in CQL (Cassandra Query Language) in hands-on, interactive labs. This session also discusses Cassandra internals and some admin topics.
Duration : 3 days
Audience : Developers
Duration : 3 days
Audience : Developers
21 hours
Overview
Teradata is one of the popular Relational Database Management System. It is mainly suitable for building large scale data warehousing applications. Teradata achieves this by the concept of parallelism.
This course introduces the delegates to Teradata.
This course introduces the delegates to Teradata.
14 hours
Overview
Voldemort is an open-source distributed data store that is designed as a key-value store. It is used at LinkedIn by numerous critical services powering a large portion of the site.
This course will introduce the architecture and capabilities of Voldomort and walk participants through the setup and application of a key-value distributed data store.
Audience
- Software developers
- System administrators
- DevOps engineers
Format of the course
- Part lecture, part discussion, heavy hands-on practice, occasional tests to gauge understanding
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
21 hours
Overview
Berkeley DB (BDB) is a software library intended to provide a high-performance embedded database for key/value data. Berkeley DB is written in C with API bindings for C++, C#, Java, Perl, PHP, Python, Ruby, Smalltalk, Tcl, and many other programming languages. Berkeley DB is not a relational database.
This course will introduce the architecture and capabilities of Berkeley DB and walk participants through the development of their own sample application using Berkeley DB.
Audience
- Application developers
- Software engineers
- Technical consultants
Format of the course
- Part lecture, part discussion, hands-on development and implementation, tests to gauge understanding
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
14 hours
Overview
Microsoft Access is a pseudo-relational database engine from Microsoft.
21 hours
Overview
Scylla is an open-source distributed NoSQL data store. It is compatible with Apache Cassandra but performs at significantly higher throughputs and lower latencies.
In this course, participants will learn about Scylla's features and architecture while obtaining practical experience with setting up, administering, monitoring, and troubleshooting Scylla.
Audience
- Database administrators
- Developers
- System Engineers
Format of the course
- The course is interactive and includes discussions of the principles and approaches for deploying and managing Scylla distributed databases and clusters.
- The course includes a heavy component of hands-on exercises and practice.
In this course, participants will learn about Scylla's features and architecture while obtaining practical experience with setting up, administering, monitoring, and troubleshooting Scylla.
Audience
- Database administrators
- Developers
- System Engineers
Format of the course
- The course is interactive and includes discussions of the principles and approaches for deploying and managing Scylla distributed databases and clusters.
- The course includes a heavy component of hands-on exercises and practice.
21 hours
Overview
In this instructor-led, live hands-on training in the UK, we will set up a live project and put into practice the skills to model, manage and access your data using neo4j. We contrast and compare graph databases with SQL-based databases as well as other NoSQL databases and clarify when and where it makes sense to implement each within your infrastructure.
21 hours
Overview
Audience
*KDB+/Q developer
Format of the course
50% lectures, 40% labs, 10% tests
*KDB+/Q developer
Format of the course
50% lectures, 40% labs, 10% tests
Upcoming Database Courses
2021-05-17 09:30:00
Portsmouth - North Harbour
7 hours
2021-06-14 09:30:00
Portsmouth - North Harbour
14 hours
2021-06-30 09:30:00
Portsmouth - North Harbour
21 hours
2021-06-30 09:30:00
Portsmouth - North Harbour
21 hours
2021-07-07 09:30:00
Portsmouth - North Harbour
21 hours
Other regions
Other countries
Consulting
Online Database courses, Weekend Database courses, Evening Database training, Database boot camp, Database instructor-led, Weekend Database training, Evening Database courses, Database coaching, Database instructor, Database trainer, Database training courses, Database classes, Database on-site, Database private courses, Database one on one training
.png "university college london (ucl)"){kind=small}
.jpg "defence science and technology laboratory (dstl)")
.png "universities and colleges admissions service (ucas)"){kind=small}
.png "national health service (nhs)"){kind=small}
.png "chartered institute of marketing (cim)"){kind=small}
