Final Exam: Novice Programmer
Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level
Overview/Description
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)
0.0
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 manage.py 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: it_fewpap_03_enus
Expertise Level
Intermediate