Oracle SQL for Development and Database Management Training Course

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 course answers questions

How to build a query?

What possibilities have SQL?

What is a relational database?

What is the structure and SQL commands

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

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?

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

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 is part of the Data Scientist skill set (Domain: Data and Technology).

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

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

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

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.

The Oracle SQL Intermediate Course is designed to bridge the gap between fundamental SQL concepts and advanced techniques, providing participants with a comprehensive understanding of intermediate-level SQL operations using Oracle Database. Through hands-on exercises and practical examples, participants will delve into various topics, including table joins, summary functions, hierarchical queries, set operators, analytic functions, execution plans, and indexes.

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

• Gain proficiency in intermediate-level SQL operations necessary for querying and manipulating data in Oracle Database environments.
• Develop a deep understanding of table joins, summary functions, hierarchical queries, set operators, and analytic functions.
• Learn advanced techniques for optimizing SQL queries and improving database performance.
• Enhance problem-solving skills through hands-on exercises and real-world SQL scenarios.
• Gain confidence to tackle complex SQL challenges and advance their career in database management and development.

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