2.2 Programming V2

2.2 Programming V2

1. Subroutines

   • Procedures
     • Are called by their names
     • They do not return their values
   • Functions
     • Are called by assigning their return value to something
     • They always return a single value
   • Defines a large amount of coding into one value
     • Useful to reuse code faster
     • Good so work can be split between programmers

2. SQL (Standard Query Language)

   • Programming language used to work with databases
   • Can be run from a special window in a database package
   • SQL Keywords
     • SELECT
     • FROM
     • WHERE

3. Operators

   • Arithmetic
   • Boolean
   • String
   • Concatenate
   • Substring
   • Delimiter
   • SPLIT

4. Variables

   • Input
   • Output
   • Assignment
   • Psuedocode
     • Flowchart
   • Identifier
   • Constant
   • Memory locations
   • Parameters

5. String Manipulation

   • Len(Length)
     • Length
   • SubString
   • Upper
   • Lower
   • CHR
   • ASC
   • Concatenate

6. Arrays

   • Index
   • Elements/items
   • Dimensions
   • Concatenate
   • Split
   • Iterating
   • Non-Sequential
   • Zero-based
   • Empty array
   • Plural naming
   • Adding and removing data
   • Overflow
   • Removing

7. Data types

   • Variable
   • Integer
   • Real
   • Boolean
   • Character and string
   • Casting
   • Data types
   • Character sets
   • ASCII
   • Unicode