Database Design

Careers in Database Design

Every modern organization uses one or more computer databases to organize the information it needs to operate successfully.

Database designers know how to collect and store that information so it can be analyzed for useful insights and accessed for whatever purpose it’s needed.

They may design and create new databases or maintain and improve existing systems. Database designers also create the equipment and software specifications that are needed to manage a system and train its users.

Employment Outlook: 2020-2030

• There will be more than 15,000 job openings for computer programmers of all types during the 10-year period
• The number of jobs for computer systems analysts is expected to grow by 15%

These ten-year projections for California employment are calculated by the state Employment Development Department, which collects data about the state's workforce and economic trends.

Database Design at De Anza

The Computer Information Systems Department offers a variety of certificates and associate degrees in programming and computer science.

You can earn certificates in several popular programming languages, either as an introduction for beginners or as a valuable upgrade to your existing skills.

Certificates and degrees are also available in such growing fields as business programming, database design, network programming and administration, systems programming, systems security and project management.

Computer Information Systems

• Business Programming - Certificate of Achievement-AdvancedDetails for Certificate of Achievement-Advanced - Business Programming

  The Business Programming Certificate of Achievement-Advanced program creates programming- savvy entrepreneurs who can make decisions about finances and technology, and who understand how to run an enterprise from both the technology and business perspectives. This program teaches skills combined from business and programming that enable a more in-depth view into the technology necessary to run a business in the 21st century.

  Requirements

  Certificate/Degree Map

• Business Programming - Associate in ArtsDetails for Associate in Arts - Business Programming

  The Business Programming A.A. degree program creates programming- savvy entrepreneurs who can make decisions about finances and technology, and who understand how to run an enterprise from both the technology and business perspectives. This program teaches skills combined from business and programming that enable a more in-depth view into the technology necessary to run a business in the 21st century.

  Requirements

  Certificate/Degree Map

• Cognitive Science - Transfer MapDetails for Transfer Map - Cognitive Science

  A transfer map is a suggested schedule of courses to take each quarter, if you are planning to transfer and pursue a bachelor’s degree in a particular subject. These maps were created to help you get a solid footing in the subject and stay on track with courses commonly required by CSU or UC schools, but they do not guarantee your admission to any university. It’s important that you work with a counselor or academic adviser to determine exactly which classes you need to reach your particular goal.

  Transfer Map

• Computer Science - Transfer MapDetails for Transfer Map - Computer Science

  A transfer map is a suggested schedule of courses to take each quarter, if you are planning to transfer and pursue a bachelor’s degree in a particular subject. These maps were created to help you get a solid footing in the subject and stay on track with courses commonly required by CSU or UC schools, but they do not guarantee your admission to any university. It’s important that you work with a counselor or academic adviser to determine exactly which classes you need to reach your particular goal.

  Transfer Map

• Computer Science for Transfer - Associate in Science-TransferDetails for Associate in Science-Transfer - Computer Science for Transfer

  The Computer Science major consists of courses appropriate for the Associate in Science in Computer Science for Transfer degree, which provides a foundational understanding of the discipline, a breadth of coursework in the discipline and preparation for transfer to any CSU that accepts the Transfer Model Curriculum (TMC). It is a starting point for students who are preparing for careers in software engineering, network administration and data base management, where scientific and technical skills are in great demand. It also provides a foundation for majors in physical science, math and engineering. The Associate in Science in Computer Science for Transfer is intended for students who plan to complete a bachelorâ??s degree in Computer Science (or an approved similar major) at a CSU campus. Students completing this degree are guaranteed admission to the CSU system, but not to a particular campus or major. Students transferring to a CSU campus that does accept this degree will be required to complete no more than 60 (semester) units after transfer to earn a bachelorâ??s degree. This degree may not be the best option for students intending to transfer to a particular CSU campus or to a university or college that is not part of the CSU system. In all cases, students should consult with a counselor for more information on university admission and transfer requirements.

  Requirements

  Certificate/Degree Map

• Cybersecurity - Certificate of AchievementOnline OptionDetails for Certificate of Achievement - Cybersecurity

  This Certificate of Achievement prepares students to become cybersecurity technicians in a networking environment. In this program, students learn network security basics, security policies and procedures, network monitoring and risk analysis and assessment based on network security.

  Requirements

  Certificate/Degree Map

