Component 02 - Programming

Component 02 - Programming

1. Data Types

   • Integer
     • int
     • Whole numbers only
   • Real (or float)
     • real
     • Numbers that have a decimal point
   • Boolean
     • bool
     • Can only take one of two values, usually true or false
   • Character
     • char
     • A single letter, number, symbol
   • String
     • string
     • Used to represent text, it is a collection of characters

2. Storing Data

   • Records
     • A record is a type of data structure (like an array) which means that it is use
   • Arrays
     • If you have multiple variables with the same record structure, you can collect them in an array

3. Searching Data

   • SQL
     • SELECT
       • SELECT keyword is followed by the names of the fields (columns) you want to retrieve and display
     • FROM
       • FROM keyword is followed by the name of the table (or tables) you want to search
     • WHERE
       • Used to filter results
       • WHERE statment is used to specify conditions that a record must satisfy before it is returned
       • AND and OR
         • Can be used with WHERE to make more specific searches
       • LIKE
         • LIKE statement can also be used with WHERE to search for a pattern.
         • In LIKE statements the % character is used as a wildcard to represent any combination of letters and numbers

4. Operators

   • ==
     • Is equal to
   • <> or !=
     • Is not equal to
   • <
     • Is less than
   • >
     • Is greater than
   • <=
     • Is less than or equal to
   • >=
     • Is greater than or equal to
   • Arithmetic Operators
     • Addition
       • +
     • Subtraction
       • -
     • Multiplication
       • *
     • Division
       • /
     • Exponentiation
       • **
     • Quotient
       • DIV
     • Remainder (modulus)
       • MOD or %