Database Training in Porto

This instructor-led, live training in Porto (online or onsite) is aimed at intermediate-level database administrators and IT professionals who wish to gain practical expertise in installing, configuring, securing, and maintaining Oracle Database 23ai. By the end of this training, participants will be able to:

• Install and configure Oracle Database 23ai.
• Manage database storage, users, and security settings.
• Optimize database performance using AI-driven automation.
• Implement backup and recovery strategies.
• Monitor and troubleshoot database performance issues.

This instructor-led, live training in Porto (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 Porto (online or onsite) is aimed at beginner-level CRM managers who wish to effectively manage and optimize their customer relationship management processes using Oracle's powerful tools and features. By the end of this training, participants will be able to:

• Understand the fundamentals of Oracle Siebel CRM.
• Learn how to configure and manage Siebel applications.
• Gain proficiency in using Siebel tools for customer relationship management.
• Explore advanced features for optimizing CRM processes.
• Develop skills in reporting and analytics for Siebel CRM.

This instructor-led, live training in Porto (online or onsite) is aimed at intermediate-level maintenance personnel who wish to streamline their maintenance processes using Oracle Cloud ERP Fusion. By the end of this training, participants will be able to:

• Understand the core functionalities of the Oracle Maintenance Cloud.
• Implement corrective, preventive, and predictive maintenance strategies.
• Manage maintenance requests, work orders, and schedules efficiently.
• Utilize analytics for maintenance performance and improvement.

This instructor-led, live training in Porto (online or onsite) is aimed at intermediate-level DevOps and SRE professionals who wish to create impactful dashboards and optimize their monitoring practices using Grafana and Prometheus. By the end of this training, participants will be able to:

• Understand best practices for designing effective dashboards.
• Create and configure advanced Grafana dashboard elements.
• Leverage Grafana templating for dynamic and reusable dashboards.
• Implement alerting mechanisms to enhance operational awareness.

This instructor-led, live training in Porto (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 Porto (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 Porto (online or onsite) is aimed at intermediate-level developers and database administrators who wish to use Oracle SQL to design, manage, and optimize database applications and automate tasks efficiently. By the end of this training, participants will be able to:

• Understand Oracle database architecture and manage users, schemas, and permissions.
• Write optimized SQL queries for data retrieval, manipulation, and analysis.
• Use advanced SQL techniques, including joins, subqueries, and hierarchical queries.
• Design and manage database objects like tables, indexes, views, and sequences.

This instructor-led, live training in Porto (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 course covers the advanced areas in the use of programming languages related to MongoDB, the goal is for the participant to have the ability to completely master the tool.

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 T-SQL and other dialects
• practical skills for writing queries

This SQL course deals with Microsoft T-SQL dialect. If you are interested in generic SQL, please see SQL Fundamentals course.

This instructor-led, live training in Porto (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 Porto (online or onsite) is aimed at sysadmins and developers who wish to use PostgreSQL 13 to set up, build, and manage databases for high-performance applications. By the end of this training, participants will be able to:

• Install and configure PostgreSQL 13.
• Understand the features, architecture, and fundamentals of operating, managing, and maintaining databases with PostgreSQL 13.
• Learn how to configure Postgres database tables and schemas.
• Learn how to perform data manipulations and queries.
• Explore the different programming interfaces (client and server) to fully utilize and extend functionalities in PostgreSQL 13.

Listeners This course is designed for people who want to use the advanced features of SQL in Oracle The course answers the questions

• How to build advanced queries?
• How to create advanced reports?

This instructor-led, live training in Porto (online or onsite) is aimed at system administrators and developers who wish to use Prometheus to monitor Kubernetes clusters. By the end of this training, participants will be able to:

• Install and configure Prometheus.
• Monitor dynamic cloud environments.
• Gain better insight into their Kubernetes clusters.
• Set up alerts that are precise and insightful.

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 Porto (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.
• Manage and monitor Oracle databases.
• Optimize Oracle database performance.

This course has been created for delegates already acquainted with SQL in Microsoft SQL Server Environment 2008/2012. The course focuses on set-based querying and query tuning, working with indexes and analyzing execution plans. The training also covers table expressions, ranking functions and how to deal with partitioned tables.

Audience

• Programmers
• Beginner IT professionals

Format of the course     Part lecture, part discussion, heavy hands-on practice

This course is divided into 3 main sections and is made up of a mixture of presentations and practical exercises.

1. VB.NET Language in Visual Studio 2012
2. VB.NET Object Orientation
3. VB.NET and Sql Server 2012

• Created Linux/Unix Administrators and developers who are interested with getting involved in LInux/Unix Servers
• Even beginners, who have the basic skill and knowledge on Linux, can catch up with this course just if you follow the instructor's lab and explanation in detail.
• This course is intended to practice enough Managing Linux Servers and to show it is very easy to understand Linux/Unix servers.
• This course will be delivered to audience with 40% lectures, 50% labs and 10% Q&A. This five-day course strongly emphasizes lab-based activities.
• You'll learn how to deploy and manage Top 4 Linux Servers that provide highly useful network services to a mission-critical enterprise environment.
• It can be deliver on any distribution (Fedora, CentOS are commonly used)

This instructor-led, live training in Porto (online or onsite) is aimed at database administrators and developers who wish to install, configure, and manage Flyway to track and apply changes in their continuous database delivery efforts. By the end of this training, participants will be able to implement, track, reverse, and manage database workflows and changes to improve their continuous database delivery.

In this instructor-led, live training in Porto, participants will learn the fundamentals of GraphQL as they step through the creation of a simple API with GraphQL. By the end of this training, participants will be able to:

• Understand what GraphQL is and what distinguishes it from REST.
• Understand top-level GraphQL terms.
• Set up a GraphQL coding environment.
• Build and improve a GraphQL API.

This instructor-led, live training in Porto (online or onsite) is aimed at engineers who wish to use JanusGraph to process very large graphs that require abnormal storage and computational capacity. By the end of this training, participants will be able to:

• Install and configure JanusGraph.
• Integrate JanusGraph with multiple backend storage systems (Cassandra, HBase, etc.) and multiple indexing software (Elasticsearch, Solr, etc.). 
• Configure multiples machines into a cluster for use by JanusGraph.
• Query the database using the Gremlin query language.
• Process graph data at scale, beyond what a single machine can provide.
• Support thousands of concurrent users traversing graph data in real time.
• Query graph data for analysis.

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

MySQL Administration training course is for anyone who wants to administrate the MySQL database server. It is a comprehensive course covering all administrator duties. The course explains how MySQL Database works, what tools are available, how we can use them, how we can secure the MySQL Database Server and configure it. During the training course you will learn how to manage user accounts and how the MySQL Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery.

This instructor-led, live training in Porto (online or onsite) is aimed at engineers who wish to migrate from Oracle Forms to Oracle Web Forms. By the end of this training, participants will be able to:

• Understand the major feature and architectural changes in Oracle Web Forms.
• Migrate to Oracle Web Forms from a previous Forms version.
• ***Deploy Oracle Web Forms in cloud or on premise.
• Leverage Oracle Web Forms to enhance user services and experience.

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

Oracle 11g is a version of Oracle's database that was released in 2007. Jest is a relational database management system that offers a wide range of features and tools for storing, managing and analyzing data. The "g" in the name stands for "grid computing" - an approach to managing IT resources. Oracle 11g offers a number of improvements over previous versions, including improved memory management, improved performance, additional security features, expanded language programming capabilities PL/SQL, and new administration tools. This version was widely used in many organizations before subsequent updates and releases of Oracle. However, it is worth noting that since the release of Oracle 11g, Oracle has released subsequent versions of its database management system, including 12c, 18c and 19c, with various improvements and new features.