Back to rrc.ca
Overview Admission Requirements English Language Assessments Who Should Enrol? Locations, Dates and Fees Courses and Descriptions Computer/Laptop Requirements Recognition of Prior Learning Awards and Scholarships Graduation Requirements Printer Friendly Version

HOW TO APPLY   APPLY TODAY

FULL-TIME | WINNIPEG LOCATIONS ITOPF-DP IT Operations

Courses and Descriptions


Apply Now

How to Apply

Printer-Friendly
Overview Admission Requirements English Language Assessments Who Should Enrol? Locations, Dates and Fees Courses and Descriptions Computer/Laptop Requirements Recognition of Prior Learning Awards and Scholarships Graduation Requirements

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-12-21 20:48:56
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.