WEB INTERFACE AND TUTORIAL FOR SQL

Posted by Anonymous 0 komentar

Download SQL Tutorial. The exercise mode of the web interface supports hands-on exercises for SQL. Please refer to the exercise sheets to find out more about the data sets that are available. As soon as you are connected, the page ‘SQL Query Input’ will be presented as shown in Figure 1. It provides the following options:

Run queries: Type in the query in the text field and press the EXECUTE QUERY button. This will result in page ‘Query Result’ (see Figure 1) which contains the result table for your query. Press the BACK button to go to page ‘SQL Query Input’. On this page you may use RESET to clean the text field. Some links are provided at the top of the page. They allow to refer to queries you have previously executed in the current session. Use the DELETE QUERIES/PLANS button to remove this list.
Show access plan: Type in the query in the text field and press the SHOW PLAN button. This will result in page ‘Access Plan’, which shows the access plan chosen by the DB2 optimizer. Press the BACK button to go to page ‘SQL Query Input’.
Show schema information: Pressing the SCHEMA INFO button results in an additional window ‘Schema Information’ with some information on the objects currently available in your database schema. This covers tables, columns, indexes, and triggers. You may keep this second window open while you work with the web interface. Press the refresh button of your web browser in the schema information window each time you want to ensure that the current information on the schema is provided. The BACK button allows to close the additional window for schema information.
Close session: Use the NEW CONNECTION or the QUIT button in order to close your session. Please do not only close your browser window. With the NEW CONNECTION button you return to the page ‘SQL Query Input’ whereas QUIT also closes the browser window.

Download SQL Tutorial