Bild 1 von 6
Galerie
Bild 1 von 6
Ähnlichen Artikel verkaufen?
Lernen SQL auf SQL Server 2005, O'Reilly Media (C)2006
US $5,00
Ca.CHF 4,03
oder Preisvorschlag
Artikelzustand:
“As seen in the photos, this book has a crease down the front cover. Otherwise, it is in great shape.”
Gut
Buch, das gelesen wurde, sich aber in einem guten Zustand befindet. Der Einband weist nur sehr geringfügige Beschädigungen auf, wie z.B. kleinere Schrammen, er hat aber weder Löcher, noch ist er eingerissen. Bei gebundenen Büchern ist der Schutzumschlag möglicherweise nicht mehr vorhanden. Die Bindung weist geringfügige Gebrauchsspuren auf. Die Mehrzahl der Seiten ist unbeschädigt, das heißt, es gibt kaum Knitter oder Einrisse, es wurden nur in geringem Maße Bleistiftunterstreichungen im Text vorgenommen, es gibt keine Textmarkierungen und die Randbereiche sind nicht beschrieben. Alle Seiten sind vollständig vorhanden. Genauere Einzelheiten sowie eine Beschreibung eventueller Mängel entnehmen Sie bitte dem Angebot des Verkäufers.
- Sofort-KaufenLernen SQL auf SQL Server 2005, O'Reilly Media (C)2006
Oops! Looks like we're having trouble connecting to our server.
Refresh your browser window to try again.
Versand:
US $5,00 (ca. CHF 4,03) Economy Shipping.
Standort: Murrayville, Georgia, USA
Lieferung:
Lieferung zwischen Mo, 4. Aug und Sa, 9. Aug nach 94104 bei heutigem Zahlungseingang
Rücknahme:
30 Tage Rückgabe. Käufer zahlt Rückversand. Wenn Sie ein eBay-Versandetikett verwenden, werden die Kosten dafür von Ihrer Rückerstattung abgezogen.
Zahlungen:
Sicher einkaufen
Der Verkäufer ist für dieses Angebot verantwortlich.
eBay-Artikelnr.:187322724063
Artikelmerkmale
- Artikelzustand
- Gut
- Hinweise des Verkäufers
- “As seen in the photos, this book has a crease down the front cover. Otherwise, it is in great shape.”
- Personalized
- No
- ISBN
- 9780596102159
Über dieses Produkt
Product Identifiers
Publisher
O'reilly Media, Incorporated
ISBN-10
0596102151
ISBN-13
9780596102159
eBay Product ID (ePID)
51577915
Product Key Features
Number of Pages
352 Pages
Language
English
Publication Name
Learning Sql on Sql Server 2005
Subject
Programming Languages / Sql, Data Processing, Databases / Data Mining
Publication Year
2006
Type
Textbook
Subject Area
Computers
Format
Perfect
Dimensions
Item Height
0.8 in
Item Weight
20 Oz
Item Length
9.2 in
Item Width
7 in
Additional Product Features
Intended Audience
Scholarly & Professional
LCCN
2006-284877
Dewey Edition
22
Illustrated
Yes
Dewey Decimal
005.75/85
Table Of Content
Dedication;Preface; Why This Book?; SQL and SQL Server; Audience and Coverage; A Few Notes About SQL Server 2005 Installation; Conventions Used in This Book; Using Code Examples; How to Contact Us; Acknowledgments;Chapter 1: Starting Microsoft SQL Server 2005; 1.1 Starting Microsoft SQL Server 2005 and SQL Server 2005's Management Studio; 1.2 Creating a Database in Microsoft SQL Server 2005; 1.3 The Query Editor; 1.4 Creating Tables Using the Load Script; 1.5 Viewing Table Definitions; 1.6 Modifying Table Definitions; 1.7 Viewing Table Data; 1.8 Deleting a Table; 1.9 Deleting a Database; 1.10 Entering a SQL Query or Statement; 1.11 Parsing a Query; 1.12 Executing a Query; 1.13 Saving a Query; 1.14 Displaying the Results; 1.15 Stopping Execution of a Long Query; 1.16 Printing the Query and Results; 1.17 Customizing SQL Server 2005; 1.18 Summary; 1.19 Review Questions; 1.20 Exercises;Chapter 2: Beginning SQL Commands in SQL Server; 2.1 Displaying Data with the SELECT Statement; 2.2 Displaying or SELECTing Rows or Tuples from a Table; 2.3 The COUNT Function; 2.4 The ROWCOUNT Function; 2.5 Using Aliases; 2.6 Synonyms; 2.7 Adding Comments to SQL Statements; 2.8 Some Conventions for Writing SQL Statements; 2.9 A Few Notes About SQL Server 2005 Syntax; 2.10 Summary; 2.11 Review Questions; 2.12 Exercises;Chapter 3: Creating, Populating, Altering, and Deleting Tables; 3.1 Data Types in SQL Server 2005; 3.2 Creating a Table; 3.3 Inserting Values into a Table; 3.4 The UPDATE Command; 3.5 The ALTER TABLE Command; 3.6 The DELETE Command; 3.7 Deleting a Table; 3.8 Summary; 3.9 Review Questions; 3.10 Exercises; 3.11 References;Chapter 4: Joins; 4.1 The JOIN; 4.2 The Cartesian Product; 4.3 Equi-Joins and Non-Equi-Joins; 4.4 Self Joins; 4.5 Using ORDER BY with a Join; 4.6 Joining More Than Two Tables; 4.7 The OUTER JOIN; 4.8 Summary; 4.9 Review Questions; 4.10 Exercises;Chapter 5: Functions; 5.1 Aggregate Functions; 5.2 Row-Level Functions; 5.3 Other Functions; 5.4 String Functions; 5.5 CONVERSION Functions; 5.6 DATE Functions; 5.7 Summary; 5.8 Review Questions; 5.9 Exercises;Chapter 6: Query Development and Derived Structures; 6.1 Query Development; 6.2 Parentheses in SQL Expressions; 6.3 Derived Structures; 6.4 Query Development with Derived Structures; 6.5 Summary; 6.6 Review Questions; 6.7 Exercises;Chapter 7: Set Operations; 7.1 Introducing Set Operations; 7.2 The UNION Operation; 7.3 The UNION ALL Operation; 7.4 Handling UNION and UNION ALL Situations with an Unequal Number of Columns; 7.5 The IN and NOT..IN Predicates; 7.6 The Difference Operation; 7.7 The Union and the Join; 7.8 A UNION Used to Implement a Full Outer Join; 7.9 Summary; 7.10 Review Questions; 7.11 Exercises; 7.12 Optional Exercise;Chapter 8: Joins Versus Subqueries; 8.1 Subquery with an IN Predicate; 8.2 The Subquery as a Join; 8.3 When the Join Cannot Be Turned into a Subquery; 8.4 More Examples Involving Joins and IN; 8.5 Using Subqueries with Operators; 8.6 Summary; 8.7 Review Questions; 8.8 Exercises;Chapter 9: Aggregation and GROUP BY; 9.1 A SELECT in Modified BNF; 9.2 The GROUP BY Clause; 9.3 The HAVING Clause; 9.4 GROUP BY and HAVING: Aggregates of Aggregates; 9.5 Auditing in Subqueries; 9.6 Nulls Revisited; 9.7 Summary; 9.8 Review Questions; 9.9 Exercises;Chapter 10: Correlated Subqueries; 10.1 Noncorrelated Subqueries; 10.2 Correlated Subqueries; 10.3 Existence Queries and Correlation; 10.4 SQL Universal and Existential Qualifiers; 10.5 Summary; 10.6 Review Questions; 10.7 Exercises;Chapter 11: Indexes and Constraints on Tables; 11.1 The "Simple" CREATE TABLE; 11.2 Indexes; 11.3 Constraints; 11.4 Summary; 11.5 Review Questions; 11.6 Exercises;The Student Database and Other Tables Used in This Book; ;Script Used to Create the Student_course Database;Glossary of Terms;Important Commands and Functions;Colophon;
Synopsis
Earp and Bagui offer a complete introduction to SQL (Structure Query Language), the standard programming language for generating, manipulating, and retrieving information from a relational database, for those who need to learn Microsoft's SQL Server 2005., Anyone who interacts with today's modern databases needs to know SQL (Structured Query Language), the standard language for generating, manipulating, and retrieving database information. In recent years, the dramatic rise in the popularity of relational databases and multi-user databases has fueled a healthy demand for application developers and others who can write SQL code efficiently and correctly. If you're new to databases, or need a SQL refresher, "Learning SQL on SQL Server 2005" is an ideal step-by-step introduction to this database query tool, with everything you need for programming SQL using Microsoft's SQL Server 2005-one of the most powerful and popular database engines used today. Plenty of books explain database theory. This guide lets you apply the theory as you learn SQL. You don't need prior database knowledge, or even prior computer knowledge. Based on a popular university-level course designed by authors Sikha Saha Bagui and Richard Walsh Earp, "Learning SQL on SQL Server 2005" starts with very simple SQL concepts, and slowly builds into more complex query development. Every topic, concept, and idea comes with examples of code and output, along with exercises to help you gain proficiency in SQL and SQL Server 2005. With this book, you'll learn: Beginning SQL commands, such as how and where to type an SQL query, and how to create, populate, alter and delete tables How to customize SQL Server 2005's settings and about SQL Server 2005's functions About joins, a common database mechanism for combining tables Query development, the use of views and other derived structures, and simple set operations Subqueries, aggregate functions and correlatedsubqueries, as well as indexes and constraints that can be added to tables in SQL Server 2005 Whether you're an undergraduate computer science or MIS student, a self-learner who has access to the new Microsoft database, or work for your company's IT department, "Learning SQL on SQL Server 2005" will get you up to speed on SQL in no time., Anyone who interacts with today's modern databases needs to know SQL (Structured Query Language), the standard language for generating, manipulating, and retrieving database information. In recent years, the dramatic rise in the popularity of relational databases and multi-user databases has fueled a healthy demand for application developers and others who can write SQL code efficiently and correctly. If you're new to databases, or need a SQL refresher, Learning SQL on SQL Server 2005 is an ideal step-by-step introduction to this database query tool, with everything you need for programming SQL using Microsoft's SQL Server 2005-one of the most powerful and popular database engines used today. Plenty of books explain database theory. This guide lets you apply the theory as you learn SQL. You don't need prior database knowledge, or even prior computer knowledge. Based on a popular university-level course designed by authors Sikha Saha Bagui and Richard Walsh Earp, Learning SQL on SQL Server 2005 starts with very simple SQL concepts, and slowly builds into more complex query development. Every topic, concept, and idea comes with examples of code and output, along with exercises to help you gain proficiency in SQL and SQL Server 2005. With this book, you'll learn: Beginning SQL commands, such as how and where to type an SQL query, and how to create, populate, alter and delete tables How to customize SQL Server 2005's settings and about SQL Server 2005's functions About joins, a common database mechanism for combining tables Query development, the use of views and other derived structures, and simple set operations Subqueries, aggregate functions and correlated subqueries, as well as indexes and constraints that can be added to tables in SQL Server 2005 Whether you're an undergraduate computer science or MIS student, a self-learner who has access to the new Microsoft database, or work for your company's IT department, Learning SQL on SQL Server 2005 will get you up to speed on SQL in no time., Anyone who interacts with today's modern databases needs to know SQL (Structured Query Language), the standard language for generating, manipulating, and retrieving database information. In recent years, the dramatic rise in the popularity of relational databases and multi-user databases has fueled a healthy demand for application developers and others who can write SQL code efficiently and correctly. If you're new to databases, or need a SQL refresher, "Learning SQL on SQL Server 2005" is an ideal step-by-step introduction to this database query tool, with everything you need for programming SQL using Microsoft's SQL Server 2005-one of the most powerful and popular database engines used today. Plenty of books explain database theory. This guide lets you apply the theory as you learn SQL. You don't need prior database knowledge, or even prior computer knowledge. Based on a popular university-level course designed by authors Sikha Saha Bagui and Richard Walsh Earp, "Learning SQL on SQL Server 2005" starts with very simple SQL concepts, and slowly builds into more complex query development. Every topic, concept, and idea comes with examples of code and output, along with exercises to help you gain proficiency in SQL and SQL Server 2005. With this book, you'll learn: Beginning SQL commands, such as how and where to type an SQL query, and how to create, populate, alter and delete tablesHow to customize SQL Server 2005's settings and about SQL Server 2005's functionsAbout joins, a common database mechanism for combining tablesQuery development, the use of views and other derived structures, and simple set operationsSubqueries, aggregate functions and correlated subqueries, as well as indexes and constraints that can be added to tables in SQL Server 2005 Whether you're an undergraduate computer science or MIS student, a self-learner who has access to the new Microsoft database, or work for your company's IT department, "Learning SQL on SQL Server 2005" will get you up to speed on SQL in no time.
LC Classification Number
QA76.73.S67B34 2006
Artikelbeschreibung des Verkäufers
Info zu diesem Verkäufer
tina_t69
100% positive Bewertungen•815 Artikel verkauft
Angemeldet als gewerblicher Verkäufer
Verkäuferbewertungen (517)
- a***k (3609)- Bewertung vom Käufer.Letzte 6 MonateBestätigter KaufgreatCupid's Wingman Toddler Short Sleeve Tee, Valentine's Day T-Shirt for Toddlers (Nr. 186287869860)
- a***k (3609)- Bewertung vom Käufer.Letzte 6 MonateBestätigter KaufgreatCooler Than Cupid Toddler Short Sleeve Tee, Valentine's Day T-Shirt (Nr. 186259246872)
- a***r (71)- Bewertung vom Käufer.Letztes JahrBestätigter KaufGreat transaction!Made to Worship Travel Mug with Handle, Christian Theme Travel Mug (Nr. 176132891890)
Noch mehr entdecken:
- C. - H. - Beck Fachbücher, Lernen und Nachschlagen,
- Lern- & Fachbücher auf Spanisch,
- Fachbücher, Lernen und Nachschlagen,
- C. - H. - Beck Deutsche Fachbücher, Lernen und Nachschlagen,
- Fachbücher, Lernen und Nachschlagen C. - H. - Beck auf Englisch,
- Klett Fachbücher, Lernen und Nachschlagen,
- Fachbücher, Lernen und Nachschlagen auf Finnisch,
- Fachbücher, Lernen und Nachschlagen Serbische,
- Wissenmedia Fachbücher, Lernen und Nachschlagen,
- Spanische Langenscheidt Fachbücher, Lernen und Nachschlagen
Verkäuferbewertungen (517)
- a***k (3609)- Bewertung vom Käufer.Letzte 6 MonateBestätigter KaufgreatCupid's Wingman Toddler Short Sleeve Tee, Valentine's Day T-Shirt for Toddlers (Nr. 186287869860)
- a***k (3609)- Bewertung vom Käufer.Letzte 6 MonateBestätigter KaufgreatCooler Than Cupid Toddler Short Sleeve Tee, Valentine's Day T-Shirt (Nr. 186259246872)
- a***r (71)- Bewertung vom Käufer.Letztes JahrBestätigter KaufGreat transaction!Made to Worship Travel Mug with Handle, Christian Theme Travel Mug (Nr. 176132891890)