SQL Queries for Mere Mortals, 4th Edition
A Hands-On Guide to Data Manipulation in SQL
|Price||$35.81 - $42.49
|Author||John L. Viescas|
|Format||Paper book / ebook (PDF)|
SQL Queries for Mere Mortals has earned worldwide praise as the clearest, simplest tutorial on writing effective queries with the latest SQL standards and database applications. Now, author John L. Viescas has updated this hands-on classic with even more advanced and valuable techniques.
Step by step, Viescas guides you through creating reliable queries for virtually any current SQL-based database. He demystifies all aspects of SQL query writing, from simple data selection and filtering to joining multiple tables and modifying sets of data.
Building on the basics, Viescas shows how to solve challenging real-world problems, including applying multiple complex conditions on one table, performing sophisticated logical evaluations, and using unlinked tables to think "outside the box".
In two brand-new chapters, you learn how to perform complex calculations on groups for sophisticated reporting, and how to partition data into windows for more flexible aggregation.
Practice all you want with downloadable sample databases for today's versions of Microsoft Office Access, Microsoft SQL Server, and the open source MySQL and PostgreSQL databases. Whether you're a DBA, developer, user, or student, there's no better way to master SQL.
4 5 117
by Gordon Du
SAP Business One is an integrated Enterprise Resource Planning (ERP) software which offers an ideal solution for growing small to midsized businesses. For such companies, retrieving the most relevant information from their business data can be key to standing out from the competition. SAP Business One is a rapidly growing software package...
Price: $30.00 | Publisher: Packt Publishing | Release: 2011
by Scott Klein, Herve Roggero
Pro SQL Database for Windows Azure, 2nd Edition shows how to create enterprise-level database deployments without the usual investment in datacenter and other infrastructure. Take advantage instead of Microsoft's worldwide backbone for cloud computing that delivers all the power of SQL Server in the form of the cloud-based SQL Database fo...
Price: $45.16 | Publisher: Apress | Release: 2012
by Stefan Kaczmarek, Brad Lees, Gary Bennett, Mitch Fisher
Learn Objective-C and its latest release, and learn how to mix Swift with it. You have a great idea for an app, but how do you bring it to fruition? With Objective-C, the universal language of iPhone, iPad, and Mac apps. Using a hands-on approach, you'll learn how to think in programming terms, how to use Objective-C to construct program ...
Price: $39.99 | Publisher: Apress | Release: 2018
by Robin Dewson
Beginning SQL Server for Developers is the perfect book for developers new to SQL Server and planning to create and deploy applications against Microsoft's market-leading database system for the Windows platform. Now in its fourth edition, the book is enhanced to cover the very latest developments in SQL Server, including the in-memory fe...
Price: $36.98 | Publisher: Apress | Release: 2014
by Clare Churcher
Get started on mastering the one language binding the entire database industry. That language is SQL, and how it works is must-have knowledge for anyone involved with relational databases, and surprisingly also for anyone involved with NoSQL databases. SQL is universally used in querying and reporting on large data sets in order to genera...
Price: $28.08 | Publisher: Apress | Release: 2016
by Janet Valade
To be on the cutting edge, Web sites need to serve up HTML, CSS, and products specific to the needs of different customers using different browsers. An effective e-commerce site gathers information about users and provides information they need to get the desired result.PHP scripting language with a MySQL back-end database offers an effec...
Price: $19.74 | Publisher: Wiley | Release: 2009
by David A. Crowder
An effective Web site is the key to success for every venture from class reunions to major corporations. And since Web technology changes rapidly, Building a Web Site For Dummies, 4th Edition is fully updated for the cutting-edge tools and trends.If you need to build and maintain a Web site, even if your experience is severely limited, th...
Price: $16.99 | Publisher: Wiley | Release: 2010
by Kevin Beaver
The best way to stay safe online is to stop hackers before they attack - first, by understanding their thinking and second, by ethically hacking your own site to measure the effectiveness of your security. This practical, top-selling guide will help you do both. Fully updated for Windows 8 and the latest version of Linux, Hacking For Dumm...
Price: $4.29 | Publisher: Wiley | Release: 2013