Welcome to the Additional Practice Section of OracleCoach.com. This section is dedicated to providing you with additional practice exercises for many of the Oracle topics that have been taught via the website. It will give you an opportunity to put your newly acquired skills to the test or just simply test your knowledge of Oracle database topics. By doing more and more practice you will gain a firm understanding of the basics as well as master concepts.

If you like this page, please select the +1 button ....

Additional Practice in Structured Query Language

Creating and Altering Tables                                                    (Learn about Creating and Altering tables)

Manipulate Data in a Table (Insert, Update, Delete)               (Learn about Manipulating Data in a Table)

Querying Data in a Table                                                          (Learn about Querying Data in a Table)

Joining Data from multiple tables                                            (Learn about Joining Data)

Additional Practice in PL/SQL (Coming Soon)

Declaring and Using Scalar Variables                                        (Learn PL/SQL programming)

Querying Data and Data Manipulation                                     

Conditional Statements (IF, IF..ELSE, IF..ELSIF, CASE)

Implicit and Explicit Cursors

%Rowtype Attribute

Exception Section (Coming Soon)

Additional Practice in User Management 

Managing Users, System Privileges, Object Privileges and Roles            (Learn User Management)

Additional Practice in Oracle Database Administration (Coming Soon)

Additional Practice in Backup and Recovery (Coming Soon)

Additional Practice in Recovery Manager (Coming Soon)

Additional Practice in Oracle Networking (Coming Soon)

Additional Practice in Tuning an Oracle Database (Coming Soon)