or
or
By clicking below, you agree to our terms of service.
New to HackMD? Sign up
Syntax | Example | Reference | |
---|---|---|---|
# Header | Header | 基本排版 | |
- Unordered List |
|
||
1. Ordered List |
|
||
- [ ] Todo List |
|
||
> Blockquote | Blockquote |
||
**Bold font** | Bold font | ||
*Italics font* | Italics font | ||
~~Strikethrough~~ | |||
19^th^ | 19th | ||
H~2~O | H2O | ||
++Inserted text++ | Inserted text | ||
==Marked text== | Marked text | ||
[link text](https:// "title") | Link | ||
 | Image | ||
`Code` | Code |
在筆記中貼入程式碼 | |
```javascript var i = 0; ``` |
|
||
:smile: | ![]() |
Emoji list | |
{%youtube youtube_id %} | Externals | ||
$L^aT_eX$ | LaTeX | ||
:::info This is a alert area. ::: |
This is a alert area. |
On a scale of 0-10, how likely is it that you would recommend HackMD to your friends, family or business associates?
Please give us some advice and help us improve HackMD.
Do you want to remove this version name and description?
Syncing
xxxxxxxxxx
2022 UC Carpentries Fall Workshop (SQL)
Workshop Details
Dates: September 6th - 13th, 2022
Time: 9am - 12pm
Workshop Agenda:
https://ucsdlib.github.io/2022-09-06-carpentries-uc/
Instructors:
Reid Otsuji - UC San Deigo, rotsuji@ucsd.edu
Ryan Gan - El Camino College, rgan@elcamino.edu
Helpers:
Sam Teplitzky - UC Berkeley
Leigh Phan - UC Los Angeles
Day 6: SQL (53)
Resources:
Today's Workshop lesson: https://librarycarpentry.org/lc-sql/
Indepth SQL lesson:
http://swcarpentry.github.io/sql-novice-survey/
SQL comprehensive keyword tutorial:
https://www.w3schools.com/sql/
Learning more about SQL Joins:
https://www.geeksforgeeks.org/sql-join-set-1-inner-left-right-and-full-joins/
SQL in R example
https://dept.stat.lsa.umich.edu/~jerrick/courses/stat701/notes/sql.html
Software Installation:
DB Browser for SQLlite
https://sqlitebrowser.org/dl/
Download SQL Database file
Go to Zenodo:
https://zenodo.org/record/2822005#.YxuznfXPweY
From Zenodo download and save the .zip file on your
Desktop
.doaj-article-sample
with 2 files saved inside calleddoaj-article-sample.db.sql
anddoaj-article-sample.db.db
If you see the 2 files in your
doaj-article-sample-db
folder on you Desktop. You're all set!NOTES:
A copy of the instructor live session notes will be made available to participants upon request at the end of the workshop.
Workshop Day 6
First name and Last Name/Organization/Dept./Email
Day 6 Questions:
Please enter any questions not answered during live session here:
1.
Exercise answers:
–exercise
–exercise answers:
–Exercise
End Day 6