FULL-TIME | WINNIPEG LOCATIONS DATSF-DP Data Science and Machine Learning

Courses and Descriptions

COMP-1701Transforming Data Into Databases

This is a data-focused course to develop confidence with quick data handling, parsing, structuring, and manipulating datasets for various database types. By viewing, understanding, and normalizing datasets, students will produce Entity Relationship Diagrams (ERDs) and other visual data schemas. Students will learn basic Structured Query Language (SQL) and NoSQL (not only SQL) data types, key-value pairs, and document stores. Students will develop basic to advanced commands including complex JOINs, advanced mathematical and string functions, and full-text search indexing functions. Students will tune the performance and execution times of queries using common practices of indexing and de-normalization. 
Page produced on 2024-11-21 20:24:29
Red River College Polytechnic endeavours to provide the most current version of all program and course information on this website. Please be advised that classes may be scheduled between 8:00 a.m. and 10:00 p.m. The College reserves the right to modify or cancel any course, program, process, or procedure without notice or prejudice. Fees may change without notice.