Relational Database Programming Study Guide

Study Guide

Session 1

Pre-Session Reading

• http://www.upi.pr.it/docs/easfg/easvrfgp7.htm
• http://www.upi.pr.it/docs/easfg/easvrfgp6.htm

Pre-Session Videos

• Crash Course Computer Science Preview
• Early Computing: Crash Course Computer Science #1
• Electronic Computing: Crash Course Computer Science #2
• Boolean Logic & Logic Gates: Crash Course Computer Science #3
• Representing Numbers and Letters with Binary: Crash Course Computer Science #4

Training Topics

• Intro to EXCEL: Cell Mechanics, Formulas, Importing and Exporting CSV Files
• Intro to Access Forms, Queries, Tables, Reports, Switchboard, VB IDE
• Intro to a Wiki and it's Markup Language

Homework Assignment

• Build an Excel Spreadsheet with a graph
  • https://www.wikihow.com/Create-a-Graph-in-Excel
  • https://support.microsoft.com/en-us/office/present-your-data-in-a-scatter-chart-or-a-line-chart-4570a80f-599a-4d6b-a155-104a9018b86e
  • https://www.excel-easy.com/data-analysis/charts.html
  • https://www.youtube.com/watch?v=Vs6-_hDX0Eg
• Get an Intellipedia Wiki Account, set up a User Page, and A Sandbox page
  • Use Joel Martin's user page as a template: search for User:Joel.e.Martin

Session 2

Pre-Session Reading

• Review these open data sources

Pre-Session Videos

• How Computers Calculate - the ALU: Crash Course Computer Science #5
• Registers and RAM: Crash Course Computer Science #6
• The Central Processing Unit (CPU): Crash Course Computer Science #7
• Instructions & Programs: Crash Course Computer Science #8
• Advanced CPU Designs: Crash Course Computer Science #9

Training Topics

• Intro to Access Table creation with Parent Child Relationships
• Intro SQL Querries

Homework Assignment

Build a 3 Table Database with 2 child relationships

Early Programming: Crash Course Computer Science #10