SQL slides | Workshop Title

## Schedule

<table class="table table-striped" style="font-size: 20px;">
  <tbody>
    <tr><td>10:00</td><td>1. <a href="https://librarycarpentry.org/lc-sql/01-introduction/index.html">Introduction to SQL</a> </td> </tr>
    <tr><td>10:15</td><td>2. <a href="https://librarycarpentry.org/lc-sql/02-selecting-sorting-data/index.html">Selecting and sorting data</a> </td></tr>
    <tr><td>10:35</td><td>3. <a href="https://librarycarpentry.org/lc-sql/03-filtering/index.html">Filtering</a> </td></tr>
    <tr><td>10:55</td><td style="text-align: center;">Short Break</td></tr>
    <tr><td>11:00</td><td>3. <a href="https://librarycarpentry.org/lc-sql/03-filtering/index.html">Filtering, cont'd.</a> </td></tr>
    <tr><td>11:10</td><td>5. <a href="https://librarycarpentry.org/lc-sql/05-aggregating-calculating/index.html">Aggregating & calculating values</a> </td></tr>
    <tr><td>11:30</td><td>6. <a href="https://librarycarpentry.org/lc-sql/06-joins-aliases/index.html">Joins and aliases</a> </td></tr>
    <tr><td>12:00</td><td style="text-align: center;">Long Break</td></tr>
    <tr><td>12:30</td><td>6. <a href="https://librarycarpentry.org/lc-sql/06-joins-aliases/index.html">Joins and aliases, cont'd.</a> </td></tr>
    <tr><td>12:45</td><td>8. <a href="https://librarycarpentry.org/lc-sql/08-database-design/index.html">Database design</a> </td></tr>
    <tr><td>13:15</td><td style="text-align: center;">Short Break</td></tr>
    <tr><td>13:20</td><td>8. <a href="https://librarycarpentry.org/lc-sql/08-database-design/index.html">Database design, cont'd.</a> </td></tr>
    <tr><td>13:30</td><td>9. <a href="https://librarycarpentry.org/lc-sql/09-create/index.html">Creating tables and modifying data</a></td></tr>
    <tr><td>13:55</td><td>Finish</td> </tr>
  </tbody>
</table>

## Relational Databases

Also: every value in the same field has the same data *type*

</div>

## Links between tables

</svg>

## Data Types

|Data type|Details|Name in SQLite|
|---|---|---|
|**text or string**|a combination of numbers, letters, symbols. Platforms may have different data types: one for variables with a set number of characters - e.g., a zip code or postal code, and one for variables with an open number of characters, e.g., an address or description variable.|TEXT|
|**integer**|sometimes called whole numbers or counting numbers. Can be 1,2,3, etc., as well as 0 and negative whole numbers: -1,-2,-3, etc.|INTEGER|
|float, real, or double|a decimal number or a floating point value. The largest possible size of the number may be specified.|REAL|
|date or datetime|depending on the platform, may represent the date and time or the number of days since a specified date. This field often has a specified format, e.g., YYYY-MM-DD|doesn’t exist - need to use built-in date and time functions and store dates in real, integer, or text formats. See Section 2.2 of SQLite documentation for more details.|
|boolean or binary|this variable type is often used to represent variables that can only have two values: yes or no, true or false.|doesn’t exist - need to use integer data type and values of 0 or 1.|
|blob|a Binary Large OBject can store a large amount of data, documents, audio or video files.|BLOB|

</div>