Contents
Catalog Links
Share

Database Management and Security (DBS)

 
Type: Career, Degree (AS)
Open Admissions
Division: STEM and Business
 
 
This program will provide students with a foundation in database analysis, security, and management.  Employment opportunities include entry-level database programming, database support and administration.  Data security measure, data back up and recovery will be emphasized.
 

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
CPS100Information Technology and Its Applications

3
CPS173Data Management Using Excel

3
CMP101Composition 1

3
MAT143Introduction to Statistics

3
CPS138Internet Networking and Security

4
Total Credit Hours:16

Spring

Course NumberTitleCredits
CPS168Introduction to Access

2
CPS170Database Theory and Applications

4
 
CPS122Operating Systems

4
OR
CPS218UNIX

4
 
CPS219Data Analysis

3
OPN-ELECTIVEOpen Elective

1
Total Credit Hours:14

Second Year

Spring

Course NumberTitleCredits
CMP102-150Composition 2 Elective

3
CPS134Introduction to Computer Networks

2
CPS182Information Systems Disaster Recovery

2
CPS221Database Administration

4
LS-ElectiveLaboratory 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.

Fall

Course NumberTitleCredits
CPS177Database Programming with SQL

3
HUM-ELECTIVEHumanities Elective

3
CPS250Advanced Network Security

3
SCI-ELECTIVEScience Elective

3
MAT151Precalculus 1

3
Total Credit Hours:15

Total Credit Hours: 60

 
Program Student Learner Outcomes
  • Manage data dynamically using PivotTables and PivotCharts
  • Manage data using database functions
  • Work collaboratively to manage data
  • Expand data functions using VBA
  • Support Excel and Access databases
  • Implement, manage and optimize schemas, tables, view, and indexes using SQL
  • Apply data modification language (DML) and data definition language (DDL)
  • Use subqueries and aggregate functions
  • Administer database servers and server groups
  • Create logins, configure permissions, assign roles, and perform other essential security tasks
  • Plan and implement a backup and recovery strategy
  • Import, export and transform data from various sources
  • Apply the various cryptograph technology to secure the database and protect the data from attacks
  • Use advanced authentication and encryption technology to secure the data transmissions in computer networks
  • Develop and implement the information disaster recovery plan, backup and restore all data from a disaster of information systems

 
Occupational Skills Required
  • Structured Query Language (SQL)
  • UNIX
  • Database
  • Security
  • 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