Loading...

Course Description

This course introduces students to the principles behind designing a well formed relational database management system (RDMS) that optimizes the storage and retrieval of data. In addition, students will learn how to utilize the SQL language for creating, manipulating and securing the various database objects that are used in a RDMS.


Course Details

A database is a structured collection of information. The data structure is a particular way of storing and organizing the data in a computer so that it can be used efficiently. A Database Management System (DBMS) is a set of computer programs that enables you to store, modify, and extract information from a database, and provides users with tools to add, delete, access, modify, and analyze data stored in one location. Online retailers, grocery stores, and hospitals all rely on the timely input and retrieval of data to maintain daily operations. How the database systems are designed to organize data plays a key role in determining the ease with which relevant and reliable information can be made available to the organization.

This course is designed for those who have little to no prior knowledge or experience with relational databases and want to gain some fundamental skills in an expanding industry. Databases are steadily becoming a vital part of IT as they comprise the backend of websites such as Amazon, Facebook, and university or government sites.


Course Level Learning Outcomes

  • Design a relational database, normalize it and create tables that implement the design
  • Apply Structured Query Language (SQL) to query and manipulate data in a relational database as required

Topics of Instruction

  • Introductory Concepts of Relational Databases
    • Introduction to SQL
  • Data Retrieval with SELECT
  • Filtering and Sorting Data Sets
  • More Complex Data Retrieval Queries
    • Joining Tables
    • Using Functions
  • Data Manipulation with INSERT, UPDATE and DELETE
  • Managing Transitions
  • Creating Tables
  • Managing Data Integrity
  • Designing Databases
    • Logical Modelling
    • Normalization
  • Introduction to Database Administration
    • Managing Secure Access and Performance

Applies Towards the Following Certificate(s)

Loading...

Enrol Now - Select a section to enrol in

Type
Online Synchronous
Days
T, Th
Time
6:00PM to 9:00PM
Dates
Jul 02, 2019 to Aug 01, 2019
Schedule and Location
Hours
30.0
Delivery Options
Course Fees
Flat Fee non-credit $825.00
Instructor(s)
Reading List / Textbook

Title: Murach's SQL Server 2016 for Developers
Edition: June 2016
Authors: Murach, Syverson
Publisher: Mike Murach & Associates
ISBN: 978-1890774967

Section Notes

Classes are held online in real time (Mountain Time) at the specified time and dates.

You will require access to a computer, Internet connection, headset with speakers and microphone, webcam, and a monitor large enough to display multiple applications (or the use of two monitors).

This course uses Desire2Learn (D2L), an online learning management system, and Adobe Connect (AC) web conferencing software. The instructor will post your course outline and other materials in D2L. If you are unfamiliar with the D2L and AC learning tools it is strongly recommended to take BMC 352 Learning Online prior to enrolling in this course. For more information about D2L, please visit our Online Learning Resources.

Unless notified, all online courses are available at 9 am MT on the start date. Students who register on (or after) the start date will receive access within one day of registration.

A $25 fee applies for course withdrawals and transfers. Unless otherwise stated, notice of a withdrawal or transfer from a course must be received at least ten calendar days prior to the start date of the course.

 

Type
Class
Days
T
Time
6:00PM to 9:00PM
Dates
Sep 17, 2019 to Nov 19, 2019
Schedule and Location
Hours
30.0
Delivery Options
Course Fees
Flat Fee non-credit $825.00
Reading List / Textbook

Title: Murach's SQL Server 2016 for Developers
Edition: June 2016
Authors: Murach, Syverson
Publisher: Mike Murach & Associates
ISBN: 978-1890774967

Section Notes

This course is delivered in a lab synchronously with an online class. The instructor will teach both online and classroom students at the same time, and may have help from an assistant.

This course uses Desire2Learn (D2L), an online learning management system. The instructor will post your course outline and other materials in D2L. For more information about D2L, please visit our Online Learning Resources.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least ten calendar days prior to the start date of the course.

