Final Exam: Novice Programmer

  • 1 Video | 30m 32s
  • Includes Assessment
  • Earns a Badge
Likes 3 Likes 3
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.


  • 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


  • Playable
    Novice Programmer


Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.


Likes 0 Likes 0  
Likes 2 Likes 2