HTMLLearn.exeactive~1.msiDatabase.htmcs668f2000.htmCar.sqllec1.htmconstructs.sqlloops.sqltypeconversions.txtcursors.htmcursor.sqlexceptions.htmexcepts.sqlPROCEDURES.htmPACKAGES.htmTRIGGERS.htmtables.htmObjectType.htmlSimpleJDBC.txtsearchscreen.htmCustomerScreen.htmSearchCode.htmCustomerDisplayCode.htmas front-end.<o:p></o:p></span></p>

<p>In my opinion the best book on Perl:</p>

<table border=0 cellspacing=0 cellpadding=0 style='mso-cellspacing:0in;
 mso-padding-alt:0in 0in 0in 0in'>
 <tr>
  <td width="1%" valign=top style='width:1.0%;padding:0in 0in 0in 0in'>
  <p class=MsoNormal><!--[if gte vml 1]><v:shapetype id="_x0000_t75"
   coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe"
   filled="f" stroked="f">
   <v:stroke joinstyle="miter"/>
   <v:formulas>
    <v:f eqn="if lineDrawn pixelLineWidth 0"/>
    <v:f eqn="sum @0 1 0"/>
    <v:f eqn="sum 0 0 @1"/>
    <v:f eqn="prod @2 1 2"/>
    <v:f eqn="prod @3 21600 pixelWidth"/>
    <v:f eqn="prod @3 21600 pixelHeight"/>
    <v:f eqn="sum @0 0 1"/>
    <v:f eqn="prod @6 1 2"/>
    <v:f eqn="prod @7 21600 pixelWidth"/>
    <v:f eqn="sum @8 21600 0"/>
    <v:f eqn="prod @7 21600 pixelHeight"/>
    <v:f eqn="sum @10 21600 0"/>
   </v:formulas>
   <v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
   <o:lock v:ext="edit" aspectratio="t"/>
  </v:shapetype><v:shape id="_x0000_i1025" type="#_x0000_t75" alt="PERL by Example with Cdrom"
   style='width:75pt;height:102pt'>
   <v:imagedata src="" o:href="http://a1204.g.akamai.net/7/1204/1401/02022212011/images.barnesandnoble.com/images/4840000/4845882.gif"/>
  </v:shape><![endif]--><![if !vml]><img border=0 width=100 height=136 src=""
  alt="PERL by Example with Cdrom" v:shapes="_x0000_i1025"><![endif]><span
  style='font-family:"Arial Unicode MS"'><o:p></o:p></span></p>
  </td>
  <td width="1%" valign=top style='width:1.0%;padding:0in 0in 0in 0in'>
  <p class=MsoNormal><!--[if gte vml 1]><v:shape id="_x0000_i1026" type="#_x0000_t75"
   alt="" style='width:7.5pt;height:.75pt'>
   <v:imagedata src="" o:href="http://a1055.g.akamai.net/f/1055/5818/5h/shop.barnesandnoble.com/gresources/cleardot.gif"/>
  </v:shape><![endif]--><![if !vml]><img border=0 width=10 height=1 src=""
  v:shapes="_x0000_i1026"><![endif]><span style='font-family:"Arial Unicode MS"'><o:p></o:p></span></p>
  </td>
  <td width="15%" valign=top style='width:15.0%;padding:0in 0in 0in 0in'>
  <p class=MsoNormal><b><span style='font-size:10.0pt;font-family:Arial'>Retail
  Price: $44.99<br>
  <span style="mso-spacerun: yes"> </span><o:p></o:p></span></b></p>
  <p class=MsoNormal><b><span style='font-size:7.5pt;font-family:Arial'>Format:</span></b><span
  style='font-size:7.5pt;font-family:Arial'> Paperback,&nbsp;3rd
  ed.,&nbsp;880pp.<br>
  <b>ISBN:</b> 0130282510<br>
  <b>Publisher:</b> Prentice Hall PTR<br>
  <b>Pub. Date:</b> September&nbsp; 2001<br>
  <b>Edition Desc<!-- ription -->:</b> 3RD BK&amp;CDR<br>
  <b>Barnes &amp; Noble</b></span><span style='font-family:"Arial Unicode MS"'><o:p></o:p></span></p>
  </td>
 </tr>
</table>

<p><span style='font-size:14.0pt;mso-bidi-font-size:12.0pt'><span
style="mso-spacerun: yes">   </span><a
href="http://comsci.liu.edu/~vasilaky/db2/HTMLLearn.exe">DownloadHTMLlearn</a>
…….<span style="mso-spacerun: yes">    </span><a
href="http://comsci.liu.edu/~vasilaky/db2/active~1.msi">Download Perl</a><o:p></o:p></span></p>

<p><span style='font-size:14.0pt;mso-bidi-font-size:12.0pt'>Some websites for
Perl and databases: <a
href="http://www.fastnetltd.ndirect.co.uk/Perl/perl-win32-database.html">http://www.fastnetltd.ndirect.co.uk/Perl/perl-win32-database.html</a><span
style="mso-spacerun: yes">   </span>…<span style="mso-spacerun: yes">  </span><a
href="http://www.info.lk/techweb/perl/tutor/">http://www.info.lk/techweb/perl/tutor/</a>
<o:p></o:p></span></p>

<p><span style='font-size:14.0pt;mso-bidi-font-size:12.0pt'>Devi’s HTML and
Perl notes: <a href="http://comsci.liu.edu/~mdevi/">http://comsci.liu.edu/~murali/</a><o:p></o:p></span></p>

