Git, APIs & SQL
Git, APIs & SQL
Collaborate with version control, consume APIs, and query relational data.
Helpful before you begin (optional -- you can start this course now): JavaScript Fundamentals
Who it's for
Learners who can already program and now need the three tools every development team expects: version control, HTTP APIs, and a database.
What you'll be able to do
- Track work with Git and collaborate through branches and pull requests
- Push, pull, and clone with a remote repository, and recover safely from a rejected push
- Explain how JSON and HTTP carry data between a client and a server
- Consume a REST API, including authentication and error handling
- Query, modify, aggregate, and join relational data with SQL
Not started — 9 lessons, no account required.
Start this coursePractice this course →Add to a study plan →Interview questions →
Version control with Git
History, branching, remotes, and team workflow.
- 20 min
Git Basics: Repositories, Commits & History
What a Git repository actually is, and how the stage-then-commit workflow builds a project's history.
- 22 min
Branches, Merging & Pull Requests
How Git branches let you work in parallel, and how GitHub pull requests turn a merge into a reviewed conversation.
- 26 min
Remote Repositories, Push, Pull & Collaboration
How a local repository connects to a remote one (GitHub or otherwise): configuring origin, pushing, fetching, pulling, cloning, and recovering from a rejected push.
HTTP and REST APIs
The data format and protocol behind every integration.
- 20 min
JSON and HTTP: The Language APIs Speak
The data format (JSON) and vocabulary (HTTP methods and status codes) almost every web API uses to exchange information.
- 22 min
REST APIs and Authentication Basics
How REST APIs organize functionality around resources and URLs, and how API keys and tokens prove who's calling.
Relational data with SQL
Reading, changing, and combining data across tables.
- 22 min
SQL Tables, Rows, Columns & Relationships
How relational databases organize data into tables, and how foreign keys connect those tables to each other.
- 24 min
Filtering and Sorting Rows: WHERE and ORDER BY
Narrowing down a table to just the rows you want with WHERE, and controlling their order with ORDER BY.
- 26 min
Changing Data: INSERT, UPDATE, and DELETE
Adding new rows, modifying existing ones, and removing rows you no longer need.
- 28 min
Aggregating and Combining Data: GROUP BY and JOIN
Summarizing rows into totals and counts with GROUP BY, and pulling related data together across tables with JOIN.
Where to go next
Optional -- these build well on what you just learned, but any course can come next.