Oracle Cloud: Basic Oracle SQL with hands on Experience

Learn the basics of SQL, the structured query language used to retrieve and modify data in relational databases, run queries, filter results, and create or alter tables, with hands-on demos.

Create and name database tables with columns and rows to store data, such as employee, department, and job tables, then use SQL to select and filter data from these tables.

Explore essential Oracle SQL data types and how to assign them to each column during table creation, using examples of number, varchar2, and date to ensure data integrity.

Create and configure a new database connection using the connections panel, supplying a connection name, user credentials, and host, port, and service details to access the HR schema.

Explore how to quickly filter and locate specific database objects in Oracle, using name filters, case sensitivity, and object type like tables to view structure and columns.

Learn to navigate SQL Developer tabs, open multiple worksheet tabs, and run simple queries against employees and departments tables, with each tab linked to a database connection.

Learn to view query output in Oracle SQL, including column headers, retrieved rows, and execution time, with options to scroll, refresh, and inspect the exact SQL used.

Learn that SQL keywords and Oracle table names are case-insensitive by default, allowing commands in any case, while string value filtering can be case-sensitive; explore editor features to switch case.

Learn the difference between grid output and plaintext script output in SQL queries, and how the same results appear in the grid tab versus the transcript button's plaintext output.

Learn to filter data in Oracle SQL using multiple where conditions, including department ID, and combining criteria with and and or. Use parentheses to group filters and refine results.

Filter employee data with where in to match multiple string job IDs, such as the ADP or IT program IDs, and select first name, last name, and job id.

Learn to use where in and not in with numeric values in Oracle SQL to filter by department and school id, returning names, departments, and schools.

Filter rows by the hired date using where with to_date and a date format mask to retrieve employees hired after January 1, 2000.

Use distinct in a SQL select to filter duplicates and display unique department ids from the employees table; apply distinct to single or multiple columns to refine results.

Apply column aliases in Oracle SQL to label calculated and existing columns, using as and quotes for spaces to produce legible output such as salary after bonus.

Use the substring function to truncate long job title values by specifying a start position and length. Return the first five or fifteen characters to format query output.

Learn to use the length function in Oracle SQL to measure string characters and include the resulting lengths of employee first and last name columns in your query outputs.

Explore Oracle sql padding with lpad and rpad to fix first name lengths. See how left and right padding with characters like stars creates consistent results.

Apply the to_char function to format date values in Oracle SQL, using a formatting mask to display month names or numbers, day, and year.

Learn to use to_char to filter date values by month in Oracle SQL. Extract the month from hire_date to select employees hired in January, and compare month name or number.

Discover how the Oracle dual table lets you return literal values from a single row, perform simple selects, and apply functions such as uppercase to hello world.

Learn to add months to a date with the add_months function in Oracle SQL. Use the date as the first argument and the number of months as the second.

Learn to combine data from two tables using sql joins, linking employee and department data to display employee id, name, and department name, and understand left, right, and full joins.

Learn how to join the employees and department tables on department_id to display employees' first and last names with their actual department names, clarifying normalization.

Explore inner join concepts by joining employees and departments on department_id to return records with matching values in both tables, the default behavior when no join type is specified.

Use table aliases in joins to reference columns such as first_name and department_name from employers and departments, and join on department_id to get the expected result.

Learn to create a simple table in Oracle SQL and insert new records by defining column names and data types, then verify results by querying the empty table.

Use insert into to add new rows with string and numeric values, verify results with select, and learn inserting with specified column lists and handling nulls for omitted columns.

Learn how commit and rollback control database transactions, making changes persistent or undoing them. Each action is an autonomous unit of work you complete with commit or rollback.

Explore how a transaction, an autonomous unit of work, controls the end state of data modifications in Oracle SQL, using commit to make changes persistent and rollback to undo.

Learn to delete rows using the DML delete command in Oracle SQL, with where clauses, examples for single or multiple rows, and rollback options to undo changes.

Truncating a table is a data definition command that deletes all rows quickly, cannot be rolled back, reduces storage on tables, and is efficient for large tables when purging data.

Explore how to use group by with max, min, and avg to analyze department salaries, round results, alias columns, and order output for clear, readable insights.

Learn how subqueries in Oracle SQL fetch data by using inner queries, inline view, and placing them in the from or where clause.