Questions tagged [databases]

Questions related to teaching about databases, tools for using them, platforms etc. Use this tag to ask about various aspects of databases.

Filter by
Sorted by
Tagged with
0
votes
0answers
30 views

Resources for the Redis course

What optimal resources you could recommend for a small Redis course with a preliminary academic foundation at the beginning of the book? I would be grateful for an applied university-level curriculum ...
2
votes
0answers
30 views

From where to study Query processing, Query optimization and Multiple Granularity protocol

I am wondering about from where do I need to consult the upper said topics in a good depth in order to solve the questions intuitively. Please help me out in this regard. Please provide some video ...
1
vote
0answers
33 views

Forming a foundation in PHP

Does anyone know what topics I should start studying to form a foundation in PHP ? Loops, outputting data, manipulating a database etc. ? Edit: I want to start using PHP to create a social site. ...
1
vote
0answers
48 views

Detailed video lecture that gives in-depth explanation of the intuition behind Fibonacci Heaps operations

I was going through the text Introduction to Algorithms by Cormen et. al. but faced some issues with the Fibonacci Heap section, especially the intuitive working of the charging and discharging of the ...
2
votes
2answers
103 views

What would be your ideal first lecture in a databases course?

As they say, you don't get a second chance to make a good first impression. Are you aware of any notes/slides appropriate for a first lecture in databases?
2
votes
2answers
49 views

Materials on database indexing with examples

Is there any good source/textbook with notes about db indexing with examples?
1
vote
1answer
50 views

How to recast an ASPX application as Object Oriented

I am a programmer in a small department creating some new tools and applications with ASPX and SQL, and explaining the methodology to co-workers, and writing documentation (so the question here ...
6
votes
4answers
246 views

Do you know of a complete textbook for teaching databases?

The textbooks that I know about, teaching databases, are not complete. In the sense that they lack a complete set of assignments, homework, projects, slides and instructor manual. Do you know of any ...
1
vote
3answers
154 views

Data and Database modelling books

I need a suggestion for books for my University. I have a subject called "Data and database modeling" but we lack of books. Our professor gave as barely understandable scripts. This is an official ...
3
votes
4answers
166 views

Easy to use database for HS students

I'm a web design teacher and I teach 9th graders (14 year olds) in the US. Currently the 9th grade curriculum in my HS programme teaches students CSS, HTML and JavaScript. Students can create buttons,...
2
votes
3answers
174 views

A better database management system, for teaching databases

I have been teaching databases, over the last few weeks, to key-stage 3 pupils (year 7 and 8). The school I am at uses Microsoft's Access. This seems adequate in many ways. However it has many ...
4
votes
4answers
351 views

Toy Databases for Class Examples/Homeworks

I am familiar with the Northwind database and Chinook database as good toy databases for allowing students to practice writing queries. Are there other databases in a similar vein that are available? ...
3
votes
4answers
143 views

Clear example of the Object-Relational Mismatch

An important issue in programming is the Object-Relational Mismatch, but I have not seen any good explanations that use familiar terms. I came up with one involving a Family Tree application. The ...
3
votes
3answers
178 views

How to keep students heads from exploding from complex, interconnected topics

My students will soon be learning ADO.Net in C#, adding on to the Windows programming skills that they recently gained. Just a few pages from one chapter in the textbook introduce the set of layers ...
3
votes
1answer
105 views

Ideas for introducing databases to Android development students

I teach an Android development course to students who have had two full years of Java experience - including a year of data structures. In the past, my students have used services such as Firebase, ...
10
votes
6answers
1k views

How can I make database normalization more clear?

Database normalization is needlessly clouded by over-explanation. I reviewed a wide array of web articles and several textbooks before starting to teach it. After I became thoroughly familiar with the ...
10
votes
5answers
1k views

Good datasets for intro CS courses?

What are engaging sources of data with which students can explore, develop questions, analyze, and draw conclusions in an intro CS course? I'm looking for flat files like XLSX or CSV, or relational ...
5
votes
1answer
175 views

Database theory (normalization) for beginners (adult education, MS Access)

When teaching database basics to non IT beginners, what is the minimum requirement in theory and technical terms? So what is absolutely necessary to talk about DBs? What helps students grasp the basic ...