Oracle SQL Starting Point

Start with section 1 of Oracle SQL starting point, a getting started guide offering a quick refresher on relational databases and what they are.

Explore relational database constructs—tables, columns, rows, and keys including primary and foreign keys—and how they relate. Master relational operations like select, project, join, and union to query data.

Relational databases store data as tables accessible by name, enforce unique primary keys, and use sql to partition and join relations while allowing easy structure modification.

Explore section 2 concepts in Oracle SQL, including data definition language basics, selecting columns, column aliases, concatenation, handling duplicate rows, and applying logical and comparison operators for restrictions.

Explore the Oracle SQL starting point by learning how to query the database to retrieve data and how to modify, insert, or remove data, plus using DDL and DML commands.

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.

Learn to remove duplicates with distinct, sort results with order by, and filter data using where with between, in, like, and not in or not between.

Explore how the where clause handles multiple conditions with and and or, and use parentheses to control operator precedence in Oracle SQL queries.

Master basic Oracle SQL queries, including select with distinct, where and order by clauses, plus column aliases, while learning to edit, save, load, and execute in the SQL buffer.

Practice Oracle SQL end of section 2 lab exercises, performing salary range filters, clerks in department 20, name-salary queries, and ranking employees by salary with salary versus commission checks.

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 row and group functions in Oracle SQL, including grouping data and core string operations like substring, trim, lower, upper, lpad, length, translate, and replace, and the dual table.

Discover Oracle SQL starting point with row and group functions. Learn numeric operations like round, truncate, sign, floor, ceiling, mod, plus date arithmetic and months between.

Explore data type conversion and formatting in Oracle SQL, including to_char, to_number, to_date, and date formats, with decode, greatest, and least supporting conditional logic in row and group contexts.

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 end of section 3 lab exercises in Oracle SQL starting point: apply a 15% raise with floor rounding, format names, and compute max, min, and average salaries.

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.

Discover how to query data from multiple tables using joins, including cartesian and equal joins, outer and self-joins, with table aliases and precise join conditions.

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

Explore correlated subqueries that execute once per outer row, using inner query values to include or exclude candidates, with exists and not exists, exemplified by employees’ salaries vs department averages.

Compose SQL queries to list employees with department name, number, location, salaries and salary grades; display departments with no employees, managers, and the highest salary per job, using union.

In section 5 on modifying data and the database, learn to insert, update, and delete data, manage commit and rollback, and use ddl with tables, indexes, views, and sequences.

Modify data using DML operations such as insert, update, and delete, and clear tables with truncate, while also using DDL to alter structures like tables, views, and indexes.

Explore transaction processing in Oracle SQL starting point, ensuring data consistency through commit, rollback, and savepoint controls while learning DML and DDL operations like create, alter, and drop.

Explore how to modify data and database structures using ddl indexes, create and use unique and composite indexes, work with synonyms and grants, and implement views and sequences.

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.

Expand section 6 by covering working with tables, saving output to a file, and installing Oracle software with a test database and secure developer overview.

Explore SQL plus basics, including substitution variables with single and double ampersand, and use basic reporting features such as titles, break points, and spooling output to a file.

Explore Oracle SQL Developer, the free tool formerly known as Project Repertoire, with GUI object browser for creation, deletion, and alteration of objects, plus debugging with breakpoints and multiple connections.

Explore the SQL developer interface: execute single or multiple statements, run scripts, view results, browse objects via the navigator, modify tables, export data, manage indexing, and gather statistics.

Explore Oracle SQL developer overview part 3: create and modify tables, views, materialized views, and secured objects; manage schemas, packages, procedures, and triggers; use debugging features like breakpoints and watches.

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 Oracle software on Windows, download and sign the agreement, then create a database directory and run setup to complete a basic test database with standard data.

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.