- 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
- BE3168A
- 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 Quicstart Guide: SQLFehily, PeachPit Press
- Assignments and Schedule
- Assignments will be in the form of handouts.The book is primarily for reference. Suggested readings will be added to the schedule below after I get a copy of the revised text (hopefully week 1)
| Week | Topic | Assignments |
|---|---|---|
| Week One | Overview of SQL and SQL Express. Creating tables | Pre survey; Create tables assignment 1, Read chapters 2 and 3, and chapter 11 |
| Week Two | More create tables, constraints and relations. Alter tables. Indexes | Create tables Assignment 2; Alter Tables, Index assignment; Chapter 11 and 12 |
| Week Three | Inserts, Updates, Deletes | Insert assignment 1, Update and Delete assignment. Chapter 10 |
| Week Four | Selects with a variety of critera, calculated fields, Aliases | Select assignments 1 and 2; Chapter 4 |
| Week Five | SQL Functions, Aggregate Functions (group by, having) | Function Assignment, Aggregate function assignment; Chapters 5 and 6 |
| Week Six | Joins (inner, Outer, full, cartesian) | Joins assignment 1 and 2; Chapter 7 |
| Week Seven | Sub queries, views, triggers | Sub query assignment, Views,Trigger assignment; Chapter 8, on-line notes |
| Week Eight | Stored Procedures | Stored procedure assignments 1 and 2; On-line notes |
| Week Nine | Security SQL, Schema, Administrative SQL, xml | Security Assignment; xml assignment; on-line notes |
| Week Ten | Final Assignment | |
| Week Eleven | Final Assignment; Post survey |
- 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 pre and post surveys count as 1 assignment together (5 point each)-though I will not grade your answers. Your final grade is based on the total points you recieve divided by the total possible points.
