Packed with examples, Simply SQL is a step-by-step introduction to learning SQL. This book 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.
What you will learn
* How to use SQL to store and retrieve database data
* Using the SELECT statement and its clauses
* How to design databases effectively, considering data types, table relationships, and primary and foreign keys
SQL is the language used by all major database systems today. SQL has been around for about 30 years, but is enjoying a real renaissance in the 21st century, thanks to the tremendous success of database-driven web sites. Whether your web site is written in PHP, ASP, Perl, ColdFusion, or any other programming language, and no matter which database system you want to use—MySQL, PostgreSQL, SQL Server, DB2, Oracle, or any of the others—one fact is almost certain: if you want to have database-driven content, you’ll need to use SQL. SQL is a simple, high-level language with tremendous power. You can perform tasks with a few lines of SQL that would take pages and pages of intricate coding to accomplish in a programming language.
Who is this for?
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 implement 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.
Rudy Limeback is an SQL Consultant living in Toronto, Canada. His SQL experience spans 20+ years, and includes working with DB2, SQL Server, Access, Oracle, and MySQL.
Great read, very easy to understand. I recommend this to anyone looking to understand and use SQL!!!
I love the direct, straight-forward dialog approach to the writing. It is like a friend explaining the concepts to me. Keeps me engaged and learning. Am doing the examples as exercises. Would recommend it to others in a heartbeat! Thanks.
Well written book. He planned out the chapters really well. Is this guy going to write any more books?
Frequently Asked Questions
Unlimited access to this title and 600+ others in our library