Oracle Database 23ai: SQL Workshop Training in Norway

  • Learn via: Classroom
  • Duration: 5 Days
  • Level: Intermediate
  • Price: From €5,928+VAT
We can host this training at your preferred location. Contact us!

Oracle Database 23ai: SQL Workshop Training in Norway is a hands-on and in-depth training designed for professionals aiming to master the fundamentals and advanced capabilities of SQL within Oracle’s latest 23c architecture. More than theory, it offers real-world data manipulation scenarios and end-to-end database practice.

You’ll benefit most if you have:

  • A basic understanding of data processing concepts

  • Familiarity with any programming language (e.g., Python, Java, C#)

  • No prior SQL experience required—but a technical mindset helps

This course is ideal for:

  • Software Developers (Backend, Full Stack, Data-Driven Roles)

  • Database Administrators (DBAs)

  • Data Analysts and Reporting Specialists

  • IT Professionals Reskilling into SQL

  • Anyone working in Oracle environments

  • Beginners looking to learn SQL properly

By the end of this Oracle Database 23ai: SQL Workshop Training in Norway, you will have gained knowledge and skills in the following areas:

  • Understand Oracle 23c database architecture and SQL’s role

  • Query and filter data from single and multiple tables

  • Use single-row and multi-row functions to customize output

  • Handle subqueries, joins, views, sequences, indexes, and synonyms

  • Perform data insertion, updates, and deletion with DML

  • Manage users, roles, and object-level privileges

  • Work with different time zones and temporal data

  • Write powerful, performance-tuned, and secure SQL statements

  • Gain readiness for real-world enterprise database environments

1. Introduction to Oracle 23c

  • Architecture & Products

  • RDBMS concepts & terminology

  • SQL Development Tools & Documentation


2. Retrieving Data with SELECT

  • SELECT capabilities

  • Arithmetic expressions & NULL

  • Column aliases, DESCRIBE command


3. Filtering & Sorting Data

  • WHERE clause

  • ORDER BY and sorting

  • Substitution variables & row limiting


4. Single-Row Functions

  • String, number, and date functions

  • Customizing query output


5. Conversion & Conditional Expressions

  • Implicit/explicit conversions

  • TO_CHAR, TO_DATE, CASE, DECODE, JSON support


6. Aggregating Data with Group Functions

  • SUM, COUNT, AVG, MAX, MIN

  • Nested aggregation, grouping logic


7. Joins: Working with Multiple Tables

  • INNER, OUTER, SELF, CARTESIAN joins

  • USING, ON, NATURAL JOIN syntax


8. Solving Queries with Subqueries

  • Single-row & multi-row subqueries

  • EXISTS, NOT EXISTS, correlated subqueries


9. Set Operators

  • UNION, UNION ALL, INTERSECT, MINUS

  • Combining query results cleanly


10. Managing Tables with DML

  • INSERT, UPDATE, DELETE

  • Transactions, read consistency, locking


11. Data Definition Language (DDL)

  • Creating tables & constraints

  • ALTER and DROP operations


12. Exploring Data Dictionary Views

  • Oracle system views

  • Querying metadata, adding comments


13. Working with Sequences, Synonyms, Indexes

  • Automating values (SEQUENCE)

  • Synonyms for aliasing

  • Performance through indexing


14. Creating and Using Views

  • View creation, modification

  • DML with views, dropping views


15. Schema Object Management

  • Temporary & external tables

  • Managing constraints and structural integrity


16. Retrieving Data via Subqueries

  • Using subqueries as data sources

  • Scalar and correlated subquery usage


17. Data Manipulation with Subqueries

  • Inserting, updating, deleting using subqueries

  • WITH CHECK OPTION, update restrictions


18. Controlling User Access

  • Object vs system privileges

  • Creating roles, granting/revoking access


19. Advanced SQL Techniques

  • Default values, multitable inserts

  • MERGE operations, Flashback, data tracking


20. Time Zone & Temporal Data Management

  • CURRENT_TIMESTAMP, DBTIMEZONE, LOCALTIMESTAMP

  • Using SYSDATE, INTERVAL, and temporal queries effectively



Contact us for more detail about our trainings and for all other enquiries!

Upcoming Trainings

Join our public courses in our Norway facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

Classroom / Virtual Classroom
21 juli 2025
Oslo, Bergen, Trondheim
€5,928 +VAT Book Now
Classroom / Virtual Classroom
24 juli 2025
Oslo, Bergen, Trondheim
5 Days
Classroom / Virtual Classroom
25 juli 2025
Oslo, Bergen, Trondheim
5 Days
Classroom / Virtual Classroom
21 august 2025
Oslo, Bergen, Trondheim
5 Days
Classroom / Virtual Classroom
12 september 2025
Oslo, Bergen, Trondheim
5 Days
Classroom / Virtual Classroom
13 september 2025
Oslo, Bergen, Trondheim
5 Days
Classroom / Virtual Classroom
14 september 2025
Oslo, Bergen, Trondheim
5 Days
Classroom / Virtual Classroom
07 november 2025
Oslo, Bergen, Trondheim
5 Days

Related Trainings

Oracle Database 23ai: SQL Workshop Training Course in Norway

The Nordic country Norway, is in Northern Europe. Known for its stunning natural beauty, including fjords, mountains, and forests, Norway is also famous for its high standard of living and strong social welfare system. Norway's capital and largest city is Oslo. Tromsø, Bergen, Trondheim and Stavanger are the other tourist attracting cities of Norway.

Norway is a constitutional monarchy with King Harald V as the head of state. The country has a population of 5,425,270 as of January 2022. Norway is a relatively small country and has a relatively low population density, with much of its land area covered by forests, mountains, and fjords. Despite its small size, Norway is known for its rich cultural heritage, strong economy, and stunning natural beauty, which attracts millions of visitors every year. This Nordic country is also known for its winter sports, such as skiing and snowboarding, and is a popular destination for outdoor enthusiasts.

Norway has a long history of invention and is home to numerous more top-tier tech firms and research facilities, such as; Kongsberg Gruppen, Telenor, Atea, Evry and Gjensidige Forsikring.

Due to the country's high latitude, there are large seasonal variations in daylight. From late May to late July, the sun never completely descends beneath the horizon. Which attracts many tourists around the world to see the "Land of the Midnight Sun". Tourists mainly visit Sognefjord, Norway's Largest Fjord, Pulpit Rock, one of the most photographed sites in Norway and of course the capital; Oslo.

Oslo is considered the business center of Norway. It is the country's largest city and the capital of Norway. The city is home to many of Norway's largest and most important companies, as well as several international organizations and research institutions. Additionally, the city is a popular tourist destination, known for its scenic location on the Oslo Fjord, its many museums and cultural attractions, and its vibrant nightlife and dining scene. Some of the most popular museums in Oslo are The Norwegian Museum of Cultural History, The Nobel Peace Center, The National Museum of Art, Architecture, and Design, The Munch Museum and The Vigeland Museum.
By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.