Course Descriptions and Schedule

Please note that course schedules may be amended due to low enrollment, faculty availability, and/or other factors.

MSDS 420-DL : Database Systems and Data Preparation


Description

In this course students explore the fundamental concepts of database management and data preparation. With a focus on applications in large-scale data analytics projects, the course introduces relational database systems, the relational model, normalization process, and structured query language (SQL). The course discusses topics related to data integration and cleaning, database programming for extract, transform, and load (ETL) operations. Students learn NoSQL technologies for working with unstructured data and document-oriented information retrieval systems. They learn how to index and score documents for effective and relevant responses to user queries. Students acquire hands-on programming experience for data preparation and data extraction using various data sources and file formats.

Recommended:  Prior programming experience or MSDS 430-DL Python for Data Science.

Prerequisite: MSDS 402-DL Introduction to Data Science or MSDS 403-DL Data Science in Practice.


Spring 2021
Start/End DatesDay(s)TimeBuildingSection
03/29/21 - 06/06/21Optional Sync M
Time: TBA 55
InstructorCourse LocationStatusCAESAR Course ID
Bader, Atef
Online
Open

Spring 2021
Start/End DatesDay(s)TimeBuildingSection
03/29/21 - 06/06/21Optional Sync Th
Time: TBA 56
InstructorCourse LocationStatusCAESAR Course ID
Ali, Abid
Online
Open

Spring 2021
Start/End DatesDay(s)TimeBuildingSection
03/29/21 - 06/06/21Optional Sync Tu
Time: TBA 57
InstructorCourse LocationStatusCAESAR Course ID
Dill, Sharon
Online
Open

Spring 2021
Start/End DatesDay(s)TimeBuildingSection
03/29/21 - 06/06/21Optional Sync W
Time: TBA 58
InstructorCourse LocationStatusCAESAR Course ID
Arroyo, Edward
Online
Open

Spring 2021
Start/End DatesDay(s)TimeBuildingSection
03/29/21 - 06/06/21Optional Sync M
7 – 9:30 p.m. 59
InstructorCourse LocationStatusCAESAR Course ID
Dill, Sharon
Online
Open

Summer 2021
Start/End DatesDay(s)TimeBuildingSection
06/21/21 - 08/29/21Optional Sync M
7 – 9:30 p.m. 55
InstructorCourse LocationStatusCAESAR Course ID
Bader, Atef
Online
Open

Summer 2021
Start/End DatesDay(s)TimeBuildingSection
06/21/21 - 08/29/21Optional Sync Th
7 – 9:30 p.m. 56
InstructorCourse LocationStatusCAESAR Course ID
Ali, Abid
Online
Open

Summer 2021
Start/End DatesDay(s)TimeBuildingSection
06/21/21 - 08/29/21Optional Sync Tu
7 – 9:30 p.m. 57
InstructorCourse LocationStatusCAESAR Course ID
Sambamoorthi, Nethra
Online
Open
^ Back to top ^