Topics

Log programming problems and what I learned. Legend: ADM -> Algorithm Design Manual LeetCode: 287. Find the Duplicate Number Given an array of integers nums containing n + 1 integers where each integer is in the range [1, n] inclusive. There is only one repeated number in nums, return this repeated number. You must solve the problem without modifying the array nums and uses only constant extra space. You can use the pigeonhole principle to prove that since we have n+1 integers, but only n distinct integers, at least one integer will occur more than one time. ...

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. ...