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
Postage:
Located in: Aurora, Illinois, United States
Delivery:
Estimated between Thu, 27 Jun and Sat, 29 Jun to 43230
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
Business seller information
Thrift Books Global, LLC
TB Thrift Books
18300 Cascade Ave S
Ste 150
98188 Seattle, WA
United States
I certify that all my selling activities will comply with all EU laws and regulations.
Seller assumes all responsibility for this listing.
eBay item number:145616802503
Postage and packaging
Item location:
Aurora, Illinois, United States
Posts 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
| Postage and packaging | To | Service | Delivery*See Delivery notes |
|---|---|---|---|
| Free postage | United States | Economy Shipping | Estimated between Thu, 27 Jun and Sat, 29 Jun to 43230 |
| US $15.99 (approx EUR 14.97) | United States | Expedited Shipping | Estimated on or before Wed, 26 Jun to 43230 |
| Taxes |
|---|
| Seller charges sales tax in |
Sales tax for an item #145616802503
Sales tax for an item #145616802503
Seller collects sales tax/VAT for items dispatched to the following states:
| County | VAT rate |
|---|---|
| Missouri (MO) | 8.238% |
Returns policy
| After receiving the item, cancel the purchase within | Refund will be given as | Return postage |
|---|---|---|
| 30 days | Money back | Seller pays for return postage |
The seller is responsible for return postage costs.
| Return policy details |
|---|
| Returns accepted |
Most Buy It Now purchases are protected by the Consumer Rights Directive, which allow you to cancel the purchase within seven working days from the day you receive the item. Find out more about your rights as a buyer and exceptions.
Payment details
Payment methods
Registered as a business seller
Seller Feedback (5,225,544)
t***u (115)- Feedback left by buyer.
Past month
Verified purchase
I heard one story read from this book. It will be a very good book to read my grandchildren.
0***o (2327)- Feedback left by buyer.
Past month
Verified purchase
A good product at a good price
n***o (2)- Feedback left by buyer.
Past month
Verified purchase
Great service, speedy delivery.
More to explore:
- Workbook Language Courses,
- Workbook Adult Learning & University Books,
- Workbook English Language Courses,
- Workbook School Textbooks & Study Guides,
- Collins School Workbooks Guides,
- English School Workbooks Guides,
- Science School Workbooks Guides,
- French School Workbooks Guides,
- Workbook Language Course in Greek,
- Workbook Language Course in Hebrew