• Cybersecurity - Certificate of Achievement-AdvancedOnline OptionDetails for Certificate of Achievement-Advanced - Cybersecurity

  This Certificate of Achievement-Advanced prepares students to become cybersecurity technicians in a networking environment. In this program, students learn network security basics, emergency response planning, internet protocols, and more advanced-level security policies and procedures, network monitoring and risk analysis and assessment based on network security.

  Requirements

  Certificate/Degree Map

• Cybersecurity - Associate in ArtsOnline OptionDetails for Associate in Arts - Cybersecurity

  The A.A. degree program offers students the opportunity to study information security principles and theories that focus on asset protection. In this program, students learn network security basics, security policies and procedures, network monitoring and risk analysis and assessment based on network security. Students in this program can pursue either a general course of study or a concentration. Graduates find employment in general public or private management, federal or local government civil service, military service, law enforcement and private security.

  Requirements

  Certificate/Degree Map

• Database Development Practitioner - Certificate of AchievementDetails for Certificate of Achievement - Database Development Practitioner

  The Database Development Practitioner Certificate of Achievement includes database management system fundamentals, SQL, PL/SQL, large scale data processing and big data and analytics. Students become proficient in organizing essential information and abstract relationships into a database. They also learn to update, maintain and repair databases. Database skills are applied by software engineers, business analysts, database architects, database administrators, database designers and reporting analysts.

  Requirements

  Certificate/Degree Map

• Database Development Practitioner - Certificate of AchievementDetails for Certificate of Achievement - Database Development Practitioner

  The Database Development Practitioner Certificate of Achievement includes database management system fundamentals, SQL, PL/SQL, large scale data processing and big data and analytics. Students become proficient in organizing essential information and abstract relationships into a database. They also learn to update, maintain and repair databases. Database skills are applied by software engineers, business analysts, database architects, database administrators, database designers and reporting analysts.

  Requirements

  Certificate/Degree Map

• Database Development Practitioner - Associate in ArtsDetails for Associate in Arts - Database Development Practitioner

  The A.A. degree prepares students for an entry-level position in the database field to work as a data analyst, business analyst, database project coordinator or database engineer.

  Requirements

  Certificate/Degree Map

• Database Development Practitioner - Certificate of Achievement-AdvancedDetails for Certificate of Achievement-Advanced - Database Development Practitioner

  The Certificate of Achievement-Advanced prepares students for an entry-level position in the database field to work as a data analyst, business analyst, database project coordinator or database engineer.

  Requirements

  Certificate/Degree Map

• Information Technology Technical Support - Certificate of AchievementDetails for Certificate of Achievement - Information Technology Technical Support

  Students earning the Information Technology Technical Support Certificate are able to apply fundamental concepts of IT support including networking, operating systems, system administration, troubleshooting and customer service, IT automation, and network security. Students upon completing this program are prepared to fill entry-level positions in IT support or continue their education in the field of technology. This program also prepares the student for the CompTIA A+ exams. Students earning this certificate will also earn Google IT Support Professional Certificate.

  Requirements

• Network Administration - Certificate of AchievementDetails for Certificate of Achievement - Network Administration

  This Certificate of Achievement offers studies in overseeing and maintaining Windows systems as part of a network enterprise. Students become proficient in running administrative processes on a Windows operating system. Focus is placed on organization, security and upkeep decisions as part of a larger business environment.

  Requirements

  Certificate/Degree Map

• Network Administration - Certificate of Achievement-AdvancedDetails for Certificate of Achievement-Advanced - Network Administration

  The Certificate of Achievement-Advanced program offer studies in overseeing and maintaining Windows systems as part of a network enterprise. Students become proficient in running administrative processes on a Windows operating system. Focus is placed on organization, security and upkeep decisions as part of a larger business environment. The program include training in programming, network management, UNIX and Perl to aid in understanding more complex networking problems that occur in business enterprises.

  Requirements

  Certificate/Degree Map

• Network Administration - Associate in ArtsDetails for Associate in Arts - Network Administration

  The A.A. degree program offer studies in overseeing and maintaining Windows systems as part of a network enterprise. Students become proficient in running administrative processes on a Windows operating system. Focus is placed on organization, security and upkeep decisions as part of a larger business environment. The program include training in programming, network management, UNIX and Perl to aid in understanding more complex networking problems that occur in business enterprises.

  Requirements

  Certificate/Degree Map

