SQL Server Essentials: Concepts & Tools
| Student Course Website Login: | http://moodle.extn.washington.edu/course/view.php?id=609 |
| Location: | 1411 4th Ave, Seattle, WA 98101-2249 (click here for map) |
| Course Overview: | http://www.extension.washington.edu/ext/certificates/sql/sql_crs.asp |
| Web Software Test: | https://admin.adobe.acrobat.com/_a227210/attendfirstmeeting/ |
Course Objectives
This course will introduce the student to Microsoft’s SQL Server database management system. Topics included are relational database concepts for production database applications, SQL programming, and SQL Server tools. This course will introduce advanced topics -- at an overview level -- that will be presented in more detail in subsequent courses. The course involves instruction, course studies, and a project that will be completed from requirements to delivery.
During the course you will design a relational database structure from a set of business requirements, developing a graphical Entity Relationship Diagram (ERD), writing Transact-SQL code for the creation of all database tables, views, stored procedures, security, indexes and maintenance scripts for a sample system. Your final project will be the entire system creation, delivered as a series of scripts, along with the ERD and pertinent conceptual documents in a SQL Server Management Studio (SSMS) Solution.
- Relational Database Management Concepts
- SQL Server Architecture
- Business Requirements Definition and Collection
- SQL Server Tools
- SQL Server Management Studio (SSMS)
- Business Intelligence Development Studio (BIDS)
- SQL Server Profiler
- SQLCMD, BCP and PowerShell
- Books Online
- Database Objects
- Data Types
- Database Structures
- Normal Forms
- OLTP
- OLAP
- Structured query language (SQL) constructs, including data definition language (DDL), data manipulation language (DML), and data control language (DCL)
- Transaction Processing
- Programming Constructs
- Dynamic SQL
- Loops
- Error Handling
- Stored Procedures
- Other Constructs (triggers, functions)
- Performance Tuning
- Security
- Standard maintenance
- Extract, Transform and Load Concepts
Prerequisites:
Basic SQL; some exposure to a database software product; familiarity with general programming concepts.
Required Textbooks
Used or new is acceptable, and you can get a copy of these wherever you like - they are available on your Safari Account:
A Developer’s Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008 by Eric Johnson; Joshua Jones
Microsoft® SQL Server 2008 Management and Administrationby Ross Mistry; Hilary Cotter
Head First SQL by Lynn Beighley
For reference, SQL Server Books Online (free, available online here: http://msdn.microsoft.com/en-us/library/ms130214.aspx)
Recommended:
Any books by Kalen Delaney, Itzak Ben-Gan, Paul Randal or Kimberly Tripp
Contact Your Instructor
Buck Woody (http://www.buckwoody.com) woodyb@hotmail.com - put “UW:” in Subject
Technology Requirements
Computer with access to the Internet – laptop is perfect, any system capable of running SQL Server is acceptable
Developer Edition of SQL Server (provided via college site download to students)
Developer Edition: http://www.microsoft.com/Sqlserver/2008/en/us/how-to-buy.aspx
Removable media for saving class work, such as a USB 1 GB or higher drive - bring to the first class
Software for remote connectivity - instructions provided the first class
Assessment Criteria
Students will be assessed based on class participation and project work. Students will be required to create databases and associated objects including tables, stored procedures, views, functions, indexes and constraints. Student project to be turned in will include a single database with associated front-end application software. The specific project requirements will be provided in the project handout. The project handout is posted on the class web page: http://faculty.washington.edu/woodyg. Projects will be reviewed at final presentation.
Students are expected to:
Check the Student Course Website (http://faculty.washington.edu/woodyg) consistently at least a few times per week and download all presentation and code files prior to class. Project information, and required course downloads will be posted here!
Notify the instructor of your e-mail address (you can get one for free on the “MyUW” site). Homework clarifications, important class notices will be posted via e-mail.
Come to class prepared with all code and to have current project media available for instructor review at any time
Preview textbook chapters before each class and complete all assignments between classes.
Contact the instructor (e-mail is best) between classes with any problems or questions; keep me apprised of your problems and concerns.