This course is a common starting point for administrators, developers, and business users. The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database.
Course Objectives
This course covers the following elements:
- Relational databases & SQL
- Use SQL *Plus
- Building select statements
- Build where clauses
- Order table results
- Pseudo columns & functions
- Utilizing joining tables
- Using set operators
- Utilizing summary functions
- Using sub queries
- Creating and selecting groups
- Using SQL *Plus reports
- Building simple SQL *Plus reports
- Using SQL data definition languages
- Utilizing SQL data manipulation language
Course Benefits
Upon successful completion students will be able to:
- Understand relational databases and SQL syntax
- Understand elements of SQL
- Use SQL *Plus
- Use the MS Windows SQL *Plus tool
- Use the iSQL *Plus web tool
- Enter commands & syntax
- Understand the select statement
- Understand select columns
- Use alias names
- Understand logical operators
- Understand equality operator
- Understand boolean operators
- Understand null and between operators
- Find text strings
- Understand in operator
- Understand the order by clause
- Utilize multiple column sorts
- Specify the sort sequence
- Understand null values within sorts
- Use columns aliases
- Understand pseudo column and functions
- Use rowid
- Use rownum
- Use the functions
- Use the dual table
- Utilize the sessiontimezone function
- Utilize joins
- Utilize inner joins
- Utilize reflexive joins
- Utilize non-key joins
- Utilize outer join
- Understand the set operators
- Set operator examples
- Summary functions
- Utilize summary functions
- Understand sub queries
- Utilize standard sub queries
- Utilize correlated sub queries
- Understand summary groups
- Find groups within base tables
- Select data from the base tables
- Select groups from the result table
- Utilize the SQL *Plus command
- Understand script files
- Invoke operating system commands
- Save session output
- Understand the SQL *Plus report features
- Understand session output with set
- Format column output with column
- Define report breaks with break
- Produce subtotals with compute
- Understand SQL DDL
- Create table statement
- Alter table statements
- Drop table statements
- Utilize supportive statements
- Understand SQL DML
- Utilize SQL data manipulation language
- Understand insert statements
- Understand the delete statements
- Understand the update statement
- Understand transactions
- Utilize truncate tables