May 03, 2024  
2020-2021 Hill Book (Class of 2024) 
    
Catalog Navigation
  Hill Book Home
  Mission and History
  Academic Life & the Curriculum
  Academic Partnerships & Resources
  International and Experiential Learning Programs
  The Cornerstone Program of General Education
  Programs of Study
  Course Descriptions
  Academic Policies and Procedures
  Graduate Policies and Procedures
  Financial Information and Scholarships
  College Legal Notices
  Faculty and Staff Listing
  Archived HillBook Catalogs
HELP
2020-2021 Hill Book (Class of 2024) [ARCHIVED HILL BOOK]

Facebook this Page (opens a new window)
Tweet this Page (opens a new window)

DAN 604 - Database & Data Warehouse Concepts

Four Credits
Spring Semester

Practical survey course covering database and data warehouse fundamentals.  Emphasizes SQL (simple and complex queries), the Extract-Transformation-Load (ETL) process, relational versus non-relational databases (and why relational databases can be a problem for analysis), an exploration of different database systems (Oracle, Microsoft SQL Server, etc.), data warehousing concepts, normalization/de-normalization, and cloud data warehousing. Course provides practical skills for database querying, and allows provides a foundational knowledge of database concepts so that students can work better with the database administration staff.

Course Applies to: M.P.S. in Data Analytics


Facebook this Page (opens a new window)
Tweet this Page (opens a new window)