buck.woody

LinkedIn | FaceBook | Twitter

 

SQL Server Essentials: Concepts & Tools

 

 

Course Objectives

 

This course will introduce Relational Database Management Systems concepts, Microsoft SQL Server (including installation, configuration and tools), and database objects. You will also be introduced to the Transact-SQL (T-SQL) language and PowerShell scripting which will be developed throughout the rest of the certificate program.

 

Topics include:

1. Overview of Relational Database Management Systems (RDBMS) and Relational Calculus. Introduction to SQL Server Editions and Configurations
2. Overview of SQL Server tools and utilities

3. PowerShell scripting concepts and uses in SQL Server

4. Introduction to Data Design

5. Introduction to Data Objects

6. Introduction to the Structured Query Language (SQL), including Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL)

7. Introduction to Security and Permissions and Optimization basics

 

Prerequisites:

• General computing concepts, including the basics of CPU, Network Interface, Memory and I/O (Storage) hardware.

• General computer networking knowledge, including a general understanding of the TCP/IP networking protocol.

• Microsoft Windows Server architecture to include multi-user networks, Windows Services and configuration of a Windows Server. 

• Ability to use a scripting language, create a script that reads data from a file and saves a file to disk.

• SQL Server 2012 Installed and configured prior to class - must be usable at your home or wherever you plan to do the assignments.

Required Textbookss

Used or new is acceptable, and you can get an electric copy of these if you like - check first to see if they are available on your Safari Account (free with class):

• 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 tests.

 

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.