Owning this reference, which covers everything from the components of a table to performing batch updates, is a must! Beginning with tips for the person who is programming with SQL for the first time, SQL Tips and Techniques grows with your skills. You can start with Tip 1, "Understanding the Definition of a Database," and by the last tip, "Displaying Image Data Stored Within a SQL Table," you will have covered all aspects of SQL. Or, you can simply keep this book as a comprehensive reference for answering specific SQL questions quickly. However you read it, this invaluable reference will be the only SQL book you need on your shelf!
| ||||||||||||
Book Description
Editorial Reviews
About the Author
Konrad King operates his own consulting business in Las Vegas, Nevada where his primary focus has been on developing enterprise database systems. Recently Konrad has designed and implemented several Web sites that allow his clients to improve customer relations and expand their business through e-commerce. In addition to a 21 year career in the computer industry, Konrad has authored or coauthored a number of books. Authoring credits include books on PowerPoint, FrontPage, Web server security and installation, and Web site design and implementation using Active Server Pages, Perl Javascript, and Visual Basic.
Worldwide, millions of computer users regard Dr. Kris Jamsa as one of the leading experts and authors in the industry. He is the author of over 95 books covering a wide range of topics in computer technology, security, graphics, networking, and programming. Kris received his bachelor's degree in computer science from the United States Air Force Academy. During his tenure in the Air Force, Dr. Jamsa worked as a VAX/VMS system manager, overseeing computer hardware, software and network security. He received his Master's Degree in computer science from the University of Nevada, Las Vegas, and his doctorate in computer science with an emphasis on operating systems from Arizona State University. In 1997, Dr. Jamsa earned an MBA degree from San Diego State University.
Worldwide, millions of computer users regard Dr. Kris Jamsa as one of the leading experts and authors in the industry. He is the author of over 95 books covering a wide range of topics in computer technology, security, graphics, networking, and programming. Kris received his bachelor's degree in computer science from the United States Air Force Academy. During his tenure in the Air Force, Dr. Jamsa worked as a VAX/VMS system manager, overseeing computer hardware, software and network security. He received his Master's Degree in computer science from the University of Nevada, Las Vegas, and his doctorate in computer science with an emphasis on operating systems from Arizona State University. In 1997, Dr. Jamsa earned an MBA degree from San Diego State University.
Product Details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, read author blogs, and more.
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
3 of 3 people found the following review helpful:
4.0 out of 5 stars
Good book, a bit wordy.,
By Robert Ken Francis (Shelton, CT United States) - See all my reviews
This review is from: SQL Tips & Techniques (Miscellaneous) (Paperback)
This book has a lot of tips about SQL Server, although it doesn't say that on the cover. This was actually good for me since I was going on a job interview and I needed something like a comprehensive tips reference book on SQL (and SQL Server). I could have easily chosen a worse book. It's a bit wordy for me, and I'm not used to seeing so many typos, but considering that I have seen some terrible SQL books out there (including my college text), this book is actually well thought out.
2 of 4 people found the following review helpful:
5.0 out of 5 stars
Answers every question you might ask,
By Sara Dant (Univ of Wash) - See all my reviews
This review is from: SQL Tips & Techniques (Miscellaneous) (Paperback)
I wasn't expecting two people from UPS to have carry this book into my office--the book is huge. I have been using MYSQL for a year and I am moving to MS SQL Server. The book's tips (over 600) have been invaluable. I used the code the book provides to convert many of applications to support transactions. Got to eliminate tons of code. Very well done! Recommend.
1 of 3 people found the following review helpful:
5.0 out of 5 stars
Everything but the kitchen sink,
By Sara Dant (Univ of Wash) - See all my reviews
This review is from: SQL Tips & Techniques (Miscellaneous) (Paperback)
I agree ... this book covers all aspects of SQL. Code examples work and are meaningful.
Share your thoughts with other customers: Create your own review
|
|
Inside This Book
(learn more)
First Sentence:
Many people use the term database to mean any collection of data items. Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
click your mouse pointer, clicking your mouse pointer, check your system manual, row value constructor, browse mode functions, query results buffer, item master table, database object owner, login component, group rows based, folders containing databases, enclosing query, grouped query, static database structure, transaction log backup file, sample text data, sql tips, character type data, statement batch, transaction processing problems, check your system documentation, column data values, multiple column values, qualified column name, final results table Key Phrases - Capitalized Phrases (CAPs): (learn more)
Query Analyzer, Performance Monitor, Visual Basic, Index Tuning Wizard, Server Agent, Data Type Description, New Data Source, Chart View, Wallace Greg, Hardy Bob, Marsh Andy, Green Bob, Restore Database, Sally Fields, Server Profiler, Server Service Manager, Default Properties, View Properties, Active Server Page, Brown Greg, Cancel Help, Control Panel, All of Two, Create Database Diagram Wizard, Database Role Properties New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
Many people use the term database to mean any collection of data items. Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
click your mouse pointer, clicking your mouse pointer, check your system manual, row value constructor, browse mode functions, query results buffer, item master table, database object owner, login component, group rows based, folders containing databases, enclosing query, grouped query, static database structure, transaction log backup file, sample text data, sql tips, character type data, statement batch, transaction processing problems, check your system documentation, column data values, multiple column values, qualified column name, final results table Key Phrases - Capitalized Phrases (CAPs): (learn more)
Query Analyzer, Performance Monitor, Visual Basic, Index Tuning Wizard, Server Agent, Data Type Description, New Data Source, Chart View, Wallace Greg, Hardy Bob, Marsh Andy, Green Bob, Restore Database, Sally Fields, Server Profiler, Server Service Manager, Default Properties, View Properties, Active Server Page, Brown Greg, Cancel Help, Control Panel, All of Two, Create Database Diagram Wizard, Database Role Properties New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
Citations (learn more)
Books on Related Topics
(learn more)
|
|
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Discussions
|
This product's forum
Active discussions in related forums
Search Customer Discussions
|
Related forums
|
