Wednesday, November 24, 2010

lecture

Relational databases
Internet vs. World Wide Web

Cartesian product
Select *
From Orders, Customer

then, filter by keys
Select *
From Orders, Customer
Where Orders.CUSID = Customer.CUSID

This is called an Inner Join
alternatively:
SELECT Orders.OrderDate, Orders.Description, Orders.Cost, Customer.FirstName, Customer.LastName
FROM Customer INNER JOIN Orders ON Customer.CUSID = Orders.CUSID;


Internet is connection of computers, or of networks
as opposed to an Intranet

can communicate across the Internet using a protocol
protocol - agreed upon method of communicating

http://en.wikipedia.org/wiki/Hypertext_Transfer_Protocol

HTTP is only ONE protocol that exists on the internet

domain names

No comments:

Post a Comment