Most SQL texts attempt to serve as an encyclopedic reference on SQL syntax -- an approach that is counterproductive, since this information is readily available in online references published by the major database vendors. For SQL beginners, it's more important for a book to focus on general concepts and offer clear explanations and examples of what the various statements can accomplish. This is that beginner book. A number of features make The LANGUAGE OF SQL unique among introductory SQL books. First, you will not be required to download software or sit with a computer as you read the text. The intent of this book is to provide examples of SQL usage that can be understood simply by reading them. Second, topics are organized in an intuitive and logical sequence. SQL keywords are introduced one at a time, allowing you to build on your prior understanding as you encounter new words and concepts. Finally, this book covers the syntax of three widely used databases: Microsoft SQL Server, MySQL, and Oracle, with special "Database Differences" boxes that will show you any differences in the syntax among those three databases, as well as instructions on how to obtain and install free versions of the databases. This is the only book you'll need to gain a working knowledge of SQL and relational databases.
"synopsis" may belong to another edition of this title.
Larry Rockoff has been involved with Business Intelligence and Data Warehouse development for many years. His main area of interest is with using reporting tools to explore, extract, and analyze data in complex databases. He holds an MBA from the University of Chicago, with a specialization in Management Science.
1. Relational Databases and SQL. 2. Basic Data Retrieval. 3. Calculations and Aliases. 4. Using Functions. 5. Sorting Data. 6. Column Based Logic. 7. Row Based Logic. 8. Boolean Logic. 9. Inexact Matches. 10. Summarizing Data. 11. Combining Tables with an Inner Join. 12. Combining Tables with an Outer Join. 13. Self Joins and Views. 14. Subqueries. 15. Set Logic. 16. Stored Procedures and Parameters. 17. Modifying Data. 18. Maintaining Tables. 19. Principles of Database Design. 20. Strategies for Displaying Data. Appendix A. Getting Started with Microsoft SQL Server. Appendix B. Getting Started with MySQL. Appendix C. Getting Started with Oracle Database. Appendix D. Listing of All SQL Statements.
"About this title" may belong to another edition of this title.
Shipping:
FREE
Within U.S.A.
Shipping:
US$ 12.91
From United Kingdom to U.S.A.
Seller: SecondSale, Montgomery, IL, U.S.A.
Condition: Good. Item in good condition. Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00080427086
Quantity: 3 available
Seller: Better World Books, Mishawaka, IN, U.S.A.
Condition: Good. Former library book; may include library markings. Used book that is in clean, average condition without any missing pages. Seller Inventory # GRP76994396
Quantity: 1 available
Seller: Goodwill of Colorado, COLORADO SPRINGS, CO, U.S.A.
Condition: Good. This item is in overall good condition. Covers and dust jackets are intact but may have minor wear including slight curls or bends to corners as well as cosmetic blemishes including stickers. Pages are intact but may have minor highlighting/ writing. Binding is intact; however, spine may have slight wear overall. Minor shelf wear overall. Please note that all items are donated goods and are in used condition. Orders shipped Monday through Friday! Your purchase helps put people to work and learn life skills to reach their full potential. Orders shipped Monday through Friday. Your purchase helps put people to work and learn life skills to reach their full potential. Thank you! Seller Inventory # 466OE3002IJ4
Quantity: 1 available
Seller: More Than Words, Waltham, MA, U.S.A.
Condition: Very Good. . . All orders guaranteed and ship within 24 hours. Before placing your order for please contact us for confirmation on the book's binding. Check out our other listings to add to your order for discounted shipping. Seller Inventory # WAL-B-0g-002146
Quantity: 1 available
Seller: ThriftBooks-Dallas, Dallas, TX, U.S.A.
Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 1. Seller Inventory # G143545751XI4N00
Quantity: 1 available
Seller: BooksRun, Philadelphia, PA, U.S.A.
Paperback. Condition: Good. 1. Ship within 24hrs. Satisfaction 100% guaranteed. APO/FPO addresses supported. Seller Inventory # 143545751X-11-1
Quantity: 1 available
Seller: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.
Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 1. Seller Inventory # G143545751XI4N00
Quantity: 1 available
Seller: ThriftBooks-Reno, Reno, NV, U.S.A.
Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 1. Seller Inventory # G143545751XI4N00
Quantity: 1 available
Seller: Books Liquidation, Sacramento, CA, U.S.A.
paperback. Condition: VeryGood. Very good condition, clean, no writings. Seller Inventory # 53IN3G002793
Quantity: 1 available
Seller: medimops, Berlin, Germany
Condition: very good. Gut/Very good: Buch bzw. Schutzumschlag mit wenigen Gebrauchsspuren an Einband, Schutzumschlag oder Seiten. / Describes a book or dust jacket that does show some signs of wear on either the binding, dust jacket or pages. Seller Inventory # M0143545751X-V
Quantity: 1 available