- Course Title and Number
- SQL
- Credits
- 5
- Times
- MW 10:00 AM-12:15 PM
- Prerequisites
- ITC 220
- Course Overview
- This course provides a hands-on introduction to the SQL database programming language
- ADA
- If you need course adaption or accomodation because of a disability, if you have emergancy medical information, or if you need special arrangements if the building must be evacuated, please make an appointment with your instructor as soon as possible
- Instructor
- Steve Conger
- Office Location
- BE3176b
- Office Phone
- 206.934.5458
- Office Hours
- See Schedule
- sconge@sccd.ctc.edu
- Web page
- http://seattlecentral.edu/faculty/sconge
- Educational Philosophy
- The pre-Socratic Philosopher Heraklitos said, "it rests by changing." By this he meant that the normal state of things is constant change. This has never been more true than today. Though, the course focuses on particular software, it has a broader purpose: Software changes constantly. The most important skills to learn, are the techniques for learning new skills, new software, and learning how to generalize the skills you've learned in order to apply them to new situations. These are the skills that will keep you afloat in stream of constantly changing technology
- Student Outcomes and competencies
- Use SQL to retrieve database information
- Use SQL to modify database data
- Use SQL to create database objects
- Use XML in the context of the database
- Trouble shoot code
- Document code
- Methods of Instruction
- There will be some lecture to convey concepts and provide examples. Daily assignments will provide practice. There will be occasional quizzes and a final Project that summarizes what has been learned
- Textbook
- Visual QuicKstart Guide: SQL 3rd EditionFehily, PeachPit Press, ISBN978-0-321-5535767
- Assignments and Schedule
- Assignments will be in the form of handouts.The book is primarily for reference. Additional meterials will be provided for stored procedures and Triggers
| Week | Topic | Assignments |
|---|---|---|
| Week One | Overview of SQL and SQL Server. | Read chapters 2 and 3, Download Database script |
| Week Two | Selecting data, functions | Read chapters 4 and 5, assignments 1 and 2 |
| Week Three | Aggregate functions and joins | Read chapters 6 and 7, Assignments 3 and 4 |
| Week Four | Subqueries, Insert Update Delete | Read chapters 8 and 10, assignments 5 and 6 |
| Week Five | Creating and altering tables | Read chapters 11 and 12, Assignments 7, midterm |
| Week Six | Views, Indexes, Creating SQL Functions, intro to Stored Procedures | Materials will be provided, Assignment 8 and 9 |
| Week Seven | More stored procedures, Triggers | Materials will be provided, Assignment 10 |
| Week Eight | XML in SQL Server | Materials provided, assignment 11 |
| Week Nine | Security SQL, Schema, Administrative SQL, xml | Materials provided, Assignment 12 |
| Week Ten | Final Project | |
| Week Eleven | Final Project |
- Grading and Attendance
- Attendence is critical. We will be covering material and doing labs most every day. If you know ahead of time you will not be able to attend, let me know as soon as possible. Otherwise contact me as soon after the abscence as you can.
- Each assignment will be worth 10 points. If you miss points you can correct the mistakes to get the points. The final project is worth 50 points. The midterm will be worth 50 points. Your final grade is based on the total points you recieve divided by the total possible points.
| Percent | Grade |
|---|---|
| 90 to 100 | 4.0 |
| 85 to 89 | 3.5 |
| 80 to 84 | 3.0 |
| 75 to 89 | 2.5 |
| 70 to 74 | 2.0 |
| 65 to 69 | 1.5 |
| 60 to 64 | 1.0 |