Type
Online Synchronous
Days
T
Time
6:00PM to 9:00PM
Dates
Sep 17, 2019 to Nov 19, 2019
Schedule and Location
Hours
30.0
Delivery Options
Course Fees
Flat Fee non-credit $825.00
Reading List / Textbook

Title: Murach's SQL Server 2016 for Developers
Edition: June 2016
Authors: Murach, Syverson
Publisher: Mike Murach & Associates
ISBN: 978-1890774967

Section Notes

Classes are held online in real time (Mountain Time) at the specified time and dates. This course is delivered online synchronously with students in a lab. The instructor will teach both online and classroom students at the same time and may have help from an assistant.

You will require access to a computer, Internet connection, a headset with speakers and microphone, webcam, and a monitor large enough to display multiple applications (or the use of two monitors).

This course uses Desire2Learn (D2L), an online learning management system, and Adobe Connect (AC) web conferencing software. The instructor will post your course outline and other materials in D2L. If you are unfamiliar with the D2L and AC learning tools it is strongly recommended to take BMC 352 Learning Online prior to enrolling in this course. For more information about D2L, please visit our Online Learning Resources.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least ten calendar days prior to the start date of the course.

Type
Online Synchronous
Days
M, W
Time
6:00PM to 9:00PM
Dates
Oct 21, 2019 to Nov 25, 2019
Schedule and Location
Hours
30.0
Delivery Options
Course Fees
Flat Fee non-credit $825.00
Instructor(s)
Reading List / Textbook

Title: Murach's SQL Server 2016 for Developers
Edition: June 2016
Authors: Murach, Syverson
Publisher: Mike Murach & Associates
ISBN: 978-1890774967

Section Notes

Classes are held online in real time (Mountain Time) at the specified time and dates.

You will require access to a computer, Internet connection, headset with speakers and microphone, webcam, and a monitor large enough to display multiple applications (or the use of two monitors).

This course uses Desire2Learn (D2L), an online learning management system, and Adobe Connect (AC) web conferencing software. The instructor will post your course outline and other materials in D2L. If you are unfamiliar with the D2L and AC learning tools it is strongly recommended to take BMC 352 Learning Online prior to enrolling in this course. For more information about D2L, please visit our Online Learning Resources.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least ten calendar days prior to the start date of the course.

The University is closed on holidays and no classes are run on these dates or their long-weekends:

  • Remembrance Day (Monday, November 11, 2019)
Type
Online Synchronous
Days
Sa
Time
9:00AM to 12:00PM
Dates
Jan 11, 2020 to Mar 21, 2020
Schedule and Location
Hours
30.0
Delivery Options
Course Fees
Flat Fee non-credit $825.00
Instructor(s)
Reading List / Textbook

Title: Murach's SQL Server 2016 for Developers
Edition: June 2016
Authors: Murach, Syverson
Publisher: Mike Murach & Associates
ISBN: 978-1890774967

Section Notes

Classes are held online in real time (Mountain Time) at the specified time and dates.

You will require access to a computer, Internet connection, headset with speakers and microphone, webcam, and a monitor large enough to display multiple applications (or the use of two monitors).

This course uses Desire2Learn (D2L), an online learning management system, and Adobe Connect (AC) web conferencing software. The instructor will post your course outline and other materials in D2L. If you are unfamiliar with the D2L and AC learning tools it is strongly recommended to take BMC 352 Learning Online prior to enrolling in this course. For more information about D2L, please visit our Online Learning Resources.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least ten calendar days prior to the start date of the course.

The University is closed on holidays and no classes are run on these dates or their long-weekends:

  • Saturday, February 15, 2020 (Family Day, Monday, February 17, 2020)
Type
Online Synchronous
Days
T, Th
Time
6:00PM to 9:00PM
Dates
Jan 14, 2020 to Feb 13, 2020
Schedule and Location
Hours
30.0
Delivery Options
Course Fees
Flat Fee non-credit $825.00
Instructor(s)
Reading List / Textbook

