Interactive textbook · 16 chapters

Using Data to Drive Business Performance

Databases and Management Information Systems

by Dr. Nimrod Dvir

A database course for people who will make decisions with data, not just store it. Students write real SQL from the first weeks, build two complete systems, and finish able to turn a pile of rows into a recommendation they can stand behind.

Format
Interactive web book
Works on
Laptop, tablet, phone
Level
Undergraduate, no coding needed
Access
Course & individual pricing on request
Cover of Using Data to Drive Business Performance by Dr. Nimrod Dvir

Here is what nobody says out loud in a database class: the syntax is the easy part. The hard part is knowing which question is worth asking, getting the right data to answer it, and trusting the answer enough to put your name on a recommendation.

Using Data to Drive Business Performance is built around that hard part. It starts where business starts, with a decision somebody needs to make. Within the first few weeks you are writing SQL against a real database, right in your browser, to answer questions a manager would actually ask. Once you have felt what good data makes possible, the book turns around and teaches you how to design it well: tables, relationships, normalization, security, the whole foundation.

It reads like a good teacher talking, not a reference manual. Every chapter follows the same rhythm, so you always know where you are. And it doesn’t stop at the query. You build reports, read KPIs honestly, and write the short memo that turns evidence into action, because that is the part your future boss will care about.

It was written and rewritten in a real classroom, semester after semester, with real students telling us exactly where they got lost. Those spots are now the clearest pages in the book.

Why this book is different

A database course that finally feels like business.

Students tell us the same things: “I know the terms but not how they connect.” “We learn SQL, but I don’t know why it matters.” So we built the book around those two sentences.

Questions first. Design second.

Most database books open with theory and diagrams and hope you stay long enough to see why it matters. This one opens with the questions a manager actually asks. Halfway through, the book turns around: you have used databases, now you design one from real requirements and business rules.

SQL you actually run

Not screenshots of code. You write and run SQL in the reader, starting with simple lookups and working up to joins, CTEs, CASE logic, date analysis, window functions and views. It feels like a real job, not a worksheet.

Two systems that grow with you

The Grading Database is your guided lab. PetVax, a veterinary clinic, is where you show you can do it on your own. Instead of fifty unrelated exercises, you watch two complete information systems mature over the semester.

It doesn’t stop at the query

A result set is not a decision. You build reports, read KPIs, check for context and bias, and write the memo that turns evidence into action. That last step is where most courses stop and where this one gets interesting.

AI, earned

Embeddings, retrieval and AI-ready data show up after you understand schemas, data quality, security and governance. AI is treated as a consumer of well-built data, not a decorative sidebar.

Built for the AI-era classroom

Every chapter pairs a short reading check with a transfer lab. Students hand in things they have to explain: diagrams, schemas, SQL portfolios, reports and decision memos. That kind of work is hard to fake with a chatbot.

The learning arc

From a single number to a confident decision.

  1. Data
  2. Tables
  3. Relationships
  4. Queries
  5. Analytics
  6. Decisions

A habit, not a formula

R.E.A.D. — the four moves behind every good data decision.

R

Recognize

Spot the business question hiding in the noise.

E

Extract

Pull the right data, and only the right data.

A

Analyze

Turn rows into patterns you can defend.

D

Decide

Make the call, and explain why.

Inside every chapter

The same steady rhythm, so you always know where you are.

Every chapter moves through six parts, from the big idea to work you can show someone. Instructors get a predictable structure that maps cleanly onto any LMS; students get a path that never leaves them guessing.

See the full table of contents →
  1. 01

    Core Concepts

    The main ideas, explained with business stakes up front.

  2. 02

    Let’s Build

    Guided, hands-on work in the Grading Database.

  3. 03

    Review & Reflection

    Connect the pieces and explain what they mean for a manager.

  4. 04

    Terms Treasury

    The vocabulary that matters, with real examples.

  5. 05

    Reading Assessment

    A quick readiness check before the applied work.

  6. 06

    Lab

    Transfer it to PetVax, a new scenario, or the capstone.

