John L. Viescas's Books

Effective SQL

61 Specific Ways to Write Better SQL

By: John L. Viescas,Douglas J. Steele,Ben G. Clothier

Write a review Read reviews Take a Quiz Solve Book Puzzle

Effective SQL

61 Specific Ways to Write Better SQL

By: John L. Viescas,Douglas J. Steele,Ben G. Clothier

Effective SQL brings together the hands-on solutions and practical insights you need to solve a wide range of complex problems with SQL, and to design databases that make it far easier to manage data in the future. Leveraging the proven format of the best-selling Effective series, it focuses on providing clear, practical explanations, expert tips, and plenty of realistic examples -- all in full color. Drawing on their immense experience as consultants and instructors, three world-class database experts identify specific challenges, and distill each solution into five pages or less. Throughout, they provide well-annotated SQL code designed for all leading platforms, as well as code for specific implementations ranging from SQL Server to Oracle and MySQL, wherever these vary or permit you to achieve your goal more efficiently. Going beyond mere syntax, the authors also show how to avoid poor database design that makes it difficult to write effective SQL, how to improve suboptimal designs, and how to work around designs you can't change. You'll also find detailed sections on filtering and finding data, aggregation, subqueries, and metadata, as well as specific solutions for everything from listing products to scheduling events and defining data hierarchies. Simply put, if you already know the basics of SQL, Effective SQL will help you become a world-class SQL problem-solver.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

661

Publisher

Addison-Wesley Professional

Published Date

ISBN 10

0134579062

ISBN 13

9780134579061

SQL Queries for Mere Mortals

A Hands-on Guide to Data Manipulation in SQL

By: John L. Viescas,Michael James Hernandez

Write a review Read reviews Take a Quiz Solve Book Puzzle

SQL Queries for Mere Mortals

A Hands-on Guide to Data Manipulation in SQL

By: John L. Viescas,Michael James Hernandez

This book on generic SQL can be used by new users to learn the foundations of SQL or act as a reference for more experienced users. This new edition brings the content up-to-date with the latest versions of the major proprietary database systems, including Access, Oracle and MySQL.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

672

Publisher

Pearson Education

Published Date

ISBN 10

0321444434

ISBN 13

9780321444431

Microsoft Office Access 2007 Inside Out

By: Jeff Conrad,John L. Viescas

Write a review Read reviews Take a Quiz Solve Book Puzzle

Microsoft Office Access 2007 Inside Out

By: Jeff Conrad,John L. Viescas

You’re beyond the basics, so dive right in and really put your database skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Discover how the experts tackle Access 2007—and challenge yourself to new levels of mastery! Create tables that support your database design strategy Import and link to data from spreadsheets, text files, databases, and other ODBC data sources Build simple to complex queries to manipulate data Learn advanced techniques for building and customizing user interface forms Design attractive reports to calculate and analyze large sets of data Automate your application with Microsoft Visual Basic(R) for Applications Customize the Office Fluent Ribbon Explore using XML and Windows(R) SharePoint(R) Services to create Web-based applications CD includes: Fully searchable eBook—plus bonus chapters Sample database applications—including query, form, and report examples Articles from the experts: designing databases, understanding SQL, exporting data, and more Links to demos, blogs, and user communities References for finding Access 2003 commands in Access 2007 Windows Vista(R) Product Guide eReference and other eBooks For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

2314

Publisher

Pearson Education

Published Date

ISBN 10

073563789X

ISBN 13

9780735637894

Microsoft Access 2010 Inside Out

By: Jeff Conrad,John L. Viescas

Write a review Read reviews Take a Quiz Solve Book Puzzle

Microsoft Access 2010 Inside Out

By: Jeff Conrad,John L. Viescas

You're beyond the basics, so dive right in and really put your database skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts tackle Access 2010 -- and challenge yourself to new levels of mastery! Master essential data management and design techniques Import and link to data from spreadsheets, databases, text files, and other sources Use action queries to quickly insert, update, or delete entire sets of data Create custom forms to capture and display data Design reports to calculate, summarize, and highlight critical data--and learn advanced techniques Automate your application with macros and Visual Basic for Applications (VBA) Use Access Services to extend your database application to the Web Try out the sample client and web database applications in both 32-bit and 64-bit versions A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. The sample client and web database applications are provided in both 32-bit and 64-bit versions. Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

2587

Publisher

Microsoft Press

Published Date

ISBN 10

0735652317

ISBN 13

9780735652316

Running Microsoft Access 2 for Windows

By: John L. Viescas

Write a review Read reviews Take a Quiz Solve Book Puzzle

Running Microsoft Access 2 for Windows

By: John L. Viescas

Release 2.0 for Windows. Beginner and intermediate users.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

962

Publisher

Penguin Books

Published Date

ISBN 10

1556155921

ISBN 13

9781556155925

The Norton Utilities

Includes Version 5

By: John Viescas

Write a review Read reviews Take a Quiz Solve Book Puzzle

The Norton Utilities

Includes Version 5

By: John Viescas

For each utility in the Norton Utilities this quick reference guide contains a brief description, complete syntax, an explanation of program parameters and usage notes. Examples are included for the more complex utilities.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

164

Published Date

ISBN 10

1556153678

ISBN 13

9781556153679

Microsoft Office Access 2003 Inside Out

By: John L. Viescas

Write a review Read reviews Take a Quiz Solve Book Puzzle

Microsoft Office Access 2003 Inside Out

By: John L. Viescas

