Schema Builder allows you to define the tables, views, snapshots, synonyms, constraints, and table relationships that will make up your database. You can visualize your database design, including the tables, columns, data types, and relationships, and then execute that design.

Query Builder will facilitate you to write “SQL” code by providing a visual interface to the database objects being linked.

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.

Open the “Schema Builder” tool.

Login as “iself” password “schooling,” and click on “connect.”

Click on the “OK” button.

Maximize the window.

Choose the “Schema” option, select “Create Table”, then click on ”Table.”

Drag your “plus sign” cursor and release it.

Resize your object.

Choose the “Data” option and click on “Rename Table.”

Change the “Table1” name to “Students,” and then click  “OK” to rename the table.

Double click on the plus sign to add new columns.

Type “Student_id;” its column attributes; and make it a Primary Key.

Click on "new column."

Type "first_name," its column attributes; and make it a required field.

Click on "new column."

Type "last_name," its column attributes; and make it a required field.

Click on "new column."

Type "ssn" for social security number, its column attributes; and make it an unique key.

Click “OK.”

This is the table that will be created.

Choose the "schema” option, and click on "Show SQL."

Here is your “create table” statement.

Click on “COMMIT” to create the table, and then

Close the window.

Now, the table was created.

Choose the "File" option, and click on "Set privileges.”

Assign the “Students” table to the public.

Give select and insert privileges to the public.

Click on "apply," and then close the window.

Now, the public users can only “insert” and “select” from the table.

Now, lets drop the table.

Choose the “Schema" option and click on “Remove.”

The gray color indicates the object was removed.

Exit from “schema builder," and Click on "yes" to commit changes.

Now, you should practice this over and over, until you become a master at it.

Good Luck!