Database Training Courses
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". Onsite live training can be carried out locally on customer premises in the UK or in NobleProg corporate training centers in the UK. Remote live training is carried out by way of an interactive, remote desktop. NobleProg -- Your Local Training Provider
Client Testimonials
What would you suggest the trainer could do to improve this? Training was excelent. Nothing to improve, just keep the good work What did you like the most about the training? Clear when explaining the topics on the training and the amount and quality of the practical exercices. Manuel Ruiz Santiago - RRDonnelley GDS
Course Name: SQL in MySQL
What did you like the most about the training?: Phil catered for all our needs and even though we had a manual to work through he did not stick to it but was willing to explain our questions about how things can be used in our work and had a lot of patience explaining stuff to us. Lorett Bredenkamp - Save the Children
Course Name: Oracle SQL Intermediate - Data Extraction
Trainer Subject Knowledge
Julian Pirau
Course Name: 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 Name: Oracle SQL Intermediate
Access to trainers individual support in resolving exercises.
Tomasz Czornak
Course Name: Oracle SQL Intermediate
How to maintain the database, and how is the orgenazition of the data.
Jiang Chang
Course Name: PostgreSQL for Administrators
good atmosphere during the training
clovis Nebouet
Course Name: Oracle 11g - SQL language for developers - Workshop
Examples
Sebastian Huerta Martinez
Course Name: SQL language in MSSQL
I liked everything he taught.
Emily Zhou
Course Name: PostgreSQL for Administrators
I like fact, that after each section we had excercises. It helps to remember discused topic.
Adam Bińczycki
Course Name: Oracle 11g - SQL language for developers - Workshop
Thorough knowledge of the material and easily answered questions and could compare PostgreSQL to other database vendors.
YAZAKI SERVICE S DE RL DE CV
Course Name: PostgreSQL for Administrators
knowledge and translations
Jan Maksymowski
Course Name: Oracle 11g - Język SQL dla administratorów - warsztaty
Translated by
Complete knowledge of the lecturer.
Bogusław Stanek
Course Name: Oracle SQL - poziom średniozaawansowany
Translated by
Oral explanations ok, interesting exercises.
Witold Sobków
Course Name: Oracle SQL - poziom średniozaawansowany
Translated by
A lot of exercises with different levels of difficulty and individual approach of the trainer to each participant
Agnieszka Cybula
Course Name: Oracle SQL - poziom średniozaawansowany
Translated by
It is difficult to assess the very consistent training. Everything was liked
Damian Ostrega
Course Name: Oracle 11g - Strojenie Aplikacji - warsztaty
Translated by
A large number of exercises
Wojciech Kozioł
Course Name: Oracle SQL - poziom średniozaawansowany
Translated by
Quality of training, and explanation of approach methods to issues
Blazej Baron
Course Name: Oracle SQL - poziom średniozaawansowany
Translated by
A professional and accessible way of transferring knowledge and assistance during training and exercises.
Michal Bialek
Course Name: Język SQL w bazie danych MySQL
Translated by
Flexibility in the issues raised, the pace and the amount of time allocated to the given issue
Karo Jarnutowski
Course Name: Język SQL w bazie danych MSSQL
Translated by
A lot of practical examples.
Paweł Miązek
Course Name: Oracle 11g - Język SQL dla programistów - warsztaty
Translated by
commitment of the teacher
Sylwia Żokowska
Course Name: Access - projektowanie baz danych
Translated by
I liked the way of conducting the training the most. It was not carried out too quickly, and in a way that everyone could write down everything and learn.
Agnieszka Grzywa
Course Name: Access - projektowanie baz danych
Translated by
The way the trainer handles knowledge.
Patrycja Wisniewska
Course Name: Język SQL w bazie danych MSSQL
Translated by
Dokladne wytłumaczenie przy problemach lub pytaniach
Serhiy Holovin
Course Name: Język SQL w bazie danych MSSQL
a lot of examples
Sławomir Dzimira
Course Name: Język SQL w bazie danych MSSQL
Translated by
adjusting the training to the participants' needs
Sylwia Lubojemska
Course Name: Język SQL w bazie danych MSSQL
Translated by
adapting the material to the knowledge, interests and needs of the interested; a small group of trainers helped in learning more quickly; nice way of conducting, trivia, conversation
Łukasz Madej
Course Name: SQL in Microsoft Access
Translated by
Commitment and passion of the trainer ☺. And with the problem of managing backupmi, Joby.
Krzysztof Klockowski
Course Name: Administracja bazą danych Microsoft SQL Server
Translated by
Knowledge and professionalism of the trainer The trainer adjusted the training material to the needs of the participant
Dagmara Bruffaerts
Course Name: Oracle 11g - Analiza danych - warsztaty
Translated by
Practical testing of transmitted information
PayPro S.A.
Course Name: Zaawansowana administracja MySQL
Translated by
available help during the exercises, answer to every question and efforts to solve any problem
Krzysztof Zieliński
Course Name: Zaawansowana administracja MySQL
Translated by
Practical, not just theoretical, approach. You can see a lot of practical knowledge that I can use.
PayPro S.A.
Course Name: Zaawansowana administracja MySQL
Translated by
factual answers, a wide range of knowledge
Łukasz Piechowiak
Course Name: Zaawansowana administracja MySQL
Translated by
examples, openness of the trainer
INTERNATIONAL PAPER POLSKA
Course Name: Język SQL w bazie danych Oracle
Translated by
flexibility
dawid bodo
Course Name: Język SQL w bazie danych Oracle
Translated by
all
Jacek Jarych
Course Name: Administracja bazą danych Microsoft SQL Server
Translated by
A huge trainer experience
Crédit Suisse (Poland) Sp. z o.o.
Course Name: Oracle 11g - Strojenie Aplikacji - warsztaty
Translated by
Nice atmosphere, a large number of examples very well explained. Training materials for every part. The coach is very helpful in repairing mistakes during the exercises. I recommend everyone who wants to get and broaden their knowledge in SQL ...
Sebastian Straczyński - Stowarzyszenie Niżańskie Centrum Rozwoju
Course Name: Oracle SQL - poziom średniozaawansowany
Translated by
Subcategories
Course Outlines
| Code | Name | Duration | Overview |
|---|---|---|---|
| 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. |
| 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) |
| ADSQL | SQL Advanced | 14 hours | Students will learn advanced queries and how to add, update, and delete data, tables, views, and indexes. |
| 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. |
| 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 |
| 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. |
| cassdbfun | Fundamentals of Cassandra DB | 21 hours | This course introduces the basics of Cassandra 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. |
| 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. |
| 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. |
| 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 processes -- these tools and processes can be referred to as Graph Computing (also known as Graph Analytics). In this instructor-led, live training, 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 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 Audience Developers Format of the course Part lecture, part discussion, exercises and heavy hands-on practice |
| sqlmysqladv | SQL Advanced in MySQL | 7 hours | This course has been created for people already acquainted with SQL. The course introduces you into secrets common to all SQL databases as well as MySQL specific syntax, functions and features. |
| 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? |
| 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. |
| vbaaccessexcel | VBA For Access & Excel | 21 hours | The objective of the course is to enable participants to gain a mastery of the fundamentals and usages of VBA for Access & Excel. |
| 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. |
| 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 |
| 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 |
| 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. |
| 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? |
| 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 |
| trafodionadm1 | Administering Trafodion | 14 hours | The objective of the course is to enable participants to gain a mastery of NewSQL Concepts and how to administer Trafodion. |
| 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. |
| 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 |
| 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 |
| 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. |
| 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. |
| 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. |
| poshadmin | Administration with Powershell | 35 hours | This intensive training provides the fundamental knowledge and skills to use Windows PowerShell for automating administration of Windows based computers. The skills taught in this course are applicable to all Microsoft products that use Windows PowerShell for daily administration. Training focuses mainly on using Windows PowerShell as an interactive command line interface however it also includes some coverage of scripting and programming topics. |
Upcoming Courses
| Course | Course Date | Course Price [Remote / Classroom] |
|---|---|---|
| Administering in Microsoft SQL Server - Leeds | Mon, 2018-07-09 09:30 | £3300 / £3900 |
| Oracle SQL Language - Portsmouth | Mon, 2018-07-09 09:30 | £2200 / £2500 |
| SQL language in MSSQL - Edinburgh Training and Conference Venue | Mon, 2018-07-09 09:30 | £2200 / £2600 |
| Oracle 11g - Advanced data analysis - workshops - Coventry - The Quadrant | Mon, 2018-07-09 09:30 | £5500 / £6750 |
| Access - Data Base Designing - Glasgow | Mon, 2018-07-09 09:30 | £3300 / £4350 |