<p><span style='font-size:14.0pt;mso-bidi-font-size:12.0pt'><a
href="http://comsci.liu.edu/~vasilaky/db2/Database.htm">Perl-Oracle Connection</a></span></p>

<p><a href="Assignments.html">Assignments</a><span style='color:red'>, </span><a
href="http://comsci.liu.edu/~vasilaky/db2/SampleMidSol.txt"><span
style='color:red'>Answers</span></a>, <a href="downloads.html">Downloads</a>, <a
href="http://comsci.liu.edu/~vasilaky/db2/cs668f2000.htm">SampleFinal</a></p>

<p>Text: Oracle8 Programming a Primer by Rajshekhar Sunderraman,
Addison-Wesley, ISBN: 0-201-61258-5 </p>

<p>Reference books:</p>

<p>Oracle PL/SQL Programming by Steven Feuerstein, O'Reilly &amp; Associates,</p>

<p>ISBN:1-56592-142-9. </p>

<p>Oracle PL/SQL by Kevin Owens, 2<sup>nd</sup> Edition, Prentice Hall,
ISBN:0-13-794314-8</p>

<p>Personal Oracle7 for Win 95 by David Lockman</p>

<p>SAMS Pub. 2<sup>nd</sup> Edition ISBN: 0-672-31025-2 Chap. 18 - Chap 23
(about 110 pages)</p>

<p>It's likely we will be using Visual Studio 7 for the second part of the
course.</p>

<p>We may use C# or Visual Basic for the presentation (interface) layer. </p>

<p>Instructor: W. Vasilaky e-mail: <a href="MAILTO:vasilaky@liu.edu">mailto:vasilaky@liu.edu</a>...
Phone: (718) 488 - 1073 .... Fax: (718) 780 - 4145</p>

<p>&nbsp;Course Grade: Lab 25%, Midterm 35%, Final 40%</p>

<p><span style='color:green'>Assignments are due two weeks from day assigned.<o:p></o:p></span></p>

<p>Approximate schedule of topics:</p>

<p>Week…… <a name=Topics>Topic </a></p>

<p>1 …………Car rental PL/SQL example<span style="mso-spacerun: yes">  </span><a
href="http://comsci.liu.edu/~vasilaky/db2/Car.sql"><b><span style='font-family:
"Courier New"'>Car.sql </span></b></a></p>

<p>2 …………<a href="http://comsci.liu.edu/~vasilaky/db2/lec1.htm">PL/SQL , data
Types</a> &amp; <a href="http://comsci.liu.edu/~vasilaky/db2/constructs.sql">IfElse
Dates Sequence, input</a><span style="mso-spacerun: yes">     </span><a
href="http://comsci.liu.edu/~vasilaky/db2/loops.sql">loops</a><span
style="mso-spacerun: yes">  </span><a
href="http://comsci.liu.edu/~vasilaky/db2/typeconversions.txt">Type
Conversions</a> </p>

<p>3 …………<a href="http://comsci.liu.edu/~vasilaky/db2/cursors.htm">Cursors</a><span
style="mso-spacerun: yes">     </span><a
href="http://comsci.liu.edu/~vasilaky/db2/cursor.sql">examples</a></p>

<p>4………….<span style="mso-spacerun: yes">  </span><a
href="http://comsci.liu.edu/~vasilaky/db2/exceptions.htm">Exceptions</a><span
style="mso-spacerun: yes">    </span><a
href="http://comsci.liu.edu/~vasilaky/db2/excepts.sql">examples</a></p>

<p>5…………..<a href="http://comsci.liu.edu/~vasilaky/db2/PROCEDURES.htm">Procedures
and Functions</a></p>

<p>6…………...<a href="http://comsci.liu.edu/~vasilaky/db2/PACKAGES.htm">Packages</a></p>

<p>7..……….... <a href="http://comsci.liu.edu/~vasilaky/db2/TRIGGERS.htm">Triggers</a></p>

<p>8 ……….MID TERM .. <a
href="http://comsci.liu.edu/~vasilaky/db2/MidTermSample.html">SampleMidTerm</a>
… <a href="http://comsci.liu.edu/~vasilaky/db2/anstosampletest.txt">SampleMidTermSolutions</a></p>

<p>9 ………….<a href="http://comsci.liu.edu/~vasilaky/db2/tables.htm">PL/SQL
Tables</a></p>

<p>10……….. <a href="http://comsci.liu.edu/~vasilaky/db2/ObjectType.html">Oracle8
objects</a> </p>

<p>11………. Oracle JDBC<span style="mso-spacerun: yes">  </span><a
href="http://comsci.liu.edu/~vasilaky/db2/SimpleJDBC.txt">Example</a></p>

<p>12……….HTML </p>

<p>13 ……….Perl Oracle connection module</p>

<p><span style="mso-spacerun: yes"> </span><a
href="http://comsci.liu.edu/~vasilaky/db2/DatCon.txt">Visual Basic &amp;
Database Connect Module</a></p>

<p><a name=code></a><a
href="http://comsci.liu.edu/~vasilaky/db2/searchscreen.htm"><span
style='mso-bookmark:code'>SearchScreen</span><span style='mso-bookmark:code'></span></a><span
style='mso-bookmark:code'></span> …<a
href="http://comsci.liu.edu/~vasilaky/db2/CustomerScreen.htm">CustomerScreen</a>
…<a href="http://comsci.liu.edu/~vasilaky/db2/SearchCode.htm">SearchCode</a> …<a
href="http://comsci.liu.edu/~vasilaky/db2/CustomerDisplayCode.htm">CustomerDisplayCode</a></p>

<p>15……… FINAL</p>

</div>

</body>

</html>