Der Verkäufer ist abwesend bis 09. Dez. 2025. Bitte rechnen Sie beim Kauf dieses Artikel mit einer späteren Lieferung.

SQL Fundamentals [With CDROM Contains a Library of Access Databases]

TeamHat
(2518)
PrivatAngemeldet als privater Verkäufer
Verbraucherschützende Vorschriften, die sich aus dem EU-Verbraucherrecht ergeben, finden daher keine Anwendung. Der eBay-Käuferschutz gilt dennoch für die meisten Käufe. Mehr erfahren
Mehr Artikel des Verkäufers
Verkäufer kontaktieren
US $12,00
Ca.EUR 10,35
oder Preisvorschlag
Artikelzustand:
Neu
Versand:
Kostenlos USPS Media MailTM.
Standort: New York, New York, USA
Lieferung:
Lieferung zwischen Mi, 10. Dez und Mi, 17. Dez nach 94104 bei heutigem Zahlungseingang
Wir wenden ein spezielles Verfahren zur Einschätzung des Liefertermins an – in diese Schätzung fließen Faktoren wie die Entfernung des Käufers zum Artikelstandort, der gewählte Versandservice, die bisher versandten Artikel des Verkäufers und weitere ein. Insbesondere während saisonaler Spitzenzeiten können die Lieferzeiten abweichen.
Rücknahme:
Keine Rücknahme.
Zahlungen:
   Diners Club 

Sicher einkaufen

eBay-Käuferschutz
Geld zurück, wenn etwas mit diesem Artikel nicht stimmt. Mehr erfahreneBay-Käuferschutz - wird in neuem Fenster oder Tab geöffnet

  • Gratis Rückversand im Inland
  • Punkte für jeden Kauf und Verkauf
  • Exklusive Plus-Deals
Mehr erfahren- eBay Plus - wird in neuem Fenster oder Tab geöffnet
Der Verkäufer ist für dieses Angebot verantwortlich.
eBay-Artikelnr.:277092410362
Zuletzt aktualisiert am 07. Mai. 2025 08:50:39 MESZAlle Änderungen ansehenAlle Änderungen ansehen

Artikelmerkmale

