Processing data using computer programs

  • SQL provides the mean to access the data stored in a relational database

  • SQL is often used in combination with other programming languages to construct a data processing application

  • Programming languages like:

      • Java
      • Python
      • PHP (web !)

    have the SQL extensions (= SQL capability) to run a SQL commands within the program

  • In this lesson, I will show you how this is done.

  • (You will need to learn computer programming if you want to write such a computer program yourself....)

Steps that a computer program executes to access a database

 

  • (0) Initial state:

    The user runs a program that accesses the mySQL database

  • Next:   the program runs and must make preparations to access the database

Steps that a computer program executes to access a database

 

  • (1) Program makes a connection to the mySQL database system:

    The user wants to access the mySQL database with a computer program.

  • Next:   the user runs a program that accesses the mySQL database