Oracle SQL basics course
Course code:
Course length:
Training language:
32 lessons
English
Course fee:
609 EUR + VAT
Oracle SQL basics course - Dates and application
First training day: 27 July 2026, Further training days: 28., 29., 30.
Weekday daytime (09.00 - 16.30 CET)
Application deadline:
17 July 2026
Training language:
English
Course fee:
609 EUR + VAT
First training day: 21 September 2026, Further training days: 22., 23., 24.
Weekday daytime (09.00 - 16.30 CET)
Application deadline:
11 September 2026
Training language:
English
Course fee:
609 EUR + VAT
First training day: 23 November 2026, Further training days: 24., 25., 26.
Weekday daytime (09.00 - 16.30 CET)
Application deadline:
13 November 2026
Training language:
English
Course fee:
609 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 SQL in Oracle environment. You will also learn how to write queries, modify data statements and define data structures.
No previous knowledge is required to complete the course.
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 our course, students will learn the basics of SQL, be able to understand complex queries and write them independently. Our students will also learn about Oracle data types and data modifying statements and defining simpler data structures. In addition to standard SQL statements, participants will learn about Oracle's features and will be able to work effectively with several tools. During the course we put a strong emphasis on the acquisition of practical knowledge, so participants will learn SQL statements through examples.
Course Outline:
1. THE SQL LANGUAGE AND RELATIONAL DATABASES
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. Editions and versions of Oracle database
2.2. Architecture of Oracle server (DATABASE, SCHEMA-USER)
2.3. Standard Oracle users
2.4. Standard example schemas
2.5. Course example database
3. SQL TOOLS FOR ORACLE SYSTEMS
3.1. Oracle SQL tools, SQLPLUS
3.2. Proprietary SQL tools, PL/SQL Developer
3.3. Getting to know 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. Aggregation functions (SUM, COUNT, MIN, MAX, AVG)
4.7. GROUP BY grouping
4.8. HAVING condition
4.9. Uniqueness with DISTINCT
4.10. CASE expression
4.11. ROWNUM, OFFSET, FETCH NEXT numbering
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
5.6. Other useful functions
6. COMPLEX QUERIES
6.1. UNION and UNION ALL
6.2. INTERSECT
6.3. MINUS
6.4. Nested queries (EXISTS, IN)
6.5. Joining tables
6.6. NATURAL JOIN
6.7. INNER JOIN
6.8. CROSS JOIN
6.9. OUTER JOIN
6.10. Self JOIN
7. ADVANCED QUERIES
7.1. Hierarchical queries
7.2. Common Type Expression - CTE (WITH)
7.3. Higher level aggregations (CUBE, ROLLUP, GROUPING SETS)
7.4. Pivot table
7.5. Analytical functions (RANK, DENSE_RANK, OVER, FIRST, LAST, etc.)
7.6. External queries
8. DATA-MODIFYING STATEMENTS
8.1. Basics of transaction management
8.2. Inserting data (INSERT)
8.3. Modifying data (UPDATE)
8.4. Deleting data (DELETE)
8.5. TRUNCATE
8.6. MERGE
9. ORACLE DATA TYPES
9.1. Character types
9.2 Numeric types
9.3. Date types
9.4. Large size types
10. BASICS OF ORACLE PRIVILEGE MANAGEMENT
10.1. User privileges
10.2. Roles (ROLE)
10.3. Basic priviliges
10.4. Granting priviliges (GRANT)
10.5. Revoking priviliges (REVOKE)
11. DDL STATEMENTS
11.1. DML and DDL statements
11.2. Types of DDL statements
11.3. Using visual tools for executing DDL statements
11.4. Creating objects (CREATE)
11.5. Modifying objects (ALTER)
11.6. Deleting objects (DROP)
12. MAIN OBJECT TYPES OF ORACLE
12.1. Tables
12.2. Views
12.3. Indices
12.4. Constraints
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 designer, 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 from the Bessenyei György Teacher Training College in Nyíregyháza as a mathematics-computer science teacher. He has been working with Oracle products for nearly 13 years, mainly in the administration, tuning, operation, and support of OLTP Oracle databases. He has extensive experience with Oracle databases from version 7.1.3 to 11gR2, both in single-server and clustered implementations. About 4 years ago, his activities...
He graduated as a computer scientist specializing in robotics and image processing at 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 are Design Patterns, C#...
Do you have any questions about the training?
Useful modelling techniques and plenty of practical examples, spontaneous exchanges of views.
Róbert Erdos