Oracle Database 12c: SQL Fundamentals

Course details

Introduction:

• Describe the features of Oracle Database 12c 
  
• Describe the salient features of Oracle Cloud 12c 
  
• Explain the theoretical and physical aspects of a relational database 
  
• Describe Oracle server's implementation of RDBMS and object relational database
  

• Explain the capabilities of SQL SELECT statements 
  
• Execute a basic SELECT statement 
  

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 
  

Using Single-Row Functions to Customize Output

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

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 
  

Reporting Aggregated Data Using the Group Functions

• Identify the available 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