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, importin 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
• Get an Intellipedia Wiki Account, set up a User Page, and A Sandbox page

Session 1

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