• Network Basics - Certificate of AchievementOnline OptionDetails for Certificate of Achievement - Network Basics

  The Network Basics Certificate of Achievement prepares students for entry-level employment as a computer support or network technician. Students are introduced to programming, networking and Internet protocols. This certificate program also gives students a foundation for further study in either network administration or programming.

  Requirements

  Certificate/Degree Map

• Network Programming - Certificate of Achievement-AdvancedDetails for Certificate of Achievement-Advanced - Network Programming

  The Certificate of Achievement-Advanced gives students a foundation for either employment or further study in the field of network programming. The curriculum offers students an introduction to computer programming, networking and internet protocols. Advanced topics include data structures, advanced computer programming, Internet programming with TCP/IP and UNIX/LINUX utilities and shell features for file manipulation and communication.

  Requirements

  Certificate/Degree Map

• Network Programming - Associate in ArtsDetails for Associate in Arts - Network Programming

  The A.A. degree gives students a foundation for either employment or further study in the field of network programming. The curriculum offers students an introduction to computer programming, networking and internet protocols. Advanced topics include data structures, advanced computer programming, Internet programming with TCP/IP and UNIX/LINUX utilities and shell features for file manipulation and communication.

  Requirements

  Certificate/Degree Map

• Programming in C/C++ - Certificate of AchievementDetails for Certificate of Achievement - Programming in C/C++

  The C/C++ Certificate of Achievement prepares students for entry-level employment in computer programming, software testing and integration, software analysis or algorithm design. The curriculum offers students an introduction to programming in C, intermediate problem solving in C and advanced C/C++ programming and design. The Certificate of Achievement also provides a solid foundation and skill set for those interested in pursuing further study towards a Certificate of Achievement-Advanced or A.A. degree in Systems Programming or Business Programming.

  Requirements

  Certificate/Degree Map

• Programming in Java - Certificate of AchievementDetails for Certificate of Achievement - Programming in Java

  This Certificate of Achievement gives students the knowledge and skills necessary to develop for client/server, web and mobile environments. Organizations running networks on private and public clouds, which pass information among desktop, server and mobile devices, count on Java as a general-purpose, object-oriented solution to fulfill the development requirement of applications. The flexible nature of the language is driving the demand for trained Java programmers.

  Requirements

  Certificate/Degree Map

• Programming in Perl - Certificate of AchievementDetails for Certificate of Achievement - Programming in Perl

  The Programming in Perl Certificate of Achievement certifies that the student can create Perl programs. Perl is a continuously developing language, designed for practical management of important server systems. Perl programming is a key skill used in server processing, web host processing and integrating multiple subsystems. Students develop basic knowledge of Perl, which enables them to match interfaces of web protocol subsystems, the operating system and database subsystems.

  Requirements

  Certificate/Degree Map

• Programming in Python - Certificate of AchievementDetails for Certificate of Achievement - Programming in Python

  Python is best known for applications in data analytics and big data processing. Python is also popular in many other software application fields, including graphics, database, network programming, game development, embedded systems, and web and internet development. Organizations running networks on private and public clouds count on Python as a general-purpose solution to fulfill the development requirement of applications. The flexible nature of the language is driving the demand for trained Python programmers and the certificate of achievement will prepare students for jobs that require professional level Python programming skills. In addition, Python is also good building block to jump start to other programming languages such as JavaScript, Perl, Ruby and other key programming languages.

  Requirements

  Certificate/Degree Map

• Project Management Practitioner - Certificate of AchievementDetails for Certificate of Achievement - Project Management Practitioner

  This Certificate of Achievement is designed for individuals who want to become project managers in their respective industries. Project management is an important responsibility as more organizations use teams and project-based methods to get work done. Using a practicum-based approach, students apply the Project Management Book of Knowledge (PMBOK) to develop skills to enhance teamwork and communication, as well as project management skills to balance scope, quality, budget and scheduling for each project. This certificate program introduces students to a career in project management and further prepares professionals who are already working in the field.

  Requirements

  Certificate/Degree Map

• Project Management Practitioner - Certificate of Achievement-AdvancedDetails for Certificate of Achievement-Advanced - Project Management Practitioner

  The Certificate of Achievement-Advanced prepares students for an entry-level position in the project management field to work as a project coordinator, project manager, business analyst or associate product manager with skills gained for assisting in program or portfolio management.

  Requirements

  Certificate/Degree Map

