Course

Course Summary

Credit Type:

Course

ACE ID:

SKIL-0214

Organization:

SkillSoft Corporation

Location:

Online

Length:

39.5 hours (52 weeks)

Dates Offered:

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:

Create and update tables, query data, implement joins, and analyze data using grouping and aggregation operators.
Define and use views, indices, standard forms, triggers, stored procedures, transactions, savepoints, and locks for efficient database management.
Build websites using Django, including working with templates, models, user registration, and configuring built-in login/logout views.
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.
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.

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