Oracle SQL Fundamentals.

Oracle Database SQL Fundamentals

Restricting and Sorting Data

• Limit the rows that are retrieved by a query
• Sort the rows that are retrieved by a query
• Use ampersand substitution to restrict and sort output at runtime
• Use SQL row limiting clause

Using Conversion Functions and Conditional Expressions

• Describe various types of conversion functions that are available in SQL
• Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
• Apply conditional expressions in a SELECT statement

Displaying Data From Multiple Tables Using Joins

• Use SELECT statements to access data from more than one table using equijoins and nonequijoins
• Join a table to itself by using a self-join
• View data that generally does not meet a join condition by using OUTER joins

Managing Tables using DML statements

• Insert rows into a table
• Update rows in a table
• Delete rows from a table
• Control transactions

Retrieving Data using the SQL SELECT Statement


• Execute a basic SELECT statement

Using Single-Row Functions to Customize Output

• Describe various types of functions available in SQL
• Use character, number, and date functions in SELECT statements

Reporting Aggregated Data Using the Group Functions

• Describe the use of group functions
• Group data by using the GROUP BY clause
• Include or exclude grouped rows by using the HAVING clause

Using Subqueries to Solve Queries

• Define subqueries
• Describe the types of problems that the subqueries can solve
• Describe the types of subqueries
• Use single-row and multiple-row subqueries
• Use a set operator to combine multiple queries into a single query
• Control the order of rows returned

Introduction to Data Definition Language

• Describe the data types that are available for columns
• Create a simple table
• Create constraints for tables
• Describe how schema objects work