Database Training in Ljubljana

This instructor-led, live training in Ljubljana (online or onsite) is aimed at beginner-level to intermediate-level IT professionals and Linux users who wish to gain a solid understanding of Oracle Linux 9, from installation and configuration to system administration and security.

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

• Install and configure Oracle Linux 9.
• Manage users, groups, and permissions.
• Work with package management and system updates.
• Configure networking and storage solutions.
• Implement security best practices.
• Automate tasks using shell scripting.

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 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 Ljubljana (online or onsite) is aimed at intermediate-level billing and revenue managers who wish to effectively manage and optimize their billing and revenue operations using Oracle's powerful tools and features.

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

• Understand the fundamentals of Oracle communications billing and revenue management (BRM).
• Learn how to configure and manage billing processes.
• Gain proficiency in using Oracle BRM for revenue management.
• Explore advanced features for optimizing billing and revenue operations.
• Develop skills in reporting and analytics for billing and revenue management.

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 Ljubljana (online or onsite) is aimed at beginner-level IT professionals and DevOps practitioners who wish to learn the basics of Grafana and Prometheus.

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

• Understand the purpose and key features of Grafana and Prometheus.
• Install and configure Grafana and Prometheus on a Linux environment.
• Set up basic data sources and dashboards in Grafana.
• Monitor system metrics and visualize data using Prometheus.

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

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.

Level
Advanced
Form
Lecture, Presentation, Intensive workshop
Purpose of the training
The training is addressed to data analysts and users who need to efficiently and flexibly extract data from the database using SQL language commands directly. It complements the ORA-SA1 training with advanced SQL language mechanisms.
Benefits of completing the training
Learn advanced data analysis techniques using SQL language for more flexible and efficient reporting.

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.

The training is intended for programmers who know the basics of SQL and PL/SQL, but want to learn more advanced mechanisms of the language, and want to create database applications based on stored PL/SQL programs.

Percona Server for MongoDB is a free, enhanced, fully compatible, open source, drop-in replacement for MongoDB 3.2 Community Edition with enterprise-grade features. It requires no changes to MongoDB applications or code.

Audience

This course is suitable for sysadmins and engineers seeking to switch to Percona Server from preexisting MongoDB instances, or deploy and administrate new Percona Server for MongoDB instances.

After completing this course, delegates will:

• understand Percona Server’s structure and deployment mechanisms
• be able to carry out installation / production environment / architecture tasks and configuration
• be able to assess code quality, perform debugging, monitoring
• be able to implement advanced production like replication, performance tuning and logging

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.

This instructor-led, live training in Ljubljana (online or onsite) is aimed at developers and administrators who wish to use PostgreSQL with Python to build secure, reliable, and stable applications at scale.

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

• Install, configure, and connect PostgreSQL with Python.
• Get a refresher on Python programming fundamentals.
• Understand the benefits of using PostgreSQL with Python.
• Learn how to perform basic SQL operations with Python.
• Learn how to use the advanced PostgreSQL features with Python.
• Implement data safety, security, monitoring, and optimization techniques.

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.

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 training discusses issues related to programming in Visual Basic for Applications and presents ways of accessing data using VBA. The training participants also learn the mechanisms that allow them to write a professional database application.

When traditional storage technologies don't handle the amount of data you need to store there are hundereds of alternatives. This course try to guide the participants what are alternatives for storing and analyzing Big Data and what are theirs pros and cons.

This course is mostly focused on discussion and presentation of solutions, though hands-on exercises are available on demand.

Audience

• Programmers
• Beginner IT professionals

Format of the course

    Part lecture, part discussion, heavy hands-on practice

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

MariaDB Administration training course is for anyone who wants to administrate the MariaDB database server. It is a comprehensive course covering all administrator duties.

The course explains how MariaDB Database works, what tools are available, how we can use them, how we can secure the MariaDB Database Server and configure it. During the training course you will learn how to manage user accounts and how the MariaDB 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 Ljubljana (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 three-day instructor-led course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016.

Skills gained

• Describekey capabilities and components of SQL Server 2016
• Describe new and enhanced features in SQL Server performance
• Describes new and enhanced features in SQL Server security
• Describe what’s new inSQL Server Availability and Scalability
• Describe new and enhanced features in reporting and PowerBIin SQL Server 2016
• Describe new and enhanced data access features
• Describe new and enhanced features in SQL Server OLAP
• Describenew SQL Server cloud functionality

This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.

This Oracle Database 19c: RAC Administration Workshop course will teach you about Oracle RAC database
architecture. Expert Oracle University instructors will deep dive into Global Resources and Cache Fusion.

Learn To:

• Install and configure RAC
• Manage RAC Database
• Upgrade and patch RAC Database
• Manage backup and recovery for RAC
• Monitor and tune RAC Database
• Manage high availability of services
• Implement High Availability for connections and applications
• Configure RAC One Node Database
• Implement In-Memory Column Store in RAC
• Configure Multitenant Architecture in RAC
• Manage Quality of Service in RAC

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