Skills Competency Award in Access SQL Professional
Santa Barbara, USA
DURATION
LANGUAGES
English
PACE
Full time
APPLICATION DEADLINE
Request application deadline
EARLIEST START DATE
Request earliest startdate
TUITION FEES
USD 419 / per credit
STUDY FORMAT
On-Campus
Introduction
The Bachelor of Access Structured Query Language (SQL) Professional, Skills Competency Award (SCA) is a certification program that validates an individual's skills and expertise in using Structured Query Language (SQL) to manipulate data in Microsoft Access databases. The program includes a series of assessments that test the candidate's knowledge of Structured Query Language (SQL) syntax, database design, query optimization, and other related concepts. Upon successful completion of the program, the candidate is awarded a Skills Competency Award (SCA), which demonstrates their proficiency in Access Structured Query Language (SQL) to potential employers and clients.
SBCC offers a Transfer Agreement Guarantee (TAG). A TAG is a contractual agreement between the student, SBCC, and specific four-year colleges or universities. This includes six University of California ( *UC) institutions, six California State Institutions (CSU), seven California private institutions, nine out-of-state institutions, as well as Honors Transfer Agreements with ten institutions and 8 CSUs without campus impaction. Students must enroll in the TAG program and work with a TAG advisor. Please click here to learn more on the TAG program website.
Gallery
Admissions
Scholarships and Funding
Enrolled students may apply one time per year in February. If awarded, the money is disbursed for the following academic year in two parts: half in the fall semester and half in the spring semester. The amounts range from very small: $100-750 and larger $1000-2500 with some variations in between.
Curriculum
Computer Information Systems (CIS)
CIS 101 Introduction to Computers and Information Systems (4 Units)
- Hours: 72 (72 lectures)
- Introduction to the role of computer information systems within modern organizations. Topics include hardware and software functions, programming, systems development, and networks. Students use computers for programming as well as popular microcomputer applications such as word processing, spreadsheets, and database management.
- SBCC General Education: SBCCGE Area D2
- Transfer Information: CSU Transferable, UC Transferable
- UC Transfer Limit: CIS 101 combined with CS 101: maximum credit, one course.
- C-ID: BUS 140, ITIS 120.
CIS 107 Introduction to Database Systems (4 Units)
- Course Advisories: CIS 101.
- Hours: 72 (72 lectures)
- Introduction to relational database management concepts. Includes database creation, manipulation, modification, and reporting; queries using SQL and Query-by-Example (QBE); and database design and normalization.
- Transfer Information: CSU Transferable, UC Transferable
- C-ID: ITIS 180.
CIS 111 Computer User Support (2 Units)
- Course Advisories: CIS 101.
- Hours: 36 (36 lectures)
- Computer user support methodologies; focus on understanding the interpersonal skills required for user support.
- Transfer Information: CSU Transferable
CIS 112 Help Desk Concepts (2 Units)
- Course Advisories: CIS 101.
- Hours: 36 (36 lectures)
- Introduction to computer help desk methodologies using the ITIL framework.
- Transfer Information: CSU Transferable
CIS 114 Virtualization Concepts (2 Units)
- Course Advisories: CIS 218.
- Hours: 36 (36 lectures)
- Introduction to virtualization concepts, with an overview of virtualization products. Creation, configuration, and management of virtual machines. Provides occupational preparation for information systems professionals such as PC support personnel, computer programmers, network/systems managers, and related technical and operations administration personnel.
- Transfer Information: CSU Transferable, UC Transferable
CIS 115 Cloud Computing Essentials (2 Units)
- Course Advisories: CIS 112 and CIS 101.
- Hours: 36 (36 lectures)
- Introduction to cloud computing. Implementation, management, security, and privacy issues associated with cloud computing. Provides occupational preparation for information systems professionals such as PC support personnel, computer programmers, network/system managers, and related technical and operations administration personnel.
- Transfer Information: CSU Transferable
CIS 116 Cloud Implementation (3 Units)
- Course Advisories: CIS 114 and CIS 115.
- Hours: 54 (54 lectures)
- Implementing cloud services in the enterprise. Provides occupational preparation for information systems professionals such as PC support personnel, computer programmers, network/system managers, and related technical and operations administration personnel.
- Transfer Information: CSU Transferable
CIS 117 Introduction to SQL Programming (2 Units)
- Course Advisories: CIS 101.
- Hours: 36 (36 lectures)
- Incorporate SQL to retrieve, insert, update, and delete information from relational databases. Create row and aggregate functions, inner and outer joins, set operations, subqueries, and parameter queries.
- Transfer Information: CSU Transferable
CIS 119 Introduction To Programming Using Visual Basic (4 Units)
- Course Advisories: CIS 101.
- Hours: 72 (72 lectures)
- Fundamental programming concepts and application development for students new to programming. Covers flowcharting and pseudocode; algorithms and program structure; control structures; objects, events, and variables; modular design, sub-programs and functions; and file processing.
- Transfer Information: CSU Transferable, UC Transferable
CIS 120 Introduction to NoSQL Databases (2 Units)
- Course Advisories: CIS 107 or CIS 117.
- Hours: 36 (36 lectures)
- Introduction to NoSQL databases. Fundamentals of NoSQL databases and survey of NoSQL products.
- Transfer Information: CSU Transferable, UC Transferable
CIS 181 Technical And Professional Writing (3 Units)
- Same as: ENG 181
- Hours: 54 (54 lectures)
- Writing course designed to teach professional-level written communication in technical fields.
- Transfer Information: CSU Transferable
CIS 200 Windows PowerShell (2 Units)
- Course Advisories: CIS 218.
- Hours: 36 (36 lectures)
- Automate system administration functions in Windows using Windows PowerShell. Provides occupational preparation for information systems professionals, such as PC support personnel, computer programmers, network/systems managers, and related technical and operations-administration personnel.
- Transfer Information: CSU Transferable
CIS 201 UNIX/LINUX System Administration (4 Units)
- Course Advisories: CIS 218 or CS 130.
- Hours: 72 (72 lectures)
- Introduction to UNIX and Linux system administration. Occupational preparation for PC-support personnel, programmers, and network systems managers.
- Transfer Information: CSU Transferable, UC Transferable
- C-ID: ITIS 155.
CIS 206 MS Windows Server System Administration (4 Units)
- Course Advisories: CIS 218.
- Hours: 72 (72 lectures)
- Introduction to Microsoft Windows Server, with emphasis on system administration. Provides occupational preparation for information systems professionals, such as PC support personnel, computer programmers, network/systems managers, and related technical and operations administration personnel.
- Transfer Information: CSU Transferable
- C-ID: ITIS 155.
CIS 209 Visual Basic .Net Programming (4 Units)
- Course Advisories: CIS 119.
- Hours: 72 (72 lectures)
- Windows programming using Visual Basic forms, controls, menus, procedures, arrays, and error-handling techniques. Accessing files and databases. Designed for students familiar with programming concepts but little or no experience with Visual Basic.
- Transfer Information: CSU Transferable, UC Transferable
CIS 213 MS Exchange Server Administration (3 Units)
- Course Advisories: CIS 206.
- Hours: 54 (54 lectures)
- Introduction to Microsoft Exchange Server with emphasis on system administration. Provides occupational preparation for information systems professionals, such as PC support personnel, computer programmers, network/systems managers, and related technical and operations/administration personnel.
- Transfer Information: CSU Transferable
CIS 218 MS Windows Desktop System Administration (4 Units)
- Course Advisories: CIS 101.
- Hours: 72 (72 lectures)
- Introduction to Microsoft Windows desktop system administration. Provides occupational preparation for information systems professionals, such as PC support personnel, computer programmers, network/systems managers, and related technical and operations administration personnel.
- Transfer Information: CSU Transferable
CIS 219 VMware vSphere System Administration (3 Units)
- Course Advisories: CIS 114 and either CIS 201 or 206.
- Hours: 54 (54 lectures)
- Introduction to VMware vSphere system administration. Provides occupational preparation for information systems professionals, such as PC support personnel, computer programmers, network/systems managers, and related technical and operations administration personnel.
- Transfer Information: CSU Transferable
CIS 220 Introduction To Electronic Commerce (3 Units)
- Same as: MKT 220
- Hours: 54 (54 lectures)
- Survey of electronic commerce and the use of the Internet to conduct business. Includes an interdisciplinary exploration of the issues, trends, opportunities, and technologies which shape electronic commerce.
- Transfer Information: CSU Transferable
CIS 222 MS Azure Cloud Administration (3 Units)
- Course Advisories: CIS 114 and CIS 116 and CIS 206.
- Hours: 54 (54 lectures)
- Introduction to configuration and administration of Microsoft Azure cloud services. Provides occupational preparation for information systems professionals, such as PC support personnel, computer programmers, network/systems managers, and technical and operations administration personnel.
- Transfer Information: CSU Transferable
CIS 224 Apache Web Server Administration (2 Units)
- Course Advisories: CIS 201 or 206.
- Hours: 36 (36 lectures)
- Install, configure, and troubleshoot the Apache Web Server on multi-platform environments.
- Transfer Information: CSU Transferable
CIS 228 Apple macOS System Administration (4 Units)
- Course Advisories: CIS 101.
- Hours: 72 (72 lectures)
- Introduction to macOS desktop and server administration. Provides occupational preparation for information systems professionals, such as PC support personnel, network/systems managers, and related technical and operations administration personnel.
- Transfer Information: CSU Transferable
CIS 231 SQL Server Design And Programming (3 Units)
- Course Advisories: CIS 117 or CIS 107 and CIS 119.
- Hours: 54 (54 lectures)
- Designing and implementing SQL Server databases. Programming in Transact-SQL. Designed for students and professionals seeking Microsoft certification.
- Transfer Information: CSU Transferable
CIS 232 SQL Server Database Administration (3 Units)
- Course Advisories: CIS 206 and CIS 231.
- Hours: 54 (54 lectures)
- Administering, backing up, and recovering SQL Server databases. Designed for students and professionals seeking Microsoft certification.
- Transfer Information: CSU Transferable, UC Transferable
CIS 234 Oracle Design and Programming (4 Units)
- Course Advisories: CIS 117 or CIS 107.
- Hours: 72 (72 lectures)
- Programming in SQL and creating basic PL/SQL procedures. Designed for students and professionals seeking Oracle certification.
- Transfer Information: CSU Transferable
CIS 235 Oracle PL/SQL Programming (4 Units)
- Course Advisories: CIS 234.
- Hours: 72 (72 lectures)
- Programming PL/SQL procedures, functions, triggers, packages, and object types in Oracle's SQL*Plus and Procedure Builder environments. Designed for students and professionals seeking Oracle certification.
- Transfer Information: CSU Transferable
CIS 236 Oracle Database Administration (3 Units)
- Course Advisories: CIS 201 or CIS 206 or CIS 234.
- Hours: 54 (54 lectures)
- Administering, backing up, and recovering Oracle databases. Designed for students and professionals seeking Oracle certification.
- Transfer Information: CSU Transferable, UC Transferable
CIS 237 Advanced SQL Programming (2 Units)
- Course Advisories: CIS 107 or CIS 117.
- Hours: 36 (36 lectures)
- Using SQL to clean and consolidate data; perform correlated subqueries and recursive common table expression retrievals; write SQL queries; and access object-relational data, query within JSON string fields.
- Transfer Information: CSU Transferable, UC Transferable
CIS 238 Data Warehousing SQL Server (3 Units)
- Course Advisories: CIS 107 or CIS 117.
- Hours: 54 (54 lectures)
- Using Microsoft SQL Server to create data warehouses and analyze warehoused data.
- Transfer Information: CSU Transferable
CIS 239 Crystal Reports (2 Units)
- Course Advisories: CIS 107, CIS 117.
- Hours: 36 (36 lectures)
- Developing database-independent reports using Crystal Reports.
- Transfer Information: CSU Transferable
CIS 243 Systems Analysis and Design (4 Units)
- Course Advisories: CIS 101.
- Hours: 72 (72 lectures)
- Analyzing and designing information systems. Information gathering, cost-benefit analysis, systems modeling techniques, and prototyping.
- Transfer Information: CSU Transferable, UC Transferable
CIS 245 IT Project Management (4 Units)
- Course Advisories: CIS 101.
- Hours: 72 (72 lectures)
- Introduction to information technology project management.
- Transfer Information: CSU Transferable
CIS 246 Management of Information Technology (3 Units)
- Course Advisories: CIS 101.
- Hours: 54 (54 lectures)
- Introduction to the management of information technology.
- Transfer Information: CSU Transferable
CIS 251 Advanced SQL Server Programming (4 Units)
- Course Advisories: CIS 231.
- Hours: 72 (72 lectures)
- SQL Server programming using advanced features of Transact-SQL. Coding functions, procedures, and triggers using Common Language Runtime integration are explored.
- Transfer Information: CSU Transferable
CIS 252 MySQL Design and Programming (3 Units)
- Course Advisories: CIS 107 or 117.
- Hours: 54 (54 lectures)
- Programming in SQL and creating basic procedures and functions in MySQL. Designed for students and professionals seeking MySQL certification.
- Transfer Information: CSU Transferable, UC Transferable
CIS 253 Business Intelligence with Microsoft SQL Server (4 Units)
- Course Advisories: CIS 238.
- Hours: 72 (72 lectures)
- Implementing and designing business intelligence solutions with Microsoft SQL Server. Provides occupational preparation for information systems professionals, such as PC support personnel, computer programmers, network/systems managers, and related technical and operations administration personnel.
- Transfer Information: CSU Transferable
CIS 254 MongoDB Design and Programming (3 Units)
- Course Advisories: CIS 120.
- Hours: 54 (54 lectures)
- Designing and programming using MongoDB document database.
- Transfer Information: CSU Transferable, UC Transferable
CIS 255 Apache Cassandra Design and Programming (3 Units)
- Course Advisories: CIS 120.
- Hours: 54 (54 lectures)
- Designing and programming an Apache Cassandra database.
- Transfer Information: CSU Transferable, UC Transferable
CIS 258 Data Analytics with R (3 Units)
- Course Advisories: CIS 101.
- Hours: 54 (54 lectures)
- Introduction to R programming concepts for data analytics. Includes data types in R, data structures, importing and manipulating data, computing basic descriptive statistics, and data visualization fundamentals.
- Transfer Information: CSU Transferable
CIS 262 VMware Desktop Administration (3 Units)
- Course Advisories: CIS 219 CIS 206.
- Hours: 54 (54 lectures)
- Virtual desktop administration using VMware Horizon View. Provides occupational preparation for information systems professionals, such as PC-support personnel, computer programmers, network/systems managers, and related technical and operation administration personnel.
- Transfer Information: CSU Transferable
CIS 263 Microsoft System Center Configuration Manager Administration (3 Units)
- Course Advisories: CIS 206.
- Hours: 54 (54 lectures)
- Administering and deploying Microsoft System Center Configuration Manager. Provides occupational preparation for information systems professionals, such as PC support personnel, computer programmers, network/systems managers, and related technical and operations administration personnel.
- Transfer Information: CSU Transferable
CIS 264 AWS Cloud Computing Architecture (3 Units)
- Course Advisories: CIS 116.
- Hours: 54 (54 lectures)
- Introduction to Amazon Web Services cloud architecture and implementation. Provides occupational preparation for information systems professionals such as network/systems managers and related technical and operations administration personnel.
- Transfer Information: CSU Transferable
CIS 265 Google Cloud Computing Architecture (2 Units)
- Course Advisories: CIS 116.
- Hours: 36 (36 lectures)
- Introduction to Google Cloud architecture and implementation. Provides occupational preparation for information systems professionals such as network/systems managers and related technical and operations administration personnel.
- Transfer Information: CSU Transferable
CIS 290 Work Experience In Computer Information Systems (1-4 Units)
- Hours: 300 (300 lab)
- Supervised employment for students whose career objectives, course of study, and employment complement each other. Students must accomplish specific course objectives. Class meetings on campus are scheduled each semester. Course restricted to 3 repetitions
- Transfer Information: CSU Transferable
Program Outcome
Learning Outcomes
- Demonstrate the ability to write simple Structured Query Language (SQL) queries using Microsoft Access.
- Compose sophisticated database queries in Microsoft Access.
English Language Requirements
Certify your English proficiency with PTE. The faster, fairer, simpler English test, accepted by thousands of universities around the world. PTE, Do it worry-free!