www.sqlzoo.net - sqlzoo

last data update: 2011/10/14, 06:45

Server
DNS
Domain
Map
Valuation
Content

Website loading time

during the test: 0.43 s

cable connection (average): 0.47 s

DSL connection (average): 0.52 s

modem (average): 2.89 s

HTTP headers

HTTP/1.1 200 OK

Date: Fri, 14 Oct 2011 13:47:12 GMT

Server: Apache/2.2.17 (Fedora)

Last-Modified: Mon, 11 Apr 2011 07:39:35 GMT

ETag: "1800ca-44e7-4a09fad5891a0"

Accept-Ranges: bytes

Content-Length: 17639

Connection: close

Content-Type: text/html; charset=UTF-8

Information about DNS servers

sqlzoo.net

146.176.166.2

38490

Received from the first DNS server

Request to the server "sqlzoo.net"
You used the following DNS server:
DNS Name: ns1.leaseweb.nl
DNS Server Address: 62.212.64.121#53
DNS server aliases:

HEADER opcode: REQUEST, status: NOERROR, id: 33251
flag: qr rd REQUEST: 1, ANSWER: 0, AUTHORITY: 0, ADDITIONAL: 0

REQUEST SECTION:
sqlzoo.net. IN ANY

Received 28 bytes from address 62.212.64.121#53 in 84 ms

Received from the second DNS server

Request to the server "sqlzoo.net"
You used the following DNS server:
DNS Name: ns5.leaseweb.nl
DNS Server Address: 83.149.64.123#53
DNS server aliases:

HEADER opcode: REQUEST, status: NOERROR, id: 3560
flag: qr rd REQUEST: 1, ANSWER: 0, AUTHORITY: 0, ADDITIONAL: 0

REQUEST SECTION:
sqlzoo.net. IN ANY

Received 28 bytes from address 83.149.64.123#53 in 84 ms

Subdomains (the first 50)

Typos (misspells)

aqlzoo.net
zqlzoo.net
xqlzoo.net
dqlzoo.net
eqlzoo.net
wqlzoo.net
s1lzoo.net
s2lzoo.net
swlzoo.net
salzoo.net
sqkzoo.net
sqpzoo.net
sqozoo.net
sqlxoo.net
sqlsoo.net

sqlaoo.net
sqlzio.net
sqlzko.net
sqlzlo.net
sqlzpo.net
sqlz0o.net
sqlz9o.net
sqlzoi.net
sqlzok.net
sqlzol.net
sqlzop.net
sqlzo0.net
sqlzo9.net
qlzoo.net
slzoo.net

sqzoo.net
sqloo.net
sqlzo.net
sqlzo.net
qslzoo.net
slqzoo.net
sqzloo.net
sqlozo.net
sqlzoo.net
ssqlzoo.net
sqqlzoo.net
sqllzoo.net
sqlzzoo.net
sqlzooo.net
sqlzooo.net

Location

IP: 146.176.166.2

continent: EU, country: United Kingdom (GBR), city:

Website value

rank in the traffic statistics: 147 154

page wievs - daily average: 643

page views - monthly average: 19 277

visitors - daily average during last 30 days: 212

visitors during last 30 days: 6 362

estimated daily income from ads: 29 USD

estimated monthly income from ads: 859 USD

estimated website value: 27 001 USD

Basic information

website build using CSS

code weight: 17.23 KB

text per all code ratio: 25 %

title:

description:

keywords: SQL, tutorial, learn, database, relational database, structured query language, interactive, MySQL, SQL Server, Oracle, Access db2

encoding: UTF-8

language: en

Website code analysis

one word phrases repeated minimum three times

Phrase	Quantity
to	22
and	21
the	18
SQL	18
of	16
How	12
SELECT	9
in	8
we	7
JOIN	7
population	7
which	7
In	7
bbc	6
WHERE	6
area	6
FROM	6
SELECT:	5
with	5
name,	5
using	4
for	4
from	3
country	3
Answers	3
data	3
get	3
other	3
join	3

two word phrases repeated minimum three times

Phrase	Quantity
How to	12
In which	7
which we	7
bbc WHERE	6
FROM bbc	6
SELECT name,	4
of the	4
area of	3
we join	3

