Skip to content
- Explaining the theoretical and physical aspects of a relational database
- Relating clauses in SQL Select Statement to Components of an ERD
- Explaining the relationship between a database and SQL
- Using Column aliases
- Using The SQL SELECT statement
- Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
- Using Arithmetic expressions and NULL values in the SELECT statement
- Applying Rules of precedence for operators in an expression
- Limiting Rows Returned in a SQL Statement
- Using Substitution Variables
- Using the DEFINE and VERIFY commands
- Sorting Data
- Manipulating strings with character functions in SQL SELECT and WHERE clauses
- Performing arithmetic with date data
- Manipulating numbers with the ROUND, TRUNC and MOD functions
- Manipulating dates with the date function
- Applying the NVL, NULLIF, and COALESCE functions to data
- Understanding implicit and explicit data type conversion
- Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
- Nesting multiple functions
- Restricting Group Results
- Creating Groups of Data
- Using Group Functions
- Displaying Data from Multiple Tables
- Using Various Types of Joins
- Using Non equijoins
- Using OUTER joins
- Understanding and Using Cartesian Products
- Using Single Row Subqueries
- Using Multiple Row Subqueries
- Update and delete rows using correlated subqueries
- Matching the SELECT statements
- Using the ORDER BY clause in set operations
- Using The INTERSECT operator
- Using The MINUS operator
- Using The UNION and UNION ALL operators
- Managing Database Transactions
- Controlling transactions
- Perform Insert, Update and Delete operations
- Performing multi table Inserts
- Performing Merge statements
- Managing Indexes
- Managing Synonyms
- Managing Sequences
- Describing and Working with Tables
- Describing and Working with Columns and Data Types
- Creating tables
- Dropping columns and setting column UNUSED
- Truncating tables
- Creating and using Temporary Tables
- Creating and using external tables
- Managing Constraints
- Differentiating system privileges from object privileges
- Granting privileges on tables
- Distinguishing between granting privileges and roles
- Using data dictionary views
- Working with CURRENT_DATE, CURRENT_TIMESTAMP and LOCALTIMESTAMP
- Working with INTERVAL data types
