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
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.
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?
- Deuteronomy 6
- If you don’t have a hardcopy Bible, you can access it online here: biblegateway.com