Please enable JavaScript to use CodeHS

Arkansas Software Development

Data Systems & APIs

Students learn how software stores, retrieves, and exchanges data. The module begins at the command line and file system, then moves into databases and SQL, where students structure tables and write queries to create, read, update, and delete records. It closes with data-driven programs that read API responses formatted in JSON and put that data to work in code, connecting database operations to the programs that depend on them.

Lessons

8.1 Command Line Interface

  • Linux/MacOS vs. Windows
  • Command Line Interface
  • Command Line Interface Quiz
  • Command Equivalents
  • Windows Command Prompt
  • +5 more

8.2 Databases

  • Databases
  • Databases
  • Database Administrator Career
  • Database Administrator Career
  • Parts of a Database
  • +7 more

8.3 What is SQL?

  • Intro to SQL
  • Quiz: What is SQL?

8.4 Structuring Data in SQL

  • How to Structure Data in SQL

8.5 Basic Querying in SQL

  • The SELECT Statement
  • Our first SELECT statement
  • Your first SELECT statement
  • More SELECT Statement
  • Selecting specific columns examples
  • +2 more

8.6 Filtering Queries in SQL

  • The WHERE Clause
  • Ravenclaw House
  • People in Gryffindor
  • Filter By ID
  • The Weasleys
  • +3 more

8.7 Data-Driven Programs

  • Using APIs
  • Reading a JSON Config
  • Read the Weather API
  • Inventory Manager

8.8 Module 8 Quiz

  • Module 8 Quiz

Courses that include this module