Contents
Catalog Links
Share

Database Management and Security (DBS)

 
2019-2020
Type: Career, Degree (AS)
Open Admissions
Division: STEM and Education
 
 
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.

If you have program advising related questions, please contact computerscience@northshore.edu or call 978-762-4048

 
 
 

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
 
MAT151Precalculus 1

3
OPN-ELECTIVE
Open Elective

1
Total Credit Hours:15

Second Year

Fall

Course NumberTitleCredits
CPS177Database Progamming with SQL

3
HUM-ELECTIVE
Humanities Elective

3
CPS250Advanced Network Security

3
SCI-ELECTIVE
Science Elective

3
CPS219Data Analysis

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 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

Average Annual Growth (10-Year Projection)
Occupation                                                              10-Year Growth Demand
Computer Systems Design and Related Services                      2,240
Other Information Services                                                     435


*Education Report for Computer and Information Systems Security/Information Assurance Boston-Cambridge-Newton, MA-NH MSA (P.9)