Overview

Database Management

This program will provide students with a strong foundation in the design and management of database systems in a business environment. An in-depth practice of Structured Query Language (SQL) is provided in the context of business-related case studies. The Database Management program covers advanced database concepts, including database administration, database technology, database web programming and selection and acquisition of database management systems. Supporting courses allow students to gain a thorough understanding of necessary business communication skills, operating systems, programming logic and system design.

 

Start building your future:

Students can earn the following degrees and certificates at Long Beach City College:

Degrees & Certificates

 

Associate in Science (AS), Database Management

The Database Management Systems concentration includes coursework in the design, development, and maintenance of relational databases. The program is designed to prepare students for employment in a computer field following graduation. Students wishing a Bachelors’ degree (transfer program) should meet with a counselor or advisor to discuss transferability of courses. 

Program Learning Outcomes: 
  • Analyze the data needs an organization or company and determine how to best organize and store the data in logical, secure, and accessible structures.
  • Design web applications to access and manipulate data using MS Access, MySQL, MS SQL Server and PHP. 
  • Understand the roles and responsibilities of a database administrator and how to diagnose and troubleshoot systems.
Required Courses:

Course Code

Course Name

Units

BCOM 15

Business Communications

3

COSA 2

Critical Thinking Using Computers

3

COSA 25

Microsoft Access for Windows

3

COSN 205

UNIX/Linux Fundamentals

4

COSN 250

Introduction to Cloud Computing

3

COSP 38

Database Concepts

4

COSP 236

Introduction to Microsoft SQL & T-SQL

2

COSP 237

Introduction to Oracle SQL & PL/SQL

2

COSP 238

Database Cloud Technologies

3

COSW 30

Web Development with PHP/MySQL

4

Total: 31 units 

 

Certificate of Achievement, Database Management

The Database Management certificate of achievement is designed to provide the fundamental knowledge and skills required of data management professionals. This certificate will prepare students for a variety of roles suitable for an entry level position as a business analyst, data analyst, data scientist, database application programmer or junior database administrator. The program provides students with hands-on experiences in three database systems including Microsoft Access, MySQL, and Microsoft SQL Server. Students learn to write SQL, create database objects, organize data, report and analyze, program forms, plan a database around a business need, normalize a relational database system, and build database web applications. Students have the opportunity to take a Microsoft Certification in Database Fundamentals as part of this certificate.

PROGRAM STUDENT LEARNING OUTCOMES:
  • Analyze the data needs an organization or company, and determine how to best organize and store the data in logical, secure and accessible structures.
  • Design web applications to access and manipulate data using MS access, MySQL, MS SQL Server and PHP.
  • Understand the roles and responsibilities of a database administrator, and how to diagnose and troubleshoot systems.
Required Courses:

Course Code

Course Name

Units

BCOM 15

Business Communications

3

COSA 2

Critical Thinking Using Computers

3

COSA 25

Microsoft Access for Windows

3

COSN 205

UNIX/Linux Fundamentals

4

COSN 250

Introduction to Cloud Computing

3

COSP 38

Database Concepts

4

COSP 236

Introduction to Microsoft SQL & T-SQL

2

COSP 237

Introduction to Oracle SQL & PL/SQL

2

COSP 238

Database Cloud Technologies

3

COSW 30

Web Development with PHP/MySQL

4

Total: 31 units 

 

Certificate of Achievement, Database Specialist

Students learn how to use Microsoft Access, MySQL, and Microsoft SQL Server. Create your own databases, forms, and reports using SQL.

Required courses:

Course Code

Course Name

Units

COSA 25

Microsoft Access for Windows

3

COSP 38

Database Concepts

4

COSP 238

Database Cloud Technologies

3

Total units: 10 

 

Certificate of Accomplishment, PHP Web Programmer

Students will learn how to build robust web applications with PHP and MySQL.

Required Courses:

Course Code

Course Name

Units

COSP 38

Database Concepts

4

COSW 10

Beginning Website Development

4

COSW 30

Database Programming with PHP/MySQL

4

COSW 200

Introduction to JavaScript

4

Total Units: 16

 

Certificate of Accomplishment, Android App Developer

Students learn programming skills in Java or C++, Android App Development, and Database hands-on concepts.

PROGRAM STUDENT LEARNING OUTCOMES:
  • Demonstrate the ability to create, design, and implement java based Android applications (apps) using the Android API.
  • Show the skills to create, manage, and use databases and SQL for Android applications (apps).
  • Be able to complete the full development process for Android Applications (apps).
Required Courses:

Course Code

Course Name

Units

CS 21 OR

CS 11

Java: Computer Science 1 OR 

Computer Programming/C++

4 OR

4

COSP 38

Database Concepts

4

COSP 230

Android App Development

3

Total Units: 11 

 

Certificate of Accomplishment, SQL Programmer Specialist

 

Course Code

Course Name

Units

COSP 236

Introduction to Microsoft SQL & T-SQL

2

COSP 237

Introduction to Oracle SQL & PL/SQL

2

Total Units: 4

 

sequence of classes 

We recommend scheduling your academic plan following the sequence of courses below.

First Semester

Units

Second Semester

Units

 

 

 

 

 

 

 

 

Third Semester

Units

Fourth Semester

Units

 

 

 

 

 

 

 

 

 

Course offerings

Course Name  Fall  Winter Spring Summer

BCOM 15 Business communications

3 units

   

COSA 2 Critical Thinking Using Computers

3 units

     

COSA 25 Microsoft Access for Windows

3 units

Recommended Preparation: COSA 1

   

COSN 205 UNIX/Linux Fundamentals

4 units

Recommended Preparation: COSA 50

   

COSN 250 Introduction to Cloud Computing

3 units

Recommended Preparation: COSA 50

     

COSP 38 Database Concepts

4 units

       

COSP 230 android app development in Java

3 units

Prerequisites: CS 21 or CS 11

   

COSP 236 Introduction to Microsoft SQL & T-SQL

2 units

       

COSP 237 Introduction to Oracle SQL & PL/SQL

2 units

       

COSP 238 Database Cloud Technologies

3 units

       

COSW 10 Beginning Website Development

4 units

Recommended Preparation: COSA 50

   

COSW 30 Web Development with PHP/MySQL

4 units

Recommended Preparation: COSW 10 and COSP 38

     

COSW 200 Introduction to JavaScript and JQuery

4 units

Recommended Preparation: COSA 50

   

CS 21 Java: computer science

4 units

       

CS 11 Computer programming/c++

4 units

       

 

Additional requirements

    Program Offers

    You can earn industry approved certificates offered by Microsoft to show off your skills on your resume’.
    These certificates are offered by COS departments.

    Microsoft Skill-based Exams:
    • Programming in HTML5 with JavaScript and CSS3 (Worth $165)
    • Introduction to Programming Using HTML and CSS (Worth $127)