Query Builder facilitates you to write your simple or complex query.  You can save your query at your client-side.  It allows you to set your table relationships and visualize your database objects that being linked, including the tables, columns, and datatypes.

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, Saving query.

 

	More Resources by Google:

Open the “Query Builder” tool.

Login as “iself” password schooling, and then click “CONNECT.”

Click on the “OK” button.

Click "OK" to create new query.

Select the "department" table and then click on “include.”

Select the “Employee” table and click on “include.”

Close the window.

Maximize the "Query Builder" window.

Click on the "set table relationship” icon.

Type “dept.deptno” the department number of the department table on the "A" box; and “emp.deptno” the department number of the employee table on the "B" box.

Then Click "OK."

Select the department name column, the employee name column and the salary column.

Click on the “Show SQL” icon.

Notice:  The “where” clause in the sql statement.

Click "execute."

Check the output.

Click on the "department name" column.

Choose the "sort ascending” icon; and then go to the “Show SQL” window and execute the query.  Table was sorted.

Close the window.

Click on the condition box and

add a “where” clause to display all the employees of the sales department whom their salaries are more than 2000.

Press the enter key.

Click on the “Show SQL” icon.

Notice:  The where clause condition were added to the “sql” statement.

Execute the statement.

Check the output and close the “Show SQL” window.

Click on the “Query” window; and then

choose the “File” option and click on “Save as” or “Save” to save the query in the “iself” folder.

Click “OK.”

Name the file “emp_salary” and click on “Save;” and exit From “Query Builder.”

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

Good Luck.