8
votes
Do you know of a complete textbook for teaching databases?
I've taught a lot of people SQL in person (over 3000), and I've had to cobble together materials out of a bunch of resources to do it.
For Exercises:
http://sqlzoo.net
http://pgexercises.com
https://...
- 121
7
votes
How can I make database normalization more clear?
There are some things you can only "get" by having repetition wear it into your brain.
This seems to me like a clear use case for first making them do it the hard way. So, construct a non-normalized ...
7
votes
Good datasets for intro CS courses?
I'm going to clean this up later, but am posting the verbatim work of the CSTA members so others can chime in with additional bullets. I'm aiming to have one resource per bullet: Resources name, link, ...
- 1,833
5
votes
A better database management system, for teaching databases
At the state college I work for we stopped teaching Access as the "intro to databases" class a while ago. I taught the class this term using MySQL and MySQL Workbench. We had it installed on our lab ...
- 301
5
votes
Accepted
Database theory (normalization) for beginners (adult education, MS Access)
Based on the comments, the minimum for theory and technical is how the nomenclature of MS Access relates to Excel.
If they've been doing everything in Excel anyway, they've developed habits for, or ...
- 5,435
5
votes
Good datasets for intro CS courses?
I'd like to expand on one source in an answer offered above: The Collection of Really Great, Interesting, Situated Datasets, or simply CORGIS.
From their About page:
The CORGIS project aims to ...
- 9,082
5
votes
Good datasets for intro CS courses?
I've been a big fan of Twitter for this type of project since 2014. You could use an API to pull some news feeds and turn them into a flat file for use with students. My students have found ...
- 457
4
votes
Good datasets for intro CS courses?
The National Oceanic and Atmospheric Administration (NOAA) has plenty of climate data sets (https://www.ncdc.noaa.gov/cdo-web/datasets). I've used them with students to predict how many school days ...
- 457
4
votes
How can I make database normalization more clear?
I agree that simplified rules such as this, in concept, can help students grasp the main concepts! Regarding these particular simplifications, I think for the last one you meant BCNF instead of 3NF. ...
- 139
4
votes
Toy Databases for Class Examples/Homeworks
I stil think this is basically a duplicate of this question: Good datasets for intro CS courses?
You're asking for a database of interesting data. The other question is asking about interesting data. ...
- 5,430
3
votes
Do you know of a complete textbook for teaching databases?
I have found the Shelly Cashman Series® of books to be effective. All too often the focus is on Microsoft products. In this case, Access is the database used in Shelly Cashman Series® ...
- 5,435
3
votes
How to keep students heads from exploding from complex, interconnected topics
Students are better able to handle structured information when they understand, at the start, what that structure is.
Explain the situation to your students. You are about to present a series of ...
- 32.9k
3
votes
What would be your ideal first lecture in a databases course?
Similarities
For a first lesson, what you want to focus on are anchor points, i.e. how databases are something that's closely related to what students already know and understand.
The prime example ...
- 1,311
2
votes
Good datasets for intro CS courses?
There are a few Stack Exchange sites you might want to check out:
Open Data: Open Data Stack Exchange is a question and answer site for developers and researchers interested in open data.
Data ...
- 5,430
2
votes
Accepted
Ideas for introducing databases to Android development students
SQlite is small and as the name suggest "lite" is great for storing data for mobile applications. Apart from that It can easily be used for other small scale web applications without hiccups (100k or ...
- 258
2
votes
Toy Databases for Class Examples/Homeworks
Look into demo instances for real products that run on various databases. I see more of sqlserver, oracle, and db2 in enterprise apps.
Download some free demo instances of Openmaint, Maximo, redmine,...
- 998
2
votes
How can I make database normalization more clear?
I think that the "problem first" approach applies here. Rules like normal form weren't handed down from on high; they were developed as logical solutions to actual existing problems.
One key ...
- 645
2
votes
Easy to use database for HS students
Is there any easy to use database platform that would allow 9th graders to enter data easily (like Google Sheets), and pull data using client-side JS?
Given that you're thinking about Google Sheets ...
- 1,673
2
votes
Accepted
Data and Database modelling books
I highly recommend Database: Principles, Programming, and Performance, by O'Neill and O'Neill. Learned from that book for my first database course and loved it.
- 870
2
votes
Do you know of a complete textbook for teaching databases?
Database Systems Concepts by Silberschatz, Korth and Sudarshan comes with a comprehensive instructor/student resources web site provided by the authors. You can find slides, assignments and even a web ...
- 161
2
votes
How to recast an ASPX application as Object Oriented
The object-oriented and procedural, or imperative, paradigms, and the functional, logical and mathematical, or declarative, paradigms are just that "paradigms." They are the embodiment of thought ...
- 5,435
2
votes
Accepted
Big Data Analytics for Policy Making with No Math inside
There's quite some ambiguity about what "managing big data" means, especially once you must avoid both mathematics and programming.
It's rather like setting up a program for financial ...
- 356
2
votes
Will learning relational algebra and calculus help me to learn SQL subqueries?
Learning the algebraic nature of SQL will certainly help you master it.
A number of warnings though.
First, "relational algebra" when referred to in the academic sense - typically meaning ...
- 356
1
vote
Do you know of a complete textbook for teaching databases?
"Fundamentals of Database Systems" (Elmasri, Navathe) is a good textbook. Still, from the practical point of view, there are no practical assignments one can use for students. Also, there is no ...
- 489
1
vote
Data and Database modelling books
I worked as a data modeler at Siebel. One of the books that the Siebel data model is based upon is Data Model Patterns by David C. Hay. The book will not teach you how to build great data models. It ...
- 161
1
vote
Easy to use database for HS students
There are some websites that have free APIs. One is JSONPlaceholder, but you can easily request access to some others. For instance, Strava offers some for those interested in developing applications ...
- 111
1
vote
A better database management system, for teaching databases
I'll start by saying that my experience is in industry, not in a classroom. I worked for a fortune 500 company that brought a new division up to the billion dollar per year mark using an MS Access ...
- 998
1
vote
A better database management system, for teaching databases
Disclaimer: This recommendation comes from my experience teaching web development (and using an ORM to interface with the database), because I've never had the opportunity to teach a database ...
- 4,795
1
vote
Toy Databases for Class Examples/Homeworks
You can look at the datasets used for TPC benchmarks. You can find the tools and instructions needed at
http://www.tpc.org/tpc_documents_current_versions/current_specifications5.asp
The advantages ...
- 161
1
vote
Toy Databases for Class Examples/Homeworks
You can check out the WorldWideImporters db (from Microsoft):
https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0
Or the AdventureWorks db (from Microsoft as well):...
- 119
Only top scored, non community-wiki answers of a minimum length are eligible