The pathway below represents an efficient and effective course taking sequence for this program. Individual circumstances might require some changes to this pathway. It is always recommended that you meet with an academic counselor to develop a personalized educational plan.
The courses have been intentionally placed and should be prioritized in
the order
in which they appear. If you are unable to take all the courses in
a semester, you
should prioritize enrolling in the courses in the order below.
Some courses have
been noted as “Appropriate for Intersession” . Should you need (or want) to take
classes
in the summer and/or winter intersessions,
the program recommends these courses as appropriate for the condensed
schedule of
the intersessions.
Some pathways combine a “Certificate of Achievement” and an “Associate
Degree”. If
you are pursuing only the Certificate of Achievement, you are only
required to take
the courses marked “Program Requirement” .
All pathways include at least one “Gateway Course” which introduces you to the program and/or field of study and helps you
decide if you want to continue with this Academic and Career Path.
Most Associate degrees (though not Associate Degrees for Transfer)
require satisfying the SMC Global Citizenship requirement. If the Program
Requirements do not include a “Global Citizenship course” , be sure to select a General Education course that also satisfies Global Citizenship.
This program develops the skills needed to design and build a database architecture as well as interact with modern database management systems locally, remotely or in the cloud. This program will provide an understanding on how to consistently design databases in an organized structure for storing and retrieving data. With increasing concerns over security, a database developer must also be able to write secure code that runs with minimum risk of attacks.
Upon completion of the program, students will:
- Upon completion of this program, students will demonstrate the ability to design, develop and populate databases locally, remotely and in the cloud. Upon completion of this program, students will demonstrate the ability to properly organize and structure information for storing and retrieving different kinds of data at industry scale.
Icon Key
-
Gateway Course
-
Program Requirement
-
General Education
-
Appropriate for Intersession
-
Available Online
-
Global Citizenship
Semester 1
15-17 Units
This is a beginning course intended for students who plan to take additional computer science courses. The course covers an introduction to programming concepts such as designing, coding and testing. Other concepts such as computer hardware, operating systems, compilers and databases are also discussed. The Internet and an introduction to cybersecurity and cloud computing are also included.
should be taken in the intersession PRIOR to semester 1
This introductory course covers basic programming constructs and techniques using VB.Net. Students will learn how to plan, create and debug code based on Object Oriented Programming design and analysis techniques. Topics covered include Data Types, Variables, Decision Statements, Loops, Arrays Input/Output, and basics of Object Oriented Programming using Classes and Objects.
- Skills Advisory: CS 3
- Area IV-B: Language and Rationality (Group B) Option 2
MATH 18, 20, or higher level recommended
See the full list: SMC GE Area IV-B Course
This introductory course in rhetoric emphasizes clear, effective written communication and preparation of the research paper.
- Prerequisite: ENGL 21B or
- Prerequisite: ENGL 22
- Prerequisite: ESL 19B or
- Prerequisite: Group A on the Placement Test
- 1A: English Composition
- A2 - Written Communication
- Area IV-A: Language and Rationality (Group A)
This course covers the basic technologies used to program Web-based applications. Topics include: HTML5, Cascading Style Sheets (CSS), XML and JavaScript, along with a basic survey of the latest extensions on JS.
- Skills Advisory: CS 3
- Area IV-B: Language and Rationality (Group B) Option 2
Semester 2
15 Units
This course introduces the Python programming language. Students will learn how to write programs dealing in a wide range of application domains. Topics covered include the language syntax, IDE, control flow, strings, I/O, classes and regular expressions. Students may use either a PC (Windows) or a Mac (Linux) to complete their programming assignments.
- Skills Advisory: CS 3
- Area IV-B: Language and Rationality (Group B) Option 2
This course introduces modern database concepts while emphasizing the relational database model. Topics include design methodologies, normalization of tables to reduce redundancies, supertypes and subtypes to reduce nulls, data integrity, referential integrity, and using locks and other techniques for concurrency control in a multi-user database. Factors that should be balanced during the design of a database are described. To document databases, entity relationship diagrams, relational schemas, and data dictionaries are described. Principles are applied by performing exercises using MySQL or other database management system. SQL and other languages are used to create and fill tables, retrieve data, and manipulate it by stored programs.
- Skills Advisory: CS 3
This course introduces cloud computing which shifts information systems from on-premises computing infrastructure to highly scalable internet architectures. The course provides a solid foundation of cloud computing technologies and provides students with the understanding required to effectively evaluate and assess the business and technical benefits of cloud computing and cloud applications. Students analyze a variety of cloud services (storage, servers and software applications) and cloud providers. Case studies will be used to examine various industry cloud practices and applications. The course also surveys cloud careers and discusses industry demand for cloud skills.
- Prerequisite: CS 3
This course provides an exploration of intellectual, psychological, social and physical factors that impact lifelong learning, well-being and success. Topics include motivation and self-efficacy; critical thinking, academic integrity and active study strategies; health issues and lifestyle choices; relating to others as a global citizen; written and oral communication; time management; career exploration; and educational planning.
- E - Lifelong Understanding and Self-Development
ENGL 2 recommended for transfer options
See the full list: SMC GE Area III Course
Semester 3
15 Units
CS 79B or 79Y recommended
See the full list: Required Elective Course from "Program Electives" list below
CS 19, 83R or 85 recommended
See the full list: Required Elective Course from "Program Electives" list below
This course introduces students to Salesforce, the industry-leading customer relationship management system. Topics include: data model and navigation; setting up company profiles, user interface and security. Students will create customized records, manage data, run reports, navigate system apps and other applications including personalizing the program to suit various business needs.
- Skills Advisory: CIS 1 or
- Skills Advisory: CS 3
This course covers how to create applications using the Salesforce platform services and tools. Topics include designing and managing data models, configuring application security, designing user interfaces and customizing the application for mobile user and Lightning users. It also focuses on VisualForce to develop custom applications that make use of the Model-View-Controller paradigm by coding in Apex, using Lightning Components and the Salesforce Object Query Language (SOQL).
- Skills Advisory: CS 77A
- Skills Advisory: CS 55
- Area IV-B: Language and Rationality (Group B) Option 2
This course covers the fundamentals of Project Management theory, implementation, and best practices. It is aimed at students who work mostly in the Technology sectors covering software and website development, and other areas of computer science or information systems. Students will learn the theory, as well as the use of Project Management software to plan, track and manage project resources. Topics covered include project life cycles, tasks, schedules, resources, and costs.
- Skills Advisory: CS 3 or
- Skills Advisory: CIS 1
SMC GE Area II-A Course 3 units

