Final Exam: Novice Programmer
1 Video | 30m 32s
- Includes Assessment
- Earns a Badge
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
allow users to update instances of your Django model by means of a UpdateView viewbuild a user login page in a web site using built-in Django objectscompute the cross-join of two relationscompute the inner join of two relationscompute the left outer join of two relationsconnect to a MySQL server using a command line interfaceconvey notifications to your web site's users with flash messagescreate a row-level trigger executed after inserts into a MySQL tablecreate a row-level trigger executed before inserts into a MySQL tablecreate a superuser for your Django project and sign in to the Django user administration appcreate a virtual Python environment and install Django in itcreate composite indices and drop indicesdefine a database index and enumerate advantages and disadvantages of indexing columns in a relationdefine a logout template to serve as the logout page for your Django web sitedefine an entity in your Django application in the form of a modeldefine a trigger and enumerate use cases of triggers in a database systemdefine a view and enumerate applications of viewsdefine the model for the profile of a user of your Django applicationdefine the natural join operatordefine the URL, view, and template for a new web page in a Django applicationdisplay all details of a Django model instance using the built-in DetailView viewenable the creation of new instances of your Django model by implementing a CreateView viewenumerate applications of stored proceduresenumerate attributes of keys, super-keys, and candidate keysenumerate the ACID properties and their importancegenerate a new app within a Django projectgenerate a new Django project and describe the various files that are created by this operationidentify commands that cannot be rolled back once executedidentify requirements that a database management system needs to satisfyidentify the correct data types and constraints for specific columns in a table schema
implement referential integrity checks using foreign key constraintsimplement views in MySQLinstall MySQL on different platformsinvoke a stored procedure and pass in required argumentsleverage stored procedures to control transaction executionlist the tasks involved in building a web site and how web frameworks can speed up the processmodel relationships in a real-world scenario for use in a database systemprepare a small but meaningful relationships that can be used to work with data aggregation operatorspresent different views for users who are signed in to your Django web site as opposed to regular userspropagate a model definition to your project's database by generating and running a migration scriptrecall the steps and software required when processing web requests for static and dynamic web sitesrecognize MySQL default behaviourrecognize the Django framework features that can help to simplify web developmentrollback insert and update commands executed within a transactionrun simple queries using wildcards and where clausessave the data submitted in a user registration form to the Django project databaseset permissions for users to delete instances of your Django model and define the redirect URL for a successful deletespecify non-null constraints while creating tablesstart a transaction and execute statements within itstart the built-in Django development server on the default port, as well a specified portuse relational and logical operators in the WHERE clause of MySQL queriesuse the built-in generic ListView to list instances of a model in your Django projectuse the DISTINCT keyword as well as the GROUP BY clause to identify duplicates and cardinalityuse the Django Admin interface to create new users and groupsuse the Django template language to generate a URL for a URL patternuse the GROUP BY clause with important common aggregation functions such as SUM, COUNT, MIN, MAXuse the LIKE and IN operators as well as wildcards in queriesuse the manage.py script of a Django project to propagate model definitions to the databaseuse views to complex abstract queries in MySQLview, update and create instances of your Django model from the built-in admin interface
IN THIS COURSE
1.Novice Programmer33sUP 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 platformDigital badges are yours to keep, forever.