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
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, ...
achhainsan's user avatar
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 ...
achhainsan's user avatar
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. ...
paus's user avatar
  • 233
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 ...
Drimades Boy's user avatar
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 ...
paus's user avatar
  • 233
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 ...
Dipankar Karmakar's user avatar
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. ...
user13477176's user avatar
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 ...
Abhishek Ghosh's user avatar
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?
Drimades Boy's user avatar
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?
Drimades Boy's user avatar
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 ...
Scott Rowe's user avatar
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 ...
IkAndej's user avatar
  • 71
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 ...
NVelichkovski's user avatar
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,...
Jonathan Ma's user avatar
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 ...
ctrl-alt-delor's user avatar
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? ...
cryptic_star's user avatar
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 ...
user3464's user avatar
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 ...
user3292's user avatar
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, ...
CS Cheerleader's user avatar
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 ...
user avatar
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 ...
Bennett Brown's user avatar
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 ...
vacip's user avatar
  • 1,398