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. Braga onsite live Database trainings can be carried out locally on customer premises or in NobleProg corporate training centers.
NobleProg -- Your Local Training Provider
Hotel Melia Braga
nº8, Avenida General Carrilho da Silva Pinto, nº 8, 4715-380 Braga, Braga, Portugal, 4715-380 Braga
This instructor-led, live training in Braga (online or onsite) is aimed at intermediate-level database administrators who wish to manage and optimize complex, high-availability Oracle database environments.
By the end of this training, participants will be able to:
Gain a comprehensive understanding of Oracle RAC architecture and Grid Infrastructure, including installation, configuration, and management.
Develop practical skills in managing Automatic Storage Management (ASM), including disk group management, instance tuning, and backup/recovery.
Learn advanced RAC performance tuning techniques, disaster recovery configurations, and best practices for high availability.
Acquire troubleshooting and diagnostic skills for resolving issues in RAC and Grid Infrastructure environments.
Understand the process of patching and upgrading Oracle RAC and Grid Infrastructure while minimizing downtime and maintaining system stability.
This instructor-led, live training in Braga (online or onsite) is aimed at beginner-level developers and database administrators who wish to learn PL/SQL to automate database tasks, implement business logic, and develop robust database applications.
By the end of this training, participants will be able to:
Develop efficient PL/SQL programs to automate database operations and integrate SQL commands effectively.
Create reusable program units, including procedures, functions, packages, and triggers, for modular and scalable applications.
Implement advanced data structures like associative arrays and manage query results using cursors.
Handle errors robustly and secure code with encryption, obfuscation, and conditional compilation techniques.
Apply PL/SQL in real-world scenarios, leveraging built-in packages for file handling, email automation, and other advanced functionalities.
This instructor-led, live training in Braga (online or onsite) is aimed at advanced-level DevOps engineers and SREs who wish to manage and scale Prometheus and Grafana for large environments effectively.
By the end of this training, participants will be able to:
Architect Prometheus and Grafana for large-scale and distributed environments.
Optimize Prometheus performance for high-traffic systems.
Configure Grafana for large datasets and complex visualizations.
Implement advanced troubleshooting and scalability strategies.
This instructor-led, live training in Braga (online or onsite) is aimed at advanced-level Kubernetes administrators and DevOps engineers who wish to enhance their monitoring skills for Kubernetes clusters using Prometheus and Grafana.
By the end of this training, participants will be able to:
Set up Prometheus and Grafana for Kubernetes monitoring.
Monitor key metrics for pods, nodes, and services.
Create dynamic dashboards to visualize cluster health and performance.
Implement alerting strategies for proactive issue resolution.
Apply best practices for scaling monitoring solutions in Kubernetes environments.
This instructor-led, live training in Braga (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.
This instructor-led, live training in Braga (online or onsite) is aimed at beginner-level to intermediate-level data scientists and software developers who wish to learn how to apply Pinecone to various AI scenarios, from semantic search to personalization.
By the end of this training, participants will be able to:
Understand the architecture and features of Pinecone.
Implement vector databases in different AI applications.
Perform similarity searches with high accuracy and speed.
This instructor-led, live training in Braga (online or onsite) is aimed at intermediate-level to advanced-level database administrators, network engineers, and IT professionals who wish to optimize database performance, scalability, and reliability using Spine-Leaf architecture with VXLAN.
By the end of this training, participants will be able to:
Understand the Spine-Leaf network topology and its benefits.
Implement VXLAN for scalable and efficient database networking.
Optimize database workloads across distributed data center environments.
Deploy Spine-Leaf architecture in cloud and on-premises data centers.
Enhance network security, redundancy, and fault tolerance for database environments.
Automate network configurations for database management using Python and Ansible.
This instructor-led, live training in Braga (online or onsite) is aimed at intermediate-level database administrators, SQL developers, and data analysts who wish to enhance their SQL skills by mastering the use of Analytic Functions.
By the end of this training, participants will be able to:
Understand the concept and importance of Analytic Functions.
Apply various Analytic Functions to solve complex analytical problems.
Combine Analytic Functions with other SQL features for comprehensive data analysis.
Optimize queries for better performance using Analytic Functions.
This instructor-led, live training in Braga (online or onsite) is aimed at intermediate-level to advanced-level data scientists and machine learning engineers who wish to master the use of vector databases for scalable, high-performance AI applications.
By the end of this training, participants will be able to:
Understand the principles of vector databases.
Learn techniques for creating and managing vector embeddings.
Explore indexing strategies for high-dimensional data.
Develop skills for performing efficient similarity searches.
Apply vector database knowledge to machine learning projects.
This instructor-led, live training in Braga (online or onsite) is aimed at intermediate-level IT professionals who wish to learn how to design, implement, and manage relational databases, and how to query and manipulate data using SQL.
By the end of this training, participants will be able to:
Understand the fundamentals of database design.
Learn to create and manage relational databases.
Gain proficiency in writing SQL queries to retrieve and manipulate data.
Understand advanced SQL concepts and techniques.
Develop skills to optimize and maintain databases.
This instructor-led, live training in Braga (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.
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.
Each delegate will need to perform a series of practical exercises.
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.
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.
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.
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.
This instructor-led, live training in Braga (online or onsite) is aimed at database admins and sysadmins who wish to use PostgreSQL to manage large-scale data while optimizing the database systems for high availability and performance.
By the end of this training, participants will be able to:
Install and configure PostgreSQL.
Understand the features and architecture of PostgreSQL.
Learn how to perform database operations with SQL.
Perform database backup and recovery to prevent data loss.
Configure the server for high availability.
Learn the tools and techniques for high performance tuning.
Explore the external tools for monitoring and observability.
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.
The objective of the course is to enable participants to gain a mastery of how to work with the SQL language in Oracle database for data extraction at intermediate level.
This instructor-led, live training in Braga (online or onsite) is aimed at system administrators who wish to learn how to use and manage an Oracle Linux 8 system.
By the end of this training, participants will be able to:
The Microsoft Access course is an intensive learning of using the database engine, focusing on practical skills. Master table design, creating queries, relationships between them, and effective collaboration with Excel. The course also covers creating forms, reports and automating work using macros.
This instructor-led, live training in Braga (online or onsite) is aimed at database administrators or developers who wish to use Microsoft Azure Cosmos DB to develop and manage highly responsive and low latency applications.
By the end of this training, participants will be able to:
Provision the necessary Cosmos DB resources to start building databases and applications.
Scale application performance and storage by utilizing APIs in Cosmos DB.
Manage database operations and reduce cost by optimizing Cosmos DB resources.
In this instructor-led, live training in Braga, 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 (also known as Graph Analytics) 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.
This instructor-led, live training in Braga (online or onsite) is aimed at database administrators and developers who wish to use Hasura to build, access, and manage databases and applications efficiently with GraphQL.
By the end of this training, participants will be able to:
Set up the necessary development environment to start building databases with Hasura.
Build, run, manage data access and queries on Hasura using GraphQL models.
Secure data access by setting up authentication with JSON Web Tokens and Firebase.
Extend database functions by integrating business logic.
Manage database migrations and metadata effectively on Hasura to prevent data loss.
This instructor-led, live training in Braga (online or onsite) is aimed at system administrators, database administrators, data architects, and developers who wish to install, configure, and manage MarkLogic Server to optimize their database systems.
By the end of this training, participants will be able to implement, develop, manage, and secure their enterprise data and database systems using MarkLogic Server.
In this instructor-led, live training in Braga, participants will learn the fundamentals of SAP ASE (SAP Adaptive Server Enterprise) Database Administration as they step through the creation and deployment of a sample SAP ASE Database System.
By the end of this training, participants will be able to:
Install and configure SAP ASE for data storage as well as transactional operations.
Understand and use SAP ASE components, tools, and utilities.
This instructor-led, live training in Braga (online or onsite) is aimed at beginners, programmers, and database administrators who wish to learn or improve their SQL development skills and knowledge.
By the end of this training, participants will be able to install, create, manage, manipulate, and monitor databases using SQL and database management systems.
Microsoft SQL Server is a relational database management system (RDBMS) for storing and retrieving data.
In this instructor-led, live training (onsite or remote), participants will learn the essentials of the SQL language needed to query a Microsoft SQL Server database.
By the end of this training, participants will be able to:
Install and configure Microsoft SQL Server
Query a Microsoft SQL Server database using Microsoft's Transact-SQL (T-SQL) language
Understand the essentials of database design
Optimize a database through normalization
Use aggregate functions to generate results similar to those of "pivot-tables"
Access Microsoft SQL Server through Excel
Audience
Data analysts
Business Intelligence professionals
Business managers
Excel experts who wish to expand their analysis skill set
Format of the Course
Interactive lecture and discussion
Lots of exercises and practice
Hands-on implementation in a live-lab environment
Course Customization Options
This training is based on the latest version of Microsoft SQL Server
To request a customized training for this course, please contact us to arrange.
Read more...
Last Updated:
Testimonials (25)
Small group, in-person for 3 days,
Annina - Ricardo AG
Course - SQL: Basics to Intermediate
I liked very much the format of the training, hands on, directly in sql developer.
Andreea - OPEN COURSE
Course - Oracle Database 19c PL and Advanced SQL
The exercises were explained very good.
Monica - DB Global Technology
Course - PL/SQL in Oracle 19c
Kamil did a great job. He asked questions to find out what we already knew and what we needed to focus on, and easily adapted the training to our needs.
Susanna - USAF
Course - MongoDB Advanced Administrator
Jose was an engaging trainer, and I appreciate him having to stay awa
Phil - Federal Court of Australia
Course - Prometheus Fundamentals
The way trainer demonstrated everything
Manveen - Tribal Grou[
Course - Developing Applications with Oracle Application Express (APEX)
The quality of training and wealth of experience !
Edvin - Verizon Connect
Course - MySQL Developer
Intresting presentation and excercises
Szymon - Agora SA
Course - Scylla Database
Andres consistently ensures that he addresses all attendee questions and strives to ensure everyone comprehends his teachings. I admire his expertise and proficiency in the subject matter
Ryan - Questronix Corporation
Course - PostgreSQL for Administrators - 3 Days
Being human and talking to us as understandable possible
Sorin
Course - Database Administration Fundamentals for MS SQL Server
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 - Honda Bank GmbH
Course - MERN Fullstack Development
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
Course - SQL in SQL Server
The trainings by our self
Andreas - Diehl
Course - Access Advanced
analytical functions
khusboo dassani - Tech Northwest Skillnet
Course - SQL 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 - Universal-Investment-Gesellschaft mit beschrankter Haftung
Course - Access Intermediate
The training materials.
Mona Dobre - DB Global Technology
Course - SQL Advanced level for Analysts
I learned complex functions and how to apply them
Ana Alexandrescu - DB Global Technology
Course - Oracle SQL Advanced
Practical exercises for practice and understanding of the concept, clarification provided for any questions.
Safdar Abbas - Medtech Limited
Course - T-SQL Fundamentals with SQL Server Training Course
Was carefully tailored to our needs, very responsive to live questions and situations, gave us lots of practice repeating what we were learning.
Colin - Drax
Course - MySQL Administration
Great comunication, Łukasz explained everything in easy and understandable way
Tomasz Wojciechowski - GP Strategies Poland sp. z o.o.
Course - ORACLE SQL Fundamentals
Ahmed has been very cooperative and knowledgeable about the subject and throughout been a good and productive training session covering some basic and important topics on Postgres.
Imran Sadiq Bhat
Course - PostgreSQL Essentials
It was quite hands-on, not too much theory.
David Lambaerts - Estee Lauder BV
Course - ORACLE PL/SQL Fundamentals
It allowed us to have an applied hands on sproc to our company database.
Corneliu Buculei - Standard Building Supplies Ltd
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
Trainer was accommodative. And actually quite encouraging for me to take up the course.
Grace Goh - DBS Bank Ltd
Course - Python in Data Science
Provisional Upcoming Courses (Contact Us For More Information)
Online Database training in Braga, Database training courses in Braga, Weekend Database courses in Braga, Evening Database training in Braga, Database instructor-led in Braga, Online Database training in Braga, Database private courses in Braga, Database classes in Braga, Database one on one training in Braga, Evening Database courses in Braga, Database instructor in Braga, Database trainer in Braga, Database instructor-led in Braga, Database boot camp in Braga, Database coaching in Braga, Database on-site in Braga, Weekend Database training in Braga