three word phrases repeated minimum three times

Phrase	Quantity
In which we	7
FROM bbc WHERE	6
which we join	3

B tags

Zoo tutorials:

0) SELECT:

1) SELECT:

3) SUM and COUNT:

4) The JOIN operation:

5) More JOIN operations:

6) Using Null:

7) Self join:

SQL User Manuals

Starting SQL

Programming with SQL

SQL standard

Error Messages

U tags

I tags

images

file name	alternative text
sqlhacks.gif	SQL Hacks Book Cover

headers

Population of more than 200 million.

Twice the area of India.

Population of more than 200 million.

Twice the area of India.

internal links

address	anchor text
http://sqlzoo.net	SQL
select.htm	SELECT
lfun.htm	FUNCTIONS
select_where.htm	SELECT WHERE
select_join.htm	SELECT JOIN
select_select.htm	SELECT SELECT
insert.htm	INSERT VALUES
insert_select.htm	INSERT SELECT
update.htm	UPDATE
delete.htm	DELETE
create.htm	CREATE TABLE
create_view.htm	CREATE VIEW
create_index.htm	CREATE INDEX
drop.htm	DROP
alter_table.htm	ALTER TABLE
0.htm	SELECT:
1.htm	SELECT:
1b.htm	More practice with SELECT:
1a.htm	SELECT in SELECT:
2.htm	SUM and COUNT:
2b.htm	more the same
3b.htm	The JOIN operation:
3a.htm	music tutorial
3.htm	More JOIN operations:
4a.htm	Using Null:
4.htm	Scottish Paliament
6.htm	Self join:
commysql.htm	MySQL
comoracle.htm	Oracle
comsqlserver.htm	SQL Server
comdb2.htm	DB2
compost.htm	Postgres
comingres.htm	Ingres
web.htm	SQL in perl on the Web
java.htm	SQL from Java
http://sqlzoo.net/sql92.html	SQL92 BNF
1.htm?answer=1	SELECT
1a.htm?answer=1	SELECT in SELECT
2.htm?answer=1	SUM and COUNT
3b.htm?answer=1	JOIN I
3.htm?answer=1	JOIN II
4a.htm?answer=1	OUTER JOIN (teachers)
4.htm?answer=1	OUTER JOIN (Parliament)
5.htm?answer=1	ACME
6.htm?answer=1	SELF JOIN
7.htm?answer=1	Top of the Pops
a6.htm	AdventureWorks
a1.htm	Neeps
a2.htm	Musicians
a3.htm	Southwind
a4.htm	Dressmaker
a5.htm	Congestion Charging
b5.htm	old questions
/big/album.txt	Album
/big/track.txt	Tracks
/big/style.txt	Style
/hack/	Exploit SQL Injection Attack
w.htm	What is SQL?
h.htm	About SQLzoo.
say.htm	How to say SQL.
7.htm	Top of the Pops: using dates
5.htm	ACME products: dealing with money.
e1.htm	Thrice Unfactorised Enigma
http://sqlzoo.net/jp/	SQLzoo in Japanese 日本語

external links

address	anchor text
http://sqlzoo.cn	SQLzoo.cn
http://linuxzoo.net	Linux
http://progzoo.net	Java
http://xmlzoo.net	XML
http://www.oreilly.com/catalog/sqlhks/	SQL Hacks Book Cover
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp	DB2
http://sybooks.sybase.com/onlinebooks/group-as/asg1251e/commands/@Generic__BookTextView/704;hf=0#X	Sybase
http://www.postgresql.org/docs/8.2/interactive/index.html	Postgres
http://www.sqlite.org/lang.html	SQLite
http://www.met-office.gov.uk/climate/uk/stationdata/southamptondata.txt	Weather data for Southhampton
http://db.grussell.org	Relational Database Theory
http://db.grussell.org/mc	quiz
http://sqlzoo.de	SQLzoo in German
http://www.dcs.napier.ac.uk/~andrew/	Andrew Cumming
http://www.soc.napier.ac.uk/	School of Computing
http://www.napier.ac.uk/	Napier University

domstat.net

sqlzoo.net

MENU