Explore Our Courses

Oracle: Programming with PL/SQL II

 21 Hours
This instructor-led, live training in Botswana (online or onsite) is aimed at advanced-level developers and database administrators who wish to use PL/SQL to develop high-performing, secure, and scalable database solutions while leveraging advanced programming techniques and integrations. By the end of this training, participants will be able to:
  • Work with complex data types, collections, and bulk operations for efficient data management.
  • Develop object types, table functions, and custom aggregates to enhance database functionality.
  • Apply performance tuning techniques, use native compilation, and safeguard against SQL injection.
  • Implement application contexts, VPD, and secure program units for robust database solutions.
Read more...

Oracle: Programming with PL/SQL I

 28 Hours
This instructor-led, live training in Botswana (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. 
Read more...

Oracle Database 19c PL and Advanced SQL

28 Hours
This instructor-led, live training in Botswana (online or onsite) is aimed at intermediate-level database administrators who wish to have an in-depth understanding of Oracle Database 19c PL/SQL programming and advanced SQL techniques. By the end of this training, participants will be able to:
  • Understand the fundamentals and advanced features of PL/SQL.
  • Develop advanced SQL queries to retrieve and manipulate data efficiently.
  • Implement PL/SQL programming constructs to manage data and database operations.
  • Optimize SQL queries for better performance.
  • Use advanced PL/SQL features like collections, bulk processing, and error handling.
  • Learn to debug and manage PL/SQL programs effectively.
Read more...

Scaling and Optimizing Prometheus and Grafana for Large Environments

 14 Hours
This instructor-led, live training in Botswana (online or onsite) is aimed at advanced-level DevOps engineers and SREs who wish to manage and scale Prometheus and Grafana for large environments effectively. By the end of this training, participants will be able to:
  • Architect Prometheus and Grafana for large-scale and distributed environments.
  • Optimize Prometheus performance for high-traffic systems.
  • Configure Grafana for large datasets and complex visualizations.
  • Implement advanced troubleshooting and scalability strategies.
Read more...

Custom Metrics and Instrumentation with Prometheus and Grafana

 14 Hours
This instructor-led, live training in Botswana (online or onsite) is aimed at intermediate-level developers and DevOps engineers who wish to instrument their applications to export and monitor custom metrics effectively using Prometheus and Grafana. By the end of this training, participants will be able to:
  • Understand the importance of custom metrics for application monitoring.
  • Instrument applications to export custom metrics for Prometheus.
  • Create and configure dashboards in Grafana to visualize custom metrics.
  • Apply best practices for integrating monitoring into the development lifecycle.
Read more...

Monitoring Kubernetes with Prometheus and Grafana

 14 Hours
This instructor-led, live training in Botswana (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.
Read more...

Advanced Alerting and Automation with Grafana and Prometheus

 14 Hours
This instructor-led, live training in Botswana (online or onsite) is aimed at advanced-level DevOps and SRE professionals who wish to enhance their alerting and automation skills with Grafana and Prometheus. By the end of this training, participants will be able to:
  • Create and manage advanced alerting rules in Prometheus.
  • Integrate Prometheus Alertmanager with external tools using webhooks.
  • Automate responses to alerts for faster issue resolution.
  • Use Grafana to visualize and manage alerts effectively.
Read more...

Integrating Grafana and Prometheus with Cloud Services

 14 Hours
This instructor-led, live training in Botswana (online or onsite) is aimed at intermediate-level cloud and DevOps engineers who wish to enhance cloud observability with Grafana and Prometheus. By the end of this training, participants will be able to:
  • Understand the benefits of integrating Grafana and Prometheus with cloud platforms.
  • Set up Prometheus for monitoring cloud-based resources.
  • Configure Grafana for visualizing cloud service metrics.
  • Leverage cloud-native tools and integrations for monitoring scalability.
Read more...

Building Effective Dashboards with Grafana and Prometheus

 14 Hours
This instructor-led, live training in Botswana (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.
Read more...

Monitoring with Grafana and Prometheus

 14 Hours
This instructor-led, live training in Botswana (online or onsite) is aimed at beginner-level system administrators and DevOps engineers who wish to develop core monitoring skills using Grafana and Prometheus. By the end of this training, participants will be able to:
  • Understand the purpose and importance of monitoring in IT environments.
  • Install and configure Grafana and Prometheus for basic monitoring tasks.
  • Create simple dashboards and alerts to visualize system performance.
  • Apply best practices for monitoring system availability and performance.
Read more...

Milvus: Open-Source Vector Database for AI Applications

 21 Hours
This instructor-led, live training in Botswana (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.
Read more...

Introduction to Grafana and Prometheus

 14 Hours
This instructor-led, live training in Botswana (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.
Read more...

Pinecone: Vector Database Solutions for AI

 21 Hours
This instructor-led, live training in Botswana (online or onsite) is aimed at beginner-level to intermediate-level data scientists and software developers who wish to learn how to apply Pinecone to various AI scenarios, from semantic search to personalization. By the end of this training, participants will be able to:
  • Understand the architecture and features of Pinecone.
  • Implement vector databases in different AI applications.
  • Perform similarity searches with high accuracy and speed.
  • Apply Pinecone to real-world AI challenges.
Read more...

Spine-Leaf Architecture with VXLAN in Database Management

 14 Hours
This instructor-led, live training in Botswana (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.
Read more...

Oracle SQL for Developers

 35 Hours
This instructor-led, live training in Botswana (online or onsite) is aimed at intermediate-level developers and database administrators who wish to use Oracle SQL to design, manage, and optimize database applications and automate tasks efficiently. By the end of this training, participants will be able to:
  • Understand Oracle database architecture and manage users, schemas, and permissions.
  • Write optimized SQL queries for data retrieval, manipulation, and analysis.
  • Use advanced SQL techniques, including joins, subqueries, and hierarchical queries.
  • Design and manage database objects like tables, indexes, views, and sequences.
Read more...

Mastering Vector Databases for Scalable AI Solutions

 14 Hours
This instructor-led, live training in Botswana (online or onsite) is aimed at intermediate-level to advanced-level data scientists and machine learning engineers who wish to master the use of vector databases for scalable, high-performance AI applications. By the end of this training, participants will be able to:
  • Understand the principles of vector databases.
  • Learn techniques for creating and managing vector embeddings.
  • Explore indexing strategies for high-dimensional data.
  • Develop skills for performing efficient similarity searches.
  • Apply vector database knowledge to machine learning projects.
Read more...

Mastering Oracle APEX 23-24: Workflows and Security

 21 Hours
This instructor-led, live training in Botswana (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.
Read more...

Database Design and Programming with SQL

 21 Hours
This instructor-led, live training in Botswana (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.
Read more...

Oracle SQL for Administrators

 21 Hours
This instructor-led, live training in Botswana (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. 
Read more...

PL/SQL in Oracle 19c

 21 Hours
This instructor-led, live training in Botswana (online or onsite) is aimed at intermediate-level developers and administrators who wish to have a solid PL/SQL programming foundation to develop efficient and robust database applications using Oracle 19c. By the end of this training, participants will be able to:
  • Gain a comprehensive understanding of what PL/SQL is and its advantages over standard SQL.
  • Learn how to declare and use variables and different data types within PL/SQL blocks.
  • Apply control structures like IF-THEN-ELSE, CASE statements, and loops to create robust PL/SQL programs.
  • Understand and implement explicit and implicit cursors for data retrieval.
  • Handle exceptions effectively using predefined and user-defined exceptions.
  • Develop and manage triggers to automate and enforce business rules.
  • Create and use PL/SQL packages to encapsulate and modularize code for reuse and maintainability.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours
This instructor-led, live training in Botswana (online or onsite) is aimed at beginner-level data professionals who wish to learn how to design, implement, and manage SSIS packages to perform data integration and transformation tasks. By the end of this training, participants will be able to:
  • Understand the architecture and components of SSIS.
  • Design and implement ETL processes using SSIS.
  • Use SSIS tools to develop, deploy, and manage data integration solutions.
  • Troubleshoot and optimize SSIS packages for performance and reliability.
Read more...

Introduction to Vector Databases

 14 Hours
This instructor-led, live training in Botswana (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.
Read more...

Oracle SQL for beginners

 21 Hours
Listeners This training is addressed for people starting to work with the SQL language in Oracle database The course answer for questions:
  • How to build a query?
  • What possibilities have SQL?
  • What is a relational database?
  • What is the structure and SQL commands
Read more...

ORACLE SQL Fundamentals

 14 Hours
This 2 day course gives an introduction to SQL Developer, SQL*Plus and to SQL, the Structured Query Language used to access a Relational Database and includes the new features of the latest version of ORACLE. The principles learnt may also be applied to databases as diverse as Microsoft SQL Server, MySQL, Access, Informix and DB2. The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core elements. Full course notes are provided along with sample database files, example SQL files and free software tools for use in accessing an ORACLE database.
Read more...

ORACLE PL/SQL Fundamentals

 21 Hours
This 3 day course gives an introduction to ORACLE PL/SQL, an application development environment that enables the writing of stored procedures, functions and triggers using both SQL and PL/SQL commands. The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core elements. Full course notes are provided along with sample database files, example SQL files and free software tools for use in accessing an ORACLE database.
Read more...

Oracle PL/SQL - introduction to programming

 14 Hours
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.
Read more...

Oracle PL/SQL advanced programming

 21 Hours
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.
Read more...

Oracle SQL Intermediate

 14 Hours
Audience All who want to improve their basic skills in Oracle SQL and also systematize already gained knowledge. Format of the course 25% lectures, 75% labs
Read more...

Oracle SQL Advanced

 14 Hours
Listeners This course is designed for people who want to use the advanced features of SQL in Oracle The course answers the questions
  • How to build advanced queries?
  • How to create advanced reports?
Read more...

Monitoring Kubernetes with Prometheus

 7 Hours
This instructor-led, live training in Botswana (online or onsite) is aimed at system administrators and developers who wish to use Prometheus to monitor Kubernetes clusters. By the end of this training, participants will be able to:
  • Install and configure Prometheus.
  • Monitor dynamic cloud environments.
  • Gain better insight into their Kubernetes clusters.
  • Set up alerts that are precise and insightful.
Read more...

Oracle SQL for Development and Database Management

 35 Hours
This instructor-led, live training in Botswana (online or onsite) is aimed at intermediate-level database professionals who wish to enhance their skills in Oracle SQL development and administration. By the end of this training, participants will be able to:
  • Build and optimize complex SQL queries.
  • Manage databases efficiently using Oracle SQL tools.
  • Apply best practices in database development and maintenance.
  • Administer user access and database security in an Oracle environment.
Read more...

Oracle SQL Intermediate - Data Extraction

 14 Hours
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.
Read more...

Migrating Oracle to Azure SQL or PostgreSQL

 7 Hours
This instructor-led, live training in Botswana (online or onsite) is aimed at database administrators and cloud architects who wish to migrate Oracle databases to Azure SQL or PostgreSQL. By the end of this training, participants will be able to:
  • Compare Azure SQL with PostgreSQL to choose the database that best meets business objectives and needs.
  • Prepare databases to move definitions, data, and procedures from Oracle to AzureSQL or PostgreSQL database system.
  • Perform post-migration steps to test, optimize, update, and maintain a migrated database.
Read more...

Introduction to SQL Server 2012 Integration Services (SSIS)

 28 Hours
This instructor-led, live training in Botswana (online or onsite) is aimed at beginner to intermediate-level developers and database administrators who wish to gain proficiency in SQL Server 2012 Integration Services. By the end of this training, participants will be able to:
  • Understand the principles of ETL and the role of SSIS.
  • Create, deploy, and manage SSIS packages.
  • Design and implement Control Flow to define the flow of tasks in a package.
  • Implement Workflow and set up constraints for effective task execution.
  • Construct Data Flows to extract, transform, and load data.
  • Work with Variables and Containers to enhance package flexibility.
  • Manage Transactions to ensure data consistency.
  • Implement effective error handling and debugging techniques.
  • Set up Logging for tracking and monitoring.
  • Handle Slowly Changing Dimensions for managing changing data.
  • Deploy a Package for production use.
  • Implement Security measures to protect sensitive data.
  • Utilize Scripting to extend SSIS functionality.
  • Apply Best Practices for efficient and maintainable SSIS solutions.
Read more...

ClickHouse Fundamentals

 14 Hours
This instructor-led, live training in Botswana (online or onsite) is aimed at developers and IT professionals who wish to set up, manage, and use ClickHouse for processing SQL queries faster than traditional database management systems. By the end of this training, participants will be able to:
  • Install and configure ClickHouse.
  • Understand the features and architecture of ClickHouse.
  • Know the differences between ClickHouse and other database systems (MySQL, PostgreSQL, etc.).
  • Configure user authentication, roles, and access controls in ClickHouse.
  • Perform SQL queries, manipulate data, and manage tables in ClickHouse.
  • Apply administrative tools and techniques to optimize performance.
  • Implement custom integrations with external systems (MySQL, PostgreSQL, MongoDB, Apache Kafka, etc.).
Read more...

NoSQL Database with Microsoft Azure Cosmos DB

 14 Hours
This instructor-led, live training in Botswana (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.
Read more...

Data Management

 35 Hours
Audience
  • Programmers
  • Beginner IT professionals
Format of the course     Part lecture, part discussion, heavy hands-on practice
Read more...

Change Data Capture (CDC) with Debezium

 14 Hours
This instructor-led, live training in Botswana (online or onsite) is aimed at engineers who wish to enable applications to continuously monitor and stream all commits made to their database. By the end of this training, participants will be able to:
  • Install and configure ZooKeeper, Kafka, and the Debezium connector service.
  • Set up applications to automatically consume and respond to database inserts, updates, and deletes.
  • Turn database row-level changes into event streams that applications can respond to immediately.
  • Stream each row-level change in the same order that it was committed to the database.
Read more...

Hasura GraphQL Engine

 14 Hours
This instructor-led, live training in Botswana (online or onsite) is aimed at database administrators and developers who wish to use Hasura to build, access, and manage databases and applications efficiently with GraphQL. By the end of this training, participants will be able to:
  • Set up the necessary development environment to start building databases with Hasura.
  • Build, run, manage data access and queries on Hasura using GraphQL models.
  • Secure data access by setting up authentication with JSON Web Tokens and Firebase.
  • Extend database functions by integrating business logic.
  • Manage database migrations and metadata effectively on Hasura to prevent data loss.
Read more...

Distributed Data Processing and Storage with Hazelcast

 14 Hours
This instructor-led, live training in Botswana (online or onsite) is aimed at developers and system administrators who wish to use Hazelcast for processing distributed data structures and optimizing application performance. By the end of this training, participants will be able to:
  • Install and configure Hazelcast to start creating and managing a cluster.
  • Create a cluster for initiating automatic discovery of multiple processes.
  • Set up Management Center for cluster connections and monitoring.
  • Develop applications and deploy them through the Hazelcast cluster.
Read more...

MarkLogic Server

 14 Hours
This instructor-led, live training in Botswana (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.
Read more...

MongoDB Atlas Fundamentals

 14 Hours
MongoDB Atlas is a multi-cloud database-as-a-service (DBaaS) platform. It simplifies the setup, operation, and management of MongoDB deployments in the cloud. This instructor-led, live training in Botswana (online or onsite) is aimed at developers and sysadmins who wish to use MongoDB Atlas to run, deploy, and manage databases at scale through automation and simplified configurations. By the end of this training, participants will be able to:
  • Set up, configure, and access the MongoDB Atlas cluster.
  • Understand the features, architecture, and advantages of MongoDB Atlas.
  • Learn how to import/export, query, and manipulate data in MongoDB Atlas.
  • Use Atlas APIs to automate database operations and administration.
  • Apply the best practices in managing and scaling MongoDB deployments.
Read more...

Beyond the Relational Database: Neo4j

 21 Hours
In this instructor-led, live hands-on training in Botswana, we will set up a live project and put into practice the skills to model, manage and access your data using neo4j. We contrast and compare graph databases with SQL-based databases as well as other NoSQL databases and clarify when and where it makes sense to implement each within your infrastructure.
Read more...

Building Graph Databases with Neo4j AuraDB

 14 Hours
This instructor-led, live training in Botswana (online or onsite) is aimed at developers who wish to use Neo4j AuraDB graph database to build cloud applications with high availability and zero administration. By the end of this training, participants will be able to:
  • Set up the necessary development environment to start developing graph database applications with Neo4j AuraDB.
  • Understand the features, core concepts, and architecture of Neo4j AuraDB.
  • Learn how to build and scale graph database applications in the cloud.
  • Enhance cloud security with AuraDB's pre-configured authentication and encryption features.
  • Migrate existing Neo4j databases to AuraDB.
Read more...

Developing Applications with Oracle Application Express (APEX)

 21 Hours
This instructor-led, live training in Botswana (online or onsite) is aimed at developers who wish to use Oracle APEX to develop, scale, and deploy applications faster with less code. By the end of this training, participants will be able to:
  • Set up the necessary development environment to start developing database apps with Oracle APEX.
  • Understand and explore the Oracle APEX tools to build a fully-featured application.
  • Learn how to create applications and pages using Oracle APEX and the Page Designer UI.
  • Extend the functionality of complex enterprise apps easily with Oracle APEX.
  • Optimize and scale application performance and deployment.
  • Control and secure access to application data and components.
Read more...

Administration with Powershell

 35 Hours
This intensive training provides the fundamental knowledge and skills to use Windows PowerShell for automating administration of Windows based computers. The skills taught in this course are applicable to all Microsoft products that use Windows PowerShell for daily administration. Training focuses mainly on using Windows PowerShell as an interactive command line interface however it also includes some coverage of scripting and programming topics.
Read more...

Prometheus Fundamentals

 14 Hours
This instructor-led, live training in Botswana (online or onsite) is aimed at system administrators and DevOps engineers who wish to use Prometheus to monitor systems and applications natively or through highly dynamic microservices running in a cloud environment. By the end of this training, participants will be able to:
  • Install and configure Prometheus.
  • Understand the features, architecture, and core concepts of Prometheus.
  • Learn how to query data using PromQL.
  • Build visualizations and dashboards with Grafana.
  • Configure systems monitoring and alerting rules.
  • Analyze and optimize systems and application performance.
  • Enable secure integration to remote endpoints and existing systems.
Read more...

SAP ASE for Database Administrators

 28 Hours
In this instructor-led, live training in Botswana, 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.
Read more...

SQLite Fundamentals

 14 Hours
This instructor-led, live training in Botswana (online or onsite) is aimed at developers who wish to use SQLite to develop embedded applications for various devices, such as desktops, mobile phones, Android TV, cameras, etc. By the end of this training, participants will be able to:
  • Install and configure SQLite on any platform.
  • Understand the features and architecture of SQLite.
  • Learn how to execute common SQL operations in SQLite.
  • Learn how to manipulate data and tables in SQLite.
  • Understand the various SQLite data types, tools, and functions.
  • Perform calculations with SQLite aggregate functions.
Read more...

Business Intelligence with SSAS

 14 Hours
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.
Read more...

Oracle SQL Language

 14 Hours
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
Read more...

Last Updated:

Testimonials(25)

Small group, in-person for 3 days,

Annina - Ricardo AG

Course - SQL: Basics to Intermediate

I liked very much the format of the training, hands on, directly in sql developer.

Andreea - OPEN COURSE

Course - Oracle Database 19c PL and Advanced SQL

Gunnar created a great rapport with the audience and was quick to identify our needs. He was engaging and highly knowledgeable throughout and we enjoyed his humour.

Kurt - Complete Coherence

Course - SQL For Data Science and Data Analysis

The exercises were explained very good.

Monica - DB Global Technology

Course - PL/SQL in Oracle 19c

Kamil did a great job. He asked questions to find out what we already knew and what we needed to focus on, and easily adapted the training to our needs.

Susanna - USAF

Course - MongoDB Advanced Administrator

Jose was an engaging trainer, and I appreciate him having to stay awa

Phil - Federal Court of Australia

Course - Prometheus Fundamentals

The way trainer demonstrated everything

Manveen - Tribal Grou[

Course - Developing Applications with Oracle Application Express (APEX)

The quality of training and wealth of experience !

Edvin - Verizon Connect

Course - MySQL Developer

Intresting presentation and excercises

Szymon - Agora SA

Course - Scylla Database

Andres consistently ensures that he addresses all attendee questions and strives to ensure everyone comprehends his teachings. I admire his expertise and proficiency in the subject matter

Ryan - Questronix Corporation

Course - PostgreSQL for Administrators - 3 Days

Being human and talking to us as understandable possible

Sorin

Course - Database Administration Fundamentals for MS SQL Server

Trainer expertise on SQL tuning

Bogdan - DB Global Technology

Course - Oracle 11g - Application Tuning - Workshop

The situation was atypical because an intensive training for developers was to be conducted with non-developers. Lukasz took up this challenge with empathy and a lot of humour. Through his intelligent and flexible manner, he was able to ensure that a concrete learning gain was achieved for everyone. I enjoyed this very much and would gladly take a seminar with Lukasz again.

Christoph - Honda Bank GmbH

Course - MERN Fullstack Development

Philip was very kind, his style of explaining SQL concepts is outstanding. I liked that he give us information and answered to questions which were not part of this course.

Stefan

Course - SQL in SQL Server

The trainings by our self

Andreas - Diehl

Course - Access Advanced

analytical functions

khusboo dassani - Tech Northwest Skillnet

Course - SQL Advanced

Our group was not that big so every time we asked a question we received an extensive answer with examples. So everything was well explained and it can be noticed that trainer has a great knowledge.

Iwona - Universal-Investment-Gesellschaft mit beschrankter Haftung

Course - Access Intermediate

The training materials.

Mona Dobre - DB Global Technology

Course - SQL Advanced level for Analysts

I learned complex functions and how to apply them

Ana Alexandrescu - DB Global Technology

Course - Oracle SQL Advanced

Practical exercises for practice and understanding of the concept, clarification provided for any questions.

Safdar Abbas - Medtech Limited

Course - T-SQL Fundamentals with SQL Server Training Course

Was carefully tailored to our needs, very responsive to live questions and situations, gave us lots of practice repeating what we were learning.

Colin - Drax

Course - MySQL Administration

Great comunication, Łukasz explained everything in easy and understandable way

Tomasz Wojciechowski - GP Strategies Poland sp. z o.o.

Course - ORACLE SQL Fundamentals

Ahmed has been very cooperative and knowledgeable about the subject and throughout been a good and productive training session covering some basic and important topics on Postgres.

Imran Sadiq Bhat

Course - PostgreSQL Essentials

It was quite hands-on, not too much theory.

David Lambaerts - Estee Lauder BV

Course - ORACLE PL/SQL Fundamentals

It allowed us to have an applied hands on sproc to our company database.

Corneliu Buculei - Standard Building Supplies Ltd

Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Other regions in Botswana

Other Countries

These courses are also available in other countries
Online Database courses, Weekend Database courses, Evening Database training, Database boot camp, Database instructor-led, Weekend Database training, Evening Database courses, Database coaching, Database instructor, Database trainer, Database training courses, Database classes, Database on-site, Database private courses, Database one on one training