Hey, you know your way around a database so now dig into Access 2003 and really put your information to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds all in concise, fast-answer format. It s all muscle and no fluff. Discover the best and fastest ways to perform everyday ......

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

1342

Published Date

ISBN 10

0735615136

ISBN 13

9780735615137

SQL Queries for Mere Mortals

A Hands-On Guide to Data Manipulation in SQL

By: John L. Viescas,Michael J. Hernandez

Write a review Read reviews Take a Quiz Solve Book Puzzle

SQL Queries for Mere Mortals

A Hands-On Guide to Data Manipulation in SQL

By: John L. Viescas,Michael J. Hernandez

The #1 Easy, Common-Sense Guide to SQL Queries—Updated for Today’s Databases, Standards, and Challenges SQL Queries for Mere Mortals ® has earned worldwide praise as the clearest, simplest tutorial on writing effective SQL queries. The authors have updated this hands-on classic to reflect new SQL standards and database applications and teach valuable new techniques. Step by step, John L. Viescas and Michael J. Hernandez guide you through creating reliable queries for virtually any modern SQL-based database. They demystify all aspects of SQL query writing, from simple data selection and filtering to joining multiple tables and modifying sets of data. Three brand-new chapters teach you how to solve a wide range of challenging SQL problems. You’ll learn how to write queries that apply multiple complex conditions on one table, perform sophisticated logical evaluations, and think “outside the box” using unlinked tables. Coverage includes -- Getting started: understanding what relational databases are, and ensuring that your database structures are sound -- SQL basics: using SELECT statements, creating expressions, sorting information with ORDER BY, and filtering data using WHERE -- Summarizing and grouping data with GROUP BY and HAVING clauses -- Drawing data from multiple tables: using INNER JOIN, OUTER JOIN, and UNION operators, and working with subqueries -- Modifying data sets with UPDATE, INSERT, and DELETE statements Advanced queries: complex NOT and AND, conditions, if-then-else using CASE, unlinked tables, driver tables, and more Practice all you want with downloadable sample databases for today’s versions of Microsoft Office Access, Microsoft SQL Server, and the open source MySQL database. Whether you’re a DBA, developer, user, or student, there’s no better way to master SQL. informit.com/aw forMereMortals.com

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

792

Publisher

Addison-Wesley Professional

Published Date

ISBN 10

0133824845

ISBN 13

9780133824841

Microsoft Access 2010 Inside Out

By: Jeff Conrad,John Viescas

Write a review Read reviews Take a Quiz Solve Book Puzzle

Microsoft Access 2010 Inside Out

By: Jeff Conrad,John Viescas

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

1440

Published Date

ISBN 10

0735626855

ISBN 13

9780735626850

Running Microsoft Access 2000

By: John L. Viescas

Write a review Read reviews Take a Quiz Solve Book Puzzle

Running Microsoft Access 2000

By: John L. Viescas

The complete reference--made by Microsoft--to help you be more productive with this bestselling relational database. This authoritative handbook has the answers you need for learning how to use Access 2000 for everything from personal desktop applications and workgroup systems to scalable back-end enterprise databases. Comprehensive Take advantage of enhanced integration with the Web for seamless data-sharing across platforms and user levels Publish live data to the Web with new data access pages Use the built-in programming language, Microsoft Visual Basic for Applications, to automate tasks, customize menus and toolbars, connect applications to the Internet, and more Gain insight into using Microsoft Access 2000 as a component within Microsoft Office 2000 Easy Access to Information "Chapters at a Glance" for quick reference Master table of contents Extensive cross-referenced index Two-color interior for easier navigation Everything Is Clear Step-by-step instructions Hundreds of screen illustrations Real-world examples Tips and advice from the experts The CD contains all sample databases from the book, which you can study and reuse. For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

1076

Published Date

ISBN 10

1572319348

ISBN 13

9781572319349

Microsoft Office Access 2007 Inside Out

By: John Viescas,Jeff Conrad

Write a review Read reviews Take a Quiz Solve Book Puzzle

Microsoft Office Access 2007 Inside Out

By: John Viescas,Jeff Conrad

Provides an overview of the features and functions of the program, discussing such topics as building queries, importing and exporting data, creating reports, securing a database, and distributing an Access application.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

1443

Published Date

ISBN 10

0735623252

ISBN 13

9780735623255

Microsoft Office Access 2003 Inside Out

By: John L. Viescas

Write a review Read reviews Take a Quiz Solve Book Puzzle

Microsoft Office Access 2003 Inside Out

By: John L. Viescas

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

1342

Published Date

ISBN 10

0735615136

ISBN 13

9780735615137

Book's by John L. Viescas

Effective SQL

Effective SQL

SQL Queries for Mere Mortals

SQL Queries for Mere Mortals

Microsoft Office Access 2007 Inside Out

Microsoft Office Access 2007 Inside Out

Microsoft Access 2010 Inside Out

Microsoft Access 2010 Inside Out

Running Microsoft Access 2 for Windows

Running Microsoft Access 2 for Windows

The Norton Utilities

The Norton Utilities

Microsoft Office Access 2003 Inside Out

Microsoft Office Access 2003 Inside Out

SQL Queries for Mere Mortals

SQL Queries for Mere Mortals

Microsoft Access 2010 Inside Out

Microsoft Access 2010 Inside Out

Running Microsoft Access 2000

Running Microsoft Access 2000

Microsoft Office Access 2007 Inside Out

Microsoft Office Access 2007 Inside Out

Microsoft Office Access 2003 Inside Out

Microsoft Office Access 2003 Inside Out

Username

Password

Username

Password

Password again

Birthday

Email