Course Topics

• RDBMS concepts
• Restricting and Sorting Data
• Using Conversion Functions and Conditional Expressions
• Displaying Data from Multiple Tables
• Using SET Operators
• Managing Indexes Synonyms and Sequences
• Managing Views
• Managing Objects with Data Dictionary Views
• Retrieving Data using the SQL SELECT Statement
• Using Single-Row Functions to Customize Output
• Reporting Aggregated Data Using Group Functions
• Using Subqueries to Solve Queries
• Managing Tables using DML statements
• Use DDL to manage tables and their relationships
• Controlling User Access
• Managing Data in Different Time Zones