Python Programming/Databases: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
Line 25: | Line 25: | ||
# Complete one or more of the following tutorials: |
# Complete one or more of the following tutorials: |
||
#* TutorialsPoint |
#* TutorialsPoint |
||
#** [https://www.tutorialspoint.com/sqlite/sqlite_python.htm SQLite Python Tutorial] |
|||
#** [http://www.tutorialspoint.com/python/python_database_access.htm MySQL Database Access] |
#** [http://www.tutorialspoint.com/python/python_database_access.htm MySQL Database Access] |
||
Revision as of 16:16, 28 October 2016
This lesson introduces Python database processing.
Objectives and Skills
Objectives and skills for this lesson include:
- Standard Library
- Data Persistence
Readings
- Wikipedia: Database
- Wikipedia: SQL
- PythonLearn:
Multimedia
Examples
Activities
Tutorials
- Complete one or more of the following tutorials:
- TutorialsPoint
Practice
Key Terms
- attribute
- One of the values within a tuple. More commonly called a “column” or “field”.[1]
- constraint
- When we tell the database to enforce a rule on a field or a row in a table. A common constraint is to insist that there can be no duplicate values in a particular field (i.e., all the values must be unique).[2]
- cursor
- A cursor allows you to execute SQL commands in a database and retrieve data from the database. A cursor is similar to a socket or file handle for network connections and files, respectively.[3]
- database browser
- A piece of software that allows you to directly connect to a database and manipulate the database directly without writing a program.[4]
- foreign key
- A numeric key that points to the primary key of a row in another table. Foreign keys establish relationships between rows stored in different tables.[5]
- index
- Additional data that the database software maintains as rows and inserts into a table to make lookups very fast.[6]
- logical key
- A key that the “outside world” uses to look up a particular row. For example in a table of user accounts, a person’s email address might be a good candidate as the logical key for the user’s data.[7]
- normalization
- Designing a data model so that no data is replicated. We store each item of data at one place in the database and reference it elsewhere using a foreign key.[8]
- primary key
- A numeric key assigned to each row that is used to refer to one row in a table from another table. Often the database is configured to automatically assign primary keys as rows are inserted.[9]
- relation
- An area within a database that contains tuples and attributes. More typically called a “table”.[10]
- tuple
- A single entry in a database table that is a set of attributes. More typically called “row”.[11]
See Also
References
- ↑ PythonLearn: Using databases and Structured Query Language (SQL)
- ↑ PythonLearn: Using databases and Structured Query Language (SQL)
- ↑ PythonLearn: Using databases and Structured Query Language (SQL)
- ↑ PythonLearn: Using databases and Structured Query Language (SQL)
- ↑ PythonLearn: Using databases and Structured Query Language (SQL)
- ↑ PythonLearn: Using databases and Structured Query Language (SQL)
- ↑ PythonLearn: Using databases and Structured Query Language (SQL)
- ↑ PythonLearn: Using databases and Structured Query Language (SQL)
- ↑ PythonLearn: Using databases and Structured Query Language (SQL)
- ↑ PythonLearn: Using databases and Structured Query Language (SQL)
- ↑ PythonLearn: Using databases and Structured Query Language (SQL)