Oct 05, 2024  
2020-2021 Course Catalog 
    
2020-2021 Course Catalog [ARCHIVED CATALOG]


APPLY TODAY

SQL Application Developer, Certificate



The purpose of the SQL Application Developer certificate is to add to the specialization of study at DMACC. This certificate can also help the student prepare for working with databases as part of a profession in programming. 

For more information about the SQL Application Developer certificate, please visit our website at  https://www.dmacc.edu/it/Pages/cis.aspx.

Program Details


Location: Ankeny, Carroll, Perry, Urban


Students may start any semester.


Program Entry Requirements


  1. Complete an application for admission.
  2. Satisfy the assessment requirement.
  3. Attend any required information/registration session.

Graduation Requirements


To earn a SQL Developer certificate, a student must complete all required coursework as prescribed and maintain a 2.0 grade point average.

Semester 2


Option 1 - Select 3 Credits


Semester 3


Total Credits Required to Complete this Certificate - 18


Fixed Costs


Tuition……………………………………………………………………………………..$170.00 per credit

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

Varied Costs


Costs Semester 1 Semester 2 Semester 3
Books (approximate) 300 345 230

Approximate total for program: $3,935**
 

**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.

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

What are the salary expectations?


This certificate would provide database skills for a programmer. The median annual wage for computer programmers was $84,280 in May 2018. 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 $48,790, and the highest 10 percent earned more than $134,630. Most programmers specialize in a few programming languages. Salary Information Source: U.S. Bureau Of Labor Statistics http://www.bls.gov

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.

2020

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.).(2018)