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. Macao 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
The own working, it helps a lot I think.
Krisztina BALOGH, Diehl
Course: Access Advanced
The trainer let us ask regarding our issues with our current projects. He explained really well what kind of approach we should choose.
Krisztina BALOGH, Diehl
Course: Access Advanced
perfect level of knowledge transfair
Pascal - Krisztina BALOGH, Diehl
Course: Access Advanced
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
Our group was not that big so every time we asked a question we received an extensive answer with examples. So everything was well explained and it can be noticed that trainer has a great knowledge.
Iwona - Iwona Domagała, Universal-Investment-Gesellschaft mit beschränkter Haftung
Course: Access Intermediate
complex introduction to queries, relationships. Useful tips in term of further using of Access as well as Access connection with different tools
Iwona Domagała, Universal-Investment-Gesellschaft mit beschränkter Haftung
Course: Access Intermediate
Trainer has very broad knowledge, not only related to access. Impressive :)
Iwona Domagała, Universal-Investment-Gesellschaft mit beschränkter Haftung
Course: Access Intermediate
starting from scratch and go further and further.
Iwona Domagała, Universal-Investment-Gesellschaft mit beschränkter Haftung
Course: Access Intermediate
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
IF ANYBODY HAD A PROBLEM, TRAINER ALWAYS HELPES
ANNA JAGIEŁKA
Course: Access Basics
The training started for the early beginners, so everybody could get to know what all is about.
Amanda Dzida
Course: Access - podstawy
I like very much the course
Miguel Angel Miranda Hernandez - Gabriela Fernandez Olvera, ENGINEERING AND SERVICES JF S.A. DE C.V.
Course: MongoDB for Administrators
El curso es muy completo, el instructor tiene muy buen domino del tema, felicidades, todo muy bueno.
Christian - Gabriela Fernandez Olvera, ENGINEERING AND SERVICES JF S.A. DE C.V.
Course: MongoDB for Administrators
Replica Set
RICARDO VILLEGAS MARTINEZ - Gabriela Fernandez Olvera, ENGINEERING AND SERVICES JF S.A. DE C.V.
Course: MongoDB for Administrators
la maquina vistual que se utilizo ahorra mucho tiempo y en general el contenido del curso fue adecuado y preciso
Emmy - Gabriela Fernandez Olvera, ENGINEERING AND SERVICES JF S.A. DE C.V.
Course: MongoDB for Administrators
Que se compartieron los Link Complementarios al curso
Manuel De L Barra - Jorge Vera, Redbanc
Course: MongoDB for Administrators
I had the good fortune to have one-on-one training with Jose. He built rapport well, got straight into the coursework, answered my questions well, and stepped outside of the agenda to demonstrate things relevant to the questions I was asking. He also extended the practical exercises with some more complex ones.
Aaron - Hayley S, Attorney General's Department
Course: MongoDB for Administrators
la resolución de problemas y la flexibilidad de la tecnología
hiram chavez - LUIS FERNANDO GUERRERO, Datavision Digital S.A. de C.V.
Course: MongoDB for Administrators
I learned many new things and terms
José Ernesto Cruz Pineda - LUIS FERNANDO GUERRERO, Datavision Digital S.A. de C.V.
Course: MongoDB for Administrators
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
Practical use cases showed on examples.
Adrian Czok, Hostersi sp. z o.o.
Course: MongoDB for Developers
Good content, and very easy to understand and follow along with the trainer who was very pedagogic
Fredrik Andersson - Magnus Angermund, Högskolan i Gävle
Course: MongoDB for Developers
The technical knowledge and the fact that he approach the NoSql technology and not only MongoDB perspective.
Siemens S.A.
Course: MongoDB for Developers
The deep dive in the technical topics.
Nuno Cruz - Siemens S.A.
Course: MongoDB for Developers
The architecture concepts and the way that using a NoSQL should be approached
Siemens S.A.
Course: MongoDB for Developers
Trainers patience to listen and answer our questions which is highly appreciated.
Elango Muthu - TransCore
Course: MongoDB for Developers
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
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
That we had a virtual environment to work on
epic ltd
Course: MongoDB for Analysts
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
He asked each individual about their thoughts and feedback. Very good knowledge of SQL.
Krisztina BALOGH, Diehl
Course: Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
Lot of content and exactly the requested one.
Pascal - Krisztina BALOGH, Diehl
Course: Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
The trainer had a high level of Expertise and could answer all upcoming questions
Krisztina BALOGH, Diehl
Course: Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
The effort it took for the trainer to prepare for the training
Krisztina BALOGH, Diehl
Course: Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
There were a lot of exercises really good exercises and the trainer passed on his knowledge well.
Zsolt - Krisztina BALOGH, Diehl
Course: Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
The excercises, because we do it together, and the trainer explained it.
Krisztina BALOGH, Diehl
Course: Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
Pace of training, explanations of tasks. Generally really good training.
Aneta Tunderska, EY GDS (CS) POLAND SP. Z O.O.
Course: Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
Trainer style and knowledge
Aneta Tunderska, EY GDS (CS) POLAND SP. Z O.O.
Course: Advanced SQL, Stored Procedures and Triggers for 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
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
Database Subcategories in Macao
Database Course Outlines in Macao
Course Name
Duration
Overview
Course Name
Duration
Overview
14 hours
This instructor-led, live training in Macao (online or onsite) is aimed at developers who wish to use and integrate Node.js, Express, and MongoDB to build fast and scalable REST APIs.
By the end of this training, participants will be able to:
- 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.
14 hours
This instructor-led, live training in Macao (online or onsite) is aimed at data analysts and data scientists who wish to use the MongoDB Aggregation Framework to perform data analysis while simplifying complex operations and aggregation pipelines.
By the end of this training, participants will be able to:
- 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.
14 hours
This instructor-led, live training in Macao (online or onsite) is aimed at developers who wish to use the FARM (FastAPI, React, and MongoDB) stack to build dynamic, high-performance, and scalable web applications.
By the end of this training, participants will be able to:
- 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.
14 hours
This instructor-led, live training in Macao (online or onsite) is aimed at advanced-level database administrators who wish to learn how to configure and manage data workload on databases.
By the end of this training, participants will be able to:
- Create and manage databases, tables, and queries.
- Manage query performance.
- Create and restore database backups.
21 hours
This instructor-led, live training in Macao (online or onsite) is aimed at advanced-level developers who wish to learn and use MySQL and database technologies for building web applications.
By the end of this training, participants will be able to:
- 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.
21 hours
This instructor-led, live training in Macao (online or onsite) is aimed at system administrators who wish to have a comprehensive understanding of the security features of Oracle Database 19c.
By the end of this training, participants will be able to:
- 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.
14 hours
This instructor-led, live training in Macao (online or onsite) is aimed at data scientists and developers who wish to use and integrate SQL, Python, and Tableau to perform complex data analysis, processing, and visualization.
By the end of this training, participants will be able to:
- 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.
14 hours
This instructor-led, live training in Macao (online or onsite) is aimed at intermediate-level data scientists who wish to learn how to utilize the COST IT module of Presto for cost analysis.
By the end of this training, participants will be able to:
- 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.
14 hours
This course covers everything a database administrator needs to know to successfully deploy and maintain MongoDB databases.
Diagnosing performance issues, importing and exporting data, and establishing the proper backup and restore routines, overview of the MongoDB CRUD API, the command shell, and the drivers are also covered.
The audience of this course include people who want to:
- Understand MongoDB from a developer's perspective, including its command shell, query API, and driver tools.
- Deploy MongoDB in all its configurations - as a single server, with master/slave replication, as a replica set, and as a sharded cluster.
- Evaluate applications and choose hardware appropriately.
- Monitor MongoDB instances and integrate with standard monitoring software (Munin, Nagios, etc.)
- Plan for backups and manage large data imports and exports.
- Troubleshoot the most common developer issues and failure scenarios.
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.
14 hours
This course covers everything a database developer needs to know to successfully develop applications using MongoDB.
21 hours
Listeners
This training is addressed for people starting to work with the SQL language in Oracle database
The course answer for questions:
- How to build a query?
- What possibilities have SQL?
- What is a relational database?
- What is the structure and SQL commands
28 hours
This course handles the administration and performance tuning of PostgreSQL databases. Attendees will learn the use of specialised PostgreSQL (AKA Postgres) modules such as replication, connection pooling and full text searching.
14 hours
After the training, you will be able to write extract and modify the data in MongoDB database. You will also learn about powerful Aggregation Pipeline that is a flexible and fast tool for data analytics, and if it's not enough for you, how to connect your current BI tools like Tableau or Excel to data stored in Mongo.
14 hours
This 2 day course gives an introduction to SQL Developer, SQL*Plus and to SQL, the Structured Query Language used to access a Relational Database and includes the new features of the latest version of ORACLE. The principles learnt may also be applied to databases as diverse as Microsoft SQL Server, MySQL, Access, Informix and DB2.
The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core elements.
Full course notes are provided along with sample database files, example SQL files and free software tools for use in accessing an ORACLE database.
14 hours
This course provides programmatic interaction with PostgreSQL databases. Learn techniques, syntaxes and structures needed to develop quality applications using PostgreSQL backend. This training also covers SQL Tuning covering best practices for writing efficient SQL.
Target audience includes developers who want to use or extend PostgreSQL, as well as database architects.
21 hours
This 3 day course gives an introduction to ORACLE PL/SQL, an application development environment that enables the writing of stored procedures, functions and triggers using both SQL and PL/SQL commands.
The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core elements.
Full course notes are provided along with sample database files, example SQL files and free software tools for use in accessing an ORACLE database.
14 hours
This training is designed for Database Administrators and Architects who want to learn PostgreSQL from basics.
You will learn PostgreSQL architecture, installation, designing as well as how to perform backup and recovery databases in PostgreSQL.
14 hours
This SQL training course is for people who want to gain the necessary skills to extract and analyse data using Microsoft Access. Course members will learn:
- how to write SQL queries
- what relational databases are and how we can use them
- what are relations and how to create them
- the structure of data
- differences between SQL dialects (Oracle, T-SQL, ANSI)
- practical skills for writing queries
14 hours
This course covers the advanced areas in the use of programming languages related to MongoDB, the goal is for the participant to have the ability to completely master the tool.
35 hours
The training course will help the participants prepare for Web Application Development using Python Programming with Data Analytics. Such data visualization is a great tool for Top Management in decision making.
35 hours
In this instructor-led, live training in Macao (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.
14 hours
This instructor-led, live training (online or onsite) is aimed at administrators wishing to solve complex deployment and management problems using MongoDB Ops Manager.
By the end of this training, participants will be able to:
- 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.
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
14 hours
This training is designed for Database Administrators and Architects who want to tune PostgreSQL Database for Performance. Learn how to log slow workload and find the possible pain points in a query. This topic also covers the most important parameters that must be tuned for optimal performance.
7 hours
Percona Server for MongoDB is a free, enhanced, fully compatible, open source, drop-in replacement for MongoDB 3.2 Community Edition with enterprise-grade features. It requires no changes to MongoDB applications or code.
Audience
This course is suitable for sysadmins and engineers seeking to switch to Percona Server from preexisting MongoDB instances, or deploy and administrate new Percona Server for MongoDB instances.
After completing this course, delegates will:
- understand Percona Server’s structure and deployment mechanisms
- be able to carry out installation / production environment / architecture tasks and configuration
- be able to assess code quality, perform debugging, monitoring
- be able to implement advanced production like replication, performance tuning and logging
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
14 hours
This training is designed for Database Administrators and Architects who want to learn the tools and techniques for implementing Backups, High Availability and Database Security in PostgreSQL.
You will also learn how to find slow queries, monitor database performance and tune PostgreSQL for Performance.
You will also learn how to find slow queries, monitor database performance and tune PostgreSQL for Performance.
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.
14 hours
This instructor-led, live training in Macao (online or onsite) is aimed at web developers who wish to use the MERN Stack for fullstack development.
By the end of this training, participants will be able to:
- Integrate React with MongoDB, Express, and Node.js.
- Build a fullstack web application from scratch.
- Implement application security through authorization and authentication.
Last Updated:
Other regions in Macao
Other countries
Consulting in Macao
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
