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

Notes

For the best experience, your computer and internet connection should meet certain requirements. See the recommended requirements...

Proficiencies

This course content is at the beginner level of the subject matter, however computer proficiency is required:

  • Students must be familiar with the personal computer, keyboard and mouse.
  • Students must have Microsoft Windows Operating systems skills and knowledge, and be able to perform the following tasks:
    • start and run Windows computers
    • use the taskbar, Start button and Help feature
    • use Minimize, Maximize, Restore Down/Up and Close
    • use the left and right mouse buttons appropriately
    • understand file management techniques
    • navigate between files, folders, or drives
    • cutting, copying, and pasting content, files and folders
    • using print screen or snipping tool

Applies Towards the Following Certificate(s)

Loading...

Enrol Now - Select a section to enrol in

Type
Online Synchronous
Days
M, W
Time
6:00PM to 9:00PM
Dates
Oct 26, 2020 to Nov 30, 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 2019 for Developers
Edition: April 2020
Authors: Murach, Syverson
Publisher: Mike Murach & Associates
ISBN: 978-1-943872-57-2

Please note: ICT textbooks are not available through the University of Calgary bookstore.

Section Notes

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

You will require access to a computer with an 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. The instructor will post your course outline and other materials in D2L.
  • Zoom web conferencing software.
  • A virtual lab with VMware Horizon, a platform that provides access to virtual applications including the latest software for the course. You will be provided with a VMware account and login information once the course starts.

For the best experience, your computer and internet connection should meet certain requirements. See the recommended requirements...

For more information, please visit our Online Learning Resources.

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

Students who are unfamiliar with Desire2Learn or Zoom are recommended to take BMC 352 Learning Online prior to enrolling in this course.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least seven 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 (Wednesday, November 11, 2020)
Type
Online Synchronous
Days
M
Time
6:00PM to 9:00PM
Dates
Jan 11, 2021 to Mar 22, 2021
Schedule and Location
Hours
30.0
Delivery Options
Course Fees
Flat Fee non-credit $825.00
Reading List / Textbook

Title: Murach's SQL Server 2019 for Developers
Edition: April 2020
Authors: Murach, Syverson
Publisher: Mike Murach & Associates
ISBN: 978-1-943872-57-2

Please note: ICT textbooks are not available through the University of Calgary bookstore.

Section Notes

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

You will require access to a computer with an 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. The instructor will post your course outline and other materials in D2L.
  • Zoom web conferencing software.
  • A virtual lab with VMware Horizon, a platform that provides access to virtual applications including the latest software for the course. You will be provided with a VMware account and login information once the course starts.

For the best experience, your computer and internet connection should meet certain requirements. See the recommended requirements...

For more information, please visit our Online Learning Resources.

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

Students who are unfamiliar with Desire2Learn or Zoom are recommended to take BMC 352 Learning Online prior to enrolling in this course.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least seven 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:

  • Monday, February 15 2021 (Family Day, Monday, February 15, 2021)
     
Type
Online Synchronous
Days
W
Time
6:00PM to 9:00PM
Dates
Feb 17, 2021 to Mar 17, 2021
Type
Online Synchronous
Days
Sa
Time
9:00AM to 12:00PM
Dates
Feb 20, 2021 to Mar 20, 2021
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 2019 for Developers
Edition: April 2020
Authors: Murach, Syverson
Publisher: Mike Murach & Associates
ISBN: 978-1-943872-57-2

Please note: ICT textbooks are not available through the University of Calgary bookstore.

Section Notes

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

You will require access to a computer with an 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. The instructor will post your course outline and other materials in D2L.
  • Zoom web conferencing software.
  • A virtual lab with VMware Horizon, a platform that provides access to virtual applications including the latest software for the course. You will be provided with a VMware account and login information once the course starts.

For the best experience, your computer and internet connection should meet certain requirements. See the recommended requirements...

For more information, please visit our Online Learning Resources.

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

Students who are unfamiliar with Desire2Learn or Zoom are recommended to take BMC 352 Learning Online prior to enrolling in this course.

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

 

Type
Online Synchronous
Days
T, Th
Time
6:00PM to 9:00PM
Dates
May 11, 2021 to Jun 10, 2021
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 2019 for Developers
Edition: April 2020
Authors: Murach, Syverson
Publisher: Mike Murach & Associates
ISBN: 978-1-943872-57-2

Please note: ICT textbooks are not available through the University of Calgary bookstore.

Section Notes

 

You will require access to a computer with an 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. The instructor will post your course outline and other materials in D2L.
  • Zoom web conferencing software.
  • A virtual lab with VMware Horizon, a platform that provides access to virtual applications including the latest software for the course. You will be provided with a VMware account and login information once the course starts.

For the best experience, your computer and internet connection should meet certain requirements. See the recommended requirements...

For more information, please visit our Online Learning Resources.

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

Students who are unfamiliar with Desire2Learn or Zoom are recommended to take BMC 352 Learning Online prior to enrolling in this course.

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

Type
Online Synchronous
Days
T, Th
Time
6:00PM to 9:00PM
Dates
Jul 06, 2021 to Aug 05, 2021
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 2019 for Developers
Edition: April 2020
Authors: Murach, Syverson
Publisher: Mike Murach & Associates
ISBN: 978-1-943872-57-2

Please note: ICT textbooks are not available through the University of Calgary bookstore.

Section Notes

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

You will require access to a computer with an 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. The instructor will post your course outline and other materials in D2L.
  • Zoom web conferencing software.
  • A virtual lab with VMware Horizon, a platform that provides access to virtual applications including the latest software for the course. You will be provided with a VMware account and login information once the course starts.

For the best experience, your computer and internet connection should meet certain requirements. See the recommended requirements...

For more information, please visit our Online Learning Resources.

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

Students who are unfamiliar with Desire2Learn or Zoom are recommended to take BMC 352 Learning Online prior to enrolling in this course.

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

 

Required fields are indicated by .