Course Syllabus
This course code has changed from CIT 325 to ITM 325. You may occasionally see references to the old course code or title.
Course Description
This course deals with concepts and principles of database theory, server application development, and deployment strategies. It focuses on the use of server application components that reside inside the database. The course explores in depth the best practices and approaches to writing database application components that ensure ACID-compliant transactions across two or more Structured Query Language (SQL) statements and/or tables. SQL will be used to query and transact against a sample database inside the procedural coding components. Specifically, the course concentrates on learning Oracle PL/SQL and Postgres PL/pgSQL.
Course Objectives and Outcomes
- Determine when to use SQL or a stored program.
- Understand the transactional processing model.
- Conceptualize, design, and implement database applications.
- Use conditional and iterative logic, as well as collections.
Prerequisites
- Take CIT 225: Database Design & Development
Required Resources
This course uses a low-cost, auto-access textbook. Read the information in the Textbook Information module to learn how to access your textbook, and how to opt out of this automatic purchase, if desired.
| Resource Title/Description (books, software, etc.) |
Author/Provider | Ed./Vol. | 13-Digit ISBN (if applicable) |
|---|---|---|---|
| Oracle Database 12c PL/SQL Programming | Michael McLaughlin | 1st | 978-0071812436 |
| Errata for Oracle Database 12c PL/SQL | Michael McLaughlin | ||
| PostgreSQL Documentation |
You will install the Oracle Database 23c or newer and PostgreSQL 14+ (or newer) database servers on a native or virtualized Microsoft Windows. During the course you will use the Oracle and PostgreSQL database servers and text editors.
Structure
Weekly Patterns
The table below displays typical weekly activities, due dates, and activity descriptions.
| Due Date* | Learning Model | Activity Title | Description |
|---|---|---|---|
| Midweek | Prepare | Preparation & Reading | Read the chapters or web references at the beginning of the week. |
| Midweek | Teach One Another | Discussion Board | Share inspirational thoughts and assist your classmates or request help from your peers by asking and answering questions on the week's lab or materials. |
| End of Week | Teach One Another | Exercise | Work on lab assignments with your team. |
| End of Week | Ponder and Prove | Quiz | Take quiz to measure content learned for the week. Must submit your own quiz. |
| End of Week | Ponder and Prove | Paper | Submit a report according to the case study expectations. Must submit your own case study. |
*Set your time zone within user preferences so the dates and times for course activities will display correctly for your time zone.
Learning Model
- Students will prepare each week by reading the textbook and web pages, taking a short quiz, and experimenting with the practice examples individually or in groups.
- Students will teach one another by sharing inspirational thoughts, assisting their classmates, and requesting help from their peers by asking and answering questions on the week's lab or materials.
- Students will ponder with a weekly quiz on the week's content.
- Students will prove through a case study report.
Expectations
Workload
Because this course follows the organization of the Learning Model, there are many opportunities to teach and work together with your peers. You should not treat this as an independent study course where you can work ahead on your own. If you work ahead on your own, you will miss key activities where peer review is required. Instead, stay within the weekly schedules set in the course schedule and use any additional time to help others in peer review activities. Make sure to complete all learning activities for one week before the next one begins!
Group Work
Discussion boards are a chance to share, teach, and learn from one another. You may work in groups on the Preparation & Reading and Lab activities in this course, but you must submit your own quiz results and case study.
Late Work
As a sign of professionalism and respect, complete your work on time.
Grading Scale
| Letter Grade | Percent |
|---|---|
| A | 100%–93% |
| A- | 92%–90% |
| B+ | 89%–87% |
| B | 86%– 83% |
| B- | 82%–80% |
| C+ | 79%–77% |
| C | 76%–73% |
| C- | 72%–70% |
| D+ | 69%–67% |
| D | 66%–63% |
| D- | 62%–60% |
| F | 59% and lower |
University Policies
Students with Disabilities
Brigham Young University-Idaho is committed to providing a working and learning atmosphere that accommodates qualified persons with disabilities. If you have a disability and require accommodations, please contact the Disability Services Office at (208) 496-9210 or visit their website and follow the Steps for Receiving Accommodations. Reasonable academic accommodations are reviewed for all students who have qualified documented disabilities. Services are coordinated with students and instructors by the Disability Services Office.
This course may require synchronous meetings. If you are currently registered with the Disability Services Office and need an interpreter or transcriber for these meetings, please contact the deaf and hard of hearing coordinator at (208) 496-9219.
Other University Policies
Go to the Student Resources module to review the university policies regarding honesty, online etiquette, communication expectations, etc.
Course Summary:
| Date | Details | Due |
|---|---|---|