?? wk1rev.htm
字號:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"><HTML><HEAD> <TITLE>Teach Yourself SQL in 21 Days, Second Edition -- Week 1 In Review</TITLE></HEAD><BODY TEXT="#000000" BGCOLOR="#FFFFFF"><CENTER><H1><IMG SRC="../buttonart/sams.gif" WIDTH="171" HEIGHT="66" ALIGN="BOTTOM" BORDER="0"><BR><FONT COLOR="#000077">Teach Yourself SQL in 21 Days, Second Edition</FONT></H1></CENTER><CENTER><P><A HREF="../ch07/ch07.htm"><IMG SRC="../buttonart/previous.gif" WIDTH="128" HEIGHT="28"ALIGN="BOTTOM" ALT="Previous chapter" BORDER="0"></A><A HREF="../wk2ag/wk2ag.htm"><IMGSRC="../buttonart/next.gif" WIDTH="128" HEIGHT="28" ALIGN="BOTTOM" ALT="Next chapter"BORDER="0"></A><A HREF="../index.htm"><IMG SRC="../buttonart/contents.gif" WIDTH="128"HEIGHT="28" ALIGN="BOTTOM" ALT="Contents" BORDER="0"></A> <HR></CENTER><CENTER><H1><FONT COLOR="#000077">Week 1 In Review</FONT></H1></CENTER><P>After setting the stage with a quick survey of database history and theory, Week1 moved right into the heart of SQL with the <TT>SELECT</TT> statement. The followingsummary of the <TT>SELECT</TT> statement syntax includes cross-references to thedays on which the particular aspect was covered:<UL> <LI><TT>SELECT [DISTINCT | ALL]</TT> (Day 2)--Columns (Day 1), Functions (Day 4) <P> <LI><TT>FROM</TT> (Day 2)--Tables or Views (Day 1), Aggregate Functions (Day 4) <P> <LI><TT>WHERE</TT> (Day 5)--Condition (Day 3), Join (Day 6), Subquery (Day 7) <P> <LI><TT>GROUP BY</TT> (Day 5)--Columns (Day 3) <P> <LI><TT>HAVING</TT> (Day 5)--Aggregate Function (Day 4) <P> <LI><TT>UNION | INTERSECT</TT> (Day 3)--(Placed between two <TT>SELECT</TT> statements) <P> <LI><TT>ORDER BY</TT> (Day 5)--Columns (Day 1)</UL><P>If you build a million queries in your programming career, more than 80 percentof them will begin with <TT>SELECT</TT>. The other 20 percent will fall into thecategories covered in Week 2.<H2><FONT COLOR="#000077">Preview</FONT></H2><P>The new skills you learn in Week 2 cover database administration. During Week2 you will learn how to<UL> <LI>Create and destroy tables <P> <LI>Assign permissions to your friends and prevent your enemies from even looking at your data <P> <LI>Update and delete data in tables</UL><H1></H1><CENTER><P><HR><A HREF="../ch07/ch07.htm"><IMG SRC="../buttonart/previous.gif" WIDTH="128" HEIGHT="28"ALIGN="BOTTOM" ALT="Previous chapter" BORDER="0"></A><A HREF="../wk2ag/wk2ag.htm"><IMGSRC="../buttonart/next.gif" WIDTH="128" HEIGHT="28" ALIGN="BOTTOM" ALT="Next chapter"BORDER="0"></A><A HREF="../index.htm"><IMG SRC="../buttonart/contents.gif" WIDTH="128"HEIGHT="28" ALIGN="BOTTOM" ALT="Contents" BORDER="0"></A><BR><BR><BR><IMG SRC="../buttonart/corp.gif" WIDTH="284" HEIGHT="45" ALIGN="BOTTOM" ALT="Macmillan Computer Publishing USA"BORDER="0"></P><P>© <A HREF="../copy.htm">Copyright</A>, Macmillan Computer Publishing. Allrights reserved.</CENTER></BODY></HTML>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -