Oracle SQL Advanced Training Course
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?
Course Outline
Control user access
- User Management
- System permissions and object
- Granting
- Receiving permission
- Roles
- Using the links
Managing schema objects
- ALTER TABLE command
- Adding, modifying, and deleting columns
- Add, remove, turn off constraintów
- Create indexes
- Flashback operations
- External tables
Operations on large data sets
- MERGE command
- DML operations of podzapytaniami
- DML operations with RETURNING clause
- INSERT command multi tables
Conditional expressions
- CASE expression
- DECODE expression
Generate reports by grouping related data
- The GROUP BY clause
- The HAVING clause
- Aggregating data - ROLLUP and CUBE operators
- Identification summaries - GROUPING function
- Aggregating data - GROUPING SETS operator
Managing data in different time zones
- Time zones
- Variations TIMESTAMP
- Differences between DATE and TIMESTAMP
- Conversion operations
Advanced subqueries
- Subqueries
- Multi-column subqueries
- The subquery in the FROM clause
- Correlated subqueries
- WITH clause - re-use query blocks
Join tables
- Inequality in the WHERE clause and the FROM clause
- Semijoin
- Antijoin
The processing of hierarchical data
- The tree structure
- hierarchical Queries
- Pseudo column
- Sort data in a hierarchical query
- Useful functions
Regular expressions
- Simple and complex patterns
Requirements
Oracle SQL undergoing a course in the first part
Open Training Courses require 5+ participants.
Oracle SQL Advanced Training Course - Booking
Oracle SQL Advanced Training Course - Enquiry
Oracle SQL Advanced - Consultancy Enquiry
Consultancy Enquiry
Testimonials (7)
many exercises with lots of explanations and time allocated for potential questions.
Theodor - DB Global Technology SRL
Course - Oracle SQL Advanced
An engaging and friendly atmosphere, lots of exercises with gradual increasing complexity to practice theoretical concepts.
Andrei - DB Global Technology SRL
Course - Oracle SQL Advanced
Training was very interactive and the trainer was always trying to make us validate our responses and to share our way of thinking
Roxana - DB Global Technology SRL
Course - Oracle SQL Advanced
The way it was structured as well as the balance between learning, exercises and breaks in order to keep the students engaged
Ciprian - DB Global Technology SRL
Course - Oracle SQL Advanced
Exercises are entertaining and the topics were nicely introduced.
Adrian-Madalin Chirita - DB Global Technology SRL
Course - Oracle SQL Advanced
The trainer knowledge and style of explication
Vlad-Mihai Nicolae - DB Global Technology SRL
Course - Oracle SQL Advanced
There were many exercises
Udrescu Daiana - DB Global Technology SRL
Course - Oracle SQL Advanced
Upcoming Courses
Related Courses
Oracle SQL Language
14 HoursThe course answers questions
How to build a query?
What possibilities have SQL?
What is a relational database?
What is the structure and SQL commands
Oracle SQL for Administrators
21 HoursThis instructor-led, live training in Switzerland (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.
Oracle SQL for Developers
35 HoursThis instructor-led, live training in Switzerland (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.
Oracle SQL for beginners
21 HoursListeners
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
Oracle SQL for Development and Database Management
35 HoursThis instructor-led, live training in Switzerland (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.
Oracle SQL LP - Fundamentals
14 HoursThe 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.
ORACLE SQL Fundamentals
14 HoursThis 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.
Oracle SQL Intermediate - Data Extraction
14 HoursThe 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.
Oracle SQL Intermediate
14 HoursAudience
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