In just 24 sessions of one hour or less, you’ll learn how to use SQL to build effective databases, efficiently retrieve your data, and manage everything from performance to security! Using this book’s straightforward, step-by-step approach, you’ll learn hands-on through practical examples. Each lesson builds on what you’ve already learned, giving you a strong real-world foundation for success. The authors guide you from the absolute basics to advanced techniques—including views, transactions, Web data publishing, and even powerful SQL extensions for Oracle and Microsoft SQL Server. | Ryan Stephens Ron Plew Arie D. Jones FIFTH EDITION Includes Coverage ol Oracle and Microsoft SQL Implementations SamsTeach Yourself SQL S Ows Sams Teach Yourself SQL SẨMS Ryan Stephens Ron Plew Arie D. Jones 24 Hours FIFTH EDITION 800 East 96th Street Indianapolis Indiana 46240 USA Down from Sams Teach Yourself SQL in 24 Hours Fifth Edition Copyright 2011 by Pearson Education Inc. All rights reserved. No part of this book shall be reproduced stored in a retrieval system or transmitted by any means electronic mechanical photocopying recording or otherwise without written permission from the publisher. No patent liability is assumed with respect to the use of the information contained herein. Although every precaution has been taken in the preparation of this book the publisher and author assume no responsibility for errors or omissions. Nor is any liability assumed for damages resulting from the use of the information contained herein. Oracle and Java are registered trademarks of Oracle and or its affiliates. Other names may be trademarks of their respective owners. ISBN-13 978-0-672-33541-9 ISBN-10 0-672-33541-7 The Library of Congress cataloging-in-publication data is on file. Printed in the United States of America First Printing May 2011 Trademarks All terms mentioned in this book that are known to be trademarks or service marks have been appropriately capitalized. Sams Publishing cannot attest to the accuracy of this information. Use of a term in this book should not be regarded as affecting the validity of any trademark or service mark. Warning and Disclaimer Every effort has been made to make this book as complete and as accurate as possible but no warranty or fitness is implied. The information provided is on an as is basis. The authors and the publisher shall have neither liability nor responsibility to any person or entity with respect to any loss or damages arising from the information contained in this book or from the programs .
