Description |
1 online resource (xvii, 501 pages) : illustrations |
Series |
Wrox beginning guides |
|
Wrox beginning guides.
|
Contents |
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 |
Summary |
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 |
|
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 |
Notes |
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. http://purl.oclc.org/DLF/benchrepro0212 MiAaHDL |
|
English |
|
Print version record |
|
digitized 2010 HathiTrust Digital Library committed to preserve pda MiAaHDL |
Subject |
SQL (Computer program language)
|
|
Programming languages (Electronic computers)
|
|
Programming Languages
|
|
COMPUTERS -- Programming Languages -- SQL.
|
|
Programming languages (Electronic computers)
|
|
SQL (Computer program language)
|
|
SQL
|
|
SQL.
|
Form |
Electronic book
|
Author |
Colby, John W., 1954-
|
ISBN |
0764596322 |
|
9780764596322 |
|
9780764577321 |
|
0764577328 |
|
1280253460 |
|
9781280253461 |
|
9786610253463 |
|
6610253463 |
|