Apr 28, 2024  
2013-14 Undergraduate Academic Catalog 
    
2013-14 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
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 )



Add to Portfolio (opens a new window)