Fundamental Database |
Creating Tables & Constraints |
Retrieving Data Using the SQL SELECT Statement |
Restricting and Sorting Data |
Row Functions to Customize Output |
Reporting Aggregated Data Using the Group Functions |
Displaying Data from Multiple Tables |
Displaying Data from Multiple Tables |
Using Subqueries to Solve Queries |
Control transactions |
Creating Other Schema Objects |
Managing Objects with Data Dictionary Views |
Controlling User Access |
Managing Schema Objects |
Manipulating Large Data Sets |
Generating Reports by Grouping Related Data |
Managing Data in Different Time Zones |
Hierarchical Retrieval |
Regular Expression Support |
Exam |