7.3 Create SQL Statements

Watch the Create SQL Statements (3:16) video for details.

Using demo database http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all

And reviewing SQL at

http://www.w3schools.com/sql/default.asp

Create the following SQL statements (be sure to test on the database, and then upload your answers)

List the names of all customers from Germany

Sort all customers by postal code

Change the postal code of all customers in London to WA2 2DP

Imagine a hacker wants to view orders placed by a specific customer; the hacker knows the customer’s name and the “orderdetails” table is visible. Given the schema, how could the hacker create a query to determine orders placed by any specific customer. 

==============================================================================

7.4 Christianity and Computer Science

According to the Bible, what is the central idea and teaching of the commandments? If you could summarize the commandments in a single word (or phrase), what would that be?

Biblical References

• Deuteronomy 6
  Deuteronomy 10
  Mark 10:28-34
  Luke 10:25-37
• If you don’t have a hardcopy Bible, you can access it online here: biblegateway.com