Database Training in Ljubljana

This instructor-led, live training in Ljubljana (online or onsite) is aimed at intermediate-level system administrators who wish to effectively manage Oracle Linux Virtualization environments.

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

• Install and configure Oracle Linux Virtualization Manager and its associated components on a physical or virtual environment.
• Create, configure, and manage virtual machines (VMs) using OLVM.
• Set up virtual networks, VLANs, and manage network interfaces for virtual machines.
• Apply resource management techniques and performance tuning for both VMs and hosts.
• Diagnose and resolve common issues in virtualized environments using OLVM diagnostic tools and logs.

This instructor-led, live training in Ljubljana (online or onsite) is aimed at beginner-level database administrators who wish to ensure that they are well-prepared to manage and optimize their Oracle environments.

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

• Understand the key features and architecture of Oracle Database 19c, including system requirements and installation methods.
• Gain practical skills in installing Oracle Database 19c and Oracle Grid Infrastructure, including configuring the network, storage, and security settings.
• Learn the complete process of upgrading to Oracle Database 19c, from pre-upgrade planning to post-upgrade validation.
• Develop troubleshooting skills to handle common issues during installation and upgrade.
• Apply best practices for Oracle Database installation and upgrade to ensure a smooth and successful deployment.

This instructor-led, live training in Ljubljana (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 Ljubljana (online or onsite) is aimed at intermediate-level developers who wish to use Oracle Visual Builder Studio to create and manage visual applications effectively.

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

• Create and design visual applications using Oracle Visual Builder Studio.
• Utilize pages, components, and flows to build user interfaces.
• Implement data binding and integrate with various data sources.
• Deploy applications to Oracle Cloud and manage environments.

This instructor-led, live training in Ljubljana (online or onsite) is aimed at intermediate-level database administrators who wish to learn the necessary skills and knowledge to effectively manage and administer SQL Server databases using SQL Server Management Studio.

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

• Understand system requirements and perform installations.
• Create, configure, and manage databases using SSMS.
• Manage logins, users, roles, and permissions.
• Perform various types of backups and restore databases.
• Create, schedule, and manage jobs using SQL Server Agent.
• Implement best practices for efficient and secure SQL Server administration.

This instructor-led, live training in Ljubljana equips advanced DevOps professionals and database engineers to implement PostgresAI at enterprise scale. Participants will master database cloning, AI-driven query optimization, and monitoring using hands-on exercises in a live-lab environment.

This instructor-led, live training in Ljubljana (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 Ljubljana (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 Ljubljana (online or onsite) is aimed at beginner-level professionals who wish to learn how to use PostgreSQL for creating databases, writing SQL queries, manipulating data, and managing tables using both SQL commands and PGAdmin. The course also provides a basic introduction to the Timescale extension for time-series data.

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

• Understand relational database principles and PostgreSQL architecture.
• Install, configure, and navigate PostgreSQL and PGAdmin.
• Write and run SQL queries for data selection, filtering, grouping, and joining.
• Manipulate data with SQL statements and manage database objects.
• Create and manage views and explore PostgreSQL extensions like Timescale.

This instructor-led, live training in Ljubljana (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 Ljubljana (online or onsite) is aimed at beginner-level software developers and database administrators who wish to learn the basics of vector databases, including their structure, operation, and use cases.

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

• Understand the concept and purpose of vector databases.
• Recognize the differences between vector and traditional databases.
• Learn basic techniques for creating and managing vector data.
• Perform simple similarity searches.
• Appreciate the role of vector databases in AI applications.

This course provides the essential knowledge required to install, configure, and manage PostgreSQL databases effectively. Participants will learn how to handle user security, perform backups and restores, manage logs, and tune basic parameters. Through practical exercises, learners will perform real-world administration tasks and prepare for advanced topics such as performance and replication.

The training is addressed to data analysts and users who need to flexibly and efficiently extract data from the database using SQL commands directly. It is a complement to the ORA_SA1 training and focuses on the efficiency of executing SQL statements and on scenarios in which the SELECT command alone is not enough and one should use the much more powerful PL/SQL language.

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

• Configure passwordless authentication.
• Administer user and group accounts.
• Configure network interface.
• Monitor and troubleshoot Oracle Linux.

This instructor-led, live training in Ljubljana (online or onsite) is aimed at intermediate-level database administrators and IT professionals who wish to implement and manage ASM solutions in Oracle Database 19c.

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

• Administer and manage ASM instances and disk groups.
• Implement and manage ACFS (Automatic Storage Management Cluster File System).
• Perform client database failover with Flex ASM.
• Troubleshoot and resolve common ASM-related issues.

CockroachDB is an open-source distributed SQL database designed for resilience and data locality. It replaces proprietary global databases like Google Spanner while keeping full infrastructure control. This instructor-led, live training (online or onsite) is aimed at advanced database engineers and architects who wish to use CockroachDB to replace proprietary global SQL databases.

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

This instructor-led, live training in Ljubljana (online or onsite) is aimed at database administrators and developers who wish to migrate from proprietary databases to open source PostgreSQL.

By the end of this training, participants will be able to assess database migration readiness, plan and execute schema migration strategies, migrate data using appropriate tools, and handle application code conversion.