May 01, 2024  
2014-2015 Undergraduate Academic Catalog 
    
2014-2015 Undergraduate Academic Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

MS 4831 - Advanced Database Management and SQL

3 lecture hours 0 lab hours 3 credits
Course Description
This course covers topics in the advanced study of database systems, including: transaction management, performance enhancement, distributed databases, security models, the Web as a presentation layer to data, XML as a standard language for data exchange, data warehouses and data mining are explored in this course. The course examines basic Structured Query Language (SQL) concepts, including an overview of Microsoft SQL Server, review of tables, stored procedures, views, and functions, basic/intermediate-level SQL query syntax, and discussion of SQL query performance. Students will develop simple SQL applications that require parameters and utilize variables and temporary tables. (prereq: MS 483 )
Course Learning Outcomes
Upon successful completion of this course, the student will be able to:
• None
Prerequisites by Topic
• None
Course Topics
• None
Coordinator
Jeffrey Blessing



Add to Portfolio (opens a new window)