Menu
Topics

Revision notes

Programming Fundamentals

  1. Section 1SQLDatabasesSQLThe SELECT ClauseThe FROM ClauseThe WHERE Clause8 notes 9 min readStart reading
  2. Section 2Arithmetic OperatorsArithmetic operatorsAddition, subtraction and multiplicationDivisionQuotient and remainderExponentiation6 notes 10 min readStart reading
  3. Section 3Relational OperatorsComparison operatorsEvaluating comparisonsBoundary comparisonsString comparisonComparisons in conditions5 notes 7 min readStart reading
  4. Section 4Boolean OperatorsBoolean OperatorsThe not OperatorRange Checks with Boolean OperatorsEvaluating Compound Conditions4 notes 5 min readStart reading
  5. Section 5VariablesVariablesVariable NamesAssigning Calculations and StringsPrinting Variables and TextUpdating Variables and Running Totals7 notes 12 min readStart reading
  6. Section 6OutputThe print FunctionPrinting StringsPrinting Numbers and ExpressionsPrinting Multiple Items with CommasString Concatenation7 notes 10 min readStart reading
  7. Section 7CastingCastingThe str() Functionint() and float() Conversionsbool() ConversionsInvalid and Chained Casts6 notes 8 min readStart reading
  8. Section 8InputStoring Input in VariablesConversion Is Not Validation2 notes 3 min readStart reading
  9. Section 9Arithmetic OperationsArithmetic expressionsOrder of operationsUsing integer division and moduloArithmetic in Python programs4 notes 7 min readStart reading
  10. Section 10Random LibraryRandom number generationImporting the random libraryrandint()The random() functionStoring random values8 notes 12 min readStart reading
  11. Section 11SelectionSelection1 note 1 min readStart reading
  12. Section 12String ManipulationStringsString length and indexingString slicingChanging caseCharacter codes: ord() and chr()6 notes 10 min readStart reading
  13. Section 13ConstantsConstantsConstants in PythonConstants and VariablesBenefits of ConstantsIdentifying and Improving Constants5 notes 9 min readStart reading
  14. Section 14Count-Controlled IterationCount-controlled iterationRange Defaults and StepsCalculations with the loop variableIterating over sequence items4 notes 7 min readStart reading
  15. Section 15Condition-Controlled IterationCondition-controlled iterationStopping valuesInfinite loops3 notes 5 min readStart reading
  16. Section 161D ArraysArraysFixed-length arraysAccessing and changing array elementsFilling and printing arraysFinding highest and lowest values6 notes 11 min readStart reading
  17. Section 172D Arrays2D arrays2D array indexesBuilding a 2D arrayProcessing one row or one columnVisiting every element in a 2D array6 notes 11 min readStart reading
  18. Section 18RecordsWhy records are usedA record in a 1D arraySearching a table held in a 2D arrayTotalling and updating numeric fields4 notes 7 min readStart reading
  19. Section 19File HandlingWhy programs use filesText files and file modesOpening and closing filesWriting to a text fileReading a line from a text file7 notes 10 min readStart reading
  20. Section 20Sub ProgramsSub programsDefining and calling sub programsProceduresFunctions and return valuesParameters8 notes 13 min readStart reading
  21. Section 21Local and Global VariablesScopeLocal variablesGlobal variablesThe global statementLocal and global variables with the same name8 notes 15 min readStart reading