Beginning SQL

Taking readers through the basics of the language, right up to some more advanced topics, this book is a practical, hands-on resource and aims to keep the reader involved at all timesFocuses on the SQL standard and is loaded with detailed examples and code; each chapter includes practice exercises t...

Full description

Bibliographic Details
Main Author: Wilton, Paul
Other Authors: Colby, John W.
Format: eBook
Language:English
Published: Indianapolis, IN Wiley Pub. 2005
Series:Wrox beginning guides
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
LEADER 03406nmm a2200493 u 4500
001 EB001910963
003 EBX01000000000000001073865
005 00000000000000.0
007 cr|||||||||||||||||||||
008 210123 ||| eng
020 |a 0764596322 
020 |a 9780764577321 
020 |a 9781280253461 
020 |a 9780764596322 
020 |a 1280253460 
020 |a 9786610253463 
020 |a 0764577328 
050 4 |a QA76.73.S67 
100 1 |a Wilton, Paul 
245 0 0 |a Beginning SQL  |c Paul Wilton and John W. Colby 
260 |a Indianapolis, IN  |b Wiley Pub.  |c 2005 
300 |a xvii, 501 pages  |b illustrations 
505 0 |a Introduction -- Introduction to SQL -- Entering information -- Extracting information -- Advanced database design -- Manipulating data -- Grouping and aggregating data -- Selecting data from different tables -- Queries within queries -- Advanced queries -- Views -- Transactions -- SQL security -- Database tuning -- Appendix A: Exercise answers -- Appendix B: Setting up and using the five database systems -- Appendix B: Initial data setup 
653 |a Programming languages (Electronic computers) / fast 
653 |a Programming Languages 
653 |a Programming languages (Electronic computers) / http://id.loc.gov/authorities/subjects/sh85107313 
653 |a SQL (Langage de programmation) 
653 |a SQL. / swd 
653 |a SQL / gnd / http://d-nb.info/gnd/4134010-3 
653 |a COMPUTERS / Programming Languages / SQL. / bisacsh 
653 |a SQL (Computer program language) / fast 
653 |a Langages de programmation 
653 |a SQL (Computer program language) / http://id.loc.gov/authorities/subjects/sh86006628 
700 1 |a Colby, John W. 
041 0 7 |a eng  |2 ISO 639-2 
989 |b OREILLY  |a O'Reilly 
490 0 |a Wrox beginning guides 
500 |a Master and use copy. Digital master created according to Benchmark for Faithful Digital Reproductions of Monographs and Serials, Version 1. Digital Library Federation, December 2002 
776 |z 9780764596322 
776 |z 0764596322 
856 4 0 |u https://learning.oreilly.com/library/view/~/9780764577321/?ar  |x Verlag  |3 Volltext 
082 0 |a 005.75/65 
520 |a Taking readers through the basics of the language, right up to some more advanced topics, this book is a practical, hands-on resource and aims to keep the reader involved at all timesFocuses on the SQL standard and is loaded with detailed examples and code; each chapter includes practice exercises that readers can challenge themselves with before looking at the sample solutions in the appendixPaul Wilton is a successful Wrox ""Beginning"" book author and is an ideal author to write for those who want a firm grasp of standard SQL before learning the details specific to a particu 
520 |a Exercises; Chapter 3: Extracting Information; The SELECT Statement; Logical Operators and Operator Precedence; Ordering Results with ORDER BY; Selecting Data from More Than One Table; Introducing NULL Data; Summary; Exercises; Chapter 4: Advanced Database Design; Normalization; Ensuring Data Validity with Constraints; Speeding Up Results with Indexes; Summary; Exercises; Chapter 5: Manipulating Data; Understanding SQL Arithmetic; Introducing String Functions; Converting Different Data Types; Re-examining NULL; Using INSERT INTO with the SELECT Statement; Summary; Exercises