Course

Credit Type:
Course
ACE ID:
SKIL-0214
Version:
2
Organization:
Internal Revenue Service
Location:
Online
Length:
39.5 hours (52 weeks)
Minimum Passing Score:
70
ACE Credit Recommendation Period:
Credit Recommendation & Competencies
Level Credits (SH) Subject
Lower-Division Baccalaureate 3 Programming
Description

Objective:

This course objective is to provide learners with the knowledge and skills required to be Novice Programmers and build upon those skills to eventually become Apprentice Programmers. The focus will be on SQL programming and building Web apps using Django. The course will also cover design patterns in JavaScript and Unit testing in JavaScript.

Learning Outcomes:

  • Define and use views, indices, standard forms, triggers, stored procedures, transactions, savepoints, and locks for efficient database management.
  • Apply creational patterns (Constructor, Factory, Abstract Factory, Singleton, Prototype, Builder) and structural patterns (Module, Revealing Module, Façade, Decorator, Mixin, Flyweight, Adapter, Composite, Proxy) to design scalable and maintainable code.
  • Build websites using Django, including working with templates, models, user registration, and configuring built-in login/logout views.
  • Install, configure, and use Node.js, npm, and Mocha, along with assertion libraries (Should.js, Must.js) and testing frameworks (Mocha, Chai, SinonJS) to ensure code quality.
  • Create and update tables, query data, implement joins, and analyze data using grouping and aggregation operators.

General Topics:

  • Building Web Apps with Django: Introduction, Basic Website, Templates, Models, and User Management
  • Advanced Django: Generic Views, Login/Logout, and User Registration
  • MySQL: Basics, Table Operations, Querying, Joins, and Aggregation
  • Advanced MySQL: Views, Indices, Triggers, Stored Procedures, and Transactions
  • JavaScript Design Patterns: Creational, Structural, and Behavioral Patterns
  • Unit Testing in JavaScript: Mocha, Chai, SinonJS, and Other Testing Frameworks
Instruction & Assessment

Instructional Strategies:

  • Computer Based Training
  • Laboratory
  • Practical Exercises

Methods of Assessment:

  • Examinations
  • Quizzes
Supplemental Materials
Equivalencies

Other offerings from Internal Revenue Service

View All Courses
College Credit Opportunities