About the Tutorial SQLAlchemy is a popular SQL toolkit and Object Relational Mapper. It is written in Python and gives full power and flexibility of SQL to an application developer. It is an open source object-relational mapper (ORM), using which classes can be mapped to the database, thereby allowing the object model and database schema to develop in a cleanly decoupled way from the beginning. Audience understanding of the Python programming language. A basic understanding of relational databases, DB- API, and SQL is desired to understand this tutorial. Copyright & Disclaimer  Copyright 2018 by Tutorials Point

views Design your templates This is just the surface Quick install guide Install Python Set up a database Install Django Verifying That’s it! Writing your first Django app, part 1 Creating a project The development server Creating the Polls app Write your first view Writing your first Django app, part 2 Database setup Creating models Activating models Playing with the API Introducing the Django Admin Writing Apache and mod_wsgi Get your database running Install the Django code Models and databases Models Making queries Aggregation Search Managers Performing raw SQL queries Database transactions Multiple databases

views Design your templates This is just the surface Quick install guide Install Python Set up a database Remove any old versions of Django Install Django Verifying That’s it! Writing your first Django mod_wsgi Get your database running Remove any old versions of Django Install the Django code Models and databases Models Making queries Aggregation Managers Performing raw SQL queries Database transactions transactions Multiple databases Tablespaces Database access optimization Examples of model relationship API usage Handling HTTP requests URL dispatcher Writing views View decorators File Uploads Django shortcut

views Design your templates This is just the surface Quick install guide Install Python Set up a database Remove any old versions of Django Install Django Verifying That’s it! Writing your first Django development server Creating the Polls app Write your first view Writing your first Django app, part 2 Database setup Creating models Activating models Playing with the API Introducing the Django Admin Writing Get your database running Remove any old versions of Django Install the Django code Models and databases Models Making queries Aggregation Search Managers Performing raw SQL queries Database transactions

views Design your templates This is just the surface Quick install guide Install Python Set up a database Install Django Verifying That’s it! Writing your first Django app, part 1 Creating a project The development server Creating the Polls app Write your first view Writing your first Django app, part 2 Database setup Creating models Activating models Playing with the API Introducing the Django Admin Writing Apache and mod_wsgi Get your database running Install the Django code Models and databases Models Making queries Aggregation Search Managers Performing raw SQL queries Database transactions Multiple databases

. . . . . . . . . . . . . . . . . . . . . . . . . . 579 4.12 Integrating Django with a legacy database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 580 4.13 Outputting CSV with Django Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 591 4.18 Writing database migrations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 592 5 • Advanced: Managers | Raw SQL | Transactions | Aggregation | Custom fields | Multiple databases | Custom lookups | Query Expressions | Conditional Expressions | Database Functions • Other: Supported

. . . . . . . . . . . . . . . . . . . . . . . . . . 598 4.12 Integrating Django with a legacy database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 599 4.13 Outputting CSV with Django Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 610 4.19 Writing database migrations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 611 5 Advanced: Managers | Raw SQL | Transactions | Aggregation | Search | Custom fields | Multiple databases | Custom lookups | Query Expressions | Conditional Expressions | Database Functions • Other: Supported

views Design your templates This is just the surface Quick install guide Install Python Set up a database Install Django Verifying That’s it! Writing your first Django app, part 1 Creating a project The development server Creating the Polls app Write your first view Writing your first Django app, part 2 Database setup Creating models Activating models Playing with the API Introducing the Django Admin Writing Apache and mod_wsgi Get your database running Install the Django code Models and databases Models Making queries Aggregation Search Managers Performing raw SQL queries Database transactions Multiple databases

. . . . . . . . . . . . . . . . . . . . . . . . . . 598 4.12 Integrating Django with a legacy database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 598 4.13 Outputting CSV with Django Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 609 4.19 Writing database migrations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 610 5 Advanced: Managers | Raw SQL | Transactions | Aggregation | Search | Custom fields | Multiple databases | Custom lookups | Query Expressions | Conditional Expressions | Database Functions • Other: Supported

views Design your templates This is just the surface Quick install guide Install Python Set up a database Remove any old versions of Django Install Django Verifying That’s it! Writing your first Django development server Creating the Polls app Write your first view Writing your first Django app, part 2 Database setup Creating models Activating models Playing with the API Introducing the Django Admin Writing Get your database running Remove any old versions of Django Install the Django code Models and databases Models Making queries Aggregation Search Managers Performing raw SQL queries Database transactions