Skip to main content Skip to site utility navigation Skip to main site navigation Skip to site search Skip to footer
Menu

IT Database Administration

Learn to ensure the quality, availability and security of data.

A man wearing headphones sits at a desk with five computer screens in front of him.
Start Date:
September
Typical Length:
2 Years
Credential:
Diploma

Apply Now

Overview

Information is the main commodity of all organizations. IT database experts identify, organize, analyze and store this important asset, focusing on the three main data priorities: big data, cloud deployment and data security.

Throughout the program, you gain a broad understanding of the IT field. You develop in-depth skills around database management, including how to write data governance policies that direct the configuration of data management systems and ensure quality, availability, recoverability, scalability and security.

You learn to work with current industry tools to analyze, manipulate and administer database structures and infrastructures. Your knowledge is developed and demonstrated through applied learning and best practices. An emphasis is placed on understanding business needs and translating them into technical ideas and solutions.

Work experience

  • Field experience is a mandatory credit course, providing you with the opportunity to apply your knowledge and skills outside of the classroom.
    • Opportunities are typically unpaid and last approximately 5 weeks.
  • This program is eligible for an optional cooperative education (co-op) credit course between year one and two.
    • Co-op provides an opportunity for paid, full-time employment in a field related to your program.
    • Co-op takes place in third term and must be a minimum of 12 weeks and 420 hours.
    • Our co-op program follows Co-operative Education and Work-Integrated Learning Canada (CEWIL) guidelines.
  • Transportation, accommodations and other costs related to work experience are your responsibility.
  • For more information, visit work experience opportunities.

Choose NSCC

  • You benefit from faculty who bring years of industry experience to the classroom.
    • You have opportunities to attend information and communications technology (ICT) functions, such as conferences, collaborative workshops and special interest groups.
    • You can use industry resources to gain further ICT knowledge and obtain vendor-specific certifications.

Other info

  • It's encouraged that applicants have strong verbal and non-verbal skills, and have an interest in solving challenging puzzles, innovating, leading and collaborating.

Availability

Seats are available for domestic applicants only. International applicants will be waitlisted.

September 2024

Campus Full time/part time Delivery Availability
Institute of Technology Campus
Halifax
Full time In person
Delivered in-person. Some courses may have online elements.
Waitlist

Admission requirements

Program requirements

  • Portfolio development – As part of your studies at NSCC, you develop a portfolio of your work; the portfolio captures your achievements and profiles your skills to employers.

Tuition

Tuition amounts are for the 2023-24 academic year. Program costs and fees (textbooks, supplies, etc.) are additional.

Tuition (Domestic):
$3,620
Tuition (International):
$11,690

Tuition, fees and program costs

In addition to annual tuition, there are program costs (books, tools, etc.) and student fees for College services, health and dental plans, your student association and parking.

View detailed program fees page(s). Please note that amounts on these pages are meant for planning purposes only. They don't represent final amounts owing.

Career options

Graduates of this program can work in the following positions:

  • Database engineer
  • Information analyst
  • Database programmer
  • System analyst
  • Data analyst
  • Data steward
  • Information privacy/security analyst
  • Data governance analyst
  • Data quality assurance analyst
  • General ICT support

Future study options

Courses may include

These are some of the courses offered in this program. It is not a complete list and courses are subject to change in advance of the academic year.

Recognizing prior learning / transfer credits
If you have previous learning (course, employment, etc...) that's relevant to your program, you may be able to apply to earn credit. Not all programs are eligible. Learn about our recognizing prior learning (RPL) process.

DBAS 1007 - Data Fundamentals
This course introduces students to the concept of a database management system and its role in the IT infrastructure of any business. Students will use a database management system to develop a database and use this database to store and manipulate data. Students will also be asked to interpret database diagrams and create database objects based on their meaning.

