SQL Application Developer, Certificate

Program Details

Semester 1

• CIS 125 - Intro to Programming Logic w/ Credits: 3
• CIS 303 - Introduction to Database Credits: 3

Semester 2

• CIS 332 - Database and SQL Credits: 3
• CIS 189 - Python Credits: 3

Semester 3

• CIS 338 - SQL/Oracle Credits: 3
• CIS 346 - Database Design Credits: 3

Total Credits Required to Complete this Certificate - 18

Fixed Costs

Tuition……………………………………………………………………………………..$160.00 per credit

The costs for each program are estimates and subject to change.

Varied Costs

Approximate total for program: $3,555**

**Program entry requirements are not included in the total approximate cost.

What Kind of Work Will You Do?

• Analyze problems and apply technical knowledge to facilitate the design of solutions/resolutions. 

• Collaborate with clients to identify and assess user requirements. 

• Participate in a team environment to meet deadlines and to make quick and accurate judgments. 

• Work with system database administrators to program for database utilization. 

• Maintain and provide functional support for implemented applications. 

• Ability to visualize the problem and design a solution. 

• Communicate both orally and in writing. 

• Work without supervision. 

• Concentrate for long periods of time. 

• Create factual data from abstract concepts. 

• Meet deadlines and handle pressure. 

• Ability to learn multiple concepts and techniques in different formats

What Skills and Abilities Will You Need?

• Meet deadlines and handle pressure in a fast-paced work environment.
• Great oral and written communication skills.
• Concentrate for long period of time.
• General business knowledge, self-starter, motivation, work without supervision.
• Excellent problem-solving skills/logical reasoning and critical thinking.
• Strong programming discipline and general knowledge of relational database management systems.
• Ability to work effectively and efficiently both as an individual and in a team environment.

What Else Should I Consider about this Specialist Certificate?

This adds necessary experience in working with databases in a data-driven world.

What are the salary expectations?

This certificate would provide database skills for a programmer. The median annual wage for computer programmers was $87,530 in May 2017. The median wage is the wage at which half the workers in an occupation earned more than that amount and half earned less. The lowest 10 percent earned less than $47,090, and the top 10 percent earned more than $132,530. Most computer programmers have a bachelor’s degree; however, some employers hire workers with an associate’s degree. Most programmers specialize in a few programming languages. Software developers usually have a bachelor’s degree in computer science and strong computer programming skills. In May 2017, the median annual wage for applications software developers was $101,790. The median annual wage for systems software developers was $107,600 in May 2017. Employment of software developers is projected to grow 24 percent from 2016 to 2026, much faster than the average for all occupations. The main reason for the rapid growth is a large increase in the demand for computer software. Salary Information Source: U.S. Bureau Of Labor Statistics http://www.bls.gov/home.htm. 

Related Certificates:  Java Application Developer, C# Application Developer, C++ Application Developer, SQL Application Developer, Informatics, and Computer Languages Diploma. Completion of the related certificate combined with the CIS AAS degree can increase employment opportunities

Program Competencies

1. Write pseudocode to design coding solution. 

2. Construct ER diagrams. 

3. Write a python application.  

4. Create SQL commands for data manipulation. 

5. Create procedures, functions and triggers to use in a database. 

6. Implement an application to store and update data.  

7. Write an application to query a database.  

8. Design and implement a database solution  

Nondiscrimination Statement

DMACC offers career and technical programs in the following areas of study:

Agriculture, National & Environmental Services /Architecture, Engineering, and Construction/Arts, Design, and Visual communications/Business, Management, and Marketing/Education, Public, and Human Services/Health Science/Hospitality and Culinary/Information Technology/Manufacturing/Transportation & Logistics

Des Moines Area Community College shall not engage in nor allow discrimination covered by law against any person, group or organization. This includes in its programs, activities, employment practices, hiring practices or the provision of services, and harassment or discrimination based on race, color, national origin, creed, religion, sex (including pregnancy), sexual orientation, gender identity, age (in employment), disability, genetic information (in employment) and actual or potential parental, family or marital status of a person. Veteran status in educational programs, activities, employment practices, or admission procedures is also included to the extent covered by law.

Individuals who believe they have been discriminated against may file a complaint through the College Discrimination Complaint Procedure. Complaint forms may be obtained from the Campus Provost’s office, the Academic Deans’ office, the Judicial Officer, or the EEO/AA Officer, Human Resources. ADA questions and concerns may be directed to the Section 504/ADA Coordinator at 2006 S. Ankeny Blvd, Bldg 6, Ankeny, IA  50023, phone 515/964-6857, sgbittner@dmacc.edu.  Title IX questions and concerns may be directed to the Title IX Coordinator at 2006 S. Ankeny Blvd, Bldg 1, Ankeny, IA  50023, phone 515/964-6216, title9@dmacc.edu.  Question or complaints about this policy may be directed to the Director of the Office for Civil Rights, U.S. Department of Education, Citigroup Center, 500 W. Madison, Suite 1475, Chicago, IL 60661, phone 312/730-1560, tax 312/730-1576..

Legal references: Iowa Code §§ 216.6 and 216.9, Titles VI and VII of the Civil Rights Act of 1964 (42 U.S. C. §§ 2000d and 2000e), the Equal Pay Act of 1973 (29 U.S.C. § 206, et seq.), Title IX (Educational Amendments, 20 U.S. C. §§ 1681-1688), Section 504 (Rehabilitation Act of 1973, 29 U.S. C. § 794), and Title II of the Americans with Disabilities Act (42 U.S.C. § 12101, et seq.).₍₂₀₁₈₎