Don't just learn "generic" SQL! Learn SQL to get results with the world's top database platforms: Oracle 9i for the enterprise, and Microsoft Access 2000 for the desktop! Based on John Patrick's hands-on SQL course for IT pros at the University of California, Berkeley, SQL Fundamentals, Second Edition shows exactly how to retrieve the data you want, when you need it, in any application -- from ad hoc reports to the data warehouse. Unlike competitive books, SQL Fundamentals, Second Edition emphasizes practical concepts and examples from the latest versions of both leading SQL implementations: Access 2000 on the desktop, and Oracle 9i for the enterprise. You'll start with the basics: creating simple queries to retrieve information from a single table. Next, you'll move on to more complex queries involving many tables. Patrick shows how to create tables and views that divide a complex process into a series of simple steps; summarize your data; work with each form of join; and much more. Throughout, he emphasizes techniques for writing SQL queries that are easy to understand, verify, modify, and extend. All tables used in the book are furnished in both Oracle and Access format.The accompanying CD-ROM contains a library of Access databases and code for building Oracle databases.

Product Description: This boxed set contains classroom resources specially created to help America's educators teach about the most important documents in U.S. history. The materials were developed by The Annenberg Foundation Trust at Sunnylands to complement Middle and High School civics and history curricula...read more

Reviews and discusses landmark cases heard by the United States Supreme court from 1803 through 2000.

Presents biographical information about the chief and associate justices, and gives descriptions of more than one hundred of the most historically significant cases heard by the Supreme Court.

Uses contemporary documents to explore the history of the first ten amendments to the U.S. Constitution, the British traditions on which they were based, and their impact on American society. (view table of contents)

Alphabetically arranged entries offer profiles of United States presidents, vice presidents, Supreme Court justices, and other significant figures, and information on elections, legislation, Supreme Court decisions, and major issues.

An authoritative, comprehensive encyclopedia of the U.S. government furnishes hundreds of alphabetically arranged entries that include biographical profiles of key figures--including the presidents, vice presidents, Supreme Court justices, and others--as well as commentary on the elections, landmark legislation and Supreme Court cases, history, issues, and more. (view table of contents)

A comprehensive reference to American government includes biographies of presidents, vice presidents, Supreme Court justices, and members of Congress; analyses of one hundred important Supreme Court cases; tourist advice on visiting the nation's capital; and much more. Original. (view table of contents)

(view table of contents)

Discusses the issues that confronted the framers of our government, shows how they arrived at consensus from their numerous conflicting positions, and includes a chronology of major events and seven topically arranged sections of documents. (view table of contents)

An introduction to the Supreme Court, using the device of alphabetically listing and explaining its decisions, justices, concepts, legal terms, practices, and issues

Product Description: Book by

Product Description: Excellent lesson plans; a fundamental document of American freedom.

Product Description: The Federalist Papers were a collection of political essays from the 18th century written by several Founding Fathers of the United States.

Gregory Mallen, an Air Force officer on vacation in Vermont at the outbreak of nuclear war, is hunted down by the new totalitarian regime and attempts to escape to British Columbia in a small plane