Two running projects

Watch real systems grow, one chapter at a time.

Guided

The Grading Database

Every student already understands grades, which makes it the perfect first system. You query it, find its flaws, normalize it, secure it and report on it, chapter by chapter, with the book walking beside you.

  • Familiar data, real complexity
  • Powers every “Let’s Build” section
On your own

PetVax

A veterinary clinic with messy notes, appointments and vaccine records. Here you transfer what you learned to a system you have never seen, turning vague requirements into a working, defensible design.

  • Unseen scenario, independent work
  • Portfolio-ready by the end of term

Table of contents

Sixteen chapters, four movements.

Part I

Why data matters

  1. 01From Data to DecisionsThe R.E.A.D. framework and the Grading Database
  2. 02Foundations of Information SystemsInputs, processes, outputs, and the KPIs that judge them
  3. 03Data FundamentalsTypes, quality, governance and the data lifecycle

Part II

Using databases

  1. 04Introduction to DatabasesFrom spreadsheets to structured systems
  2. 05SQL FoundationsSelecting, filtering, sorting, joining, summarizing
  3. 06The Relational ModelKeys, relationships and integrity
  4. 07NormalizationFrom flat files to reliable relational design
  5. 08Midpoint ReviewPulling the first half together

Part III

Building reliable systems

  1. 09Database DesignThe pivot: requirements, business rules and data models
  2. 10Advanced SQL for Business AnalysisCTEs, CASE logic, dates, window functions and views
  3. 11Database AdministrationSecurity, transactions, recovery and performance

Part IV

From data to decisions

  1. 12Business Intelligence & ReportingDashboards, KPIs and honest interpretation
  2. 13Strategy & JudgmentCompetitive advantage, ethics and the decision memo
  3. 14Data Infrastructure for the AI EraCloud databases, APIs, JSON, embeddings and retrieval
  4. 15Capstone ProjectOne complete system, from requirements to recommendations
  5. 16Your Career in DataTurning what you built into résumé lines and interview stories

Appendices

  • Microsoft AccessA complete, beginner-friendly pathway: 12 parts, 38 figures and a full project
  • AirtableRelational thinking in a modern no-code tool
  • TableauFrom query results to visual stories
  • DBCodeWorking with databases from a code editor

Who it’s for

Made for the people in the room.

Students

Business majors who never planned to write code, and are about to discover they can. Clear, friendly and honest about what matters.

Instructors

A predictable six-part chapter package, transfer labs, reading checks and artifacts students must explain. Less stitching, more teaching.

Programs

One integrated course instead of a theory text plus a separate software manual. Flexible enough for MIS, AIS, analytics and applied SQL.

For instructors & programs

Teaching this course next term?

Request a review copy, ask about course adoption, or tell us what your students need. A person reads every message.

Getting access

Three ways in.

Read online

Through your course

Open the interactive reader and sign in with the access your course or instructor provides.

Open the reader

Course & campus

Custom pricing

Section, department and institution-wide access, with LMS-friendly structure and onboarding support.

Ask about adoption

Purchases are covered by our refund policy and terms.

Questions

Good questions, straight answers.

Is this a PDF?

No. It is an interactive web book that works on a laptop, tablet or phone. You read, run SQL and check your understanding in one place, and the content is updated as tools change.

Do students need to install anything?

For most of the book, no. SQL runs right in the reader. The optional Microsoft Access appendix needs Access, which many campuses provide.

Who is it for?

Undergraduate business students taking an introductory database or MIS course, including those who have never written a line of code. It also works for Accounting Information Systems, business analytics and applied SQL courses.

Can I use only part of it?

Yes. Chapters 1–8 work as a business data-literacy course, Chapters 9–16 as an applied database and BI course, and the Access appendix stands on its own as a skills pathway.

I’m an instructor. Can I review it?

Absolutely. Request a review copy and we will set you up with the full reader, the chapter structure, labs and assessment materials.

Open it. Run a query. See for yourself.