• Writing Basic SQL SELECT Statements
• Restricting and Sorting Data
• Single-Row Functions
• Displaying Data from Multiple Tables
• Displaying Data from Multiple Tables
• Aggregating Data Using Group Functions
• Manipulating Data
• Creating and Managing Table
• Including Constraints
• Creating Views
• Other Database Objects
• Controlling User Access
• Using SET Operators
• Enhancements to the GROUP BY Clause
• Extensions to DML and DDL Statements

Programming in PL/SQL

• Creating and Running PL/SQL Code
• Loop Basics
• Exception Handlers
• Strings
• Numbers
• Records
• Data Retrieval
• Procedures, Functions, and Parameters
• Packages
• Triggers

• Writing Basic SQL SELECT Statements
• Restricting and Sorting Data
• Single-Row Functions
• Displaying Data from Multiple Tables
• Displaying Data from Multiple Tables
• Aggregating Data Using Group Functions
• Manipulating Data
• Creating and Managing Table
• Including Constraints
• Creating Views
• Other Database Objects
• Controlling User Access
• Using SET Operators
• Enhancements to the GROUP BY Clause
• Extensions to DML and DDL Statements

Programming in PL/SQL

• Creating and Running PL/SQL Code
• Loop Basics
• Exception Handlers
• Strings
• Numbers
• Records
• Data Retrieval
• Procedures, Functions, and Parameters
• Packages
• Triggers