Topics

Linkedin Learning By Bill Weinman Installation SQL database manager Using SQLite Studio v3.2.1 Text editor BBEdit for Mac Notepad++ for Windows SQL Overview SQL is a standard query language for relational databases. The main operations on a database are Create, Read, Update, and Delete (CRUD). -- SQL statement SELECT * FROM Countries WHERE Continent = 'Europe'; SQL is made up of statements. Each statement contains one or more clauses. A clause starts with a keyword like SELECT followed by an argument or expression. Statements are terminated by semicolons. Semicolons are optional, but it’s considered good practice to use them. ...

This course is an introduction to CRUD web applications. It uses Vagrant as a development environment along with Python and SQLalchemy. Working with CRUD Most web applications have a front end web page that connects to a database. The most common database operations are summarized with CRUD: Create, Read, Update, and Delete. Most relational databases use SQL to query the database. Python provides an SQLite database, but you can only write SQL queries as strings. This doesn’t allow for any error checking. An alternative to directly coding SQL is using an ORM or an Object-relational Mapping. This additional layer translates native language objects to SQL statements as well as the inverse operation. This is what SQLalchemy does. ...