Oracle Database 19c: SQL Workshop

• Introduces the command-line interfaces for SQL.

Introduces the graphical user interface for SQL.

• Covers the syntax and use of the SELECT statement to retrieve data from one or more tables.

• Covers the use of WHERE to restrict the rows returned and ORDER BY to sort the results. Also introduces GROUP BY and HAVING clauses to aggregate and filter data.

• Covers the different types of single-row functions in SQL such as numeric, character, and date functions, and how to use them in SELECT statements to manipulate data.

• Joining tables using inner, outer, self and cross joins
• Using the ON clause to specify join conditions
• Using aliases to simplify table names

• Using subqueries to filter data based on criteria
• Using subqueries in SELECT, FROM, WHERE, and HAVING clauses
• Correlated subqueries and their usage

• Using UNION, UNION ALL, INTERSECT, and MINUS operators to combine results
• Applying set operators to queries with different column names and data types

• Inserting data into tables using the INSERT statement
• Updating data in tables using the UPDATE statement
• Deleting data from tables using the DELETE statement

• Creating and modifying tables using CREATE and ALTER statements
• Adding and dropping columns using ALTER statements
• Setting constraints using CONSTRAINT statements

• Understanding the structure and usage of data dictionary views
• Querying data dictionary views to retrieve metadata information about tables, columns, constraints, and indexes

• Creating and using sequences to generate unique values for columns
• Creating and using synonyms to simplify table names
• Creating and using indexes to improve query performance

• Creating and using views to simplify complex queries
• Modifying and dropping views using the CREATE, ALTER, and DROP statements
• Understanding the benefits and limitations of views

• Moving schema objects to different tablespaces using the ALTER statement
• Renaming schema objects using the RENAME statement
• Truncating tables using the TRUNCATE statement

• Using subqueries in the SELECT and FROM clauses to retrieve data
• Using subqueries to calculate aggregates and perform grouping

• Using subqueries in the SET and WHERE clauses to update data
• Using subqueries to delete data from tables based on criteria

• Managing user accounts, roles, and privileges
• Granting and revoking privileges using the GRANT and REVOKE statements
• Understanding the security implications of user access control
  
  

• Using advanced SQL techniques like hierarchical queries, recursive queries, and pivot queries
• Using the MODEL clause to perform complex calculations on data
• Combining multiple queries using the WITH clause

• Understanding the basics of time zones and time zone offsets
• Using the TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE data types
• Converting between different time zones using the TO_TIMESTAMP_TZ and
• FROM_TIMESTAMP_TZ functions

• Recap of the key topics covered in the course
• Future directions for learning and career development in Oracle database management
• Final thoughts and tips for success in working with Oracle databases