Database Training in Slovenia

This instructor-led, live training in Slovenia (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 Slovenia (online or onsite) is aimed at advanced-level system administrators who wish to learn advanced system administration tasks, security configurations, network management, automation, and performance tuning for enterprise environments.

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

• Master advanced package management techniques, including creating custom repositories, resolving dependencies, and managing RPM packages with GPG keys.
• Implement and manage advanced filesystems and storage solutions using LVM, encryption, snapshots, and high-performance filesystems like XFS, Btrfs, and ZFS.
• Configure and manage advanced network services such as NIC bonding/teaming, VPNs, and secure remote administration tools.
• Configure high-availability clusters using Pacemaker and Corosync, including setting up failover services and monitoring cluster health.
• Manage virtualization environments with Oracle Linux Virtualization Manager (OLVM), and containers using Docker and Podman for container orchestration.

This instructor-led, live training in Slovenia (online or onsite) is aimed at beginner-level database administrators who wish to manage backup and recovery tasks in Oracle Database 19c.

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

• Understand the essential concepts of backup and recovery in Oracle Database 19c, including the architecture and various types of failures.
• Gain hands-on experience in configuring backup and recovery settings, including the RMAN environment and fast recovery area.
• Develop practical skills in performing different types of backups and recovery operations, including full, incremental, and point-in-time recovery.
• Learn how to utilize Oracle's Flashback technology for effective database recovery and manage disaster recovery scenarios.
• Apply best practices for backup, recovery, and disaster recovery to ensure data availability and minimize downtime in Oracle Database 19c.

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

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.

Database is a structured system for storing, managing, and retrieving data efficiently. This course introduces participants to the principles of database systems, with a focus on relational database models, data normalization, and SQL-based querying.

This instructor-led, live training (online or onsite) is aimed at intermediate-level IT professionals who wish to understand database management concepts, with a focus on relational database models, and gain practical skills in working with databases.

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

• Understand database concepts and relational database models.
• Design simple data models and understand normalization.
• Use basic SQL queries to retrieve, insert, and update data.
• Understand key concepts in database administration and security.

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.

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.

Oracle APEX (Application Express) is a low-code development platform that enables the rapid creation of scalable, secure enterprise apps using minimal code.

This instructor-led, live training (online or onsite) is aimed at intermediate-level developers and IT professionals who wish to build secure and scalable enterprise applications using Oracle APEX with minimal hand-coding.

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

• Design and build data-driven applications using APEX.
• Use built-in components to accelerate development.
• Deploy, evaluate, and certify applications efficiently.
• Manage user authentication and application security.

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.

This instructor-led, live training in Slovenia (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 Slovenia (online or onsite) is aimed at intermediate-level developers and IT professionals who wish to learn how to leverage new features in APEX 23-24, design efficient workflows, and ensure application security.

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

• Develop and manage APEX applications using the latest features in versions 23-24.
• Design and implement efficient workflows within APEX.
• Apply advanced security measures to protect APEX applications and data.
• Integrate APEX applications with external systems and ensure smooth data exchange.
• Test, debug, and deploy APEX applications following best practices.

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 advanced-level developers who wish to learn and use MySQL and database technologies for building web applications.

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

• Write SQL queries to retrieve, filter, sort, and aggregate data.
• Perform data manipulation operations such as inserting, updating, and deleting data.
• Implement advanced SQL concepts such as subqueries, derived tables, and conditional logic.
• Integrate MySQL with popular programming languages and execute queries from application code.

This training is designed for Database Administrators and Architects who want to learn PostgreSQL from basics.

You will learn PostgreSQL architecture, installation, designing as well as how to perform backup and recovery databases in PostgreSQL. 

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

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.

The course participants will learn how to speed up the operation of the database, how to write advanced queries, create a convenient system of forms and reporting. The course introduces the participant to automate all operations using macros and VBA.

This course will introduce Cassandra –  a popular NoSQL database.  It will cover Cassandra principles, architecture and data model.   Students will learn data modeling  in CQL (Cassandra Query Language) in hands-on, interactive labs.  This session also discusses Cassandra internals and some admin topics.

Audience : Developers

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

Audience

• Programmers
• Beginner IT professionals

Format of the course

    Part lecture, part discussion, heavy hands-on practice

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.

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 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 training is designed to introduce the knowledge that allows you to configure the database server according to your requirements, and to create appropriate procedures for monitoring the functioning of its various components, as well as to quickly respond to any irregularities that arise. After completing this training, the participant will be able to effectively diagnose the sources of performance problems in the operation of SQL Server and apply various types of implementations leading to the removal of so-called "bottlenecks".

Upon completion of the training, the participant:
▪ will be able to diagnose so-called "bottlenecks" in the operation of the database and/or server
▪ will be able to monitor the operation of SQL Server
▪ will know what to recommend to improve the performance of the database and server.

This instructor-led, live training in Slovenia (online or onsite) is aimed at engineers who wish to set up, deploy, migrate to and manage an Oracle 18c Database.

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

• Understand the major feature and architectural changes from previous Oracle versions.
• Migrate to Oracle 18c from a previous version.
• Deploy Oracle 18c in cloud or on premise.
• Understand Oracle 18c's new yearly release cycle and plan maintenance around it.

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.

Redis is an open source (BSD licensed), in-memory data structure store, used as database, cache and message broker.

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.

This instructor-led live training in Slovenia (onsite or remote) is designed for database administrators, SQL developers, and data analysts who wish to expand their specialized knowledge in the area of SQL tuning.

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

• Work with user-defined data types (UDDT) and user-defined types (UDT) to enhance data modeling.
• Effectively manage hierarchical data, considering structural elements, storage methods, strategies, and indexing techniques.
• Implement ranking and analytical functions using the OVER clause, window functions, and various operators such as GROUPING SETS, GROUPING_ID, ROLLUP, CUBE, PIVOT, UNPIVOT.
• Leverage temporary data and other temporary features for efficient query processing.
• Improve query performance through advanced data indexing techniques, including index selectivity, server suggestions for missing indexes, and measuring execution time with and without indexes.
• Create and manage statistics to optimize cardinality estimation and eliminate potential errors.
• Analyze SQL query execution plans, understand query plan reading, parameter sniffing, and code recompilation.
• Control SQL query execution using hints, extended events, the database engine tuning advisor, data collector, and query store.

The course answers questions

How to build a query?

What possibilities have SQL?

What is a relational database?

What is the structure and SQL commands