The Oxford Guide to the United States Government is the ultimate resource for authoritative information on the U.S. Presidency, Congress, and Supreme Court. Compiled by three top scholars, its pages brim with the key figures, events, and structures that have animated U.S. government for more than 200 years.
In addition to coverage of the 2000 Presidential race and election, this Guide features biographies of all the Presidents, Vice Presidents, and Supreme Court Justices, as well as notable members of Congress, including current leadership; historical commentary on past elections, major Presidential decisions, international and domestic programs, and the key advisors and agencies of the executive branch; in-depth analysis of Congressional leadership and committees, agencies and staff, and historic legislation; and detailed discussions of 100 landmark Supreme Court cases and the major issues facing the Court today. In addition to entries that define legal terms and phrases and others that elaborate on the wide array of government traditions, this invaluable book includes extensive back matter, including tables of Presidential election results; lists of Presidents, Vice Presidents, Congresses, and Supreme Court Justices with dates of service; lists of Presidential museums, libraries, and historic sites; relevant websites; and information on visiting the White House, the Capitol, and Supreme Court buildings.
A one-stop, comprehensive guide that will assist students, educators, and anyone curious about the inner workings of government, The Oxford Guide to the United States Government will be a valued addition to any home library....

SQL for the Real World

 

Don’t just learn “generic” SQL. Learn SQL to get results with the world’s top database platforms–Oracle for the enterprise and Microsoft Access for the desktop. Based on John Patrick’s hands-on SQL course at the University of California, Berkeley Extension, this book shows exactly how to retrieve the data you want, when you need it, in any application–from ad hoc reports to the data warehouse. Thoroughly updated for the newest versions of Oracle, Access, and the SQL standard, this book contains more exercises, techniques, and solutions than ever before. You’ll learn exactly how to write SQL queries that are easy to understand, verify, modify, and extend–even if you’ve never worked with databases before.

 

SQL Fundamentals,Third Edition, teaches you how to

• Build simple statements to retrieve, store, or modify data
• Craft complex queries that draw information from multiple tables
• Sort and summarize your data just the way you want it
• Create and edit your own tables
• Protect the integrity of your data
• Create more efficient, high-performance queries
• Work with unions, subqueries, self joins, cross joins, inner joins, and outer joins
• Use the Oracle Data Dictionary

About the Web Site

 

The accompanying Web site, http://groups.google.com/group/sqlfun, contains all the SQL code and tables from the book, including the full databases for several versions of Access and code for building the corresponding Oracle databases. It also provides solutions to many of the book’s problems and an open area for discussions with the author and other readers.

...