Skip to Main Content
SQL All-in-One For Dummies, 4th Edition
book

SQL All-in-One For Dummies, 4th Edition

by Allen G. Taylor, Richard Blum
April 2024
Intermediate to advanced content levelIntermediate to advanced
800 pages
18h 34m
English
For Dummies
Content preview from SQL All-in-One For Dummies, 4th Edition

Chapter 4

Designing a Sample Application

IN THIS CHAPTER

Bullet Discovering the client’s problem

Bullet Taking a first run at the problem

Bullet Deciding on the deliverables

Bullet Creating and transforming an Entity-Relationship model

Bullet Creating, changing, and deleting tables

Bullet Building the user interface

The whole point of knowing SQL is being able to apply that knowledge to solve some problem. Individuals and organizations need information to conduct their businesses, whatever they may be. At any given time, the information they need is buried within a huge collection of data, the vast majority of which they don’t need right now. The key to being able to retrieve information that you do need is to make sure that it’s organized in a way that facilitates retrieval, regardless of your specific needs today.

In this chapter, I go through the steps of creating an application that gives one (fictitious) organization ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SQL All-In-One For Dummies, 3rd Edition

SQL All-In-One For Dummies, 3rd Edition

Allen G. Taylor
SQL Essentials For Dummies

SQL Essentials For Dummies

Richard Blum, Allen G. Taylor
SQL in a Nutshell, 4th Edition

SQL in a Nutshell, 4th Edition

Kevin Kline, Regina O. Obe, Leo S. Hsu

Publisher Resources

ISBN: 9781394242290Purchase Link