Semester 4
15 Units
SMC GE Area II-B Course 3 units

SMC GE Area I Course 3 units
Elective Course 3 units
Elective Course 3 units
Elective Course 3 units
Program Electives
6 Units
This course covers advanced programming techniques using Visual Basic .NET. Topics include Structures, Classes, Events, Inheritance, and Polymorphism, Overloading, Dynamic Binding, Multiple Document Interface, Windows API, Collections, and Exception Handling. Students also learn how to interface to Databases and build Web forms.
- Skills Advisory: CS 15
- Area IV-B: Language and Rationality (Group B) Option 2
VB.Net is an object-oriented programming language that is part of the .Net Microsoft suite. It provides a graphical programming environment used to create applications for Microsoft Windows and the Web. This course covers advanced concepts for VB .NET that relate to interfaces to databases. Topics include Object Oriented Programming, database interfaces programming, SQL query language, using LINQ and EM, and applying security measures in connections.
- Skills Advisory: CS 15
- Area IV-B: Language and Rationality (Group B) Option 2
C # (read as C-Sharp) is a modern object-oriented language that enables programmers to quickly build solutions for the Microsoft.NET platform. In this class, programmers will learn to build C# components for use by Web and Windows-based applications. Students will generate MSIL (Microsoft Intermediate Language) code and PE (Portable Executable) files that utilize the services of the CLR (Common Language Runtime) which are all part of the Microsoft.NET platform.
- Skills Advisory: CS 19 or
- Skills Advisory: CS 50
- Area IV-B: Language and Rationality (Group B) Option 2
VB.Net is an object-oriented programming language that is part of the .Net Microsoft suite. This course covers Web application development, including the use of ASP and VB .NET. Topics include ASP .NET, Web forms and controls, Web data access, state management, Web services, using AJAX and security measures implementation.
- Skills Advisory: CS 15
- Area IV-B: Language and Rationality (Group B) Option 2
Microsoft SQL Server is a popular midrange relational database management system (DBMS) that is used in client/server systems and as a personal DBMS. It can be accessed through the Internet. Topics covered in this course include installing the software, principles of relational databases; creating databases, tables, indexes, and views; inserting, deleting, and updating raw data; updating transactions; and querying the database. With the Transact-SQL extensions, topics include creating functions, procedures, and triggers stored in the database.
- Skills Advisory: CS 3
This course is a practical, hands-on overview of the Oracle Database Management System to store, retrieve, and manipulate data. Oracle is a widely used database that runs on PC¿s, minicomputers, and mainframes, and Oracle programmers and developers are very much in demand. Oracle's SQL is used to create and alter tables with various constraints. Data is retrieved and manipulated by using SELECTS that can group data and retrieve data from several tables by joining them or by using set operations. Views are created. PL/SQL, with its variables, symbolic constants, IF statements, and loops is used to program stored functions, stored procedures, and triggers. Cursors and error handling (exceptions) are introduced.
- Prerequisite: CS 3 and
- Prerequisite: one Programming class.
In this introductory course students will learn how to defend and protect critical computer assets from various security threats including computer worms and viruses. This course will describe fundamental techniques and principles for modeling and analyzing security. Students will learn how to express security requirements, translate requirements into policies, implement mechanisms that enforce policy, and ensure that these policies are effective. Current industry best practices for safeguarding computer resources will be discussed. Various case studies will outline the typical way that security failures get exploited by attackers and how these attacks can be discovered, understood, and countered.
- Skills Advisory: CS 3 and
- Skills Advisory: CS 70
This course addresses cloud database management which supports a number of different approaches for storing data. In the course, students define, operate and scale both SQL and noSQL data storage solutions. This course considers factors that should be balanced during the design of a storage solution. Principles are applied by performing exercises using Amazon RDS and SQL to create and fill tables, retrieve and manipulate data. Object-based APIs are used to serialize objects to Amazon DynamoDB for noSQL solutions. Topics include automated backups, transaction logs, restoration and retention.
- Prerequisite: CS 79A
In this course, students will learn to deploy relational and non-relational databases in Azure. Students will define, operate and scale both SQL and noSQL data storage solutions. Principles are applied by performing exercises using the Azure SQL Database service as well as Azure Storage Explorer. Students will store, manage and analyze data in all the different storage options offered in Azure including blob storage, file storage, table storage, queue storage, Cognos DB and Azure Data Lakes.
- Skills Advisory: CS 79A
- Skills Advisory: CS 79Z
This course teaches how to design and write applications utilizing Ruby on Rails, an open-source web application framework based on the Ruby programming language. In this course, students will create applications that gather information from a web server, query databases and render results.
- Skills Advisory: CS 60 and
- Skills Advisory: CS 80 and
- Skills Advisory: CS 15 or
- Skills Advisory: CS 52 or
- Skills Advisory: CS 53A or
- Skills Advisory: CS 55
- Area IV-B: Language and Rationality (Group B) Option 2
This course teaches how to design and write applications that extend Web servers. These applications process data submitted from Web forms and access back-end databases to dynamically generate Web pages. This course covers the PHP server-side technology. PHP, which stands for "PHP: Hypertext Preprocessor" is a widely-used, Open Source, general-purpose scripting language that is especially suited for Web development and can be embedded into HTML.
- Skills Advisory: CS 81
- Area IV-B: Language and Rationality (Group B) Option 2