Final Exam: Novice Programmer

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