Database Training in Portugal

This instructor-led, live training in Portugal (online or onsite) is aimed at beginner-level customer service managers who wish to effectively manage and optimize their customer service operations using Oracle's powerful tools and features.

By the end of this training, participants will be able to:

• Understand the fundamentals of Oracle Service Management.
• Learn how to configure and manage service requests.
• Gain proficiency in using Oracle Service Cloud for customer service operations.
• Explore advanced features for optimizing service delivery.
• Develop skills in reporting and analytics for service management.

This instructor-led, live training in Portugal (online or onsite) is aimed at beginner-level to intermediate-level data scientists and software developers who wish to learn about Milvus and its practical applications in various AI scenarios.

By the end of this training, participants will be able to:

• Understand the architecture and features of Milvus.
• Implement vector databases in different AI applications.
• Perform similarity searches with high accuracy and speed.
• Apply Milvus to real-world AI challenges.

This instructor-led, live training in Portugal (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 Portugal (online or onsite) is aimed at intermediate-level to advanced-level database administrators who wish to deepen their knowledge of SQL Server for efficient database management, performance tuning, high availability, and advanced troubleshooting.

By the end of this training, participants will be able to:

• Administer and configure SQL Server instances using best practices.
• Optimize performance of queries and databases.
• Implement high availability and disaster recovery strategies.
• Diagnose and resolve complex issues in production environments.A

Greenplum is an open-source massively parallel data platform based on PostgreSQL, designed for advanced analytics and large-scale data warehousing.

This instructor-led, live training (online or onsite) is aimed at intermediate-level administrators who wish to install, configure, and manage Greenplum environments effectively, including managing system updates and libraries.

By the end of this training, participants will be able to:

• Install and configure a production-ready Greenplum cluster.
• Manage system updates and apply patches safely.
• Handle Greenplum library management for analytics and extensions.
• Troubleshoot and monitor Greenplum systems.

Format of the Course

• Interactive lecture and discussion.
• Hands-on use of Greenplum in a controlled lab environment.
• Guided exercises focused on cluster setup, upgrade workflows, and system extensions.

Course Customization Options

• To request a customized training for this course based on your environment or data platform, please contact us to arrange.

SQL Tuning in Oracle Database 19c is the process of improving SQL performance through analysis, statistics, and optimization techniques.

This instructor-led, live training (online or onsite) is aimed at intermediate-level Oracle professionals who wish to understand and apply SQL tuning techniques for Oracle Database 19c to improve query execution and database efficiency.

By the end of this training, participants will be able to:

• Interpret execution plans and identify performance bottlenecks.
• Apply Oracle tuning tools such as AWR, ADDM, and SQL Tuning Advisor.
• Use indexes, hints, and statistics to optimize queries.
• Diagnose and resolve inefficient SQL statements in real-world environments.

Format of the Course

• Interactive lecture and discussion.
• Hands-on use of Oracle tuning tools and SQL queries.
• Guided exercises focused on real tuning scenarios and performance analysis.

Course Customization Options

• To request a customized training for this course based on your system or business queries, please contact us to arrange.

This instructor-led, live training in Portugal (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 Portugal (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 Portugal (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.

This instructor-led, live training in Portugal (online or onsite) is aimed at intermediate-level developers and administrators who wish to leverage the latest features and improvements in PostgreSQL 16.

By the end of this training, participants will be able to:

• Understand the architecture and components of PostgreSQL 16.
• Utilize advanced SQL features and PostgreSQL extensions.
• Implement security best practices and access controls.
• Perform database administration tasks, including backup, recovery, and monitoring.
• Optimize database performance through tuning and indexing strategies.
• Utilize PostgreSQL's built-in tools for high availability and replication.
• Integrate PostgreSQL with modern application development frameworks.

This instructor-led, live training in Portugal (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 developer needs to know to successfully develop applications using MongoDB.

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

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 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.

This instructor-led, live training in Portugal (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.

This instructor-led, live training in Portugal (online or onsite) is aimed at intermediate-level database professionals who wish to enhance their skills in Oracle SQL development and administration.

By the end of this training, participants will be able to:

• Build and optimize complex SQL queries.
• Manage databases efficiently using Oracle SQL tools.
• Apply best practices in database development and maintenance.
• Administer user access and database security in an Oracle environment.

This instructor-led, live training in Portugal (online or onsite) is aimed at database administrators and cloud architects who wish to migrate Oracle databases to Azure SQL or PostgreSQL.

By the end of this training, participants will be able to:

• Compare Azure SQL with PostgreSQL to choose the database that best meets business objectives and needs.
• Prepare databases to move definitions, data, and procedures from Oracle to AzureSQL or PostgreSQL database system.
• Perform post-migration steps to test, optimize, update, and maintain a migrated database.

This instructor-led, live training in Portugal (online or onsite) is aimed at professionals who wish to learn the fundamental concepts of Oracle Fusion and implement Oracle Fusion HCM in their organization.

By the end of this training, participants will be able to:

• Learn and understand the concepts of Oracle Fusion Human Capital Management (HCM).
• Implement complete workforce structure management in any organization.

The course participants will learn the terminology of relational databases, acquire the skills to design database applications, know the basic principles of creating forms and reports.

The course is designed for administrators, developers and database developers.

The objectives of the training:

• acquire and strengthen the skills to create and manage databases
• knowledge of the syntax and use SQL to retrieve and modify data
• apply safety rules in the database
• the use of advanced elements (replication, automation, BI)
• the use of Microsoft SQL Server capabilities to create complex reports and solutions for developers

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 course will introduce Cassandra –  a popular NoSQL database.  It will cover Cassandra principles, architecture and data model.   Students will learn data modeling  in CQL (Cassandra Query Language) in hands-on, interactive labs.  This session also discusses Cassandra internals and some admin topics.

Audience : Developers

Audience

• Programmers
• Beginner IT professionals

Format of the course

    Part lecture, part discussion, heavy hands-on practice

This instructor-led, live training in Portugal (online or onsite) is aimed at administrators who wish to set up Greenplum Database for business intelligence and data warehousing solutions.

By the end of this training, participants will be able to:

• Address processing needs with Greenplum.
• Perform ETL operations for data processing.
• Leverage existing query processing infrastructures.

This instructor-led, live training in Portugal (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 bespoke course has been designed specifically against the requirements provided by Now Managed Learning Services

Relational databases have been the technology of choice for storing, retrieving and querying data. Relational databases allow users to organize their data using a structured, well-defined set of patterns (model). While this approach works well for storing data that is standardized and well-understood in advance (think of a hospital check-in application that holds patient records with the same consistent set of pre-defined fields...patient id, first name, last name, date of last visit, etc.), there are limitations to this model. For organizations whose incoming data is not well-defined (think of an online inquiry form for a startup whose still in the process of experimenting with different fields for collecting visitor data, removing and adding fields as they go to accommodate for the changing nature of the business), any established definitions for how the data should fit into an existing database would need to be re-defined regularly. This would require recreating the data model (schema) that dictates the structure of the data and its allowed data types to support different types of data inputs, etc., before any new data could be saved to the database.

Enter NoSQL (Not Only SQL) databases. NoSQL databases free users from having to predefine the structure of the incoming data, allowing them to insert and update new data on the fly. NoSQL databases are often faster than relational databases and can handle very large amounts of data with ease. NoSQL databases also scale better than relational databases, due to their ability to efficiently partition data across many servers (cluster) and load balance the access to this data. NoSQL databases integrate particularly well with applications that support real-time analytics, site personalization, IoT, and mobile apps

In this instructor-led, live training, participants will understand the architecture, design principles and functionality of the most popular NoSQL databases as they setup, operate and asses a number of NoSQL databases in a live lab environment. The goal of this training is to enable participants to intelligently evaluate, propose and implement a suitable NoSQL database solution within their organization.

By the end of this training, participants will be able to:

• Install and configure different types of NoSQL databases, including MongoDB, Cassandra, Redis and Neo4j
• Understand the benefits and disadvantages of NoSQL databases vs relational databases
• Understand the underlying data formats used by NoSQL databases and how these formats can be used to an advantage when developing modern applications (desktop, mobile, cloud, IoT)
• Perform create, insert, update, delete operations in a NoSQL database
• Setup a mixed environment with both a relational database and NoSQL working in tandem
• Configure a cluster of NoSQL database to distribute the processing of very large datasets
• Understand the security implications of using a NoSQL database
• Deploy and scale a NoSQL database in a production environment

Audience

• Database professionals
• Data architects
• Data strategists
• Project managers
• Application developers wishing to integrate a flexible database solution in their application

Format of the Course

• Part lecture, part discussion, exercises and heavy hands-on practice

Note

• To request a customized training for this course, please contact us to arrange.

This instructor-led, live training in Portugal (online or onsite) is aimed at IT administrators and developers who wish to set up, deploy and manage cloud applications using the services and technologies provided by Oracle PaaS.

By the end of this training, participants will be able to:

• Build, deploy, and manage cloud applications using Oracle PaaS.
• Configure and use data management tools for easy storage and backup.
• Visualize and evaluate application performance and logs.
• Generate business analytics reports.
• Understand and implement security standards.

Redis is an open source (BSD licensed), in-memory data structure store, used as database, cache and message broker.

In this instructor-led, live training in Portugal, 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.

redis

nosql