Local, 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 "onsite live training" or "remote live training". The UK onsite live Database trainings can be carried out locally on customer premises or in NobleProg corporate training centres. Remote live training is carried out by way of an interactive, remote desktop.
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 likedthat 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
The trainer did bring some good insight and ways to approach developing a graph database. He used examples from the slides presented but also drew on his own experience which was good.
Autodata Ltd
Course: Beyond the Relational Database: Neo4j
How it was tailored to my needs.
James Wood - E-Legal Technolo
Course: SQL in SQL Server
I believe in the fact: good to have more exercises than lectures.
DXC Technology via SCC
Course: MongoDB for Administrators
I liked the mongol / Mongol / Mongodump / Mongorestore / MongoDB.
DXC Technology via SCC
Course: MongoDB for Administrators
very logical and step by step but not too much
Anne Homer - States of Jersey
Course: SQL Fundamentals
I enjoyed the flexibility to explore different areas outside the set training materials.
BMW Group
Course: SQL Fundamentals
There was a good amount of practical exercises which helped cement the learning and kept us engaged throughout.
Samuel Reeve - Capita Business Services Ltd
Course: PostgreSQL Administration, Optimization and Replication
interaction with the teacher. We had a lot of discussions about the several subjects.
arno bongenaar - KLM Accounts Payable SPL/AP
Course: Redis for Developers and System Administrators
In depth knowledge of the trainer and his unbiased opinion. Felt like he was genuinely teaching us about the subject (Redis), the pro's and con's, and not selling it.
KLM Accounts Payable SPL/AP
Course: Redis for Developers and System Administrators
I liked the small group, good interaction and possibility to customise.
Erik de Ruiter - KLM Accounts Payable SPL/AP
Course: Redis for Developers and System Administrators
The amount of knowledge we got.
Course: Beyond the Relational Database: Neo4j
Phil was incredibly knowledgeable, worked at our pace and took the time to talk us through multiple ways of doing different queries. He consistently took the time throughout the sessions to check both myself and my colleague were on board with what was being discussed, no question was too big/too small. This was my first time taking a training course remotely and I'm completely sold on it - Phil is a credit to you.
Chris Teasdale - Openreach
Course: SQL Fundamentals
Pace of the training and detail of content was perfect for a virtual session
Chris Hopton - Openreach
Course: SQL Fundamentals
Relevance to BigQuery.
Spark44
Course: SQL in SQL Server
We use BigQuery and the trainer decided we would use BigQuery instead to run all of the codes which was really really useful
Spark44
Course: SQL in SQL Server
Almost one to one training and Michal had a lot of experience on the subject matter.
CACI LTD
Course: PostgreSQL for Administrators
A lot of useful infromation has been provided.
MTU Aero Engines Polska Sp. z o. o.
Course: Administering in Microsoft SQL Server
I got a great starting point in sql server administatrion
MTU Aero Engines Polska Sp. z o. o.
Course: Administering in Microsoft SQL Server
Pace was perfect. Topics suitable.
MTU Aero Engines Polska Sp. z o. o.
Course: Administering in Microsoft SQL Server
Well prepared trainer open for additional questions of any kind at any time
Thomas Griffig - MTU Aero Engines Polska Sp. z o. o.
Course: Administering in Microsoft SQL Server
I like the comprehensive approach to the subject taught. The course was well-structured, the topics were prepared and presented in a good order, helping us understand step-by-step logic how particular aspects of Teradata work. Especially I like that a lot of impact was put on the topic of indices. Pablo is a very likeable person and a good teacher. The time spent on this training was definitely spent well.
MicroStrategy Poland Sp. z o.o.
Course: Teradata Fundamentals
Helpful trainer, Good amount of training materials.
Matyas Sandor - Training360 Kft.
Course: MongoDB for Administrators
interaction
Maastricht University | UMIO
Course: Teradata Fundamentals
Discussing many examples.
Emily Chesworth - Maastricht University | UMIO
Course: Teradata Fundamentals
exercises & subquery
Maastricht University | UMIO
Course: Teradata Fundamentals
I liked the depth of the training. I was able to understand most of it and definitely learned from this training
Maastricht University | UMIO
Course: Teradata Fundamentals
passionate trainer
Sylvia Baniak - Maastricht University | UMIO
Course: Teradata Fundamentals
x
Maastricht University | UMIO
Course: Teradata Fundamentals
New learned skills
Maastricht University | UMIO
Course: Teradata Fundamentals
The enthusiasm of the trainer
Maastricht University | UMIO
Course: Teradata Fundamentals
Explaining the step to take when trying to answer a question via the SQL
Maastricht University | UMIO
Course: Teradata Fundamentals
great knowledge from the presenter
ANIXE Polska sp. z o.o.
Course: PostgreSQL for Developers
Detailed knowledge and customer approach
Wojciech Polak - ANIXE Polska sp. z o.o.
Course: PostgreSQL for Developers
The exercises.
ANIXE Polska sp. z o.o.
Course: PostgreSQL for Developers
The in depth explaination of mechanisms working inside of psql instance and humour.
Łukasz Biel - ANIXE Polska sp. z o.o.
Course: PostgreSQL for Developers
deep explanation about mechanisms how actually postgres is working underneath, experiments on database
Paweł Rynowiecki - ANIXE Polska sp. z o.o.
Course: PostgreSQL for Developers
The openness, the way of the presentation
Marcin Szewczyk - ANIXE Polska sp. z o.o.
Course: PostgreSQL for Developers
new knowledges that can be apply in our system
Laurence Bangsal - PayMaya Philippines, Inc.
Course: PostgreSQL Administration, Optimization and Replication
the additional and extensive postgres knowledge we attained
PayMaya Philippines, Inc.
Course: PostgreSQL Administration, Optimization and Replication
the learnings, because of the exercises given per topic it help us to apply and understand more the concepts.
PayMaya Philippines, Inc.
Course: PostgreSQL Administration, Optimization and Replication
Interactive exercises
Matthew Viner - Thames Water Utilites Ltd
Course: Transact SQL Basic
The amount of knowledge we got.
Course: Beyond the Relational Database: Neo4j
Database Course Outlines
Target audience includes developers who want to use or extend PostgreSQL, as well as database architects.
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.
You will also learn how to find slow queries, monitor database performance and tune PostgreSQL for Performance.
You will learn PostgreSQL architecture, installation, designing as well as how to perform backup and recovery databases in PostgreSQL.
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.
Training focuses mainly on using Windows PowerShell as an interactive command line interface however it also includes some coverage of scripting and programming topics.
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
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
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.
By the end of this training, participants will be able to:
- Employ Presto key concepts to optimize modern big data systems.
- Use Presto to run exabyte scale warehouses.
- Clone data to a proprietary data storage system.
- Work with existing BI tools such as R and Tableau.
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
By the end of this training, participants will be able to:
- Understand the major feature and architectural changes in Oracle Web Forms.
- Migrate to Oracle Web Forms from a previous Forms version.
- ***Deploy Oracle Web Forms in cloud or on premise.
- Leverage Oracle Web Forms to enhance user services and experience.
By the end of this training, participants will be able to:
- Understand the major feature and architectural changes from previous Oracle versions.
- Migrate to Oracle 18c from a previous version.
- Deploy Oracle 18c in cloud or on premise.
- Understand Oracle 18c's new yearly release cycle and plan maintenance around it.
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.
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.
By the end of this training, participants will be able to:
- Create mutations to enable clients to manipulate data in databases.
- Script an automated test suite for a node application.
- Use GraphQL schemas to define data interaction.
- Secure node application data with an authentication system.
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.
By the end of this training, participants will be able to:
- Install and configure MongoDB
- Understand the difference between accessing a NoSQL document database and a traditional relational databases' (e.g., MySQL)
- Query a MongoDB database from within Python
- Create and write data to a MongoDB databasse
- Understand MongoDB's "data processing pipeline"
- Perform real-time analytics and statistical analysis
- Generate reports for dashboarding
- Implement exception handling in Python application
Format of the Course:
- Interactive lecture and discussion
- Lots of exercises and practice
- Hands-on implementation in a live-lab environment
Course Customization Options:
- To request a customized training for this course, please contact us to arrange.
-
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
By the end of this training, participants will be able to:
- Install and configure ProxySQL.
- Enable thousands of concurrent database connections over multiple backend servers.
- Deploy multiple ProxySQL proxies spanning numerous database instances.
- Optimize the performance of a MySQL cluster, without altering the querying applications.
In this instructor-led, live training (onsite or remote), participants will learn the essentials of the SQL language needed to query a Microsoft SQL Server database.
By the end of this training, participants will be able to:
- Install and configure Microsoft SQL Server
- Query a Microsoft SQL Server database using Microsoft's Transact-SQL (T-SQL) language
- Understand the essentials of database design
- Optimize a database through normalization
- Use aggregate functions to generate results similar to those of "pivot-tables"
- Access Microsoft SQL Server through Excel
Audience
- Data analysts
- Business Intelligence professionals
- Business managers
- Excel experts who wish to expand their analysis skill set
Format of the Course
- Interactive lecture and discussion
- Lots of exercises and practice
- Hands-on implementation in a live-lab environment
Course Customization Options
- This training is based on the latest version of Microsoft SQL Server
- To request a customized training for this course, please contact us to arrange.
.png "university college london (ucl)")
.jpg "defence science and technology laboratory (dstl)")
.png "universities and colleges admissions service (ucas)")
.png "national health service (nhs)")
.png "chartered institute of marketing (cim)")