DBAS 2104 - Business Analysis Essentials
This course teaches the fundamental business processes that govern the operation of any business. The focus is on the tools and methodologies used by business analysts to gather information regarding those operational processes and how the gathered information is used to support strategic and tactical decision-making in the business. This fundamental understanding of the business and analysis is then used by the learners to accurately interpret the detailed business requirements that drive design and implementation of supporting IT products and services. Extensive use is made of real world case studies from the local area, including guest lectures from local business analysts. Tools and software used in the course will be chosen according to current local industry standards.

DBAS 3018 - Data Movement and Integration
The course is designed to familiarize learners with the process and methodologies used to discover, analyze, cleanse, integrate and provide large and potentially volatile datasets from heterogeneous data sources to complex processing environments. Progression of skill in this course is done in the end-to-end context of the ETL process within an encompassing Data Governance structure. Enterprises that have adopted a modern data architecture including noSQL platforms must reconcile data management realities when they bring existing and new data from disparate platforms under management. Learners will investigate, discover and identify data sources based on analyzed client requirements, link to those data, perform cleansing, perform any necessary transformations, accurately integrate and load the data to its end platform. Due to the fact that in production, data programmers may be applying all or any component of the ETL process, a variety of platforms will be used ranging from command line ANSI standard SQL to comprehensive ETL suites. Every platform choice in the course will reflect current local industry standards.

DBAS 3021 - Metadata Management
This course introduces students to the concept of managing data assets across an organization to improve business efficiencies and quality, and to reduce redundancy, and maintenance of data. For business to achieve productive data analysis, there needs to be measures set up to control the volume, velocity and variety of the data. Concepts will be introduced to learn about the current strategies and challenges of an organization’s data assets for management, storage, movement, provisioning and access.

DBAS 3025 - Information Governance
The course is designed to familiarize Students with data governance practices and principles to assist business with solving data-related challenges. Students will understand the importance and value data governance brings to an organization. They will be introduced to different strategies and controls that ready the organization for data governance and to be able to incorporate new processes in existing practices such as Change Management, Project Management, and the Data Lifecycle.

DBAS 3035 - Information Systems Design
This course will introduce the learner to the concepts and approaches for improving system wide efficiency at the application level through proper design and implementation. They will cover the system modifications necessary to enhance overall performance. The course will cover logical and physical recommendations for the system from analysis to recommendations.

DBAS 3080 - Database Backup and Recovery
The course will explore a range of backup and recovery strategies available to DBMS platforms. Tools to implement the strategies will be practiced hands-on using case scenarios. Platforms enabling point in time recovery through the use of repository managed change archives will be explored through applied work.

DBAS 3085 - Data Security
This course focuses on the concerns around security in the age of big data. Learners will identify the best practices required to equip an organization for potential data breaches or threats, address roles and responsibilities regarding regulation and examine the requirements for the data lifecycle of an organization.

DBAS 4002 - Transactional Database Programming
This introduction to SQL and transactional processing is designed to give learners a familiarity and hands-on practice with the basic command line interface to an RDBMS. SQL query and data manipulation commands will be fully developed. Data definition language (DDL) commands including CREATE, ALTER and DROP will be developed and practiced to fine-tune database structure and architecture. The course will move on to cover transactional processing, and learners will be challenged to complete a project that demonstrates their mastery of database SQL concepts.

ICOM 2701 - Professional Practice for IT I
This course exposes students to tools and process that support professional continuous improvement. This course builds the foundations for professional habits and methodologies that help graduates remain current and relevant in an ever-evolving profession.

ICOM 2702 - Professional Practice for IT II
This course develops the skills, attitudes, processes and habits required to successfully prepare for a variety of interview scenarios and the associated presentation techniques. Emphasis is on the development of a professional portfolio and the part that personal marketing plays in gaining successful, relevant employment.

ICOM 2703 - Professional Practice for IT III
This course provides students with the skills and knowledge to curate a personal, professional portfolio in readiness for employment in the IT industry. In addition, students will practice and prepare for numerous interview situations and scenarios by honing the skills and techniques previously acquired.

