Introduction: General Front-end and Back-end tools introduction

Note on the important definitions to remember  

Hands-On 01: Introduction to Schema Builder

In this Hands-On, you will learn how to: 

Create the "students" table,

Define columns, Define attributes, Define Primary key,

Define require field, Define Unique Key,

Grant Privileges to public,

Check what other users can access,

Remove table, and

Check table access.  

Hands-On 02: Introduction to Query Builder

In this Hands-On, you will learn how to: 

Create a query,

Join Multiple tables (the "dept" table and the "emp" table),

Set table relationship,

Execute Query,

Sort query,

Add where clause condition,

Listing query, and

Saving query.  

Hands-On 03: Introduction to Procedure Builder

In this Hands-On, you will learn how to: 

Creating PL/SQL Procedure using Procedure Builder,

Add a record into the "dept" table using PL/SQL.  

Hands-On 04: Introduction to Form Builder

In this Hands-On, you learn how to: 

Create a Datablock for the "Customer" table,

Create a layout, Use "content" canvas,

Use "execute query",

Navigate a table, Use next, previous record,

Enter query,

Manipulate table's record, Insert, Update, Delete and

Save record.  

Hands-On 05: Introduction to Report Builder

In this Hands-On, you will learn how to: 

Use report wizard,

Use object navigator,

Use report builder,

Save report,

Use "data model",

Use property palette,

Work on query and group box,

Change report style and use tabular style,

Navigating through report's record, and

Change the format mask for dollar, numeric and date items.  

Hands-On 06: Introduction to Graphics Builder

In this Hands-On, you learn how to: 

Create a chart,

Write a query,

Execute a query,

Modify a query, and

Save a chart