Picture 1 of 1
Picture 1 of 1
Learning SQL: A Step-By-Step Guide Using Oracle by Earp, Richard; Bagui, Sikha
by Earp, Richard; Bagui, Sikha | PB | Acceptable
US $7.52
ApproximatelyAU $11.28
Condition:
“Readable copy. Pages may have considerable notes/highlighting. ~ ThriftBooks: Read More, Spend ”... Read moreabout condition
Postage:
Estimated between Tue, 25 Jun and Fri, 28 Jun to 43230
Located in: Aurora, Illinois, United States
Returns:
Payments:
Shop with confidence
Seller assumes all responsibility for this listing.
eBay item number:374175895083
Item specifics
- Condition
- Acceptable
- Seller notes
- Binding
- Paperback
- Weight
- 1 lbs
- Product Group
- Book
- IsTextBook
- Yes
- ISBN
- 9780201773637
- Subject Area
- Computers
- Publication Name
- Learning Sql : a Step-By-Step Guide Using Oracle
- Publisher
- Addison-Wesley Longman, Incorporated
- Item Length
- 9.2 in
- Subject
- Desktop Applications / Databases, Programming Languages / Sql
- Publication Year
- 2002
- Type
- Textbook
- Format
- Trade Paperback
- Language
- English
- Item Height
- 0.7 in
- Item Weight
- 21.9 Oz
- Item Width
- 8 in
- Number of Pages
- 368 Pages
About this product
Product Information
Step-by-step examples and exercises help readers gain proficiency with SQL in this tutorial for those with little or no experience with databases or SQL. Material starts with simple Oracle SQL concepts and progresses to more complex query development and PL/SQL, covering SQL as it is invoked via SQL
Product Identifiers
Publisher
Addison-Wesley Longman, Incorporated
ISBN-10
0201773635
ISBN-13
9780201773637
eBay Product ID (ePID)
2286278
Product Key Features
Number of Pages
368 Pages
Language
English
Publication Name
Learning Sql : a Step-By-Step Guide Using Oracle
Publication Year
2002
Subject
Desktop Applications / Databases, Programming Languages / Sql
Type
Textbook
Subject Area
Computers
Format
Trade Paperback
Dimensions
Item Height
0.7 in
Item Weight
21.9 Oz
Item Length
9.2 in
Item Width
8 in
Additional Product Features
LCCN
2002-021516
Target Audience
College Audience
Illustrated
Yes
Lc Classification Number
Qa76.73.S67e27 2002
Table of Content
(Each Chapter concludes with Exercises.) Preface. PART I. 0. The Software Engineering Process and Relational Databases. What is a Database?Database Models.What is the Software Engineering Process?References. 1. Getting Started with Oracle 8 in the Windows Environment. Getting Started in Oracle.Setting Your System Parameters.Using Oracle Commands.Editing SQL Statements.Displaying the "Student-Course" Database.Introducing the Oracle Data Dictionary.Using DESC.Employing a Convention for Writing SQL Statements. 2. More "Beginning" SQL Commands. An Extended SELECT Statement.A Simple CREATE TABLE Command.Inserting Values into a Created Table.The UPDATE Command.The DELETE Command.ROLLBACK, COMMIT, and SAVEPOINT.The ALTER TABLE Command.Data Types. 3. The Cartesian Product, the Join, the Aliases. The Cartesian Product.The Join.Column Aliases.Scripting.COUNT and Rownum.References. 4. Functions and Matching (LIKE). The COUNT Function.Additional Basic Functions.The Data Dictionary Revisited. 5. Query Development, Privileges, and Derived Structures. Query Development.Parentheses in SQL Expressions.Derived Structures.GRANTing and REVOKEing Privileges on Tables and Views.Query Development and Derived Structures. 6. Set Operations. Introducing a Set Operation.The IN and NOT..IN Predicates.The Difference Operation. 7. Joins versus Subqueries. The IN Subquery.The Subquery as a Join.When the Join Cannot be Turned into a Subquery.More Examples Involoving Joints and IN.Subqueries with Operators. 8. GROUP BY and HAVING. Aggregates/Column Functions.The GROUP BY Clause.The HAVING Clause.Auditing IN Subqueries.Nulls Revisited. 9. Correlated Subqueries. Non-Correlated Subqueries.Correlated Subqueries.Existence Queries and Correlation.NOT EXISTS.SQL Universal and Existential Qualifiers: The "For All" Query.References. PART II. 10. CREATE TABLESs and SQLLOADER. The "Simple" CREATE TABLE.The NOT NULL Constraint.PRIMARY KEY Constraints.The UNIQUE Constraint.The CHECK Constraint.Referential Integrity.More on CONSTRAINT Names.SQLLOADER. 11. Multiple Commands, START Files, and Reports in SQLPLUS. Creating a File (a START Table) and STARTing It.Using the DECODE, GREATEST and LEST Functions.Adding Reporting Commands to a START File.Using START Files with ACCEPT and PROMPT.Using START Files with Positional Input. 12. Beginning PL/SQL Examples: Anonymous Scripts, Procedures, Functions, and Packages. Anonymous Blocks.Elementary Procedures with Sequence Structures.Procedures with Selection and Iteration.Functions.Packages.Defining a PL/SQL INDEX BY Table.References. 13. Triggers. What is a Trigger?Using WHEN.A Trigger Where One Table Affects Another Trigger.Mutating Tables.References. Appendix 1: Getting Started with Oracle in the UNIX System. Getting Started on Oracle in UNIX.Signing onto Oracle in UNIX.Editing SQL Commands in UNIX.Some UNIX Commands.Editors.Appendix 1 Exercises. Appendix 2: The Data Dictionary. Beginning to Explore the Data Dictionary.A Paradigm for Choosing a View from the Dictionary.Views of TABLES.Other Objects: Tablespaces and Constraints.Views of Tablespaces.Views of Constraints.Appendix 2 Exercises.References. Appendix 3: The Student Database and Other Tables Used in this Book. The Student-Course Database.Other Tables Used in this Book. Appendix 4: Improvements in Oracle 8i and 9i. Improvements in Oracle 8i.Improvements in Oracle 9i.References. Glossary of Terms. Glossary of Important Commands and Functions. Index of Terms. Index of Important Commands and Functions.
Copyright Date
2003
Item description from the seller
Seller assumes all responsibility for this listing.
eBay item number:374175895083
Postage and handling
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 handling | To | Service | Delivery*See delivery notes |
---|---|---|---|
Free postage | United States | Economy Shipping | Estimated between Tue, 25 Jun and Fri, 28 Jun to 43230 |
US $15.99 (approx. AU $23.99) | United States | Expedited Shipping | Estimated on or before Mon, 24 Jun to 43230 |
Taxes |
---|
Seller charges sales tax in |
Sales tax for an item #374175895083
Sales tax for an item #374175895083
Seller collects sales tax for items posted to the following states:
State | Sales tax rate |
---|---|
Missouri (MO) | 8.238% |
Return policy
Item must be returned within | Refund will be given as |
---|---|
30 days after the buyer receives it | Money back |
The seller is responsible for return postage costs.
You must return items in their original packaging and in the same condition as when you received them. If you don't follow our item condition policy for returnsitem condition policy for returns, you may not receive a full refund.
Refunds by law: In Australia, consumers have a legal right to obtain a refund from a business if the goods purchased are faulty, not fit for purpose or don't match the seller's description. More information at returnsreturns - opens in a new window or tab.
Payment details
Payment methods
Seller Feedback (5,223,657)
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 (282)- 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!!⭐️⭐️⭐️⭐️⭐️
a***r (329)- Feedback left by buyer.
Past 6 months
Verified purchase
thrift.books is an awesome place to purchase books! excellent communication! often the books arrive in better condition than described. ships very fast & the books arrive quickly! carefully packaged! +AAAAAAAAAA ebay sellers. i highly recommend thrift.books for people wanting to purchase books! reaasonable prices and shipping costs!
Product ratings and reviews
Most relevant reviews
- 16 Mar, 2023
Good Title
Verified purchase: YesCondition: Pre-ownedSold by: thrift.books
More to explore:
- Textbook Adult Learning & University Books,
- Learning to Read Fiction Books,
- Study Guide School Textbooks & Study Guides,
- Education Adult Learning & University Books,
- History Adult Learning & University Books,
- Medicine Adult Learning & University Books,
- Nursing Adult Learning & University Books,
- School Textbooks & Study Guides,
- Paperback Adult Learning & University Books,
- Strategy Adult Learning & University Books