- Course Title and Number
- SQL
- Credits
- 5
- Times
- MW 10:00 AM-12:15 PM
- Prerequisites
- ITC 220
- Course Overview
- The course will provide an in depth look at Ansi SQL using SQL Server Express, as well as some Transact SQL in the form of Triggers and Stored procedures. In addition we will look at some security features and SQL Server 2005 use of Schema.
- 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.587.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 information from a database
- Use SQL to create and modify database structures
- Use SQL to create and modify records
- Use SQL to set Constraints and create Views
- Create stored procedures
- Translate SQL into simple XML
- Work together in teams to successfully complete projects
- Locate and use additional sources of information
- Troubleshoot SQL errors and problems
- Recognize and address security issues
- Document code and activities
- 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 assignment that summarizes what has been learned
- Textbook
- Visual QuicKstart Guide: SQL 3rd EditionFehily, PeachPit Press
- 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 Trigger
| Week | Topic | Assignments |
|---|---|---|
| Week One | Overview of SQL and SQL Express. | 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 Assignment | |
| Week Eleven | Final Assignment |
- 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 assignment 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.