| Assignments |
Link to retrieve |
|---|
| If you can manage to get ahead of the posted weeks, you will have more time at the end of the summer to
work on the project and the final! |
Assignments Week #1
Week ending June 1st |
Student survey - must be sent to me!
Read the notes and study the presentations for: Introduction to SQL in Oracle, Create a table in SQL, SQL Conditions and
start reading Working with SQL. This information will carry over into next week!
Notes:
Introduction to SQL in Oracle
Create a table in SQL
SQL Conditions
Working with SQL
Presentations:
Introduction to SQL in Oracle
Separate speaker notes for Introduction to SQL in Oracle
Create a table in SQL
Separate speaker notes for Create a table in SQL
SQL Conditions
Separate speaker notes for SQL Conditions
Working with SQL
Separate speaker notes for Working with SQL
Note the first few slides in Working with SQL show login procedures using scott and tiger.
Oracle assignment on introductory material
Please see Ernie Nicholson for a login password etc if you plan to use Oracle at BCC. If you plan to install
Oracle at home, get in touch with me if there are problems.
|
Assignments Week #2
Week ending June 8th |
Because of the installation problems with 8i (8 with Windows 95 and 7.3 with either
Windows 95 or 98 work fine), I am changing the order of things a little and I am
going to deal with the theory of relational databases this week. Hopefully this will
buy us enough time to solve the installation problem. If you are without access to
Oracle, please let me know what your problem is so we can try to get you up and running!
Please read information about third normal form and relational databases. I have put
a variety of links to sources on the Web on the site, you can also read information from
a book (your text book has a little information).
Please read the handout on definitions: Normalization definitions
Also view the slide presentation on normalization:
Normalization - information on third normal form
Separate speaker notes for normalization presentation
For futher information look at the design aspects of the following presentations - we will deal with the
Oracle code later.
Relational database notes and examples
Goes with notes Introduction to multiple tables (relational) - joins - uses donor, donations and drive tables
Separate speaker notes for relational database presentation
Relational database examples - order system
Separate speaker notes for relational database examples - order system
Student system relational database example
Separate speaker notes for student system relational database example
Set up relational database for an oil company
|
Assignments Week #3
Week ending June 15th |
Please read the following information about relational databases in Oracle.
Introduction to multiple tables (relational) - joins
Relational database examples
Look at the relational examples in the presentations from last week.
Read the following information about maintaining a table and view the accompanying presentation.
More on maintaining an SQL table
More on maintaining an SQL table
Separate speaker notes for More on maintaining an SQL table
Do the following assignment:
Implementing your oil design
|
Assignments Week #4
Week ending June 22nd |
Please read the following information about tables and functions.
SQL functions
More SQL functions
Group SQL functions
You should also watch the presentations on these topics:
SQL functions - part 1 character
Separate speaker notes for SQL functions - part 1 characters
SQL functions - part 2 numeric & date
Separate speaker notes for SQL functions - part 2 numeric & date
More SQL functions (includes DECODE,
ways to edit SQL code and nested functions)
Separate speaker notes for more SQL functions
Group functions
Separate speaker notes for group functions
Oracle quiz - must be passed in next week
Oracle create, query and maintain assignment with functions
|
Assignments Week #5
Week ending June 29th |
Please read the following information about subroutines, maintenance etc.
Subqueries
More on subqueries
Using input variables
More on variables with Oracle's SQL*Plus
Table maintenance revisited (again)
Continuation of table maintenance revisited (again)
Exporting an Oracle table
You should also look at the presentation on these topics especially the one that
accompanies More on subqueries.
Subqueries
Separate speaker notes for subqueries
More on Subqueries
Separate speaker notes for More on subqueries
Using Input Variables
Separate speaker notes for Using Input Variables
More on variables with Oracle's SQL*Plus
Separate speaker notes for More on variables with Oracle's SQL*Plus
Table maintenance revisited (again)
Separate speaker notes for Table maintenance revisted (again)
Continuation of table maintenance revisited (again)
Separate speaker notes for Continuation of table maintenance revisted (again)
Assignment:
Oracle assignment on subqueries and variables.
Quiz: Second quiz
|
Assignments Week #6
Week ending July 6th |
Please finish the information about table maintenance from last week and read the information on views and reports.
Introduction to views
Introduction to reports
You should also look at the accompanying presentations:
Introduction to views
Separate speaker notes for Introduction to views
Introduction to Reports
Separate speaker notes for Introduction to reports
Assignment on views and reports
|
Assignments Week #7
Week ending July 13th |
Please read the following:
Indexes in Oracle - An introduction
More on Primary and Foreign keys
Notes on key questions
Also please look at the accompanying presentations:
Indexes in Oracle - An Introduction
Separate speaker notes for Indexes in Oracle - An Introduction
More on Primary and Foreign Keys also info from questions
Separate speaker notes for More on Primary and Foreign Keys etc.
Town taxes set up as a relational database with constraints, keys and indexes
|
Assignments Week #8
Week ending July 20th |
Please read the following:
Introduction to PL/SQL
More examples of inner/outer procedures
Introduction to IF statements
More on PL/SQL IF statements
Introduction to loops
Also please look at the accompany presentations:
Introduction to PL/SQL
Separate speaker notes for Introduction to PL/SQL
PL/SQL - Using IF statements
Separate speaker notes for PL/SQL - Using IF statements
More on PL/SQL IF statements
Separate speaker notes for More on PL/SQL IF statements
Introduction to loops
Separate speaker notes for Introduction to loops
PL/SQL IF statements and LOOPS
Looking ahead to the notes on data manipulation might help with the extra credit.
|
Assignments Week #9
Week ending July 27th |
Please read the following notes and watch the slide presentations.
Data manipulation in PL/SQL - introduction
Record and table types
Data manipulation in PL/SQL - introduction
Separate speaker notes on Data manipulation in PL/SQL - introduction
PL/SQL User Defined Types - record and table
Separate speaker notes for PL/SQL User Defined Types - record and table
This week we will finish dealing with types and introduce cursors.
Introduction to Cursors
Introductory assignment on cursors and type table
This is another one of the quizzes that can be discussed with other classmates.
First PL/SQL Quiz (also quiz #3)
|
Assignments Week #10
Week ending August 3rd |
Please read the following notes and watch the slide presentation.
Example 1 using cursors
Continuing example 1 using cursors
Another set of cursor examples
Covers: Cursors in PL/SQL, cursor example and continuation of first cursor example
Separate speaker notes for Cursors in PL/SQL, cursor example and continuation of first cursor example
Covers: Another set of cursor exampes
Separate speaker notes for Another set of cursor examples
Multiple cursor assignment
Important:
I am going away to Europe for two weeks. Continue to send assignments to the
usual account. Needless to say I will not be correcting until I get home!
If you have questions, then use my email account pgrocer@hotmail.com. I will check this
account from the Internet cafes when I can. I have also asked my workstudy Wendy and
Tess to be available for questions and help while I am gone. The information to
contact them is:
Wendy can be reached at Wenco35@aol.com or wenco@mediaone.net
Tess can be reached at tfarias@stu-mail.bristol.mass.edu or mstess73@aol.com
You can also set up an appointment with Wendy via email or you can contact Tess in
the K building lab Monday,Tuesday and Thursday nights from 4 till 9.
|
Assignments Week #11
Week ending August 10th |
Please read the notes and view the presentations on exceptions and start reading
the notes on procedures and functions - we will deal those this week and next.
Introduction to exceptions
Introduction to procedures
Exceptions in PL/SQL
Separate speaker notes for Exceptions in PL/SQL
Introduction to PL/SQL Procedures
Separate speaker notes for Introduction to PL/SQL Procedures
Homework has ended - the assignment for the rest of the semester is the PROJECT!!!
Project - due the last day of classes
See note under Week #10 about contacting me!
|
Assignments Week #12
Week ending August 17th |
Please read the notes and view the presentations on procedures, functions and triggers.
Introduction to functions
Internal procedures
More on internal procedures and functions
Still more on procedures and functions
Introduction to triggers
More on triggers
Introduction to PL/SQL Functions
Separate speaker notes for Introduction to PL/SQL Functions
More on Procedures - Internal Procedures
Separate speaker notes for More on Procedures - Internal Procedures
Introduction to Triggers
Separate speaker notes for Introduction to Triggers
More and Still More on Procedures and Functions
Separate speaker notes for More and Still More on Procedures and Functions
More on Triggers
Separate speaker notes for More on Triggers
I will be home mid week!
|
Assignments Week #13
Week ending August 24th |
Read the notes on Developer.
Continue working on Project!
Final exam
Status sheet - required
|
Assignments Week #14
Week ending August 31st |
Final due on August 28th!
You are required to turn in a status sheet for this course!
Status sheet
|