Final Exam: Novice Programmer

Expected Duration
Lesson Objectives
Course Number
Expertise Level


Final Exam: Novice Programmer will test your knowledge and application of the topics presented throughout the Novice Programmer track of the Skillsoft Aspire Web Programmer to Apprentice Programmer Journey.

Expected Duration (hours)

Lesson Objectives

Final Exam: Novice Programmer

  • allow users to update instances of your Django model by means of a UpdateView view
  • build a user login page in a web site using built-in Django objects
  • compute the cross-join of two relations
  • compute the inner join of two relations
  • compute the left outer join of two relations
  • connect to a MySQL server using a command line interface
  • convey notifications to your web site's users with flash messages
  • create a row-level trigger executed after inserts into a MySQL table
  • create a row-level trigger executed before inserts into a MySQL table
  • create a superuser for your Django project and sign in to the Django user administration app
  • create a virtual Python environment and install Django in it
  • create composite indices and drop indices
  • define a database index and enumerate advantages and disadvantages of indexing columns in a relation
  • define a logout template to serve as the logout page for your Django web site
  • define an entity in your Django application in the form of a model
  • define a trigger and enumerate use cases of triggers in a database system
  • define a view and enumerate applications of views
  • define the model for the profile of a user of your Django application
  • define the natural join operator
  • define the URL, view, and template for a new web page in a Django application
  • display all details of a Django model instance using the built-in DetailView view
  • enable the creation of new instances of your Django model by implementing a CreateView view
  • enumerate applications of stored procedures
  • enumerate attributes of keys, super-keys, and candidate keys
  • enumerate the ACID properties and their importance
  • generate a new app within a Django project
  • generate a new Django project and describe the various files that are created by this operation
  • identify commands that cannot be rolled back once executed
  • identify requirements that a database management system needs to satisfy
  • identify the correct data types and constraints for specific columns in a table schema
  • implement referential integrity checks using foreign key constraints
  • implement views in MySQL
  • install MySQL on different platforms
  • invoke a stored procedure and pass in required arguments
  • leverage stored procedures to control transaction execution
  • list the tasks involved in building a web site and how web frameworks can speed up the process
  • model relationships in a real-world scenario for use in a database system
  • prepare a small but meaningful relationships that can be used to work with data aggregation operators
  • present different views for users who are signed in to your Django web site as opposed to regular users
  • propagate a model definition to your project's database by generating and running a migration script
  • recall the steps and software required when processing web requests for static and dynamic web sites
  • recognize MySQL default behaviour
  • recognize the Django framework features that can help to simplify web development
  • rollback insert and update commands executed within a transaction
  • run simple queries using wildcards and where clauses
  • save the data submitted in a user registration form to the Django project database
  • set permissions for users to delete instances of your Django model and define the redirect URL for a successful delete
  • specify non-null constraints while creating tables
  • start a transaction and execute statements within it
  • start the built-in Django development server on the default port, as well a specified port
  • use relational and logical operators in the WHERE clause of MySQL queries
  • use the built-in generic ListView to list instances of a model in your Django project
  • use the DISTINCT keyword as well as the GROUP BY clause to identify duplicates and cardinality
  • use the Django Admin interface to create new users and groups
  • use the Django template language to generate a URL for a URL pattern
  • use the GROUP BY clause with important common aggregation functions such as SUM, COUNT, MIN, MAX
  • use the LIKE and IN operators as well as wildcards in queries
  • use the script of a Django project to propagate model definitions to the database
  • use views to complex abstract queries in MySQL
  • view, update and create instances of your Django model from the built-in admin interface
  • Course Number:

    Expertise Level