Loading...

Course Description

This course provides a foundation in data management for data analysts. Topics include database architectures, formation of queries, queries themselves, data warehousing, relational database systems, NoSQL, and responsibilities of data management professionals.

What Will You Learn?

This course provides database skills in the application of knowledge transfer, advanced critical thinking, research application, and report writing with respect to big data and data analytics.

Learn how to:

  • Use a practical procedural language to define, construct, manipulate, share, and protect a structured database.
  • Reverse and Forward engineer a database to create valid logical models and migratable snapshots.
  • Manipulate the basic components of a relational model, its entity/referential integrity constraints, and update operations.
  • Extract data from data and document-centric databases (for example, XMLs and JSONs) using XPATH and XQuery expressions.
  • Differentiate between database and information retrieval systems.
  • Index, search and retrieve information from large collection of unstructured documents using statistical approaches.
  • Use data mining techniques, such as association rules, sequential patterns, and classification trees for big data analyses.

Notes

Students are recommended to check the important dates for the Chang School current term before enrolling in the course and paying the fees. Notably, the Azure Virtual Desktop assigned to students will be accessible two days after the course’s starting date, and swapping between sections will not be permitted.

Students are also encouraged to download the Microsoft Remote Desktop app to access the software needed to complete this course’s requirements. Students also need to test the compatibility of the computer they plan to use before the first session, as machines operated using a third-party administrator, such as laptops provided by a workplace, may not allow access to the required software/download(s). International students might need to use their virtual private network (VPN) software if they cannot connect to University resources.

Classroom Delivery

This course offers on-campus section(s) for the 2022/23 academic year. On-campus sections are identified in each section's detail summary as “Classroom” (and/or “Downtown” as the location). Visit COVID-19 Updates for Chang School Students for the most up-to-date guidance on attending on-campus classes.  

 

Relevant Programs

Loading...
Course Sections
Class Number
5632
Type
LEC
Days
T
Time
6:30PM to 9:30PM
Dates
Jan 10, 2023 to Apr 18, 2023
Schedule
Contact Hours
42.0
Location
  • Online
Delivery Options
Online  
Fees
Domestic Fee non-credit $1,028.53 Click here to get more information
Domestic Out of Province Fee non-credit $0.00 Click here to get more information
International Fee non-credit $0.00 Click here to get more information
Class Number
5630
Type
LEC
Days
Th
Time
6:30PM to 9:30PM
Dates
Jan 12, 2023 to Apr 20, 2023
Schedule
Contact Hours
42.0
Location
  • Online
Delivery Options
Online  
Fees
Domestic Fee non-credit $1,028.53 Click here to get more information
Domestic Out of Province Fee non-credit $0.00 Click here to get more information
International Fee non-credit $0.00 Click here to get more information
Class Number
5631
Type
LEC
Days
Sa
Time
9:30AM to 12:30PM
Dates
Jan 14, 2023 to Apr 22, 2023
Schedule
Contact Hours
39.0
Location
  • Online
Delivery Options
Online  
Fees
Domestic Fee non-credit $1,028.53 Click here to get more information
Domestic Out of Province Fee non-credit $0.00 Click here to get more information
International Fee non-credit $0.00 Click here to get more information
Class Number
6309
Type
LEC
Days
Sa
Time
1:00PM to 4:00PM
Dates
Jan 14, 2023 to Apr 22, 2023
Schedule
Contact Hours
39.0
Location
  • Downtown
Delivery Options
Classroom  
Fees
Domestic Fee non-credit $1,028.53 Click here to get more information
Domestic Out of Province Fee non-credit $0.00 Click here to get more information
International Fee non-credit $0.00 Click here to get more information
Class Number
1313
Type
LEC
Days
Sa
Time
9:30AM to 3:30PM
Dates
Apr 29, 2023 to Jun 17, 2023
Schedule
Contact Hours
42.0
Location
  • Online
Delivery Options
Online  
Fees
Domestic Fee non-credit $1,028.53 Click here to get more information
Domestic Out of Province Fee non-credit $0.00 Click here to get more information
International Fee non-credit $0.00 Click here to get more information
Class Number
1315
Type
LEC
Days
T, Th
Time
6:30PM to 9:30PM
Dates
May 02, 2023 to Jun 15, 2023
Schedule
Contact Hours
42.0
Location
  • Online
Delivery Options
Online  
Fees
Domestic Fee non-credit $1,028.53 Click here to get more information
Domestic Out of Province Fee non-credit $0.00 Click here to get more information
International Fee non-credit $0.00 Click here to get more information
Class Number
1755
Type
LEC
Days
W
Time
6:30PM to 9:30PM
Dates
May 03, 2023 to Aug 02, 2023
Schedule
Contact Hours
42.0
Location
  • Online
Delivery Options
Online  
Fees
Domestic Fee non-credit $1,028.53 Click here to get more information
Domestic Out of Province Fee non-credit $0.00 Click here to get more information
International Fee non-credit $0.00 Click here to get more information
Class Number
1314
Type
LEC
Days
Sa
Time
9:30AM to 3:30PM
Dates
Jun 24, 2023 to Aug 19, 2023
Schedule
Contact Hours
42.0
Location
  • Online
Delivery Options
Online  
Fees
Domestic Fee non-credit $1,028.53 Click here to get more information
Domestic Out of Province Fee non-credit $0.00 Click here to get more information
International Fee non-credit $0.00 Click here to get more information