Syllabus IS341

Instructor: Patrick M. Bailey, MS, Room NH291

Office Hours: Wednesdays, immediately after class

Text Book:

Required: Microsoft SQL Server 2008 Bible, Paul Nielsen, Wiley, 978-0470257043

Supplemental References:

Beginning T-SQL 2008, Kathy Kellenberger, ISBN 978-1-4302-2461-7 (Kel)

DOI = http://www.springerlink.com/content/978-1-4302-2461-7/contents/

Beginning SQL Server 2005 for Developers, Robin Dewison, ISBN 978-1-59059-588-6 (Dew)

DOI = http://www.springerlink.com/content/978-1-59059-588-6/contents/

Any reference source on ASP.Net and C# is recommended.

Lecture: SB382 (Monday and Wednesday, 4:30) Lab: SB382/337 (Friday, 4:30)

Course Description: (3). F. This course prepares students to set up and administer database servers and clients on a network. Topics include an introduction to database design; SQL programming; principles for interfacing with a database server using the Microsoft Visual Studio development environment (C#, ADO.Net and ASP.NET); issues in data management integrity and security; legal and ethical issues. Prerequisite: 141, 271 or permission of the instructor.

Course Goals and Approach: The expected outcomes for the course are as follows:

• Understand the business expectations of database technology.
• Understand concepts of relational database design to include functional dependencies and rules of normalization
• Understand how to translate requirements and business rules into a data model
• Become proficient in the use of ANSI SQL and its use in Transact-SQL
• Become proficient in server side programming to include stored procedures, triggers and transaction processing
• Understand the trends in data mining and cloud computing
• Understand the types of indexing options and their performance impact
• Gain experience in integrating database connectivity into applications
• Understand basic database administration and security support through SQL (e.g. GRANT, DENY ) and tools (e.g. SQL Server Management Studio)