wk3ag.htm
来自「Learn SQL in an easy way...」· HTM 代码 · 共 65 行
HTM
65 行
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"><HTML><HEAD> <TITLE>Teach Yourself SQL in 21 Days, Second Edition -- Week 3 At A Glance </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="../wk2rev/wk2rev.htm"><IMG SRC="../buttonart/previous.gif" WIDTH="128"HEIGHT="28" ALIGN="BOTTOM" ALT="Previous chapter" BORDER="0"></A><A HREF="../ch15/ch15.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 3 At A Glance</FONT></H1></CENTER><H2><FONT COLOR="#000077">Applying Your Knowledge of SQL</FONT></H2><P>Welcome to Week 3. So far you have learned the fundamentals of SQL and alreadyknow enough to apply what you have learned to some real-life situations. This weekbuilds on the foundation established in Weeks 1 and 2. Day 15 shows you how to streamlineSQL statements for improved performance. Day 16 talks about the data dictionary,or system catalog, of a relational database and shows you how to retrieve valuableinformation. Day 17 extends the concept of using the data dictionary to generateSQL as output from another SQL statement. You will learn the benefits of this techniqueand discover how generating SQL can improve your efficiency on the job. Day 18 coversOracle's PL/SQL, or Oracle procedural language. PL/SQL is one of the many extensionsto standard SQL. Another extension is Sybase's and Microsoft Server's Transact-SQL,which is covered on Day 19. Day 20 returns to Oracle to cover SQL*Plus, which allowsyou to use advanced commands to communicate with the database. SQL*Plus also enablesyou to format query-generated reports in an attractive manner. You can use SQL*Plusin collaboration with PL/SQL. Day 21 examines errors and logical mistakes that relationaldatabase users frequently encounter. We provide brief descriptions of the errors,solutions, and tips on avoiding errors.</P><CENTER><P><HR><A HREF="../wk2rev/wk2rev.htm"><IMG SRC="../buttonart/previous.gif" WIDTH="128" HEIGHT="28"ALIGN="BOTTOM" ALT="Previous chapter" BORDER="0"></A><A HREF="../ch15/ch15.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 + =
减小字号Ctrl + -
显示快捷键?