Oracle SQL Fundamentals

You’ll begin with the essentials of retrieving data, learning how to choose specific columns, filter and sort results, and apply column aliases. You’ll practise using aggregate functions, grouping results and filtering grouped data. You’ll then move on to modifying data, inserting new rows, updating existing records, and removing unwanted entries, all while applying transaction control to ensure accuracy and data integrity. 

You’ll explore the full range of join types, including inner, outer and self joins, using both Oracle and ANSI-standard syntax to combine data from multiple tables. You’ll learn to create subqueries, from simple to correlated and multi-column, enabling advanced filtering and data transformation. The course also covers in-line views and the ‘with’ clause for reusable query logic. You’ll continue by creating and managing views to simplify query writing, secure sensitive columns, and improve database efficiency. 

You’ll develop your skills with number, string and date functions to format, clean and manipulate data. You’ll apply conversion functions and conditional expressions to handle variable data conditions. Analytic queries will introduce you to ranking and calculating running totals, bucketising data, and summarising text. You’ll also learn how to use rollup, cube and grouping sets to produce richer, multi-level summary reports. 

You’ll be creating and altering tables, applying constraints for data accuracy, and working with indexes to improve query performance. You’ll manage sequences for auto-generating keys, create synonyms for simpler referencing, and work with external tables for flexible data loading. You’ll also use Oracle SQL Developer and SQL*Plus to run queries and scripts, navigate the Data Dictionary for metadata, and carry out flashback operations to recover dropped data. Finally, you’ll configure user accounts, assign privileges, and ensure secure access to database objects.