Skip to main content
Share Your Experience: Take the 2024 Developer Survey
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://...
Liz H's user avatar
  • 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 ...
G. Ann - SonarSource Team's user avatar
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, ...
Bennett Brown's user avatar
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 ...
ivanivan's user avatar
  • 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 ...
Gypsy Spellweaver's user avatar
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 ...
Peter's user avatar
  • 9,102
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 ...
CS Cheerleader's user avatar
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 ...
CS Cheerleader's user avatar
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. ...
Dave Musicant's user avatar
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. ...
Kevin Workman's user avatar
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® ...
Gypsy Spellweaver's user avatar
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 ...
Ben I.'s user avatar
  • 33.7k
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 ...
Flater's user avatar
  • 1,361
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 ...
Kevin Workman's user avatar
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 ...
T K Sourabh's user avatar
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,...
pojo-guy's user avatar
  • 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 ...
Wildcard's user avatar
  • 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 ...
Peter Taylor's user avatar
  • 1,683
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.
David White's user avatar
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 ...
bkm's user avatar
  • 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 ...
Gypsy Spellweaver's user avatar
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 ...
Steve's user avatar
  • 491
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 ...
Steve's user avatar
  • 491
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 ...
Drimades Boy's user avatar
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 ...
bkm's user avatar
  • 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 ...
natn2323's user avatar
  • 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 ...
pojo-guy's user avatar
  • 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 ...
thesecretmaster's user avatar
  • 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 ...
bkm's user avatar
  • 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):...
Akos Nagy's user avatar
  • 119

Only top scored, non community-wiki answers of a minimum length are eligible