2.2 programming V2

variables, inputs, outputs and assignment
1. programs accept inputs from the user
  1. processes it using constants and outputs to user
2. we can label various inputs and constants
  1. this is known as assignment
    1. information is stored in locations called 'identifiers'
3. it is called a 'variable' if it changes throughout the program
  1. allow programs to have different purposes
4. but a 'constant' if it doesn't change
5. any information that a program makes use of is stored in RAM
  1. RAM is divided in memory locations with long hexadecimal addresses
6. example of a computer processing an input:
  1. input - people getting on bus
    1. processing - bus moving along route
      1. output - people getting off the bus for work
7. parameters
  1. used to pass information between functions or procedures
variables : operators
1. Boolean - AND, OR, NOT
  1. AND - two conditions must be true for statement to be true
  2. OR - at least one of the values has to be correct
  3. NOT - inverts the results
2. addition
3. subtraction
4. division
5. left
6. mid
7. right
8. modular division - how many times a number can go into another with a remainder
  1. integer division ignores the remainder
9. SPLIT
10. join
iteration
1. while
2. for
3. counter
4. condition
5. boolean
6. iteration
7. break
8. nested iteration
9. stepping
Text files are used to store a variety of data: lists of names, logs of events, tables of data
1. String handling: to get the length of the string, to get a substring, the string will start with the 0th character, ascii conversion
2. Procedure: are sets of instructions stored under one name
3. Functions: are similar to procedures but always return a value to the main program.
4. SQL- Standard Query Language
  1. SELECT
  2. FROM
  3. WHERE
  4. SCRUD
    1. search
    2. create
    3. read
    4. update
    5. delete
Arrays
1. index
2. elements/items
3. dimensions
4. split
5. iterating
6. zero-based
7. empty array
8. removing
9. overflow
10. adding/removing data
sub programs
1. parameter
2. function
3. procedure
4. argument
5. variable
6. program
data types
1. variable
2. integer
3. real
4. boolean
5. character and string
6. casting
7. data types
8. character sets
9. ASCII
10. unicode
file handling
1. EOF-end of line
2. EOL-end of line
3. new line character
4. file mode
5. commit
6. append
7. overwrite
8. tabulation
9. serialise
10. deserialise
11. delimeter
12. schema
13. SELECT
14. WHERE
15. LIKE
16. ORDER BY
17. ascending
18. descending
19. SQL
20. query
21. criteria
22. count
23. pattern

Next up

2.2 programming V2

Description

Resource summary

Similar

	Created by liam oneill over 5 years ago