

Oracle SQL Interactive Workbook
by Morrison, Alexandrea; Morrison, Alex;... | PB | Good
US $5.46
Approximately£4.11
Condition:
“Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, ”... Read moreAbout condition
Good
A book that has been read, but is in good condition. Minimal damage to the book cover eg. scuff marks, but no holes or tears. If this is a hard cover, the dust jacket may be missing. Binding has minimal wear. The majority of pages are undamaged with some creasing or tearing, and pencil underlining of text, but this is minimal. No highlighting of text, no writing in the margins, and no missing pages. See the seller’s listing for full details and description of any imperfections.
Last one1 sold
Oops! Looks like we're having trouble connecting to our server.
Refresh your browser window to try again.
Postage:
Free USPS Media MailTM.
Located in: Aurora, Illinois, United States
Delivery:
Estimated between Fri, 9 May and Wed, 14 May
Returns:
30 days return. Seller pays for return postage.
Payments:
Shop with confidence
Seller assumes all responsibility for this listing.
eBay item number:374567624376
Item specifics
- Condition
- Good
- Seller notes
- Binding
- Paperback
- Book Title
- Oracle SQL Interactive Workbook
- Weight
- 1 lbs
- Product Group
- Book
- IsTextBook
- Yes
- ISBN
- 0130157457
About this product
Product Identifiers
Publisher
Prentice Hall PTR
ISBN-10
0130157457
ISBN-13
9780130157454
eBay Product ID (ePID)
1729003
Product Key Features
Number of Pages
516 Pages
Language
English
Publication Name
Oracle Sql Interactive Workbook
Publication Year
2000
Subject
Desktop Applications / Databases, Programming Languages / Sql, Databases / General
Type
Workbook
Subject Area
Computers
Format
Trade Paperback
Dimensions
Item Height
1.4 in
Item Weight
36.1 Oz
Item Length
9.2 in
Item Width
7 in
Additional Product Features
Intended Audience
Scholarly & Professional
LCCN
00-027499
Dewey Edition
21
Dewey Decimal
005.75/65
Edition Description
Workbook
Table Of Content
(NOTE: All chapters conclude with Test Your Thinking. ) 1. SQL and Data. Data, Databases, and the Definition of SQL. A Case Study Schema Diagram. Referential Integrity and Table Relationships. The SQL *PLUS Environment. 2. SQL: The Basics. The Anatomy of a SELECT Statement. Editing a SQL Statement. The WHERE Clause: Comparison and Logical Operators. The ORDER BY Clause. 3. Character and Number Functions. Character Functions. Number Functions. 4. Date and Conversion Functions. Converting from One Datatype to Another. Applying Oracle's Date Format Models. Performing Date and Time Math. The NVL and DECODE Functions. 5. Aggregate Functions, GROUP BY, and HAVING. Aggregate Functions. The GROUP BY and HAVING Clauses. 6. Equijoins. The Two Table Join. Joining More Than Two Tables. 7. Subqueries. Simple Subqueries. Correlated Subqueries. ANY, COME, and ALL Operators in Subqueries. 8. Set Operators. The Power of UNION and UNION ALL. The MINUS and INTERSECT Set Operators. 9. Complex Joins. Outer Joins. Self-Joins. 10. Insert, Update, and Delete. Manipulaitng Data and Transaction Control. 11. Create, Alter, and Drop Tables. Creating and Dropping Tables. Altering Tables and Manipulating Constraints. 12. Views, Indexes, and Sequences. Creating and Modifying Views. Indexes. Sequences. 13. The Data Dictionary and Dynamic SQL Scripts. The Oracle Data Dictionary Views. Dynamic. SQL Scripts. 14. Security. Users, Privileges, Roles, and Synonyms. 15. Advanced SQL Queries. DECODE Magic and In-line Views. Hierarchical Queries. 16. SQL Optimization. The Oracle Optimizer and Writing Effective SQL Statement. Appendix A: Answers to Self-Review Questions. Appendix B: SQL Formatting Guide and SQL*Plus Command Reference. Appendix C: Student Database Schema. Index.
Synopsis
Before Oracle DBAs and developers can move on to sophisticated application development, they must gain an in-depth understanding of Oracle SQL. Oracle SQL Interactive Workbook is the fastest way to master Oracle SQL. This integrated book-and-Web learning solution teaches all the Oracle SQL skills you need, through hands-on, real-world labs, exercises, projects, and our great Web-based training site! Coverage includes every key Oracle SQL concept, including: entity-relationship diagrams, the SQL*Plus environment, SELECT and other statements, Boolean operations, joins, aggregate and not-aggregate functions; pseudocolumns; complex joins and subqueries; relational operators; date and conversion functions; DML, DDL, and more. A free Web-based training module includes a Virtual Study Lounge where readers can interact with the author; "Test Your Thinking" project solutions and explanations, interactive Q&As, self-review exercises, new projects, book updates, and more!, Foreword by Peter Koletzke Technical Advisor: Douglas Scherer The Hands-On Oracle SQL Course Thats Fast, Easy, & Web-charged FREE Access to Interactive Oracle SQL Training Web Site *Learn to write SQL fluently-now *No Oracle SQL experience necessary *Covers all key Oracle SQL concepts *Real-life labs and Test Your Thinking Q&As New to Oracle development? This integrated book-and-Web learning solution will help you master Oracle SQL - fast Learn every Oracle SQL skill you need, through hands-on, real-world labs, exercises, projects, and our great Web-based training site. Master entity-relationship diagrams, SQL *Plus, SELECT statements, Boolean operations, functions, joins, NULLS, subqueries, relational operators, data and database object manipulation, and the Oracle dictionary. Totally integrated with a FREE, state-of-the-art Oracle SQL learning Web site Every Prentice Hall Interactive Workbook is fully integrated with its own exclusive Web site, giving you all this and more: *Test Your Thinking project solutions and detailed explanations *Authors Corner: Your personal connection to this books expert author *Additional self-review exercises with instant feedback and explan, A complete, interactive tutorial on the four most important topics that lead to Oracle DBA Certification: SWL, PL/SQL, Forms and Oracle DBA., Written by some of the world's leaders in communications, this is a hands-on, example-rich guide to simulating communications systems. The first book to present complete simulation models built with MATLAB, it offers practical guidance on every key aspect of simulation, as well as detailed models that can serve as laboratories for evaluating the potential impact of changes in system design.
LC Classification Number
QA76.73.S67M68 2000
Item description from the seller
Seller business information
Popular categories from this shop
Seller Feedback (5,615,870)
- y***e (1041)- Feedback left by buyer.Past 6 monthsVerified purchase🏆 SUPER STAR🤩 AMAZING PHOTOS 🎯 ACCURATE DESCRIPTION ✏️ GENUINE PRODUCTS 💎 HIGH QUALITY 🍯 SUPER PRICES 💰 EASY TO WORK WITH 🍰 ECONOMY HANDLING ⏱️ FAST SHIPPING 🚀 BUBBLE PACKAGE 📦 ARRIVED WITHIN DAYS 🌎 EXCEPTIONAL COMMUNICATION 🎙️ OUTSTANDING CUSTOMER SERVICE 🛎️ GREAT SENSE OF HUMOR 🍿 TOTAL ASSET TO THE EBAY-ECO SYSTEM 🥇 SAVED SELLER 🎱 PROMT REPLY FOR RETURNS 🎯 WOULD BUY FROM AGAIN 🧲 UNDER PROMISES OVER DELIVERS ⛳️ MADE ME VERY HAPPY 🌈 LEFT POSITIVE FEEDBACK 🌼 THANK YOU! 😇 AAAA
- f***f (1515)- Feedback left by buyer.Past 6 monthsVerified purchaseThe seller was incredibly communicative and was willing to lump together multiple items I'd purchased to combine shipping, which was greatly appreciated. The item itself was in perfect condition, looks better than in the photo, and was packaged well to avoid any damage during shipping. It arrived quickly and without any issues! Excellent Seller, Goes the Extra Mile. Smooth Transaction, Shipped Very Quickly, As Advertised; Good Price; Well Packaged & Delivered Within a Few Days. A+
- e***r (2702)- Feedback left by buyer.Past 6 monthsVerified purchaseThank you so much for offering this art book. Your price was fabulous on it. I had no communication, but you are no doubt a kind person. You are also a professional person, and your attention to detail really helped me in making my purchase decision. I'm adding you to my favorite seller list, and I always do shop with this list first. And also, I'd like to thank you for the lovely packaging, and the extremely fast shipping. The book was exactly as you described it. Happy New Year, if I can say.
More to explore:
- Workbook Language Courses,
- Oracle Comics, Graphic Novels & TPBs,
- Workbook English Language Courses,
- HarperCollins Workbook Language Course,
- Technology School Workbooks Guides,
- Workbook Language Course Polish,
- Collins School Workbooks Guides,
- Science School Workbooks Guides,
- Education School Workbooks Guides,
- Workbook Language Courses in French