Get To Know IT · Module

APIs & Databases

Course

Code Lab

Duration

8 lessons

Topics

What you will learn

  • understand what an API is and what it is used for
  • read and process JSON data
  • understand and build basic REST APIs
  • transfer data between applications using APIs
  • understand the fundamentals of relational databases
  • manage data using basic CRUD operations
  • connect a PostgreSQL database to a web application
  • understand basic concepts of users and authentication
  • store, retrieve, and organize data in a structured way
  • develop their own data-driven application

Module content

What we'll cover

  • What is an API?
  • Why do applications need APIs?
  • Client and server
  • Requests & responses
  • HTTP fundamentals
  • REST APIs
  • What is JSON?
  • Objects and arrays
  • Data structures
  • Reading and creating JSON
  • Transferring data between frontend and backend
  • Structure of a REST API
  • Endpoints
  • HTTP methods
  • GET, POST, PUT/PATCH, and DELETE
  • Error handling
  • Building an API with Node.js
  • Why do applications need databases?
  • Relational databases
  • Tables, columns, and records
  • Relationships between data
  • PostgreSQL fundamentals
  • Create
  • Read
  • Update
  • Delete
  • Managing data through an API
  • Connecting an API to a database
  • User accounts
  • Registration and login
  • Authentication vs. authorization
  • Sessions and tokens – fundamentals
  • Basic security considerations

Ready to get started?

Start the module now and put what you learn into practice with your own project.

Book the module
Get To Know IT | APIs & Databases