
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. Singapore onsite live Database trainings can be carried out locally on customer premises or in NobleProg corporate training centers.
NobleProg -- Your Local Training Provider
Testimonials
LIttle to no breaks. At least time is not wasted on breaks.
ST Electronics (Info-Software Systems) Pte Ltd
Course: MongoDB for Developers
All the various ways Darius explained concepts and then put them into our database tables.
James Rodi - Charlotte Perry, Medtech Limited
Course: T-SQL Fundamentals with SQL Server Training Course
Practical exercises for practice and understanding of the concept, clarification provided for any questions.
Safdar Abbas - Charlotte Perry, Medtech Limited
Course: T-SQL Fundamentals with SQL Server Training Course
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
Trainer was accommodative. And actually quite encouraging for me to take up the course.
Grace Goh - DBS Bank Ltd
Course: Python in Data Science
I liked the trainer Michal a lot - he had a good clear voice - which made it easier to understand the complicated subject matter.
Services Australia
Course: PostgreSQL for Developers
The thing I liked most was the audience engagement, getting the participants to work through the examples whilst everyone else follows along.
Services Australia
Course: PostgreSQL for Developers
Learning new things that I didn't know before
Nicholas Johnson - Services Australia
Course: PostgreSQL for Developers
Michal was really helpful when people had problems and no one was left behind in the exercises.
Elvin Kennedy - Services Australia
Course: PostgreSQL for Developers
Learning new topics
Services Australia
Course: PostgreSQL for Developers
There was no one thing that stood out, it was all pretty good. The occasional non-English word appearing in the slides - I assume that the original was in Polish - I found amusing.
Services Australia
Course: PostgreSQL for Developers
Training was well paced, engaging, and informative.
Matthew Sohar - Services Australia
Course: PostgreSQL for Developers
Optimizing queries and foreign data wrapping.
Sebastian Khor - Services Australia
Course: PostgreSQL for Developers
Well organized lectures and pacing was good.
Synetek Systems Pty Ltd
Course: PostgreSQL for Developers
Trainer was very helpful and style of doing exercises together was great
Mark Wyatt - Services Australia
Course: PostgreSQL Essentials
I liked Michal's approach to ensuring that everyone was involved on exercises. Obviouslyi this would present challenges given the remote training scenario, but I think he did this in a far more effective manner than other trainers I've had recently on other courses.
Services Australia
Course: PostgreSQL Essentials
The trainer scribbling on the pages to provide extra illustration, making the learning easier. It is unusual but effective.
Services Australia
Course: PostgreSQL Essentials
The hands on practical parts of the training were engaging, I tended to lose a little interest if there was too much talking.
Bob Burt - Services Australia
Course: PostgreSQL Essentials
I liked that we got hands on experience with exercises in the Virtual Desktop, rather than just purely listening to a presentation. The trainer was great - very understanding and helpful when one of us was lost.
Cruise Speck - Services Australia
Course: PostgreSQL Essentials
the pace and the knowledge of the trainer.
Ashneet Maharaj, Auckland Council
Course: PostgreSQL Advanced DBA
interactive (participation) and checking with audience on what to cover the entire time
Ashneet Maharaj, Auckland Council
Course: PostgreSQL Advanced DBA
The way it was presented Getting "under the hood" information on Postgres. The topics on vacuum, backups and replication were very useful.
Greg Albrecht - Ashneet Maharaj, Auckland Council
Course: PostgreSQL Advanced DBA
Really well organised and managed by Michal.
Services Australia
Course: PostgreSQL Performance Tuning
Course focus on more coding than theory.
Services Australia
Course: PostgreSQL Performance Tuning
Database Subcategories in Singapore
Database Course Outlines in Singapore
- 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: