3 - Git, SQL
Objectives
- Introduction to Git
- Introduction to SQL
- Exercises for self-study
Topics
- Git is the version control system these days: We learn what it is and how to use it
- Plenty of simply examples for you to try
- Starting from ‘git as a time machine’ allowing access to earlier versions
of files
- Branches from simple ‘will this work’ to separating alternate work
- Next are merging, then remote operations, pull requests
- We also get to GitHub, the most promiment and visible hosting site
- GitHub enables social coding and collaboration
- SQL (Structured Query Language) is maybe the most common data processing
language
- We will learn the basics of relational daya and schema
- SQL commands:
select; where; select distinct; select limit
- SQL command
join and its variants for combining table
- SQL command
group by for grouped operations
Core Material
Lecture Slides
Lecture Videos
The core videos which complement the slides are the (now captioned) versions of the 2021 course. As the captions may obstruct some of the displayed code, we also show the uncaptioned original
versions.
- Video 10 (2024): Week 4 (Box)
- Video 11 (2021): Git ‘first steps’ (Box, captioned) (and first_steps.sh example code), also Video 11 (2021): Git ‘first steps’ (uncaptioned)
- Video 12 (2021): Git
‘branching’ (Box,
captioned) (and branching.sh example code), also Video 12 (2021): Git ‘branching’ (uncaptioned)
- Video 13 (2021): Git ‘fork and pull request’ (Box, captioned), also Video 13 (2021): Git ‘fork and pull
request’ (uncaptioned)
- Video 14 (2024): Week 5 (Box)
- Video 15 (2021): SQL and SQLite Intro (Box, captioned), also Video 15 (2021) (Box)
- Video 16 (2021): SQL JOIN and GROUP BY (Box, captioned), also Video 16 (2021) (Box)
Further References