CST 363 Week 3

• What is an SQL view. How is it similar to a table? In what ways is it different (think about primary keys, insert, update, delete operations) ?

a sql view is a temporary table that is built from the results of a select query and can be used similarly to a regular table with some differences. A few limitations of a view table is that there is no data stored to the table itself, as the table is created only from retrieved information. Additionally there is no primary key functionality.

• We have completed our study of SQL for this course. This is not to imply that we have studied everything in the language. There are many specialized features such as calculating rolling averages, query of spatial data (data with latitude and longitude) coordinates, and more. But take a minute to think about how SQL compares to other programming languages such as Java. What features are similar , and which are present in one language but not in the other? For example, Java has conditional if statements which are similar to SQL WHERE predicates, the SELECT clause is similar to a RETURN statement in that it specifies what data or expression values are to be returned in the query result (although it is strange that a statement should specify the RETURN as the first part of a SELECT.

The two languages are very different and are used for different things. while some of thier syntax my seem reminiscent to each others, SQL is build for the manipulation and retrieval of information from a database where as Java is used to build and design programs. Some of the operations found in the two do work off of similar logic. Both languages can use logical operators such as < > and = to achieve goals.