October 2021
Intermediate to advanced
664 pages
16h 1m
English
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 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:
Read now
Unlock full access