Unit 06 | Retrieving Data from Relational Databases |
| 5 + 3 hrs |
Upon completion of this module, you will be able to:
- install and start a relational database servers
- connect to a relational database
- issue SQL queries from R to retrieve data
- use E-R diagrams to visualize a relational model
- leverage joins, grouping, subqueries, aggregation in SQL
Key Concepts in Relational Databases |
60 min
|
|
Required Work
Additional Resources
Advanced ReadingsSlide Deck & Data Sets |
SQLite, RSQLite, and Basic SQL Queries |
90 min
|
|
Required Work
Additional ResourcesAdvanced Readings
SQL Scripts for Video Lessons |
SQL Programming |
90 min
|
Required Work
Additional Resources |
SQLite: The Database at the Edge of the Network
|
Optional Work
Additional Resources
Data Sets
|