Python GUI Programming with Tkinter - Second Edition

B

A Quick SQL Tutorial

For over three decades, relational database systems have remained a de facto standard for storing business data. They are more commonly known as SQL databases, after the Structured Query Language (SQL) used to interact with them. Although a full treatment of SQL warrants a book of its own, this appendix will provide a brief coverage of its basic concepts and syntax that will be adequate for following its usage in this book.

SQL concepts

SQL databases are made up of tables. A table is something like a CSV or spreadsheet file, in that it has rows representing individual items and columns representing data values associated with each item. A SQL table has some important differences from a spreadsheet, though:

• First, each ...