Difference between revisions of "Relational Database Programming Study Guide"
Jump to navigation
Jump to search
Joelmartin (talk | contribs) |
Joelmartin (talk | contribs) |
||
| 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/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/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/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/zltgXvg6r3k?list=PL8dPuuaLjXtNlUrzyH5r6jN9ulIgZBpdo Instructions & Programs: Crash Course Computer Science #8] |
| − | [https://youtu.be/rtAlC5J1U40?list=PL8dPuuaLjXtNlUrzyH5r6jN9ulIgZBpdo Advanced CPU Designs: Crash Course Computer Science #9] | + | *[https://youtu.be/rtAlC5J1U40?list=PL8dPuuaLjXtNlUrzyH5r6jN9ulIgZBpdo Advanced CPU Designs: Crash Course Computer Science #9] |
===Training Topics=== | ===Training Topics=== | ||
Revision as of 02:46, 24 June 2020
Study Guide
Session 1
Pre-Session Reading
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 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