Database Training in Slovenia

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

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

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.

The training is intended for people who work with databases as programmers using the SQL language and need to extend the possibilities of work with the mechanisms of the procedural language.

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

The Oracle SQL Fundamentals training course is a comprehensive program designed to equip participants with essential skills and knowledge in Structured Query Language (SQL) using Oracle Database.

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

• Gain proficiency in writing SQL queries to retrieve and manipulate data in Oracle databases.
• Acquire essential skills in joining tables and handling complex data relationships.
• Understand how to use functions effectively for data manipulation and calculation.
• Master the art of writing efficient sub-queries to perform advanced data filtering and processing
• Gain confidence to work with Oracle SQL in real-world scenarios, enhancing their career prospects in database management and development.

This instructor-led, live training (online or onsite) is aimed at intermediate to advanced level users who wish to use learn more about SQL.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

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

redis

nosql