Artikelzustand
Neu: Neues, ungelesenes, ungebrauchtes Buch in makellosem Zustand ohne fehlende oder beschädigte ...
Binding
Paperback
Product Group
Book
Book Title
SQL Fundamentals [With CDROM Contains a Library of Access...
Weight
2 lbs
IsTextBook
Yes
ISBN
9780130960160
Kategorie

Über dieses Produkt

Product Identifiers

Publisher
Prentice Hall PTR
ISBN-10
0130960160
ISBN-13
9780130960160
eBay Product ID (ePID)
1740752

Product Key Features

Number of Pages
544 Pages
Language
English
Publication Name
Sql Fundamentals
Publication Year
1999
Subject
Programming Languages / Sql, Databases / General
Type
Textbook
Subject Area
Computers
Author
John J. Patrick
Format
CD-ROM / Trade Paperback

Dimensions

Item Height
1.4 in
Item Weight
36.2 Oz
Item Length
9.2 in
Item Width
7 in

Additional Product Features

Intended Audience
College Audience
LCCN
99-024536
Dewey Edition
22
Illustrated
Yes
Dewey Decimal
005.75/65
Table Of Content
1. Storing Information in Tables. Introduction. What is SQL? What is a Relational Database and why would you use one? Why learn SQL? What is in this book? The parts of a table. Data is stored in tables. A row represents an object and the information about it. A column represents one type of information. A cell is the smallest part of a table. Each cell should express just one thing. Primary key columns identify each row. Most tables are tall and thin. Examples of tables. An example of a table in Oracle and Access. Some database design decisions. The Lunches database. Oracle and Access. Obtaining Oracle and Access. Using Oracle. Using Access. 2. Getting Information from a Table. The Select statement. The goal: get a few columns and rows from a table. Overview of the Select statement. The Select clause. Overview of the Select clause. Using the Select clause to get a list of columns. Using the Select clause to get all the columns. Using the Select clause to get the distinct values in one column. Using the Select clause to get the distinct values of several columns. The Where clause. Overview of the Where clause. Using an Equal condition in the Where clause. Using a Less Than condition in the Where clause. Using a Not Equal To condition in the Where clause. Using the In condition in the Where clause. Using the Between condition in the Where clause. Using the Like condition in the Where clause. Using the Is Null condition in the Where clause. Using a compound condition in the Where clause. Using a complex compound condition in the Where clause. Using NOT with IN, BETWEEN, LIKE, and IS NULL. The Order By clause. Overview of the Order By clause. Sorting the rows of several columns in ascending order. Sorting the rows of several columns with some in ascending order and others in descending order. Other techniques. Using a lookup table to find the meanings of codes. The Whole Process. The whole processso far. Punctuation matters. Summary. Exercises. 3. Saving Your Results. Saving your results in a new table or view. Creating a new table from the results of a Select statement. Creating a new view from the results of a Select statement. The similarities and differences between a table and a view. Deleting a table or a view. One view can be built on top of another view. Preventative deletes. Modifying the data in a table. Adding one new row to a table. Adding many new rows to a table with a Select statement. Changing data in the rows already in a table. Deleting rows from a table. Using the GUI environment to change the table data in Access. Modifying data through a view. Changing data through a view. Example of changing data through a view. Views using With Check Option. Finding information about tables and views. The Data Dictionary. How to find the names of all the tables. How to find the names of all the views. How to find the Select statement that defines a view. How to find the names of the columns in a table or view. How to find the primary key of a table. Summary. Exercises. 4. Creating Your Own Tables. Creating tables. The Create Table command. Datatypes in Oracle and Access. Sequences. Changing tables. Adding a primary key to a table. Deleting a primary key from a table. Adding a new column to a table. Deleting a column from a table. Making other changes to tables. Tables with duplicate rows. Finding more information about tables in the Data Dictionary. Finding information about columns. Finding information about sequences. Finding information about your database objects. Finding where to find things in the Data Dictionary. Formats. Date formats. Displaying formatted dates. Entering formatted dates. Summary. Exercises. 5. Row Functions. Introduction to row functions. Getting data directly from the beginning table. Understanding a row function. An example of a row function. Usin
Synopsis
Dont just learn generic SQL Learn SQL to get results with the worlds top database platforms: Oracle for the enterprise and Microsoft Access for the desktop Based on John Patricks hands-on SQL course for IT pros at the University of California, Berkeley, this book shows exactly how to retrieve the data you want, when you need it, in any application - from ad hoc reports to the data warehouse. SQL Fundamentals covers all this and more: * Simple queries that retrieve information from a single table * Creating tables and views to divide a complex process into a series of single steps * Summarizing your data * Inner joins, outer joins, unions, self joins, cross joins, and subqueries * Writing SQL queries that are easily understood, verified, modified, and extended Want better access to business data? Want to make your data more accessible to others? SQL Fundamentals delivers the practical techniques and examples you need - on the database platforms you already use If you want to fully use the information in your database, then read this book CD-ROM INCLUDED The accompanying CD-ROM contains a library of Access databases and the code for building Oracle databases. All the tables use, The book covers: the fundamental concepts and ideas of SQL used for creating ad-hoc reports. It covers the way these concepts are implemented in SQL products. Oracle and Access are the two examples used. Access for small data bases and Oracle for large data bases.
LC Classification Number
QA76.73.S67P38 1999

Artikelbeschreibung des Verkäufers

Info zu diesem Verkäufer

TeamHat

99,8% positive Bewertungen•5.692 Artikel verkauft

Mitglied seit Okt 2003
Antwortet meist innerhalb 24 Stunden
Angemeldet als privater VerkäuferDaher finden verbraucherschützende Vorschriften, die sich aus dem EU-Verbraucherrecht ergeben, keine Anwendung. Der eBay-Käuferschutz gilt dennoch für die meisten Käufe. Mehr erfahrenMehr erfahren
Shop besuchenKontakt

Detaillierte Verkäuferbewertungen

Durchschnitt in den letzten 12 Monaten
Genaue Beschreibung
5.0
Angemessene Versandkosten
4.9
Lieferzeit
5.0
Kommunikation
5.0

Beliebte Kategorien in diesem Shop

Alle ansehenKategorien
Baltimore OriolesBrooklyn CyclonesCalifornia Bear RepublicCalifornia Golden BearsChicago White SoxColorado BuffaloesColorado RockiesDenver BroncosDenver Nuggets

Verkäuferbewertungen (2.204)

Alle Bewertungenselected
Positiv
Neutral
Negativ
  • *****- Bewertung vom Käufer.
    Letzter Monat
    Bestätigter Kauf
    Super fast shipping. I had a question, and the vendor answered me right away. The quality of the product was as promised, in brand-new condition. Great value for the price and with a beautiful appearance. Highly recommended vendor. A++++
  • *****- Bewertung vom Käufer.
    Letzter Monat
    Bestätigter Kauf
    Very quick shipping, and the product was nicely packaged, clean, such a reasonable price and just as described. Thank you for taking care of returning very smoothly (just needed a different item)!
  • *****- Bewertung vom Käufer.
    Letzte 6 Monate
    Bestätigter Kauf
    Item as described, very good quality and very fast shipping! This is my 2nd recent order of this item from this seller. I really appreciate the low prices and especially the free shipping!! THANKS!! AAA++
Alle Bewertungen ansehen
Dies ist ein Angebot mit nicht öffentlicher Bieter-/Käuferliste. Nur der Verkäufer kann Ihren Nutzernamen sehen.

Noch mehr entdecken: