Oracle SQL Starting Point

Learn to log into the Oracle SQL database via command prompt, run basic queries, select columns, use aliases and concatenation, handle null values, and perform simple calculations.

Explore row and group functions, character functions such as substr and trim, as well as date and numeric functions, nesting, and related lab exercises.

Explore how to nest functions and apply row and group functions in Oracle SQL, with examples of salary totals and averages, and using group by and having.

Explore joining multiple tables with inner joins and aliases, including non-equal, outer, and self-joins, and cover union, intersect, and exists, including correlated exists in section 4 introduction.

Learn to query multiple tables with union, union all, intersect, and minus, and use subqueries with group by.

Update employee pay and commit changes, then rollback as needed. Create a department and a sequence, build an employee table, insert data using the sequence, and query via a synonym.

From Oracle SQL starting point, end of section 6 exercises teaches building a query to list employees by job type, with comma separated columns and blank lines between jobs.

Install SQL Developer by downloading Windows 64-bit or 32-bit version and accepting license agreement. Connect to a local database, explore the schema, and confirm four records in the department table.