SQL Fundamentals

This 25-part video course introduces SQL in Hungarian, covering queries, functions, joins, subqueries and analytic functions, followed by query-writing exercises using the Oracle HR schema.

The course is for people starting to work with relational databases and SQL. The videos are available on the Enrol Consulting YouTube channel. Follow the playlist order below, or return to a topic when you need a refresher.

Language: Hungarian audio.

Open the course playlist on YouTube

Course lessons

The English labels below translate the original Hungarian video titles. The numbering follows the playlist order.

Getting started

1. Why do we write programs?
2. Client-server architecture
3. SQL practice environment
4. Tables in the HR schema

Queries and functions

5. The SELECT statement
6. The WHERE condition
7. Aggregate functions
8. Conversion functions
9. Character functions
10. Date functions
11. Working with numbers
12. Logical functions

Relational databases and more advanced queries

13. Relational databases — Part 1
14. Data queries — NO JOIN
15. JOIN — Part 1
16. JOIN — Part 2
17. Subqueries — Part 1
18. Subqueries — Part 2
19. Analytic functions

Query-writing exercises

20. Employees
21. Departments
22. Locations
23. Countries
24. Regions
25. Jobs

Continue learning

Explore my database articles, or continue with Oracle APEX for Beginners to start building applications.