By Rudy Limeback
The fun and easy way to learn best-practice SQL.
Simply SQL is a practical step-by-step guide to writing SQL. You’ll learn how to make the most of your data using best-practice SQL code. Rather than bore you with theory, it focuses on the practical use of SQL with common databases and uses plenty of diagrams, easy-to-read text, and examples to help make learning SQL easy and fun.
This book comprises the following chapters. In the first eight chapters, we’ll learn about SQL, the language, its various statements and clauses, and how to use SQL to store and retrieve database data. These chapters are organized to provide first an introduction to the SQL language, then an overview of the SELECT statement, followed by an examination of each of the SELECT statement’s clauses. In the last three chapters, we’ll learn how to design databases effectively, taking into consideration column data types, table relationships, primary and foreign keys, and so on.
Why this separation? Why do we postpone learning about designing tables until well after the SELECT statement has been thoroughly dissected? Because effective database design requires an understanding of how SQL works. You must walk before you can run. If you’re new to SQL, you’ll want to focus on learning SQL first, rather than be prematurely sidetracked on the whys and wherefores of database design issues.
Who should read this book?
If you’re a web designer or developer looking for guidance in learning SQL for your web projects, this book is for you.
In the early days of the Web, everyone was a web developer. Nowadays, the field has matured to the point where many different disciplines exist. Two broad categories emerged:
- Web designers are responsible for what web site visitors see. This includes the design, graphics, and layout of the site. It also includes designing the functionality of the site, how it works, with considerations for the usability of site features.
If you’re a web designer, you can benefit from learning SQL—at least at a rudimentary level—because it will help you design better user interactions. Understanding how SQL works means that you can make life simpler for the developers who will im plement your designs: by ensuring that the web site is organized in a way that not only serves the web site visitor, but also allows for simple SQL and good database design. We’ll cover both SQL and database design in this book.
Web developers are the primary audience for the book. Using several simple web application examples, we’ll explore all aspects of SQL and database design that are required by web developers to develop efficient and effective web pages. The sample applications in this book really are quite simple, and you may already be familiar with one or more of them, just by using them on the Web.
“This book shows me how to make the best use of SQL for a new website. It also shows me some of the "gotchas" that I have to avoid. All in all, a good read with plenty of meat in the pages.”
“We're new to SQL and this was exactly the jump start we needed to begin developing what we need to do. ”
“Great book. Good explanations. Just what I needed.”
If you feel that "Simply SQL" falls short of being everything you wanted, we’d like you to have your money back.
Simply contact us within 30 days of purchasing your book from SitePoint, and we'll promptly send a refund. We know you'll be thrilled with the quality of our books!