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

Live Training Topics

• Intro to EXCEL: Cell Mechanics, Formulas, Importing and Exporting CSV Files
• 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 Forms, Queries, Tables, Reports, Switchboard, VB IDE
• Build several tables with data elements
• Introduction to Wikipedia style editing on Intelink

Homework Assignment

• Create an Intel project to develop that will require data collection storage in tables

Session 3

Pre-Session Videos

• Early Programming: Crash Course Computer Science #10
• The First Programming Languages: Crash Course Computer Science #11
• Programming Basics: Statements & Functions: Crash Course Computer Science #12
• Intro to Algorithms: Crash Course Computer Science #13
• Data Structures: Crash Course Computer Science #14

Live Training Topics

• Intro to Form input interface for table data

Homework Assignment

• Develop a table with notional people with some bio data and create fake photos using the artificial intelligence face creator located at: https://thispersondoesnotexist.com/

Session 4

Pre-Session Videos

• Alan Turing: Crash Course Computer Science #15
• Software Engineering: Crash Course Computer Science #16
• Data Structures & Algorithms #1 - What Are Data Structures?
• An Overview of Arrays and Memory (Data Structures & Algorithms #2)
• What is SQL? in 4 minutes for beginners

Live Training Topics

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