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 training can be carried out locally on customer premises in Évora or in NobleProg corporate training centers in Évora.
This instructor-led, live training in Évora (online or onsite) is aimed at intermediate-level to advanced-level system administrators and IT professionals who wish to deepen their expertise in Oracle Linux 9 for system administration, performance tuning, security hardening, and automation.
By the end of this training, participants will be able to:
Manage and optimize Oracle Linux 9 for enterprise environments.
Implement advanced networking and security configurations.
Automate system administration tasks using scripting.
Monitor and troubleshoot performance issues effectively.
This instructor-led, live training in Évora (online or onsite) is aimed at advanced-level system administrators who wish to deepen their knowledge in system management, troubleshooting, and performance tuning.
By the end of this training, participants will be able to:
Configure and manage advanced user and group settings, including implementing user quotas and system-wide user environments.
Use security auditing tools and configure sudo for controlled administrative access.
Monitor and optimize system performance.
Configure, analyze, and troubleshoot system logs.
Develop and implement backup and recovery solutions.
This instructor-led, live training in Évora (online or onsite) is aimed at intermediate-level database administrators who wish to manage, optimize, and secure Data Guard environments for robust disaster recovery and high availability.
By the end of this training, participants will be able to:
Understand the architecture and benefits of Oracle Data Guard for disaster recovery and high availability.
Gain hands-on experience in configuring and managing physical and logical standby databases, including Data Guard broker.
Develop practical skills in monitoring, troubleshooting, and optimizing Data Guard environments for optimal performance.
Learn advanced features such as Active Data Guard, Data Guard with RAC, and securing Data Guard communications.
Apply best practices for disaster recovery planning, ensuring data consistency, and automating Data Guard operations.
This instructor-led, live training in Évora (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 Évora (online or onsite) is aimed at beginner-level system administrators and DevOps engineers who wish to develop core monitoring skills using Grafana and Prometheus.
By the end of this training, participants will be able to:
Understand the purpose and importance of monitoring in IT environments.
Install and configure Grafana and Prometheus for basic monitoring tasks.
Create simple dashboards and alerts to visualize system performance.
Apply best practices for monitoring system availability and performance.
This instructor-led, live training in Évora (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 Évora (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 Évora (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 Évora (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:
This instructor-led, live training in Évora (online or onsite) is aimed at beginner-level database administrators and developers who wish to learn SQL to efficiently manage, query, and manipulate data in Oracle databases for administrative and operational tasks.
By the end of this training, participants will be able to:
Understand Oracle database architecture, including schemas, users, and sessions.
Write and optimize SQL queries for data retrieval, filtering, and manipulation.
Use joins, subqueries, and set operators to work with multiple tables and complex queries.
Perform data aggregation, grouping, and analysis using SQL functions.
Manage schema objects like views, sequences, and indexes to enhance database operations.
This instructor-led, live training in Évora (online or onsite) is aimed at intermediate-level developers and administrators who wish to have a solid PL/SQL programming foundation to develop efficient and robust database applications using Oracle 19c.
By the end of this training, participants will be able to:
Gain a comprehensive understanding of what PL/SQL is and its advantages over standard SQL.
Learn how to declare and use variables and different data types within PL/SQL blocks.
Apply control structures like IF-THEN-ELSE, CASE statements, and loops to create robust PL/SQL programs.
Understand and implement explicit and implicit cursors for data retrieval.
Handle exceptions effectively using predefined and user-defined exceptions.
Develop and manage triggers to automate and enforce business rules.
Create and use PL/SQL packages to encapsulate and modularize code for reuse and maintainability.
This instructor-led, live training in Évora (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.
Delegates will gain an understanding of some of the more advanced features of Transact SQL as well as being able to do each of the following:
Use queries to return complex result sets
Manage database objects to aid query performance
Tune queries to perform more efficiently
This course is for anyone who currently uses Transact SQL to extract data from a Microsoft SQL Server database and wishes to expand their knowledge particularly in the areas of data analysis and improving query speed.
This instructor-led, live training in Évora (online or onsite) is aimed at system administrators who wish to learn how to administer, monitor, and support an Oracle database.
By the end of this training, participants will be able to:
Understand the major feature and architectural changes Oracle database.
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 SQL dialects (Oracle, T-SQL, ANSI)
practical skills for writing queries
This SQL course deals with generic ANSI SQL. It can be used in any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL any other relational databases.
The course participants will learn how to speed up the operation of the database, how to write advanced queries, create a convenient system of forms and reporting. The course introduces the participant to automate all operations using macros and VBA.
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.
When traditional storage technologies don't handle the amount of data you need to store there are hundereds of alternatives. This course try to guide the participants what are alternatives for storing and analyzing Big Data and what are theirs pros and cons.
This course is mostly focused on discussion and presentation of solutions, though hands-on exercises are available on demand.
This instructor-led, live training in Évora (online or onsite) is aimed at engineers who wish to enable applications to continuously monitor and stream all commits made to their database.
By the end of this training, participants will be able to:
Install and configure ZooKeeper, Kafka, and the Debezium connector service.
Set up applications to automatically consume and respond to database inserts, updates, and deletes.
Turn database row-level changes into event streams that applications can respond to immediately.
Stream each row-level change in the same order that it was committed to the database.
This instructor-led, live training in Évora (online or onsite) is aimed at database administrators who wish to install, set up, and manage Flyway and its capabilities to perform database migrations.
By the end of this training, participants will be able to clean up, migrate, validate, repair, and monitor databases using Flyway.
This instructor-led, live training in Évora (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.
MariaDB Administration training course is for anyone who wants to administrate the MariaDB database server. It is a comprehensive course covering all administrator duties.
The course explains how MariaDB Database works, what tools are available, how we can use them, how we can secure the MariaDB Database Server and configure it. During the training course you will learn how to manage user accounts and how the MariaDB Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery.
This course is intended for database administrators.
The course presents options for High-Availability solutions using Galera Cluster.
You will learn the basics of Galera technology, as well as more advanced topics and practical knowledge related to configuring, optimizing and administering a Galera Cluster.
This instructor-led, live training in Évora (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.
This intensive training provides the fundamental knowledge and skills to use Windows PowerShell for automating administration of Windows based computers. The skills taught in this course are applicable to all Microsoft products that use Windows PowerShell for daily administration.
Training focuses mainly on using Windows PowerShell as an interactive command line interface however it also includes some coverage of scripting and programming topics.
This instructor-led, live training in Évora (online or onsite) is aimed at system administrators and DevOps engineers who wish to use Prometheus to monitor systems and applications natively or through highly dynamic microservices running in a cloud environment.
By the end of this training, participants will be able to:
Install and configure Prometheus.
Understand the features, architecture, and core concepts of Prometheus.
Learn how to query data using PromQL.
Build visualizations and dashboards with Grafana.
Configure systems monitoring and alerting rules.
Analyze and optimize systems and application performance.
Enable secure integration to remote endpoints and existing systems.
In this instructor-led, live training in Évora, 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.
Integrate SAP ASE with non-SAP ASE applications.
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 Évora, Database training courses in Évora, Weekend Database courses in Évora, Evening Database training in Évora, Database instructor-led in Évora, Database private courses in Évora, Database classes in Évora, Database coaching in Évora, Online Database training in Évora, Database instructor in Évora, Database on-site in Évora, Database boot camp in Évora, Evening Database courses in Évora, Database one on one training in Évora, Weekend Database training in Évora, Database instructor-led in Évora, Database trainer in Évora
