| 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 September 7th |
Student survey - must be sent to me! You should take this time to get a copy of Oracle if you are working on a computer outside the labs. You can use 7.3, 8 or 8i. A site to download is: Oracle downloads 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 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. 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 |
| Assignments Week #2 Week ending September 14th |
To give you some time to get a copy of Oracle installed, we are going to deal with
the theory of relational databases this week. 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. 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 September 21st |
We will continue with the design of a relational database. Because of the missed day, the assignment for last week will not be actually assigned until this Tuesday. Therefore, the design may go over into next week as well. We will see how things go! Because of the design delay, I have decided to delay the implementation of the relational database until next week and cover functions now! If you are a distance learning student and have started the othe readings - don't worry - just be at the right place by the end of week #4! 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 late next week There are two assignments in week #4 - you might start the first one this week! I did no a little rearranging to give more time on the oil design - hopefully the topics for week #3 and week #4 can be finished by the beginning of week #5! |
| Assignments Week #4 Week ending September 28th |
We will finish functions and then start the multiple tables - the goal is to get caught up by the end of
the week but it could still go over into week #5! Assignment: Oracle create, query and maintain assignment with functions 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 #5 Week ending October 5th |
My goal is to get through all of this... We will see! 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 October 12th |
I was overly optimistic last week - I did not get through the maintenance revisited or
the continuation of it, so... 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 If we do not finish views and reports, this assignment will be the first of next week! |
| Assignments Week #7 Week ending October 19th |
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. No assignment this week! |
| Assignments Week #8 Week ending October 26th |
We will finish SQL this week so please read the rest of the notes and look at the
rest of the presentations. Assignment on constraints Start reading the introductory handout on PL/SQL and look at the PowerPoint presentation! Introduction to PL/SQL More examples of inner/outer procedures Introduction to PL/SQL Separate speaker notes for Introduction to PL/SQL |
| Assignments Week #9 Week ending November 2nd |
Please read the following: Introduction to IF statements More on PL/SQL IF statements Introduction to loops Also please look at the accompany presentations: 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 #10 Week ending November 9th |
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 #11 Week ending November 16th |
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 Check back! |
| Assigments Week #12 Week ending November 23rd |
I will be on campus at 9:00 on Monday for advisement so office hours will be
either on campus during the day Monday or Monday evening over the web! We will continue with cursors. |
| Assignments Week #13 Week ending November 30th |
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 Project: Final project due the last day of classes! For those that actually get it in on time there is extra credit! I hope this clarifies any misreading! |
| Assignment Week #14 Week ending December 7th |
We have a little left from last week and then we will start looking at the notes
on Developer. No assignments related to Developer! Continue working on project! Note, if you use a set of tables that already has constraints, indexes, keys etc. then you are going to loose some points for not creating them - the goal is to do this a second time and make sure you are comfortable with it! You can add some others constraints and add some other tables to cover this! Let me clarify - everyone must do a project and it is due the last day of classes. Those who meet this due date will get extra credit! Check back for date final will be posted. |
| Assignment Week #15 Week ending December 14th |
Let me clarify - everyone must do a project and it is due the last day of classes. Those
who meet this due date will get extra credit! I have booked some open lab time to work on project, assignments etc. On Tuesday the 11th, I have booked K205 and on Friday the 14th I have booked K101. These are optional labs - come if you have questions or just want to work on your projects. Final is posted! Remember you must also fill in the status sheet which is posted! |
Week #16 Final Exam December 20th at 1:00 |
If I have not received the Final and the Status Sheet by 1:00 on Thursday, December 20th you
must report to K202 to take the final! Final Exam Status Sheet I will accept homework up to the final - you may pass the project through Saturday, December 22nd. |