Group functions transform many rows into a single result, making them essential for answering questions such as totals, averages, counts, minimums, maximums, and rankings.
In this section, we cover the most important conditional expressions supported by Oracle SQL, focusing on syntax, behavior, and exam relevant details.
This section focuses on Oracle SQL conversion functions, which are essential for controlling how data moves between numbers, characters, and date or time data types.
Single-row functions are heavily used in real-world SQL queries and appear frequently in certification exam questions. Mastering them will significantly improve your ability to customize query output and solve complex data manipulation problems.
How to filter and limit data in your queries
Now we're already populating, deleting and updating data in tables. And learn about transaction control
In this section we'll learn basics (but in depth) around creating tables and their properties
Now we're getting to know concepts on Oracle and overall around relational database
How to setup everything we need in order to practice and follow along the course.