Picture 1 of 1
Oracle SQL Interactive Workbook
by Morrison, Alexandrea; Morrison,... | PB | Acceptable
Condition:
“Readable copy. Pages may have considerable notes/highlighting. ~ ThriftBooks: Read More, Spend ”... Read moreabout condition
Shipping:
Estimated between Thu, Jun 27 and Sat, Jun 29 to 43230
Located in: Aurora, Illinois, United States
Returns:
Payments:
Shop with confidence
Seller information
- 99% positive feedback
Registered as a Business Seller
Seller assumes all responsibility for this listing.
eBay item number:145616802503
Item specifics
- Condition
- Acceptable
- Seller Notes
- Binding
- Paperback
- Weight
- 0 lbs
- Product Group
- Book
- IsTextBook
- Yes
- ISBN
- 9780130157454
- Subject Area
- Computers
- Publication Name
- Oracle Sql Interactive Workbook
- Publisher
- Prentice Hall PTR
- Item Length
- 9.2 in
- Subject
- Desktop Applications / Databases, Programming Languages / Sql, Databases / General
- Publication Year
- 2000
- Type
- Workbook
- Format
- Trade Paperback
- Language
- English
- Item Height
- 1.4 in
- Item Weight
- 36.1 Oz
- Item Width
- 7 in
- Number of Pages
- 516 Pages
About this product
Product Information
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!
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
LCCN
00-027499
Dewey Edition
21
Target Audience
Scholarly & Professional
Dewey Decimal
005.75/65
Edition Description
Workbook
Lc Classification Number
Qa76.73.S67m68 2000
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.
Copyright Date
2000
Item description from the seller
Seller assumes all responsibility for this listing.
eBay item number:145616802503
Shipping and handling
Item location:
Aurora, Illinois, United States
Ships to:
Afghanistan, Albania, Algeria, Andorra, Angola, Anguilla, Antigua and Barbuda, Argentina, Armenia, Aruba, Australia, Austria, Azerbaijan Republic, Bahamas, Bahrain, Bangladesh, Belgium, Belize, Benin, Bermuda, Bhutan, Bolivia, Bosnia and Herzegovina, Botswana, Brazil, Brunei Darussalam, Bulgaria, Burkina Faso, Burundi, Cambodia, Cameroon, Canada, Cape Verde Islands, Cayman Islands, Central African Republic, Chad, Chile, China, Colombia, Costa Rica, Cyprus, Czech Republic, Côte d'Ivoire (Ivory Coast), Democratic Republic of the Congo, Denmark, Djibouti, Dominican Republic, Ecuador, Egypt, El Salvador, Equatorial Guinea, Eritrea, Estonia, Ethiopia, Fiji, Finland, France, Gabon Republic, Gambia, Georgia, Germany, Ghana, Gibraltar, Greece, Greenland, Grenada, Guatemala, Guinea, Guinea-Bissau, Guyana, Haiti, Honduras, Hong Kong, Hungary, Iceland, India, Indonesia, Ireland, Israel, Italy, Jamaica, Japan, Jordan, Kazakhstan, Kenya, Kiribati, Kuwait, Kyrgyzstan, Laos, Latvia, Lebanon, Lesotho, Liberia, Liechtenstein, Lithuania, Luxembourg, Macau, Macedonia, Madagascar, Malawi, Malaysia, Maldives, Mali, Malta, Mauritania, Mauritius, Mexico, Moldova, Monaco, Mongolia, Montenegro, Montserrat, Morocco, Mozambique, Namibia, Nauru, Nepal, Netherlands, New Zealand, Nicaragua, Niger, Nigeria, Norway, Oman, Pakistan, Panama, Papua New Guinea, Paraguay, Peru, Philippines, Poland, Portugal, Puerto Rico, Qatar, Republic of Croatia, Republic of the Congo, Romania, Rwanda, Saint Helena, Saint Kitts-Nevis, Saint Lucia, Saint Vincent and the Grenadines, San Marino, Saudi Arabia, Senegal, Serbia, Seychelles, Sierra Leone, Singapore, Slovakia, Slovenia, Solomon Islands, South Africa, South Korea, Spain, Sri Lanka, Suriname, Swaziland, Sweden, Switzerland, Taiwan, Tajikistan, Tanzania, Thailand, Togo, Tonga, Trinidad and Tobago, Tunisia, Turkey, Turkmenistan, Turks and Caicos Islands, Uganda, United Arab Emirates, United Kingdom, Uruguay, Uzbekistan, Vanuatu, Vatican City State, Vietnam, Virgin Islands (U.S.), Wallis and Futuna, Western Samoa, Worldwide, Yemen, Zambia, Zimbabwe
Excludes:
Barbados, French Guiana, French Polynesia, Guadeloupe, Libya, Martinique, New Caledonia, Reunion, Russian Federation, Ukraine, Venezuela
| Shipping and handling | To | Service | Delivery*See Delivery notes |
|---|---|---|---|
| Free shipping | United States | Economy Shipping | Estimated between Thu, Jun 27 and Sat, Jun 29 to 43230 |
| US $15.99 (approx C $21.91) | United States | Expedited Shipping | Estimated on or before Wed, Jun 26 to 43230 |
| Taxes |
|---|
| Seller charges sales tax in |
Sales tax for an item #145616802503
Sales tax for an item #145616802503
Seller collects sales tax for items shipped to the following provinces:
| Province | Sales Tax Rate |
|---|---|
| Missouri (MO) | 8.238% |
Return policy
| After receiving the item, contact seller within | Refund will be given as |
|---|---|
| 30 days after the buyer receives it | Money Back |
The seller is responsible for return shipping costs.
Payment details
Payment methods
Seller feedback (5,225,544)
r***6 (6)- Feedback left by buyer.
Past month
Verified purchase
Very satisfied! Reliable seller with fair prices. One ordered item turned out to be sold during the process, but was promptly refunded. Other ordered items arrived eralier than estimated. They were neatly packed and in the condition described. Contact with seller prior to the order wasn't possible, but communication afterwards was spotless.
z***z (603)- Feedback left by buyer.
Past 6 months
Verified 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! 😇 A+++
u***2 (284)- Feedback left by buyer.
Past 6 months
Verified purchase
Outstanding seller. Fair prices that are more than reasonable in this economy. The product is in better condition than described, a true value for my money.
Packaged and shipped well shows seller has concern for the products sold to arrive in excellent condition. The seller communicated timely with progress. Highly recommend this seller & will do business again. Thank you!!⭐️⭐️⭐️⭐️⭐️