*The fastest, easiest way to master SQL-no experience required *Master every business SQL skill you need Grouping, totaling, summaries, modifying databases, integrating data from multiple tables, and much more *Includes video introduction, 2+ hours of expert audio commentary, 200+ animated figures, 100+ self-review questions, 100+ exercises, searching, hyperlinking, and more. Now you can learn SQL hands on--and get the business information you need, faster than you ever imagined This package brings together the industry's #1 interactive SQL training CD-ROM, the SQL Queries Multimedia Cyber Classroom, with the world's best SQL book for business professionals, SQL Queries for Mere Mortals No matter what database you use, you'll master SQL by practicing with hundreds of live queries and exercises--and learning from hours of animations and audio commentary by two world-renowned database consultants *Over 200 animated figures, with expert audio commentary, illustrate key concepts *Learning SQL is just one click away searchable version of SQL Queries for Mere Morals *Test your knowledge with 100+ self-review questions and 100+ practice exercises *INCLUDES THE #1 BUSINESS GUIDE TO SQL *BONUS: SECOND CD-ROM contains five real-world sample databases designed to support virtually any practice query. *Starts from scratch No unnecessary jargon: just plain-English help and useful examples *Real-world focus: Solutions for the problems businesspeople really encounter. *Up to date Covers the latest ANSI standard SQL--skills apply to virtually any current desktop or enterprise database *Includes advanced, high-performance techniques for solving even complex SQL problems. Queries Training Course covers everything you need to know to succeed with SQL, including concepts, syntax, troubleshooting techniques, performance optimization, and more: *Basic relational database concepts *Fundamental SQL concepts *SELECT statements *Creating expressions *Applying filters *Working with joins *Integrating data from multiple tables *Grouping data *Totaling data *Summarizing data *Updating data *Inserting data *Deleting data *And much more -- including advanced techniques Requirements Windows(r) 95/98/2000/NT(r) 4.0 Internet Explorer (included) 20 MB disk space 32 MB RAM CD-ROM drive Sound card support

The Complete SQL Queries Training Course: Student Edition

Computers & Technology

Hernandez, Michael J.

Viescas, John L.

Programming Languages

PRENTICE/HALL

This package brings together an interactive SQL training CD-ROM ( SQL Queries Multimedia Cyber Classroom ) with an SQL text for business professionals ( SQL Queries for Mere Mortals ) in order to present concepts, syntax, troubleshooting techniques, performance optimization, and more. Topics include basic relational database concepts; fundamental SQL concepts; SELECT statements; creating expressions; applying filters; working with joins; integrating data from multiple tables; grouping, totaling, summarizing, updating, inserting, and deleting data; and advanced techniques. A second CD-ROM contains five real-world sample databases designed to support virtually any practice query. Hernandez is a Microsoft Access instructor and owner of a consulting group; Viescas is also a consultant. Annotation c. Book News, Inc., Portland, OR (booknews.com)

The Complete SQL Queries Training Course

Software

Prentice Hall PTR

Helps new users learn the foundations of SQL queries, and will prove to be an essential reference guide for intermediate and advanced users. Softcover. DLC: SQL (Computer program language).

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL

Addison-Wesley

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

Addison-Wesley Professional