INET 3700 - Server Operating Systems and Scripting
This course focuses on the skills needed to manage an operating system and automate the management of the same operating system. Learners will be able to configure, maintain and troubleshoot the operating system using industry standard toolsets and be able to automate simple management tasks in various platforms. The significant learning of the course will be focused in the command line interface of the operating system.

INFT 3000 - Capstone
Learners acquire hands-on experience on a group project applying much of the material learned throughout their program. Throughout this course, learners will apply their skills to prepare and deliver technical documentation and presentations using various media platforms.

INFT 4100 - Work Experience
This course is a summative experience in the context of a real-world organization. Students will apply learning in an authentic professional IT working environment and gain hands-on industry related skills and knowledge.

ISEC 3050 - Ethics and Law in Data Analytics
This course will explore what it means to use analytics ethically and how to think about its ethical implications. The approach is from the perspective of professionals who lead analytics-oriented teams or organizations, and whose success depends on the ability to recognize the ethical issues at stake and resolve these to the satisfaction of multiple stakeholders. This course provides an overview of current emerging Canadian legislation affecting information technology and management, with a focus on the intersection of these legal principles with business ethics. Learners will practice thinking through and processing legal problems consistent with ethical norms and analyze business risk, taking into consideration ethical issues, to arrive at business decisions.

NETW 1027 - Introduction to Networking and Security
This course is focused on supporting network connected devices covering troubleshooting and maintaining connectivity from a client perspective.

NETW 2700 - Network Infrastructure
The course focuses on switching technologies and router operations that support small-to-medium business networks and includes wireless local area networks (WLANs) and security concepts. Students learn key switching and routing concepts and will be able perform basic network configuration, identify and mitigate LAN security threats, and configure and secure a basic WLAN.

OSYS 1000 - Operating Systems - Linux
This course introduces the skills and knowledge that will enable the student to install, configure, maintain and troubleshoot a current UNIX based operating system (OS) in standalone workstation mode.

OSYS 1200 - Introduction to Windows Administration
This course is an introductory course to familiarize the student with key topics in managing a Windows client operating system.

OSYS 3017 - Data Server Management in Linux
This course introduces learners to the concept of administering a data server system in Linux. Concepts will Include the management, movement, provisioning and security of data files and storage through a Linux command line and scripting environment. Scripting functions related to system monitoring, user data access and log creation and analysis will be examined.

PROG 1400 - Introduction to Object Oriented Programming
This course is an introduction to the essentials of object oriented programming (OOP). This course provides an explanation of the paradigm on which OOP is based, and how it affects programming strategies and solutions.

PROG 1700 - Logic and Programming
This course introduces the fundamentals of logic and computer programming and their role in the creation of software solutions for any problem. Logic is used to break down complex problems into manageable tasks to allow for comprehensive problem-solving using computer code. This course covers the process of creating logical designs and implementing them as programmatic code to build computer software programs.

SAFE 1000 - Introduction to WHMIS (Workplace Hazardous Materials Information Systems)
This course offers learners basic overview of WHMIS principles and establishes a solid foundation to support workplace-specific training on the safe storage and handling of controlled/hazardous products. Upon successful completion of the course, students receive basic WHMIS certification.

SAFE 1001 - Introduction to NS OH&S Act
This course offers students an introduction to the Occupational Health & Safety (OH&S) Act of Nova Scotia, which is required by any person employed in a Nova Scotia workplace. This is a generic, introductory course that provides basic knowledge of the Act for students and is considered to be the basis from which more specific training can be given.

WEBD 1000 - Website Development
This course provides an introduction to website development. Emphasis will be placed on development processes, usability, and adhering to current industry standards.

Apply Now

Learn more about this program

Contact us

Share your details with us and we'll send you a program overview.

Required fields are marked with a red symbol (*)

Thank you for contacting us.

Your program overview is on the way. While you wait, feel free to browse our list of Programs & Courses or visit our Admissions information section.

Explore similar programs

To find other programs and career options that might be a good fit for you check out these areas of interest:

Top