Goodreads helps you keep track of books you want to read.
Start by marking “SQL (Database Programming) (2015 Edition)” as Want to Read:
SQL (Database Programming) (2015 Edition)
by
Chris Fehily
2015 Edition. Perfect for end users, analysts, data scientists, and app developers, this best-selling guide will get you up and running with SQL, the language of databases. You'll find general concepts, practical answers, and clear explanations of what the various SQL statements can do. Hundreds of examples of varied difficulty encourage you to experiment and explore. Full
...more
Kindle Edition, 424 pages
Published
July 14th 2014
by Questing Vole Press
(first published July 29th 2002)
Friend Reviews
To see what your friends thought of this book,
please sign up.
Reader Q&A
To ask other readers questions about
SQL (Database Programming),
please sign up.
Be the first to ask a question about SQL (Database Programming)
This book is not yet featured on Listopia.
Add this book to your favorite list »
Community Reviews
(showing 1-30 of 192)
This book is a lesson in good educational design. It was a perfect match, at least, for the way that I learn. That's high praise for a reference book from 2002, but SQL isn't complicated enough to warrant a step-by-step approach and it was more than enough to show me what's possible, how it's generally done, and how to tailor the SQL statements for different DBMS. There were only a few occasions on which I had to scroll down to the 'fine print' in Microsoft's Access documentation to troubleshoot
...more
It's been 4 or 5 years since I've done anything with SQL, so I was hoping to use this to shake off the rust. Related topics seem to be scattered about rather than grouped together, which makes it difficult to go through from start to finish. Its explanations and examples are also fairly wordy, which makes this difficult to use as a reference. I ended up having to rely on an older SQL book and searching the internet for updates to the language to get back up to speed.
It is fairly short but comprehensive introduction to standard SQL, the book has fair amount of examples, that illustrate concepts well enough.
The distinctive feature is compatibility with around 10 most important RDBMSs.
The distinctive feature is compatibility with around 10 most important RDBMSs.
Still use this is a reference book while working, highly recommended if you're kind of slow like me.
Hard to get passionate about a textbook but this is easy to read and useful. 4 stars.
Jul 18, 2015
Eric Brooke
rated it
really liked it
·
review of another edition
Shelves:
software-development
A really handy reference and good learning tool.
There are no discussion topics on this book yet.
Be the first to start one »
Goodreads is hiring!
![Microsoft Windows 7 [With Access Code]](https://d.gr-assets.com/books/1348598161m/7429080.jpg "Microsoft Windows 7 [With Access Code]")
Share This Book
No trivia or quizzes yet. Add some now »
“Microsoft SQL Server, Oracle, DB2, and PostgreSQL let you create user-defined types (UDTs). The simplest UDT is a standard or built-in data type (CHARACTER, INTEGER, and so on) with additional check and other constraints. You can define the data type marital_status, for example, as a single-character CHARACTER data type that allows only the values S, M, W, D, or NULL (for single, married, widowed, divorced, or unknown). More-complex UDTs are similar to classes in object-oriented programming languages such as Java or Python. You can define a UDT once and use it in multiple tables, rather than repeat its definition in each table in which it’s used. Search your DBMS documentation for user-defined type. UDTs are created in standard SQL with the statement CREATE TYPE.”
—
0 likes
More quotes…
Jan 09, 2013 09:55AM
Jan 12, 2013 11:41AM