Contents
Catalog Links
Share

Database Management and Data Security (DBD)

 
Type: Career, Degree (AS)
Open Admissions
Division: STEM and Business

This program will accept students effective the Spring 2026 semester.

 
This program will provide students with a foundation in database design, management, and data analysis. Data security measures, data back-up and recovery will be emphasized. Employment opportunities include entry-level database administration and support, SQL database programming, data analysis, and data protection and recovery support.

After completing the degree, students are prepared to take the “Oracle Database 12c: Install and Admin (1Z0-062)” Oracle certification exam.
 
If you have questions related to program admissions or applications, please contact info@northshore.edu or call 978-762-4188.
 
 

First Year

Fall

Course NumberTitleCredits
CMP101Composition 1

3
MAT143Introduction to Statistics

3
Total Credit Hours:6

Fall: 1st 7 Weeks

Course NumberTitleCredits
CPS100Information Technology and Its Applications

3
Total Credit Hours:3

Fall: 2nd 7 Weeks

Course NumberTitleCredits
CPS138Internet Networking and Security

4
CPS173Data Management Using Excel

3
Total Credit Hours:7

Spring

Course NumberTitleCredits
CPS168Introduction to Access

2
CPS170Database Theory and Applications

4
CPS122Operating Systems

4
OR
CPS218UNIX

4
CPS219Data Analysis

3
OPN-ELECTIVE
Open Elective

1
Total Credit Hours:14

Second Year

Fall

Course NumberTitleCredits
CPS177Database Programming with SQL

3
HUM-ELECTIVE
Humanities Elective

3
CPS250Advanced Network Security

3
SCI-ELECTIVE
Science Elective

3
MAT151Precalculus 1

3
Total Credit Hours:15

Spring

Course NumberTitleCredits
CMP102-150
Composition 2 Elective

3
CPS134Introduction to Computer Networks

2
CPS182Information Systems Disaster Recovery

2
CPS221Database Administration

4
LS-Elective
Laboratory Science Elective

4
Total Credit Hours:15

Program Information

  • Communication and Mathematics proficiency required to graduate.
  • See guided pathway sheets for advising information specific to your area of focus.

Total Credit Hours: 60

 

Program Student Learning Outcomes

  • Communicate clearly and effectively using both verbal and written methods.
  • Import, export, and transform data from various sources and analyze it dynamically using tools like PivotTables, PivotCharts, and database functions.
  • Develop, manage, and optimize schemas, tables, views, and indexes using SQL data modification language (DML) and data definition language (DDL).
  • Apply various cryptographic technologies, including advanced authentication and encryption, to secure databases and protect data transmissions in computer networks from attacks.
  • Understand the ethics of data queries, methods of obtaining data, the designated visualization of data, and the communication of the data analysis results.
  • Administer database systems by managing permissions, roles, and server groups, and implementing robust backup and disaster recovery strategies.

Occupational Skills Required

  • Database administration
  • Database design and development
  • Structured Query Language (SQL) proficiency
  • Data security and privacy
  • Data analysis
     

Experiential Learning Required in Program

  • Opportunity to take the Coop/Internship course as an open elective
 

Most Common Linked Occupation Title – All Education Levels

  • Entry-level Database Administrators
  • Database Support
  • Entry-Level SQL Database Programmer
  • Entry-Level Data Analyst

Most Common Linked Occupation Title – Associate’s or Less

  • Database Support
  • Entry-level Database Administrators
  • Entry-Level SQL Database Programmer