| 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 |