Database Programming and Applications Development, Certificate of Achievement (C)

Program Overview

Database Programming and Applications Development, Certificate of Achievement (C)

Overview

This certificate prepares students for employment as junior programmers, programmer/analysts, and systems analysts and designers. The areas of emphasis include Visual Basic, Access, and SQL Server.

Requirements

• Complete all department requirements for the certificate with a C or better or "pass" in each course.
• Candidates for a Certificate of Achievement are required to complete at least 20% of the department requirements through SBCC.

Course List

Learning Outcomes

1. Create programs that reflect the use of modular design and incorporate event-driven and object-oriented approaches.
2. Use database management systems to retrieve discrete and aggregate data from databases and to insert, update, and delete discrete data.
3. Create and implement well-designed databases to reflect enterprise needs.
4. Develop business applications using well-structured programs, normalized databases, and a multi-tier architecture.

Recommended Sequence

Make an appointment with your SBCC academic counselor through Starfish to create a Student Education Plan that reflects a recommended course sequence for this program that is tailored to your individual needs.

Program Outline

Degree Overview:

• Overview:
• This Certificate of Achievement prepares students for employment as junior programmers, programmer/analysts, and systems analysts and designers in the areas of emphasis such as Visual Basic, Access, and SQL Server.
• Objectives:
• To equip students with the necessary skills and knowledge to develop business applications using well-structured programs, normalized databases, and a multi-tier architecture.
• To enable students to design and implement well-designed databases that meet enterprise needs.
• To provide students with a strong foundation in database management systems, enabling them to retrieve discrete and aggregate data, as well as insert, update, and delete discrete data.
• To instill in students the ability to create programs that reflect the use of modular design and incorporate event-driven and object-oriented approaches.

Outline:

• Program Content:
• Core courses include Introduction to Computers and Information Systems, Introduction to Database Systems, Introduction to Programming Using Visual Basic, Microsoft Access, and six units from a selection of elective courses.
• Course Schedule:
• The program can be completed in as little as two semesters, with courses offered during both the day and evening to accommodate students' schedules.
• Individual Modules:
• The program is designed around a modular approach, allowing students to customize their learning experience by selecting elective courses that align with their career goals.
• Elective courses cover topics such as SQL Server Design and Programming, Oracle Design and Programming, MySQL Design and Programming, MongoDB Design and Programming, Apache Cassandra Design and Programming, Introduction to NoSQL Databases, SQL Server Database Administration, Oracle PL/SQL Programming, Oracle Database Administration, Advanced SQL Programming, Data Warehousing SQL Server, Crystal Reports, Advanced SQL Server Programming, and Business Intelligence with Microsoft SQL Server.

Assessment:

• Assessment Methods:
• Student learning is assessed through a combination of methods, including exams, quizzes, assignments, and projects.
• Assessments are designed to evaluate students' understanding of the concepts and their ability to apply them in practical settings.
• Assessment Criteria:
• The program uses a variety of assessment criteria to evaluate student performance, including accuracy, completeness, logic, and presentation.
• Students are expected to demonstrate a high level of proficiency in all aspects of the program to earn a passing grade.

Teaching:

• Teaching Methods:
• The program utilizes a variety of teaching methods to cater to different learning styles, including lectures, discussions, hands-on exercises, and group projects.
• Instructors are experienced professionals with strong industry experience, ensuring that students receive up-to-date and relevant instruction.
• Faculty:
• The program's faculty are highly qualified and dedicated to providing students with a supportive and engaging learning environment.
• Faculty members are actively involved in research and industry collaborations, bringing cutting-edge knowledge and best practices to the classroom.
• Unique Approaches:
• The program emphasizes hands-on learning, providing students with ample opportunities to apply their knowledge in real-world scenarios.
• The program also incorporates industry-standard software and tools, ensuring that students graduate with the skills and experience necessary to succeed in the workplace.

Careers:

• Potential Career Paths:
• Graduates of the program are well-prepared for employment as junior programmers, programmer/analysts, and systems analysts and designers.
• These roles are in high demand in various industries, including software development, IT consulting, and data analytics.
• Career Opportunities:
• Graduates can find employment in a wide range of settings, including technology startups, large corporations, and government agencies.
• They can work on projects involving database design, application development, and systems analysis.
• Career Outcomes:
• Graduates of the program have gone on to successful careers in the field of computer information systems, holding positions such as software developers, database administrators, and IT project managers.