Difference between revisions of "Relational Database Programming Study Guide"
Jump to navigation
Jump to search
Joelmartin (talk | contribs) |
Joelmartin (talk | contribs) m (→Session 2) |
||
| Line 42: | Line 42: | ||
Build a 3 Table Database with 2 child relationships | Build a 3 Table Database with 2 child relationships | ||
| + | =Session 3== | ||
| + | ===Pre-Session Reading=== | ||
| + | ===Pre-Session Videos=== | ||
| + | *[https://www.youtube.com/watch?v=nwDq4adJwzM&list=PL8dPuuaLjXtNlUrzyH5r6jN9ulIgZBpdo&index=11 Early Programming: Crash Course Computer Science #10] | ||
| + | *[https://www.youtube.com/watch?v=RU1u-js7db8&list=PL8dPuuaLjXtNlUrzyH5r6jN9ulIgZBpdo&index=12 The First Programming Languages: Crash Course Computer Science #11] | ||
| + | *[https://www.youtube.com/watch?v=l26oaHV7D40&list=PL8dPuuaLjXtNlUrzyH5r6jN9ulIgZBpdo&index=13 Programming Basics: Statements & Functions: Crash Course Computer Science #12] | ||
| + | *[https://www.youtube.com/watch?v=rL8X2mlNHPM&list=PL8dPuuaLjXtNlUrzyH5r6jN9ulIgZBpdo&index=14 Intro to Algorithms: Crash Course Computer Science #13] | ||
| + | *[https://www.youtube.com/watch?v=DuDz6B4cqVc&list=PL8dPuuaLjXtNlUrzyH5r6jN9ulIgZBpdo&index=15 Data Structures: Crash Course Computer Science #14] | ||
| − | + | ===Training Topics=== | |
| + | |||
| + | ===Homework Assignment=== | ||
| + | |||
| + | =Session 4== | ||
| + | ===Pre-Session Reading=== | ||
| + | |||
| + | ===Pre-Session Videos=== | ||
| + | *[https://www.youtube.com/watch?v=7TycxwFmdB0&list=PL8dPuuaLjXtNlUrzyH5r6jN9ulIgZBpdo&index=16 Alan Turing: Crash Course Computer Science #15] | ||
| + | *[https://www.youtube.com/watch?v=O753uuutqH8&list=PL8dPuuaLjXtNlUrzyH5r6jN9ulIgZBpdo&index=17 Software Engineering: Crash Course Computer Science #16] | ||
| + | *[ | ||
| + | *[ | ||
| + | *[ | ||
| + | ===Training Topics=== | ||
| + | |||
| + | ===Homework Assignment=== | ||
Revision as of 00:16, 15 September 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, 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
- 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
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
Session 3=
Pre-Session Reading
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
Training Topics
Homework Assignment
Session 4=
Pre-Session Reading
Pre-Session Videos
- Alan Turing: Crash Course Computer Science #15
- Software Engineering: Crash Course Computer Science #16
- [
- [
- [