
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. New Zealand onsite live Database trainings can be carried out locally on customer premises or in NobleProg corporate training centers.
NobleProg -- Your Local Training Provider
Testimonials
Training Room and quite location and all the stuff.
Abdullah Adelyar - USAID - Kabul Afghanistan
Course: Access VBA
I learned a lot of new things which will be useful for my tasks.
Zsolt - Krisztina BALOGH, Diehl
Course: Access Advanced
The trainings by our self
Andreas - Krisztina BALOGH, Diehl
Course: Access Advanced
I liked that all the neccessary topics have been explored.
Krisztina BALOGH, Diehl
Course: Access Advanced
The training started for the early beginners, so everybody could get to know what all is about.
Amanda Dzida
Course: Access - podstawy
Kamil 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
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
examples and the way he explained
Sandeep Parashar
Course: VBA For Access & Excel
The situation was atypical because an intensive training for developers was to be conducted with non-developers. Lukasz took up this challenge with empathy and a lot of humour. Through his intelligent and flexible manner, he was able to ensure that a concrete learning gain was achieved for everyone. I enjoyed this very much and would gladly take a seminar with Lukasz again.
Christoph - Christoph Pflaumer, Honda Bank GmbH
Course: MERN Fullstack Development
The training platform and functionalities as well as the Kamil way of knowledge transfer
panayiotis kakouris - epic ltd
Course: MongoDB for Analysts
The lab environment
Samer Roshdi - epic ltd
Course: MongoDB for Analysts
los temas que vimos fueron bien explicados.
Daniela Valdez, Banco de México
Course: MongoDB for Administrators
Los ejercicios para repasar teoría y que al inicio de cada sesión había un resumen que me permitía recordar lo visto.
Daniela Valdez, Banco de México
Course: MongoDB for Administrators
El contenido del curso
Daniela Valdez, Banco de México
Course: MongoDB for Administrators
Kamil was excellent at explaining even the difficult topics in a way that I understood them straight away. The presentation and delivery were both clear and methodical, and the teacher passionate about the subject.
Mark Novak - Kiloo
Course: MongoDB for Advanced Users
It was very flexible and adapted to our expectations and skill level
Raúl Alberto Canales Requena - Kiloo
Course: MongoDB for Advanced Users
the trainer tried to listen to us and encouraged us to ask questions
TransCore
Course: MongoDB for Developers
LIttle to no breaks. At least time is not wasted on breaks.
ST Electronics (Info-Software Systems) Pte Ltd
Course: MongoDB for Developers
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
Communicative, big knowledge and well presented material
Filip Gotowicki - Aneta Tunderska, EY GDS (CS) POLAND SP. Z O.O.
Course: Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
I appreciated Fulvio's wide breadth of knowledge. Not only was he familiar with the course content, but he also knew of constructs in languages we were familiar with to make examples more meaningful to us. During intervals he shared his knowledge of technologies and solutions outside the training scope to provide insights into other solutions we could use in future (and future training).
Raphael Keymer - Markit Valuations Limited
Course: Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012
Being human and talking to us as understandable possible
Sorin - Radu Petrus, np
Course: Database Administration Fundamentals for MS SQL Server
I liked the practical and immediate application of concepts to lectures.
Nordex Energy GmbH
Course: MS SQL Server 2016
Philip was very kind, his style of explaining SQL concepts is outstanding. I liked that he give us information and answered to questions which were not part of this course.
Stefan - Radu Petrus, np
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
Relevance to BigQuery.
Spark44
Course: SQL in SQL Server
Phil was great! He was both patient and knowledgeable. The training went at a good pace, moving a team of mixed SQL abilities through the basics into more advanced SQL querying together. The exercises were an excellent way for us to commit our newly learned skills to memory, and Phil's instructions/class discussions on numerous ways to achieve the same thing were interesting.
Sophie Clement - Thames Water Utilites Ltd
Course: Transact SQL Basic
It felt very relatable. The exercises were well picked out and I was able to work well with it due to clear knowledge provided.
Leah Bayliss - Thames Water Utilites Ltd
Course: Transact SQL Basic
Interactive exercises
Matthew Viner - Thames Water Utilites Ltd
Course: Transact SQL Basic
I like how approachable the trainer is during our activities.
Mark Anthony Geamoga - Romegio Cobatsa, Metrobank
Course: Introduction to SQL Server 2012 Integration Services (SSIS)
The hands-on trainings and wide knowledge of the instructor on the subject.
Teodulo Jr. Templo - Romegio Cobatsa, Metrobank
Course: Introduction to SQL Server 2012 Integration Services (SSIS)
The thorough / hands-on knowledge the trainer has
Pieter Peirs
Course: Introduction to SQL Server 2012 Integration Services (SSIS)
pues lo sencillo de la herramienta
Viviana González Moreno, Seguros Banorte
Course: Business Intelligence with SSAS
Still didn't finished the content
Mahmoud Abdallah Mohamed Hussein, e-finance
Course: MariaDB Database Administration
I mostly enjoyed the knowledge about replication database.
Suparman - Universitas Terbuka
Course: Advanced MariaDB for High Availability and Performance
The trainer has extensive knowledge of IT.
Iwan Susanto - Universitas Terbuka
Course: Advanced MariaDB for High Availability and Performance
all topics are interesting
Stolt Tankers BV
Course: MySQL Database Administration
The exercises done during the training.
Melvin Joseph Manalo - Stolt Tankers BV
Course: MySQL Database Administration
The training exceeded my expectations on what I was hoping to learn.
Ian Matthews - Cision
Course: MySQL Database Administration
Trainer was accommodative. And actually quite encouraging for me to take up the course.
Grace Goh - DBS Bank Ltd
Course: Python in Data Science
the fact that we did a lot of exercises and Philip as an experienced trainer walked us through the answers
Angela - Anca Daescu, Ness
Course: SQL Fundamentals
The structure of the course was perfect for my training style. For the time that we had here i think that the balance between theoretical work and practical work was perfect.
Matei - Anca Daescu, Ness
Course: SQL Fundamentals
tonality, rhythm, good structure
Mihalache Dana - Anca Daescu, Ness
Course: SQL Fundamentals
The course built lesson to lesson, and the pacing was a big deal for me.
Bradford Moore - Regis College
Course: SQL in MySQL
He was very friendly and he created a very good environment.
European Commision, Joint Research Centre
Course: SQL Advanced in MySQL
Exercises from the day 2
Amelia Bontu - OTP BANK ROMANIA S.A.
Course: Oracle SQL Language
the trainer was very helpful , the pace of the training was really good and the exercises weren't too hard, also not too easy. whenever I got stuck he helped me out very well and made sure I understood everything.
Jade Stappaerts - KULeuven
Course: Oracle SQL Language
I like fact, that after each section we had excercises. It helps to remember discused topic.
Adam Bińczycki
Course: Oracle 11g - SQL language for developers - Workshop
good atmosphere during the training
clovis Nebouet
Course: Oracle 11g - SQL language for developers - Workshop
very high competence of the trainer!!
Heino Eilers
Course: Oracle 11g - Programming with PL / SQL I - Workshops
Database Subcategories in New Zealand
Database Course Outlines in New Zealand
- Set up and integrate Node.js and Express with MongoDB.
- Understand the features and architecture of Node.js, Express, and MongoDB.
- Learn how to build RESTful APIs using the Node.js, Express, and MongoDB backend stack.
- Implement routes, filtering, sorting, and pagination to Node.js REST APIs.
- Design data models and perform CRUD operations with MongoDB and Mongoose.
- Test and debug APIs with Postman.
- Install and configure MongoDB for data analysis.
- Understand the concepts and stages of the MongoDB Aggregation Framework.
- Learn about the basic structure, syntax, and operations for aggregation.
- Learn how to handle advanced operations in aggregation.
- Apply some optimization tools and techniques to improve aggregation performance.
- Set up the necessary development environment that integrates FastAPI, React, and MongoDB.
- Understand the key concepts, features, and benefits of the FARM stack.
- Learn how to build REST APIs with FastAPI.
- Learn how to design interactive applications with React.
- Develop, test, and deploy applications (front end and back end) using the FARM stack.
- Create and manage databases, tables, and queries.
- Manage query performance.
- Create and restore database backups.
- Write SQL queries to retrieve, filter, sort, and aggregate data.
- Perform data manipulation operations such as inserting, updating, and deleting data.
- Implement advanced SQL concepts such as subqueries, derived tables, and conditional logic.
- Integrate MySQL with popular programming languages and execute queries from application code.
- Understand the concepts of database security.
- Implement authentication and authorization mechanisms to control access to the database.
- Configure and manage user accounts, roles, and privileges effectively.
- Implement robust security measures against various threats and vulnerabilities.
- Set up the necessary environment to perform data analysis with SQL, Python, and Tableau.
- Understand the key concepts of software integration (data, servers, clients, APIs, endpoints, etc.).
- Get a refresher on the fundamentals of Python and SQL.
- Perform data pre-processing techniques in Python.
- Learn how to connect Python and SQL for data analysis.
- Create insightful data visualizations and charts with Tableau.
- Understand the fundamentals of Presto and its role in big data analytics.
- Gain proficiency in using Presto's COST IT module for cost analysis.
- Optimize Presto queries for improved performance and resource utilization.
- Identify and implement cost-based optimizations in Presto.
- Troubleshoot and resolve common performance and cost-related issues in Presto.
- 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.
- How to build a query?
- What possibilities have SQL?
- What is a relational database?
- What is the structure and SQL commands
- 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
- 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.
- Install and configure MongoDB Ops Manager
- Set up and manage different types of environments
- Understand and implement MongoDB Enterprise Server specific solutions to solve complex enterprise challenges
- Interactive lecture and discussion
- Lots of exercises and practice
- Hands-on implementation in a live-lab environment
- This training is based on MongoDB Enterprise Server, which includes Ops Manager. Please consult with us to arrange license requirements.
- To request a customized training for this course, please contact us to arrange.
- 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
- 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
You will also learn how to find slow queries, monitor database performance and tune PostgreSQL for Performance.
- Integrate React with MongoDB, Express, and Node.js.
- Build a fullstack web application from scratch.
- Implement application security through authorization and authentication.
Last Updated: