Overview

A database administrator plays a crucial role in managing and maintaining databases within an organization. You ensure the availability, security, integrity and performance of the databases that store critical data.  

This program may be for you if you have existing relational database knowledge and an interest in computers and information technology.

In this program, you will learn:

  • how to use database administration tools from industry leaders like Oracle and Microsoft and gain proficiency in managing databases on Windows and Linux platforms, commonly used in enterprise environments
  • how data is organized, structured and related within these databases
  • to design efficient and scalable database systems, master data modelling, and normalization techniques while creating database schemas that meet business requirements
  • how to create, design and optimize database systems for speed, responsiveness and scalability
  • to be proficient at ongoing database maintenance tasks
  • to implement robust backup and recovery plans to safeguard data integrity
  • to implement security measures to safeguard data from unauthorized access and security threats, a top priority for organizations to protect sensitive information.

Apply your knowledge and skills as a database system administrator to real-world computer science scenarios. Hands-on experience in a practicum placement will prepare you to tackle the challenges and complexities of database administration in actual work settings.

Database technology is continuously evolving. As a graduate, you will be well-prepared for a career in a dynamic field as an asset to organizations relying on data-driven decision-making.

Potential roles include Oracle database administrator, database developer, data analyst or database architect.

Due to the tight integration of the courses in the Database Administrator program, credit for prior learning is unavailable.

Those working in the database administration field tend to be innovative, methodical and directive.  

You need:

  • to learn quickly, think logically and study information
  • to build abstract structures that represent complex relationships
  • to focus on details without losing sight of the whole
  • an awareness of legal, policy and privacy restrictions
  • speaking, listening and writing skills
  • to work on a team
  • an active interest in keeping up with changes in technology.

This program is designed for learners with existing IT literacy. We strongly recommend you have prior experience with relational databases (like Microsoft Access) and operating systems (like Linux/Unix, Windows.)

To do well in this field, you should enjoy working with a variety of people in a team setting and solving problems.

During your final semester, you’ll participate in a practicum at a participating company, providing you with a realistic taste of the technology industry and the opportunity to network with a potential employer. 

This program, offered in conjunction with the Oracle Workforce Development Program, includes core Oracle Education courses needed to challenge the Oracle Certified Professional Database Administrator designation. 

With additional relevant work experience and exam preparation study, you will be prepared to successfully challenge and complete the Oracle Certified Professional (OCP) Database Administration designation. 

Upon successful completion of this program, you will be awarded a SAIT Database Administrator certificate.

Download program info

Careers and opportunities

Each year, SAIT conducts a survey between February and April to determine the employment rate, salary and satisfaction of our newest SAIT alumni. 

people icon 100% graduate employment rate

Find out more about our graduate employment statistics >

Our graduates may work in the following occupations. Some careers require additional experience and education.

Associated National Occupational Classification (NOC) codes: 21211, 21223.

Test

Career counselling and support

Unsure which career path is for you? SAIT offers career planning services to help you decide your future.

You can also get started by taking our online career finder quiz, which can help you narrow down your search based on your current skills and interests.

Finally, you can also head to Alberta alis for various tools and resources, including additional quizzes and labour market information to help you narrow down a career path.

Courses

The Database Administrator certificate requires 39 credits (18 courses) to complete.

The program spans 40 weeks, with three semesters.

View classes by semester

Course Credits

This course is designed to give the Oracle Database Administrator a firm foundation in basic administrative tasks and provide the necessary knowledge and skills to set up, maintain and troubleshoot an Oracle database. This course uses Oracle-certified curriculum.

3

In this course, learners configure an Oracle database in a networked environment. Networking security risks and optional solutions are presented. In addition, learners are introduced to common errors and troubleshooting and debugging tools. This course uses Oracle-certified curriculum.

1.5

This course covers the basics of shell scripts for databases.

1.5

This course provides an extensive introduction to data server technology including relational databases and the SQL and PL/SQL programming languages. Learners are taught to create and maintain database objects and to store, retrieve, and manipulate data. In addition, learners create PL/SQL code. This course uses Oracle-certified curriculum.

3

This course introduces learners to network concepts, network designs, client/server configurations, system administration, networking and troubleshooting in Windows environments. Database concepts are explored using Microsoft Office Access.

3

This course covers Entity Relationship Modelling in detail through real-life examples, practical business problems and solutions. The second part of the course explores the design process and presents the considerations for creating a normalized, stable, maintainable and well-defined relational database.

1.5

Learners are introduced to the concepts and application of data warehousing and mining. Data warehousing and mining processes are explored. Various data mining techniques are examined, with a focus on business problem applications.

1.5

This course introduces learners to the critical task of planning and implementing database backup and recovery strategies. The course addresses backup and recovery techniques and examines various backup, failure, restore and recovery scenarios. This course uses Oracle-certified curriculum.

3

Learners conduct a system analysis, develop a project schedule, incorporate the components of a database and prepare a proposal.

6

Learners are introduced to the techniques used to improve the performance of the Oracle server. Learners use various tools to recognize, troubleshoot and resolve common performance-related problems in administering a database.

1.5

This course will include the skills required for career management, including resume and cover letter writing, job search strategies and interviewing skills.

1.5

This course provides learners the technical skills to program a database solution and write SQL queries. It also provides learners the knowledge and skills to install, configure, administer, and troubleshoot the client-server database management system of Microsoft® SQL Server™.

1.5

Learners are introduced to network concepts, designs, client/server configurations, system administration, networking and troubleshooting in Unix/Linux environments.

1.5

Learners will gain the knowledge and skills they need to create dynamic websites. After the course, learners will be able to explain and demonstrate the process of building a dynamic website and will also learn how to create a site that pulls content from a database. In addition, learners can create a web interface for the database involved, enabling data input without requiring any prior knowledge of Hypertext Markup Language (HTML) or database functionality.

Equivalents:
  • CMPP 281
1.5

Learners will receive an introduction to system administration and networking in a Unix environment. The emphasis is on aspects of the Unix operating system required for successful database administration, backup and security. Topics include customizing the login environment, standard Unix editors, Unix file system, device management, printers, backup and recovery tools, security, process control, Unix networking and shell programming.

Equivalents:
  • CMPP 275
1.5

This course offers learners an overall view of the importance of Database Security in the larger picture of IT.

1.5

This is a practicum conducted off campus at a participating corporation or business. It provides learners with a realistic taste of what it is like to work in the technology industry. Learners are involved in all steps of the practicum process.

3

Learners will be introduced to system analysis concepts and the project life cycle. Topics include planning and feasibility, project life cycle, cost-benefit analysis, requirements analysis and documentation, estimation and allocation of project resources and budgets.

1.5

Progression

You must attain a PGPA and/or a CGPA of 2.0 or better each semester and pass the prerequisite courses to progress through the program.

To qualify for graduation, you must pass all courses, attain a CGPA of 2.0 or better and complete course requirements within the prescribed timelines.

Review our grading and progression procedure >

Admission requirements

Applicants educated in Canada

All applicants must demonstrate English language proficiency and meet the following requirements or equivalents.

  • at least 60% in English Language Arts 30-1 or 30-2 or equivalent OR
  • a minimum of two years of post-secondary education from a recognized university, institute or college.

SAIT accepts high school course equivalents for admission for applicants educated outside Alberta.

All applicants who were educated outside of Canada must demonstrate English Language proficiency and provide proof they meet the program admission requirements with an international document assessment. Find out what educational documents are accepted and assessment options.

SAIT may also accept courses completed at certain international post-secondary institutions.

hall

Academic Upgrading

Missing an admission requirement for this program? Upgrade your prior education to help you receive admission into one of SAIT's career programs.

hall

English language proficiency

All applicants must demonstrate English language proficiency prior to admission, including students educated in Canada.

Transfer agreements

At SAIT, we evaluate post-secondary credit you have previously earned and apply it to your SAIT credential. Explore our formal transfer agreements available for this program.

We can evaluate your prior education, even if we don't have a formal agreement in place.

Submit a transfer credit application

There are no formal transfer agreements currently in place for this program.

Transfer options for graduates

Build on the knowledge you’ve learned at SAIT. The opportunity to advance your education at an accredited post-secondary institution may be available.

🔗 Visit Transfer Alberta search tool for a full list of transfer opportunities within the province.

Available intakes

Fall 2024

Start dates:

Domestic students: Open
  • Application deadline: June 28, 2024
International students: Closed
  • Application deadline: May 29, 2024

Costs

2024/25 tuition and fees

The following estimated costs are effective as of July 1, 2024.

Domestic students

The estimated total cost of tuition and fees for domestic students is based on the recommended course load per year.
Year Number of semesters Tuition fees Additional fees Total per year
1 2.5 $18,174 $1,840 $20,014
Total cost:
$20,014

The estimated total cost of tuition and fees for international students is based on the recommended course load per year.
Year Number of semesters Tuition fees Additional fees Total per year
1 2.5 $29,718 $1,922.50 $31,640.50
Total cost:
$31,640.50

Books and supplies are approximately $1,000 - $1,500 per full-time year.

This is a bring-your-own-device program with a power-user hardware and software requirement. See the specific requirements on our computers and laptops page.

Find your booklist on the SAIT Bookstore's website. The booklist will be available closer to the program start date.

Can’t find your program or course? The bookstore didn't receive a textbook list. Contact your program directly to determine if they’re still refining course details or if you're in luck; no textbook purchase is required this term.

sait

Financial aid

Paying for your education may feel overwhelming, but we have resources and programs that can help, including information about payment options, student loans, grants and scholarships.

Application process

Ready to apply?

Follow our step-by-step guide to submitting a successful application.

Learn how to apply

Communication during admission

Email is the primary source of communication during the selection process. Ensure your personal email account is managed appropriately to receive our emails, files and communications. We recommend you add the sadt.advising@sait.ca domain to your safe senders' list or you risk missing critical email messages.

sait

Begin your application

Apply now using the online application portal. 

Ensure you have a valid Visa or Mastercard to pay the non-refundable application fee of $120 for domestic applicants or $150 for international applicants. 

Information sessions

Prepare for a strong start in your chosen program or get the details you need to decide your future path.

Our expert staff and faculty are ready to answer your questions and provide information about the following:

  • What sets SAIT apart
  • An introduction to the program and area of study
  • Admission requirements
  • Future career paths
  • Information on the earning potential and graduate employment rates.
a view of the moutains and stream in between

Oki, Âba wathtech, Danit'ada, Tawnshi, Hello.

SAIT is located on the traditional territories of the Niitsitapi (Blackfoot) and the people of Treaty 7 which includes the Siksika, the Piikani, the Kainai, the Tsuut’ina and the Îyârhe Nakoda of Bearspaw, Chiniki and Goodstoney.

We are situated in an area the Blackfoot tribes traditionally called Moh’kinsstis, where the Bow River meets the Elbow River. We now call it the city of Calgary, which is also home to the Métis Nation of Alberta, Region 3.