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

Classroom sessions for this course are held in a computer lab and attendance is required to be successful in the course.

Open lab hours are also available outside of class time to complete the mandatory labs and assignments.

Course materials, video lectures and discussions are delivered and facilitated online within the D2L Learning Management System.

Throughout the semester, student questions related to course content may be answered either by the instructor on discussion board or by an online tutor via email. For more information, please email Anne-Marie Brinsmead, Program Director, at a2brinsm@ryerson.ca

Relevant Programs

Loading...

Course Sections

Class Number
5415
Type
LEC
Days
F
Time
6:30PM to 9:30PM
Dates
Jan 10, 2020 to Apr 17, 2020
Schedule
Contact Hours
39.0
Location
  • Downtown
Delivery Options
Classroom/Online  
Compulsory Fees
Domestic Fee non-credit $1,017.01 Click here to get more information
International Fee non-credit $0.00 Click here to get more information
Class Number
5416
Type
LEC
Days
Sa
Time
9:30AM to 12:30PM
Dates
Jan 11, 2020 to Apr 18, 2020
Schedule
Contact Hours
39.0
Location
  • Downtown
Delivery Options
Classroom/Online  
Compulsory Fees
Domestic Fee non-credit $1,017.01 Click here to get more information
International Fee non-credit $0.00 Click here to get more information
Class Number
6212
Type
LEC
Days
T, Th
Time
1:00PM to 4:00PM
Dates
Jan 14, 2020 to Mar 03, 2020
Schedule
Contact Hours
3.0
Location
  • Downtown
Delivery Options
Classroom/Online  
Compulsory Fees
Domestic Fee non-credit $1,017.01 Click here to get more information
International Fee non-credit $0.00 Click here to get more information
Class Number
5414
Type
LEC
Days
Th
Time
6:30PM to 9:30PM
Dates
Jan 16, 2020 to Apr 16, 2020
Schedule
Contact Hours
39.0
Location
  • Downtown
Delivery Options
Classroom/Online  
Compulsory Fees
Domestic Fee non-credit $1,017.01 Click here to get more information
International Fee non-credit $0.00 Click here to get more information
Class Number
1374
Type
LEC
Days
M, W
Time
1:00PM to 4:00PM
Dates
May 04, 2020 to Jun 17, 2020
Schedule
Contact Hours
39.0
Location
  • Downtown
Delivery Options
Classroom/Online  
Compulsory Fees
Domestic Fee non-credit $1,017.01 Click here to get more information
International Fee non-credit $0.00 Click here to get more information
Class Number
1375
Type
LEC
Days
T, Th
Time
6:30PM to 9:30PM
Dates
May 05, 2020 to Jun 16, 2020
Schedule
Contact Hours
39.0
Location
  • Downtown
Delivery Options
Classroom/Online  
Compulsory Fees
Domestic Fee non-credit $1,017.01 Click here to get more information
International Fee non-credit $0.00 Click here to get more information
Class Number
1370
Type
LEC
Days
Th
Time
9:30AM to 12:30PM
Dates
May 07, 2020 to Jul 30, 2020
Schedule
Contact Hours
39.0
Location
  • Downtown
Delivery Options
Classroom/Online  
Compulsory Fees
Domestic Fee non-credit $1,017.01 Click here to get more information
International Fee non-credit $0.00 Click here to get more information
Class Number
1371
Type
LEC
Days
F
Time
5:00PM to 11:00PM
Dates
May 08, 2020 to Jun 19, 2020
Schedule
Contact Hours
42.0
Location
  • Downtown
Delivery Options
Classroom/Online  
Compulsory Fees
Domestic Fee non-credit $1,017.01 Click here to get more information
International Fee non-credit $0.00 Click here to get more information
Class Number
1372
Type
LEC
Days
F
Time
4:30PM to 10:30PM
Dates
Jun 26, 2020 to Aug 14, 2020
Schedule
Contact Hours
42.0
Location
  • Downtown
Delivery Options
Classroom/Online  
Compulsory Fees
Domestic Fee non-credit $1,017.01 Click here to get more information
International Fee non-credit $0.00 Click here to get more information
Class Number
1373
Type
LEC
Days
Sa
Time
4:00PM to 10:00PM
Dates
Jun 27, 2020
Type
LEC
Days
Sa
Time
9:30AM to 3:30PM
Dates
Jul 04, 2020 to Aug 15, 2020
Schedule
Contact Hours
42.0
Location
  • Downtown
Delivery Options
Classroom/Online  
Compulsory Fees
Domestic Fee non-credit $1,017.01 Click here to get more information
International Fee non-credit $0.00 Click here to get more information