Oracle SQL for Development and Database Management Training Course

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

This instructor-led, live training in Argentina (online or onsite) is aimed at intermediate-level database administrators, developers, and analysts who wish to master advanced SQL functionalities for complex data operations and database management.

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

• Perform advanced querying techniques using unions, subqueries, and complex joins.
• Add, update, and delete data, tables, views, and indexes with precision.
• Ensure data integrity through transactions and manipulate database structures.
• Create and manage databases efficiently for robust data storage and retrieval.

Amazon Redshift is a petabyte-scale cloud-based data warehouse service in AWS.

In this instructor-led, live training, participants will learn the fundamentals of Amazon Redshift.

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

• Install and configure Amazon Redshift
• Load, configure, deploy, query, and visualize data with Amazon Redshift

Audience

• Developers
• IT Professionals

Format of the course

• Part lecture, part discussion, exercises and heavy hands-on practice

Note

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

The course is part of the Data Scientist skill set (Domain: Data and Technology).

In this instructor-led, live training in Argentina, participants will learn how to build a Data Vault.

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

• Understand the architecture and design concepts behind Data Vault 2.0, and its interaction with Big Data, NoSQL and AI.
• Use data vaulting techniques to enable auditing, tracing, and inspection of historical data in a data warehouse.
• Develop a consistent and repeatable ETL (Extract, Transform, Load) process.
• Build and deploy highly scalable and repeatable warehouses.

Apache Druid is an open-source, column-oriented, distributed data store written in Java. It was designed to quickly ingest massive quantities of event data and execute low-latency OLAP queries on that data. Druid is commonly used in business intelligence applications to analyze high volumes of real-time and historical data. It is also well suited for powering fast, interactive, analytic dashboards for end-users. Druid is used by companies such as Alibaba, Airbnb, Cisco, eBay, Netflix, Paypal, and Yahoo.

In this instructor-led, live course we explore some of the limitations of data warehouse solutions and discuss how Druid can compliment those technologies to form a flexible and scalable streaming analytics stack. We walk through many examples, offering participants the chance to implement and test Druid-based solutions in a lab environment.

Format of the Course

• Part lecture, part discussion, heavy hands-on practice, occasional tests to gauge understanding

This instructor-led, live training in Argentina (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 Argentina (online or onsite) is aimed at intermediate-level big data professionals who wish to utilize Apache Kylin for building real-time data warehouses and performing multidimensional analysis on large-scale datasets.

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

• Set up and configure Apache Kylin with real-time streaming data sources.
• Design and build OLAP cubes for both batch and streaming data.
• Perform complex queries with sub-second latency using Kylin's SQL interface.
• Integrate Kylin with BI tools for interactive data visualization.
• Optimize performance and manage resources effectively in Kylin.

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

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

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?

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

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.

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.

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