Difference between revisions of "Relational Database Programming Study Guide"

From RobotX
Jump to navigation Jump to search
Line 24: Line 24:
  
 
===Pre-Session Videos===
 
===Pre-Session Videos===
−
 
+
[https://youtu.be/1I5ZMmrOfnA?list=PL8dPuuaLjXtNlUrzyH5r6jN9ulIgZBpdo How Computers Calculate - the ALU: Crash Course Computer Science #5]
 +
[https://youtu.be/fpnE6UAfbtU?list=PL8dPuuaLjXtNlUrzyH5r6jN9ulIgZBpdo Registers and RAM: Crash Course Computer Science #6]
 +
[https://youtu.be/FZGugFqdr60?list=PL8dPuuaLjXtNlUrzyH5r6jN9ulIgZBpdo The Central Processing Unit (CPU): Crash Course Computer Science #7]
 +
[https://youtu.be/zltgXvg6r3k?list=PL8dPuuaLjXtNlUrzyH5r6jN9ulIgZBpdo Instructions & Programs: Crash Course Computer Science #8]
 +
[https://youtu.be/rtAlC5J1U40?list=PL8dPuuaLjXtNlUrzyH5r6jN9ulIgZBpdo Advanced CPU Designs: Crash Course Computer Science #9]
  
 
===Training Topics===
 
===Training Topics===

Revision as of 02:45, 24 June 2020

Study Guide

Session 1

Pre-Session Reading

Pre-Session Videos

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 2

Pre-Session Reading

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

Retrieved from "http://OCRobotx.org/mediawiki/index.php?title=Relational_Database_Programming_Study_Guide&oldid=13359"