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
Condition:
“Readable copy. Pages may have considerable notes/highlighting. ~ ThriftBooks: Read More, Spend ”... Read moreabout condition
Price:
US $6.70
ApproximatelyC $9.16
- Buy It NowLearning SQL: A Step-By-Step Guide Using Oracle by Earp, Richard; Bagui, Sikha
Shipping:
Estimated between Tue, May 28 and Fri, May 31 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:374175895083
Item specifics
- Condition
- Acceptable
- Seller Notes
- Binding
- Paperback
- Weight
- 1 lbs
- Product Group
- Book
- IsTextBook
- Yes
- ISBN
- 9780201773637
- Publication Year
- 2002
- Type
- Textbook
- Format
- Trade Paperback
- Language
- English
- Publication Name
- Learning Sql : a Step-By-Step Guide Using Oracle
- Item Height
- 0.7in
- Item Length
- 9.2in
- Publisher
- Addison-Wesley Longman, Incorporated
- Item Width
- 8in
- Item Weight
- 21.9 Oz
- 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
Publication Name
Learning Sql : a Step-By-Step Guide Using Oracle
Format
Trade Paperback
Language
English
Publication Year
2002
Type
Textbook
Number of Pages
368 Pages
Dimensions
Item Length
9.2in
Item Height
0.7in
Item Width
8in
Item Weight
21.9 Oz
Additional Product Features
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
Target Audience
College Audience
Topic
Desktop Applications / Databases, Programming Languages / Sql
Lccn
2002-021516
Illustrated
Yes
Genre
Computers
Item description from the seller
Seller assumes all responsibility for this listing.
eBay item number:374175895083
Shipping and handling
Item location:
Aurora, Illinois, United States
Ships to:
Afghanistan, Albania, Algeria, American Samoa, Andorra, Angola, Anguilla, Antigua and Barbuda, Argentina, Armenia, Aruba, Australia, Austria, Azerbaijan Republic, Bahamas, Bahrain, Bangladesh, Belarus, Belgium, Belize, Benin, Bermuda, Bhutan, Bolivia, Bosnia and Herzegovina, Botswana, Brazil, British Virgin Islands, Brunei Darussalam, Bulgaria, Burkina Faso, Burundi, Cambodia, Cameroon, Canada, Cape Verde Islands, Cayman Islands, Central African Republic, Chad, Chile, China, Colombia, Comoros, Cook Islands, Costa Rica, Cyprus, Czech Republic, Côte d'Ivoire (Ivory Coast), Democratic Republic of the Congo, Denmark, Djibouti, Dominica, Dominican Republic, Ecuador, Egypt, El Salvador, Equatorial Guinea, Eritrea, Estonia, Ethiopia, Falkland Islands (Islas Malvinas), Fiji, Finland, France, Gabon Republic, Gambia, Georgia, Germany, Ghana, Gibraltar, Greece, Greenland, Grenada, Guam, Guatemala, Guernsey, Guinea, Guinea-Bissau, Guyana, Haiti, Honduras, Hong Kong, Hungary, Iceland, India, Indonesia, Iraq, Ireland, Israel, Italy, Jamaica, Japan, Jersey, Jordan, Kazakhstan, Kenya, Kiribati, Kuwait, Kyrgyzstan, Laos, Latvia, Lebanon, Lesotho, Liberia, Liechtenstein, Lithuania, Luxembourg, Macau, Macedonia, Madagascar, Malawi, Malaysia, Maldives, Mali, Malta, Marshall Islands, Mauritania, Mauritius, Mayotte, Mexico, Micronesia, Moldova, Monaco, Mongolia, Montenegro, Montserrat, Morocco, Mozambique, Namibia, Nauru, Nepal, Netherlands, Netherlands Antilles, New Zealand, Nicaragua, Niger, Nigeria, Niue, Norway, Oman, Pakistan, Palau, 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 Pierre and Miquelon, Saint Vincent and the Grenadines, San Marino, Saudi Arabia, Senegal, Serbia, Seychelles, Sierra Leone, Singapore, Slovakia, Slovenia, Solomon Islands, Somalia, South Africa, South Korea, Spain, Sri Lanka, Suriname, Svalbard and Jan Mayen, Swaziland, Sweden, Switzerland, Taiwan, Tajikistan, Tanzania, Thailand, Togo, Tonga, Trinidad and Tobago, Tunisia, Turkey, Turkmenistan, Turks and Caicos Islands, Tuvalu, Uganda, United Arab Emirates, United Kingdom, Uruguay, Uzbekistan, Vanuatu, Vatican City State, Vietnam, Virgin Islands (U.S.), Wallis and Futuna, Western Sahara, 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 Tue, May 28 and Fri, May 31 to 43230 |
| US $15.99 (approx C $21.86) | United States | Expedited Shipping | Estimated on or before Sat, May 25 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 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,192,484)
z***z (602)- 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 (269)- Feedback left by buyer.
Past month
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 (326)- Feedback left by buyer.
Past month
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
- Mar 15, 2023
Good Title
Verified purchase: YesCondition: Pre-OwnedSold by: thrift.books
More to explore:
- Richard Scarry Fiction Learning to Read Picture Books Books,
- Richard Scarry Fiction Learning to Read Picture Books Books in English,
- Kaplan Usmle Step 1 Lecture Notes,
- Richard Scarry Fiction & Books,
- TV Guide Magazines,
- Study Study Guides Prep,
- Learning to Read Fiction Picture Books Books,
- Science Study Guides & Test Prep,
- Study Guides & Test Prep,
- TV Guide Magazines 1980-1999