
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. Onsite live Database trainings in the US can be carried out locally on customer premises or in NobleProg corporate training centers.
NobleProg -- Your Local Training Provider
Testimonials
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
The course built lesson to lesson, and the pacing was a big deal for me.
Bradford Moore - Regis College
Course: SQL in MySQL
The pace was excellent. It seemed custom made for me ... loved it!
Varnie Karmo - Indiana Legislative Services Agency
Course: PostgreSQL for Developers
Michal was very knowledgable and engaging as a teacher.
Nate Clifton - NIIT (USA) Inc.
Course: PostgreSQL Advanced DBA
Michal is a knowledgeable and experienced trainer. It's good to have trainers who have industry experience. I also liked the hands-on exercises with remote VMs.
NIIT (USA) Inc.
Course: PostgreSQL Advanced DBA
I liked that he was able to talk me through each of the exercises and explain the reasoning behind each component of the queries
Erik McConnon - Quality Resource Group
Course: SQL in One Day
The broad coverage of the subjects
Roche
Course: Big Data Storage Solution - NoSQL
Good knowledge of base subject, thanks. Clear presentation.
AXWAY INC
Course: Cassandra Administration
Quite Interactive with trainer and Hands-on training
Paresh Kumar Giri - The Raymond Corporation
Course: Redis for Developers and System Administrators
It provided a basic idea of how Redis worked.
Ben Lake - The Raymond Corporation
Course: Redis for Developers and System Administrators
The overview covered a nice breadth and depth of information. Personally, I'm not opposed to the hands-off style, as it's what I'm comfortable with from college (relatively short lectures & a good balance of exercises).
The Raymond Corporation
Course: Redis for Developers and System Administrators
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
Database Subcategories
Database Course Outlines
- 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: