Topics

• Getting started with Django
• Getting started with MySQL
• INSERT
• Getting started with postgresql
• Error codes
• Class based views
• Unit Testing
• Querysets
• Stored routines (procedures and functions)
• DELETE
• VIEW
• Role Management
• ArrayField - a PostgreSQL-specific field
• Getting started with sqlite
• Backup and Restore
• LOAD DATA INFILE
• Many-to-many relationships
• Table Creation
• Signals
• INSERT
• ALTER TABLE
• Change Password
• JSON
• TRIGGERS
• Command line dot-commands
• Data Types
• Performance Tuning
• Debugging
• Django from the command line.

Examples

• Installation on GNU+Linux
• A complete hello world example.
• Context data
• List and Details views
• Testing - a complete example
• Advanced queries with Q objects
• Create a user with a password
• Specifying the maximum size of an ArrayField
• Querying for membership of ArrayField with contains
• Installation
• Limit the number of tests executed
• Backing up one database
• Restoring backups
• Backing up the whole cluster
• A view from two tables
• With a through model
• Table creation with Primary Key
• Simple Many To Many Relationship.
• Show table definition
• Create simple table with a primary key and JSON field
• Insert a simple JSON
• Basic Trigger
• Basic delete
• Insert mixed data into a JSON field.
• Updating a JSON field
• Implicit / automatic casting
• Grant and Revoke Privileges.
• Insert data using COPY
• Using Copy to import
• Using Copy to export
• Using psql to export data
• Process
• Have an INDEX
• Don't hide in function
• OR
• Subqueries
• JOIN + GROUP BY
• Renaming a MySQL database
• Swapping the names of two MySQL databases
• Renaming a MySQL table
• Renaming a column in a MySQL table
• Django from the command line.
• Load data with duplicates
• Create a function
• How to find if it's an insert or update in the pre_save signal