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.
22
questions
0
votes
1
answer
51
views
How to learn database management systems?
database
navathe/elmasri
connally begg
date
korth
gehrke/ramakrishnan
Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design 2nd Edition
database systems peter rob, ...
2
votes
2
answers
105
views
Will learning relational algebra and calculus help me to learn SQL subqueries?
I'm finding SQL subqueries tough to understand and write.
When I ask how I can make it easier to write subqueries, the first response people give is "practice". But what do I practice? Where ...
1
vote
1
answer
66
views
Big Data Analytics for Policy Making with No Math inside
Good afternoon, colleagues!
We are now preparing to launch a new training program, which will be designed for government managers and policy makers whose competencies will include managing big data. ...
2
votes
0
answers
126
views
Any recent textbooks for an "Introduction to Databases" course?
Are you aware of any recently published textbooks (2018-2022) suitable for an introductory course in databases? I've been using the classical textbooks so far, i.e. "Database Systems Complete ...
0
votes
0
answers
35
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
0
answers
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
0
answers
35
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
0
answers
50
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
2
answers
127
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
2
answers
61
views
Materials on database indexing with examples
Is there any good source/textbook with notes about db indexing with examples?
1
vote
1
answer
58
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 ...
7
votes
4
answers
368
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
3
answers
177
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
4
answers
170
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
3
answers
194
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
4
answers
680
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
4
answers
164
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
3
answers
187
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
1
answer
109
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
6
answers
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
5
answers
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
1
answer
181
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 ...