Final Exam: Novice Programmer

Intermediate
  • 1 Video | 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.

WHAT YOU WILL LEARN

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

IN THIS COURSE

  • Playable
    1. 
    Novice Programmer
    33s
    UP NEXT

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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.

YOU MIGHT ALSO LIKE

Likes 3 Likes 3  
Likes 8 Likes 8  
Likes 5 Likes 5