SQL & PL/SQL guide by Dario Margeli

 

01-topic-1-arithmetic

01-topic-2-concatenation

01-topic-3-literal-strings

01-datatype

01-round   round-answer

01-topic6-null

01-topic7-eliminating-repeats

01-topic8-dates-prompt-checkpnt-datadictionary-other

01-integrity-constriant-display-date

01-update-change-value

02-topic10-comparison-operators-character-strings-in-WHERE clause

02-AND operator

02-topic12-IS NULL and NOT IN

02-ORDER-BY

02-lab-excersize-no4 Part 2 contiuation

note about PL/SQL

Expanded Table of Contents section of book about Sql & Pl SQL  : updated Oct 2004

 

page with interesting stuff from your txt files notes of the class

page with interesting stuff from your txt files notes of the class part 2

interesting_stuff_from_txt_class_notes_3.

interesting_stuff_from_txt_class_notes_4.

A long full code of PL/SQL

interesting notes from your paper notebook of the class

flash cards (incomplete)

cursor

what_is_plsql_other_source    (when offline link)

sql flash cards part 2 (online link)     (when offline link)

 

Pic of Tables used
  sql-customer-table.jpg   sql-emp-table.jpg   sql-item-table.jpg   sql-ord-table.jpg   sql-price-table.jpg

 

Other Files

pl_sql_bk3_review.xls

sql-server-class-day.doc

 

 

NOTE: The SQL section of my site is still UNDER CONSTRUCTION

Sulle construzione. Under Construction. Bajo Construccion. Zire Saakht
Last Updated Jan, 2002

OUTSIDE LINK:

Speaking SQL - (beginner) Very general but useful introduction to SQL. "....this article will get you up to speed on the basics of creating tables and inserting data into them" Author icarus melonfire MySQL tutorial outside link

.

e-mail:
Send me an e-mail
dariointernet@gmail.com

email:
dmargeli@yahoo.com

webmaster Hire me, I need employment (any category)
                  Necesito Trabajo

To Dario's Main Page