Oracle SQL Queries Course
Course code:
Course length:
Training language:
16 lessons
English
Course fee:
319 EUR + VAT
Oracle SQL Queries Course - Dates and application
First training day: 27 July 2026 , Further training days: 28.
Weekday daytime (09.00 - 16.30 CET)
Training language:
English
Course fee:
319 EUR + VAT
First training day: 21 September 2026 , Further training days: 22.
Weekday daytime (09.00 - 16.30 CET)
Training language:
English
Course fee:
319 EUR + VAT
First training day: 23 November 2026 , Further training days: 24.
Weekday daytime (09.00 - 16.30 CET)
Training language:
English
Course fee:
319 EUR + VAT
Applying for closed-group training
If you and your colleagues are attending a closed group training course and you have a training date code, you can apply here.
Application without a date
If none of the dates is right for you, but you are interested in the course, please submit your application without a date. When we publish a new date you will be notified.
In this course, students will learn the basics of writing SQL queries in Oracle environment.
No previous knowledge is required.
Writing SQL queries is no longer required only for software developers, and is increasingly expected in the fields of analysis, design, testing or reporting. In this course, students will learn the basics of the SQL language, and how to write queries.
In addition to the standard SQL statements, they will be able to use these stand-alone query languages effectively with specific knowledge of Oracle databases.
Throughout the course, there will be a strong emphasis on practical knowledge, so students will learn by practicing the queries in real Oracle database environment.
Course Outline:
1. SQL LANGUAGE AND RELATIONAL DATABASE SERVERS
1.1. SQL standards
1.2. Data models
1.3. Relational database servers
1.4. Table
1.5. Field
1.6. Relationships between tables
1.7. Table operations
1.8. NULL value
2. BASICS OF ORACLE DATABASE SERVER
2.1. Oracle database versions and variants
2.2. Database instances and schemas
2.3. Connecting to Oracle database
2.4. Referring to objects
2.5. Course example database
3. TOOLS FOR ORACLE DATABASE
3.1. SQLPlus
3.2. Oracle SQL Developer
4. SIMPLE SQL QUERIES
4.1. Basics of SQL syntax
4.2. SELECT statement
4.3. WHERE condition
4.4. Operators (LIKE, BETWEEN, IN, IS NULL)
4.5. ORDER BY - Sorting
4.6. GROUP BY - Grouping
4.7. Aggregation functions (SUM, COUNT, MIN, MAX, AVG)
4.8. HAVING condition
4.9. DISTINCT - Ensuring uniqueness
4.10. Limiting the number of lines retrieved (ROWNUM, OFFSET, FETCH NEXT)
4.11. CASE expression
5. BUILT-IN FUNCTIONS
5.1. Numeric functions
5.2. Text-handling functions
5.3. Date and time functions
5.4. Conversion functions
5.5. NULL functions
6. COMPLEX QUERIES
6.1. UNION and UNION ALL
6.2. INTERSECT
6.3. EXCEPT
6.4. Nested queries (EXISTS, IN, ALL, SOME, ANY)
6.5. Joining tables
6.6. INNER JOIN
6.7. CROSS JOIN
6.8. OUTER JOIN
6.9. Self JOIN
Trainers
He holds teaching qualifications from Eszterházy Károly College and ELTE in several fields. His dedication to adult education is further evidenced by his master's degree in Educational Leadership from BME. With over 20 years of experience in higher education and two decades of programming expertise, he emphasizes the importance of practical experience alongside training activities to maintain instructional credibility. He is an...
He graduated from Eszterházy Károly College as a software developer, then obtained his degree as an IT teacher at the successor institution, Eszterházy Károly University. He became involved in the institution's development and research projects during his studies. He participated in research and development projects such as "Development Opportunities of RFID/NFC Technology based on Internet of Things Concepts" and...
He graduated from the Budapest University of Technology and Economics with a degree in software technologies and telecommunications, but began his computer science studies at the Neumann János Vocational School and Grammar School. Even then, he demonstrated his abilities with excellent placements in national academic competitions in programming. He completed postgraduate studies in Banking Informatics Engineering at BME and...
He graduated as a computer scientist specializing in robotics and image processing from Budapest University of Technology and Economics. He has been working as a software developer since 2004 and as a programming instructor in higher education since 2005. In the field of adult education, he has been providing corporate professional training courses in programming topics since 2012.His main areas of competence include Design Patterns,...
Do you have any questions about the training?
It was a well-paced, interesting course, which included everything that fit into the short time, considering the length of 8 hours.
Károly Szabó