Title: Murach's SQL Server 2016 for Developers
Edition: June 2016
Authors: Murach, Syverson
Publisher: Mike Murach & Associates
ISBN: 978-1890774967

Section Notes

Classes are held online in real time (Mountain Time) at the specified time and dates.

You will require access to a computer, Internet connection, headset with speakers and microphone, webcam, and a monitor large enough to display multiple applications (or the use of two monitors).

This course uses Desire2Learn (D2L), an online learning management system, and Adobe Connect (AC) web conferencing software. The instructor will post your course outline and other materials in D2L. If you are unfamiliar with the D2L and AC learning tools it is strongly recommended to take BMC 352 Learning Online prior to enrolling in this course. For more information about D2L, please visit our Online Learning Resources.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least ten calendar days prior to the start date of the course.

Type
Online Synchronous
Days
T, Th
Time
6:00PM to 9:00PM
Dates
Apr 14, 2020 to May 14, 2020
Schedule and Location
Hours
30.0
Delivery Options
Course Fees
Flat Fee non-credit $825.00
Reading List / Textbook

Title: Murach's SQL Server 2016 for Developers
Edition: June 2016
Authors: Murach, Syverson
Publisher: Mike Murach & Associates
ISBN: 978-1890774967

Section Notes

Classes are held online in real time (Mountain Time) at the specified time and dates.

You will require access to a computer, Internet connection, headset with speakers and microphone, webcam, and a monitor large enough to display multiple applications (or the use of two monitors).

This course uses Desire2Learn (D2L), an online learning management system, and Adobe Connect (AC) web conferencing software. The instructor will post your course outline and other materials in D2L. If you are unfamiliar with the D2L and AC learning tools it is strongly recommended to take BMC 352 Learning Online prior to enrolling in this course. For more information about D2L, please visit our Online Learning Resources.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least ten calendar days prior to the start date of the course.

Type
Class
Days
M
Time
6:00PM to 9:00PM
Dates
Apr 20, 2020 to Jun 29, 2020
Schedule and Location
Hours
30.0
Delivery Options
Course Fees
Flat Fee non-credit $825.00
Reading List / Textbook

Title: Murach's SQL Server 2016 for Developers
Edition: June 2016
Authors: Murach, Syverson
Publisher: Mike Murach & Associates
ISBN: 978-1890774967

Section Notes

This course uses Desire2Learn (D2L), an online learning management system. The instructor will post your course outline and other materials in D2L. For more information about D2L, please visit our Online Learning Resources.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least ten calendar days prior to the start date of the course.

The University is closed on holidays and no classes are run on these dates or their long-weekends:

  • Victoria Day (Monday, May 18, 2020)
Type
Online Synchronous
Days
M, W
Time
6:00PM to 9:00PM
Dates
Jul 06, 2020 to Aug 10, 2020
Schedule and Location
Hours
30.0
Delivery Options
Course Fees
Flat Fee non-credit $825.00
Instructor(s)
Reading List / Textbook

Title: Murach's SQL Server 2016 for Developers
Edition: June 2016
Authors: Murach, Syverson
Publisher: Mike Murach & Associates
ISBN: 978-1890774967

Section Notes

Classes are held online in real time (Mountain Time) at the specified time and dates.

You will require access to a computer, Internet connection, headset with speakers and microphone, webcam, and a monitor large enough to display multiple applications (or the use of two monitors).

This course uses Desire2Learn (D2L), an online learning management system, and Adobe Connect (AC) web conferencing software. The instructor will post your course outline and other materials in D2L. If you are unfamiliar with the D2L and AC learning tools it is strongly recommended to take BMC 352 Learning Online prior to enrolling in this course. For more information about D2L, please visit our Online Learning Resources.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least ten calendar days prior to the start date of the course.

The University is closed on holidays and no classes are run on these dates or their long-weekends:

  • Heritage Day (Monday, August 3, 2020)
Required fields are indicated by .