• Project Management Practitioner - Associate in ArtsDetails for Associate in Arts - Project Management Practitioner

  The A.A. degree prepares students for an entry-level position in the project management field to work as a project coordinator, project manager, business analyst or associate product manager with skills gained for assisting in program or portfolio management.

  Requirements

  Certificate/Degree Map

• Systems Programming - Certificate of Achievement-AdvancedDetails for Certificate of Achievement-Advanced - Systems Programming

  Students pursuing the Systems Programming Certificate of Achievement-Advanced learn computer programming fundamentals of both low-level and high-level languages and gain computing experience on both Windows and Linux platforms.

  Requirements

  Certificate/Degree Map

• Systems Programming - Associate in ArtsDetails for Associate in Arts - Systems Programming

  Students pursuing the Systems Programming A.A. degree learn computer programming fundamentals of both low-level and high-level languages and gain computing experience on both Windows and Linux platforms.

  Requirements

  Certificate/Degree Map

• UNIX/LINUX Operating System - Certificate of AchievementDetails for Certificate of Achievement - UNIX/LINUX Operating System

  Students pursuing the UNIX/LINUX Operating System Certificate of Achievement learn the fundamentals of the UNIX/LINUX OS, ranging from text file manipulation, job control and communication to implementation of shell scripts to automate tasks.

  Requirements

  Certificate/Degree Map

• Visual Basic Programming - Certificate of AchievementDetails for Certificate of Achievement - Visual Basic Programming

  The Visual Basic Certificate of Achievement prepares students for entry-level positions such as Visual Basic developer, .NET developer and web database developer. Additionally, students will enhance their skills in working with spreadsheets and databases. These skills can be applied to degrees in MIS, web development or any associated area.

  Requirements

  Certificate/Degree Map

• Web Development - Certificate of AchievementDetails for Certificate of Achievement - Web Development

  The Certificate of Achievement in Web Development certifies that the student can create web pages and client side programming for web pages.

  Requirements

  Certificate/Degree Map

Computer Information Systems: Noncredit

• Business Software Applications - Certificate of CompletionDetails for Certificate of Completion - Business Software Applications

  Students pursuing the Business Software Applications Certificate of Completion will receive hands-on experience with the fundamentals of popular computer applications that are required by most business offices. The courses provide students with the knowledge and skills necessary to enter or advance in professions such as administrative assistant, technical assistant, administrative professional, administrative services coordinator, office clerk, executive assistant or operations and support assistant. Administrative assistants perform routine clerical and administrative functions such as drafting correspondence, scheduling appointments, organizing and maintaining paper and electronic files, or providing information to callers. (Noncredit courses are tuition-free but students are required to purchase course materials.)

  Requirements

• Database Science Practitioner - Certificate of CompletionNEWDetails for Certificate of Completion - Database Science Practitioner

  The Certificate of Completion prepares students for an entry-level position in the database field to work as a data analyst, business analyst, database project coordinator or database engineer.

  Requirements

• Information Technology Technical Support - Certificate of CompletionDetails for Certificate of Completion - Information Technology Technical Support

  Students earning the Information Technology Technical Support Certificate are able to apply fundamental concepts of IT support including networking, operating systems, system administration, troubleshooting and customer service, IT automation, and network security. Students upon completing this program are prepared to fill entry-level positions in IT support or continue their education in the field of technology. This program also prepares the student for the CompTIA A+ exams. Students earning this certificate will also earn Google IT Support Professional Certificate.

  Requirements

• Introduction to Computer Science - Certificate of CompletionDetails for Certificate of Completion - Introduction to Computer Science

  The Certificate of Completion in Introduction to Computer Science sequence prepares students to be academically successful in the coursework to enter a career in software engineering, computer science, data science or related fields. Student will learn to execute basic commands in Unix/Linux and to apply basic constructs to coding.

  Requirements

• Project Management Practitioner - Certificate of CompletionNEWDetails for Certificate of Completion - Project Management Practitioner

  This Certificate of Completion is designed for individuals who want to become project managers in their respective industries. Project management is an important responsibility as more organizations use teams and project-based methods to get work done. Using a practicum-based approach, students apply the Project Management Book of Knowledge (PMBOK) to develop skills to enhance teamwork and communication, as well as project management skills to balance scope, quality, budget and scheduling for each project. This certificate program introduces students to a career in project management and further prepares professionals who are already working in the field.

  Requirements

In addition to the programs listed above, you may be able to apply courses in this department toward General Education requirements.

Want to Know More?