Online Database Training in Slovenia

This instructor-led, live training in Slovenia (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 Slovenia (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 Slovenia (online or onsite) is aimed at beginner-level developers and database administrators who wish to learn PL/SQL to automate database tasks, implement business logic, and develop robust database applications.

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

• Develop efficient PL/SQL programs to automate database operations and integrate SQL commands effectively.
• Create reusable program units, including procedures, functions, packages, and triggers, for modular and scalable applications.
• Implement advanced data structures like associative arrays and manage query results using cursors.
• Handle errors robustly and secure code with encryption, obfuscation, and conditional compilation techniques.
• Apply PL/SQL in real-world scenarios, leveraging built-in packages for file handling, email automation, and other advanced functionalities. 

This instructor-led, live training in Slovenia (online or onsite) is aimed at advanced-level Kubernetes administrators and DevOps engineers who wish to enhance their monitoring skills for Kubernetes clusters using Prometheus and Grafana.

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

• Set up Prometheus and Grafana for Kubernetes monitoring.
• Monitor key metrics for pods, nodes, and services.
• Create dynamic dashboards to visualize cluster health and performance.
• Implement alerting strategies for proactive issue resolution.
• Apply best practices for scaling monitoring solutions in Kubernetes environments.

The DP-300T00: Administering Microsoft Azure SQL Solutions certification is a testament to an IT professional's skills in managing and implementing database solutions in the cloud on Microsoft Azure. It validates one’s proficiency in managing Azure SQL Server instances, databases, and usage of T-SQL. This certification is pivotal in industries seeking digital transformation as it ensures that the certified professional can efficiently handle data management, migration, and performance tuning in Azure environments. Obtaining the DP-300T00 certification enhances the recipients' credibility, making them a valuable asset in the IT industry, particularly in roles related to database administration and management.

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.

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.

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 course covers the administration and performance tuning of PostgreSQL databases. 

Target audience includes system administrators and database architects. Attendees will learn the use of specialised PostgreSQL (AKA Postgres) modules such as replication, connection pooling and full text searching.

The training course will help the participants prepare for Web Application Development using Python Programming with Data Analytics. Such data visualization is a great tool for Top Management in decision making.

This training is designed for Database Administrators and Architects who want to tune PostgreSQL Database for Performance. Learn how to log slow workload and find the possible pain points in a query. This topic also covers the most important parameters that must be tuned for optimal performance. 

This training is designed for Database Administrators and Architects who want to learn the tools and techniques for implementing Backups, High Availability and Database Security in PostgreSQL.
You will also learn how to find slow queries, monitor database performance and tune PostgreSQL for Performance.

This training is designed for Database Administrators and Architects who want to learn Streaming Replication in PostgreSQL and how pgpool-II can be used to achieve automatic failovers and setup a highly available PostgreSQL Database Cluster.

• How to build a query?
• What is a relational database?
• What is the structure and SQL commands?

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 SQL training course is for people who want to acquire basic skills to deal with SQL Server Databases. Course will help the members to learn:

• How to work with SQL Server and SQL Server Management Studio.
• Meaning of Databases, SQL and RDBMS etc.
• How to create tables, use DDL, DML and DAL.
• Which are the various RDBMS Packages in the market and how they compare with each other.
• An Introduction to NoSQL and how they are organizations are changing into hybrid databases.

In this instructor-led, live training in Slovenia, participants will learn three different approaches for accessing, analyzing and visualizing data. We start with an introduction to RDMS databases; the focus will be on accessing and querying an Oracle database using the SQL language. Then we look at strategies for accessing an RDMS database programmatically using the Python language. Finally, we look at how to visualize and present data graphically using TIBCO Spotfire. 

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

This instructor-led, live training in Slovenia (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 Slovenia (online or onsite) is aimed at database administrators who wish to learn and use the features of Oracle Database 21c in performing administrative tasks.

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

• Understand the core concepts of Oracle Database 21c administration.
• Understand the Oracle 21c architecture.
• Learn how to perform administration tasks on Oracle 21c.
• Understand the Oracle 21c backup and recovery process.

Audience

• Programmers
• Beginner IT professionals

Format of the course

    Part lecture, part discussion, heavy hands-on practice

• 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 (online or onsite) is aimed at developers who wish to use Firebase to build powerful data-driven mobile or web application. 

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

• Understand the Firebase Web Platform
• Understand how to simplify a database by using Firebase data modeling
• Develop powerful applications that can process real-time data without the need to define detailed database structures.
• Transact data on Firebase
• Perform realtime data synchronization
• Authenticate users with Firebase
• Monitor users

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.
• To learn more about Firebase, please visit: https://firebase.google.com/

In this instructor-led, live training in Slovenia, 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 Slovenia (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 Slovenia (online or onsite) is aimed at web developers who wish to query and update big data with LINQ using C#.

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

• Create and execute LINQ queries.
• Implement advanced libraries for data querying.
• Filter, search, transform, and manipulate local or remote objects.

This instructor-led, live training in Slovenia (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 instructor-led, live training in Slovenia (online or onsite) is aimed at intermediate-level database administrators and IT professionals who wish to optimize the performance of Oracle Database 19c.

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

• Understand Oracle Database 19c performance tuning concepts.
• Use performance management tools effectively.
• Optimize database performance through tuning techniques.
• Troubleshoot and resolve performance issues.

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

About the training
Training on working with SQL language for a selected SQL database server including DML and DDL - updating data and creating database objects. General-purpose training aimed at people involved in active data processing.

Purpose of the training
To familiarize with the terminology and tools necessary for working with a database. To learn the extension of the knowledge of SQL language and its use in everyday work with a database.

What will Sharepoint improve in your work?
You will learn how to retrieve data efficiently. You will shorten data flow paths by skipping CSV, Excel files, etc. You will gain the ability to use the latest analytical tool. You will increase your confidence at work by learning new skills. You will dramatically increase your chances for promotion. You will radically increase the level of your professional competence.

Where will you use the acquired knowledge?
You will increase the efficiency of your work related to creating reports and statements in spreadsheets and BI tools. You will also notice an increase in your comfort in accessing data.

What will you learn?
You will improve information sharing with colleagues. You will be able to create a unified reporting system. Standardization of methods for generating reports and creating statements for analysis will no longer be a problem for you. At the same time, you will move the security of the created analyses to a new higher level.

SSAS (SQL Server Analysis Services), is a Microsoft SQL Server transactional processing (OLAP) and data mining tool for analyzing data across multiple databases, tables or files. The semantic data models provided by SSAS are used by client applications such as Power BI, Excel, Reporting Services, and other data visualization tools.

In this instructor-led, live training (onsite or remote), participants will learn how to use SSAS to analyze large volumes of data in databases and data warehouses.

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

• Install and configure SSAS
• Understand the relationship between SSAS, SSIS, and SSRS
• Apply multidimensional data modeling to extract business insights from data
• Design OLAP (Online Analytical Processing) cubes 
• Query and manipulate multidimensional data using the MDX (Multidimensional Expressions) query language
• Deploy real-world BI solutions using SSAS

Audience

• BI (Business Intelligence) professionals
• Data Analysts
• Database and data warehousing professionals

 
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 the latest version of Microsoft SQL Server and SSAS.
• To request a customized training for this course, please contact us to arrange.