connection information (ip, port, username, password). Click “Test Connection”to check if the connection works well, then click OK to save the new connection.
-From the Home screen, click the connection you defined in the previous step -Once connected, you work with the server by writing SQL statements, in the query panel. To run a single statement, just select it, and press “Ctrl + Enter”or click button on the tool box.
II.Getting started with SQL statements1.Write a SQL statement to create a new database name “Company”. 2.Write a SQL statement to create to set the default working database to “Company”. 3.Write SQL statements to define tables of “Company”databases with contraints and columns illustrated by igures below. You should determine appropriate datatype for each column. 4.Add column Partner_ssn to the table EMPLOYEE. This column indicates the SSN of spouse of each employee. For those who are now single, the value should be NULL. 5.Write SQL statements to insert sample rows to these tables. 6.Write SQL statements to delete the tables you created.