-
Notifications
You must be signed in to change notification settings - Fork 21
/
Copy pathlearn_sql.htm
220 lines (166 loc) · 9.11 KB
/
learn_sql.htm
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
<HTML><HEAD><TITLE>Learn SQL - FAQs</TITLE></HEAD>
<BODY bgcolor="#FFFFFF" bgcoloUUUr="#B0D8FF" TEXT="#202020">
<TABLE bgcolor="#FFFFFF" BORDER=0 WIDTH=100%>
<TR>
<TD ALIGN=left VALIGN=top>
<IMG ALT="Database Answers Header" HEIGHT=58 WIDTH=400 SRC="images/dba_400_home.jpg">
</TD>
<TD ALIGN=right VALIGN=top>
<A HREF="http://philip.greenspun.com/photography/" TARGET=_NEW>
<IMG ALT="Cows in Costa Rica" BORDER=0 HEIiiiGHT=98 WIiiiDTH=216 SRC="images/philg/cows-in-costa-rica_sml.jpg"></A>
</TD>
</TR>
</TABLE>
<!--- START OF MAY 21ST. TOP MENU BAR --->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="32" background="images/nav_bg.jpg" align="left" valign="middle">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="1%"><img src="images/spacer.gif" width="15" height="15"></td>
<td WIDTH=4%><A STYLE="text-decoration:none" HREF="index.htm"><font COLOR=yellow FACE=Verdana SIZE=2>Home</font></td>
<td WIDTH=8% wiIIIdth="10%"><A STYLE="text-decoration:none" HREF="pi_ask_a_question/index.asp"><font color="#FFFFFF" FACE=Verdana SIZE=2>
Ask a Question</font></A></td>
<td width="10%"><A STYLE="text-decoration:none" HREF="http://databaseanswers.ning.com/" TARGET=_NEW><font color="#FFFFFF" FACE=Verdana SIZE=2>Community</font></A></td>
<td width="10%"><A STYLE="text-decoration:none" HREF="data_models/index.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Data Models</font></A></td>
<td WIDTH=10%><A STYLE="text-decoration:none" HREF="tutorials.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Tutorials</font></A></td>
<td WIDTH=10%><A STYLE="text-decoration:none" HREF="site_map.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Site Map</font></A></td>
<td align=LEFT WIDTH=10%><A STYLE="text-decoration:none" HREF="about_us.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>About Us</font></A>
</td>
<td ALIGN=LEFT WIDTH=15%><A STYLE="text-decoration:none" HREF="contact_us.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Contact Us</font></A>
</td>
</tr>
</table>
</td>
</tr>
</table>
<!--- END OF MAY 21ST. TOP MENU BAR --->
<!--- START OF PAGE NAME --->
<FONT COLOR=blue FACE="Verdana" SIZE=2>
<TABLE bgcolor="#B0D8FF" BGCOLOuuuR="#98CEFD" BORDER=0 CELLPADDING=5 CELLSPACING=5 WIDTH=100%>
<tr>
<td height="32" background="IIIimages/nav_bg.jpg" align="left" valign=top>
<!-----
<table width="10%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td background="IIIimages/nav_bg.jpg" valign=top width="1%"><img src="images/spacer.gif" width="15" height="15"></td>
<td ALIGN=left background="images/nav_bg.jpg" height="32" width="10%"><PRE><FONT COLOR=yellow coloUUUr="#FFFFFF" FACE=Verdana SIZE=2> How can I learn SQL ? </font>
</td>
</tr>
</table>
-------->
</td>
</tr>
</TABLE>
<!--- END OF PAGE NAME --->
<!----- <FONT COLOR=red FACE="Comic Sans MS" SIZE=4>
<B>How Can I Learn SQL ?</B></FONT>
<P>
------>
<FONT COLOR=blue FACE=Verdana SIZE=2>
<!-- end Standard Header - Version 3-->
<FONT FACE="Verdana" SIZE=2>
<!-- begin body Text -->
<FONT COLOR=blue FACE=Verdana SIZE=2>
<FONT COLOR=blue SIZE=4><B>Here is my Answer to 'How do I learn SQL'</B></FONT>
<BR><B>Feel free to email me on info (at) barryw.org</B>
<BR>
<OL>
<LI>The First Step is to become familiar with <B>the basics of the SQL language</B> :-
<BR><PRE><FONT COLOR=blue SIZE=2>SQL is very powerful because it consists of only 4 statements,
sometimes referred to as CRUD :-
1) Create - INSERT - to store new data
2) Read - SELECT - to retrieve data
3) Update - UPDATE - to change or modify data.
4) Delete - DELETE - delete or remove data
For example, you could create a table of STUDENTS data, then find all the students
from Richmond by saying :-
SELECT first_name, UPPER(last_name) FROM students WHERE address_town = 'Richmond'
ORDER BY last_name;
This would give you, for example :-
Barry WILLIAMS
A CRUD matrix is a table showing which parts of an application contain an
SQL statement, which is a CRUD operation which affects which parts of a database.
</FONT>
</PRE>
<LI>The Second Step is to check out some suggested <B>online Tutorials</B>, and if you have any good or bad
experiences with them, please <A HREF="mailto:info@databaseanswers.com">let us know</A> :-
<OL>
<LI><A HREF="http://dbasupport.com/oracle/ora10g/JustSQL01.shtml" TARGET=_NEW>Getting Started</A>,
published by DBA Support.
<LI><A HREF="http://deal.unl.edu/tutorials/sql/index.html" TARGET=_NEW>MySQL Tutorial from University of Nebraska-Lincoln</A>
<BR>It focusses on <B>MySQ</B>L, which is a popular free version of SQL, but the material presented is still very general.
<LI>
<A HREF="http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html" TARGET=_NEW>MySQL Tutorial from WebMonkey</A>
which also includes a <A HREF="http://hotwired.lycos.com/webmonkey/backend/databases/tutorials/tutorial3.html">
Tutorial on Your First Database Application</A>
<BR><BR>
<LI><A HREF="http://www.sqlclauses.com/" TARGET= NEW><B>SQL Clauses</A> Highly recommended</B>
<BR><BR>
<LI><A HREF="http://www.sqlcourse2.com/" TARGET=_NEW>SQL Course</A> from Internet.Com.
<BR>This has an SQL Interpreter so you can practice what you learn. It also has some useful links.
<LI><A HREF="http://www.inquiry.com/techtips/thesqlpro" TARGET=_NEW>SQL Pro from Development Exchange</A>
<BR>This Site hundreds of Tutorials and fragments of SQL Server Code.
<LI><A HREF="http://www.thunderstone.com/quickref.html" TARGET=_NEW>SQL Quick Reference Site</A>
<BR>Texis WebScript from <A HREF="http://www.thunderstone.com/texis/site/pages" TARGET=_NEW>Thunderstone</A> -
has a Search facility.
<LI><A HREF="http://users.neca.com/ltruett/sql.html" TARGET=_NEW>SQL Reference and Example Site</A>
<BR>A well organised Site from Lawrence Truett that uses a movie database in its examples.
<!---
<LI><A HREF="http://www.ilook.fsnet.co.uk/index/oracle.htm" TARGET=_NEW>SQL Tutorial from Elliott Spencer which explains the basics</A>.
<LI><A HREF="http://w3.one.net/~jhoffman/sqltut.htm" TARGET=_NEW>SQL Tutorial from James Hoffman</A>.
<BR>This is an excellent Tutorial which includes some examples from the real world.
<BR>It also includes a number of very useful links and the author says his course is widely used in database classes.
--->
http://www.1keydata.com/sql/sql.html
<LI><A HREF="http://www.1keydata.com/sql/sql.html" TARGET=_NEW>SQL Tutorial from KeyData.</A> A good basic introduction.
<LI><A HREF="http://jrbnt.vuse.vanderbilt.edu/slides/sql/sld001.htm" TARGET=_NEW>SQL Tutorial from Vanderbilt University.</A>
<BR>Presented as a series of 19 Slides, which contain print-screen shots
showing Tables in Microsoft Access.
<BR>Some of these are large files,(like 144K) and take a long time to download.
<BR>This Tutorial is a step-by-step course on how to use Access.
<BR>Access is an excellent product to learn SQL but it is vendor-specific
<BR>and it lacks many features of other products, such as Oracle and IBM's DB2.
<LI><A HREF="http://www.sql-zone.com/" TARGET=_NEW>SQL Zone</A> - a good place to start for Microsoft SQL Server,
<BR>which also includes a <A HREF="http://www.uml-zone.com/">UML Zone</A>.
</OL>
<BR><BR>
<LI>The Third Step is to become familiar with some SQL Discussion Groups :-
<UL>
<LI>Go to <A HREF="http://www.deja.com/usenet/" TARGET=_NEW>Deja.com</A>
<BR>Check out <A HREF="http://www.deja.com/group/comp.databases" TARGET=_NEW>'comp.databases'</A>,
<BR>where you will find a number of general Groups,
(like <A HREF="http://www.deja.com/group/comp.databases.theory" TARGET=_NEW>comp.databases.theory)</A>,
<BR>and vendor specific ones,
(like <A HREF="http://www.deja.com/group/comp.databases.ibm-db2" TARGET=_NEW>comp.databases.ibm-db2</A>,
and <A HREF="http://www.deja.com/group/comp.databases.oracle.server" TARGET=_NEW>comp.databases.oracle.server</A>, etc).
<BR>Search for SQL and you will get all manner of useful responses.
<BR>On Deja, you can also check out <A HREF="http://www.deja.com/group/alt.comp.databases" TARGET=_NEW>'alt.comp.databases'</A>
<LI><A HREF="http://clubs.yahoo.com/clubs/structuredquerylanguage" TARGET=_NEW>
Yahoo</A> has an SQL Club.
</UL>
</OL>
<BR><IMG SRC="images/barrys_vsml.jpg">
<BR>I hope you enjoyed this page.
<BR>If you have any suggestions for improvements, please email me on info (at) barryw.org</B>
<BR><BR>
</BODY>
<!--- START OF MAY 21ST. BOTTOM MENU BAR --->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="32" background="images/nav_bg.jpg" align="left" valign="middle">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="80%"><img src="images/spacer.gif" width="80" height="15"></td>
<td align=LEFT WIDTH=10%><A STYLE="text-decoration:none" HREF="about_us.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>About Us</font></A>
</td>
<td align=LEFT WIDTH=15%><A STYLE="text-decoration:none" HREF="contact_us.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Contact Us</font></A>
</td>
</tr>
</table>
</td>
</tr>
</table>
<!--- END OF MAY 21st. BOTTOM MENU BAR --->
<CENTER><FONT SIZE=1><I> © Database Answers 2011</I></FONT></CENTER>
</HTML>