dc:abstract """
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 tasks, and challenge yourself to new levels of Access mastery! <ul>
<li>Build on what you already know about Access and quickly dive into what’s new </li> <li>Design your database the way the experts do—and sidestep common mistakes</li> <li>Import data from spreadsheets, text files, databases, and other sources</li> <li>Write simple to sophisticated queries to manipulate data</li> <li>Learn advanced techniques for building forms and reports </li> <li>Develop PivotTable and PivotChart dynamic views</li> <li>Tap the power of Microsoft SQL Server with Access projects and views, functions, and stored procedures</li> <li>Implement database security features </li> <li>Deliver dynamic data on the Web with data access pages and XML</li> <li>Use Microsoft Visual Basic for Applications (VBA) and script to automate your applications and Web pages </li> </ul>
CD features: <ul>
<li>Complete eBook in PDF format</li> <li>Insider Extras—including fully functional sample databases, VBA code, and sample web pages</li> <li>Catalog of Access resources with links to third-party tools and demos</li> <li>Microsoft resources and demos, including Insider’s Guide to Microsoft Office OneNote 2003 eBook</li> <li>Microsoft Computer Dictionary, Fifth Edition, eBook—10,000+ entries</li> </ul>
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). 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. Please direct any questions or concerns to booktech@oreilly.com.

Microsoft® Office Access 2003 Inside Out (Bpg-Inside Out)

Computer Science

Microsoft Press

Get fully functional database samples and table designs for four of the most common Microsoft Access database types—and use them as templates to create your own Access solutions. Database expert and Microsoft MVP John L. Viescas provides the detailed guidance you need to customize your own solutions from these application types: <ul>
<li>Membership Tracking</li> <li>Inventory Management</li> <li>Customer Support</li> <li>Reservations Management</li> </ul>
For each type, you’ll walk through typical usage scenarios, design considerations, and common pitfalls. You’ll examine the logic behind each application’s table design, and learn how to adapt it for your own Access solution. Get expert insights and examples to help you: <ul>
<li>Learn specific design techniques to improve your table structures</li> <li>Build forms with an attractive, intuitive, and easy-to-use interface</li> <li>Create queries, forms, and reports specific to each application type</li> <li>Design for client/server from the start?and share data more efficiently 
</li> <li>Apply best practices to help your application run more smoothly </li> <li>Avoid the 10 most common design problems—and deliver more robust solutions!</li> </ul>
Note: This book covers Microsoft Office Access 2003, Access 2002, and Access 2000 CD includes database samples and a fully searchable eBook. Use the sample databases on CD to model your own solutions for: <ul>
<li>Membership Tracking: Enter, track, and manage member information and communications. </li> <li>Inventory Management: Track and manage stock and create purchase orders, invoices, and packing lists.</li> <li>Customer Support: Track contacts, enter customer details, identify follow-up items, and create reminders. </li> <li>Reservations Management: Manage course registrations, car rentals, room reservations, and more.</li> </ul>
A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). 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. Please direct any questions or concerns to booktech@oreilly.com.

Building Microsoft® Access Applications

Operating Systems

Access and SQL Server Developer's Handbook offers a practical new approach to enterprise database application development. At last, one volume shows how to build bulletproof SQL Server databases with intuitive Access user interfaces. Get a handle on client/server concepts. Take a detailed look at client/server architecture and essential technologies. Explore client/server application design techniques. Understand all aspects of Access with SQL Server, its advantages and limitations. Build high-performance applications. Task-oriented discussions give you the information you need to build efficient queries, master the upsizing tools, use replication features, secure your data, enhance productivity with the ODBC API, solve common upsizing problems, manage SQL Server fron Access, and handle your applications after deployment. Get more done faster. Discover efficient, proven methods for distributing tasks between the two products. With Access and SQL Server Developer's Handbook, you'll spend more time building high-speed, user-friendly applications - and less time figuring out how to make Access and SQL Server work together.

Access and SQL Server Developer's Handbook

Science & Math

Gunderloy, Mike

Chipman, Mary

Mathematics

Sybex, Inc.

A comprehensive alphabetical guide to all commands in versions 3 through 5 of the Norton Utilities. Annotation copyright Book News, Inc. Portland, Or.

The Norton Utilities: Includes Version 5 (Microsoft Quick Reference)

A major revision of one of the bestselling Microsoft Access books around. The first section provides information on how relational databases work and what they're used for and then offers a quick overview of Access itself. Includes all new examples, and more than 200 pages of new material.

Running Microsoft Access 2 for Windows

Microsoft Pr

Running titles are beating the competition on top bestseller lists around the country. This Access for Windows version should be no exception with its in-depth reference and inside tips from the software experts.

Running Microsoft Access 97

See the best price to sell, buy, or rent books by Viescas, John L.. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Viescas, John L.

See the best price to sell, buy, or rent books by Viescas, John L.. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

The Complete SQL Queries Training Course: Student Edition

The Complete SQL Queries Training Course

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL

Microsoft® Office Access 2003 Inside Out (Bpg-Inside Out)

Building Microsoft® Access Applications

Access and SQL Server Developer's Handbook

The Norton Utilities: Includes Version 5 (Microsoft Quick Reference)

Running Microsoft Access 2 for Windows

Running Microsoft Access 97