Beginning SQL Programming (Programmer to programmer) - Softcover

Kauffman, John; Matsik, Brian; Spencer, Kevin; Herbert, Ian; Youness, Sakhr; Skinner, Julian

Softcover

ISBN 10: 1861001800 ISBN 13: 9781861001801

Publisher: WROX Press Ltd, 2001

Synopsis

Structured Query Language is the industry standard for querying data held in relational databases. SQL can be used to create and alter the structure of databases, add new data, and access or modify existing data. Beginning SQL Programming begins by looking at what SQL is, then moves on to teach you the fundamentals of ANSI SQL, using the familiar Northwind database that comes with versions of Microsoft Access and SQL Server.

The book gives step-by-step instructions, alerts readers to common pitfalls, tricks and traps, and uses real-world examples, including two extensive case studies, to create a thorough tutorial. It will furnish readers with a firm grasp of SQL concepts that you can work with straight away, as well as provide solid foundations and challenging ideas with which you can later develop more advanced SQL techniques.

Included with this book is a 120-day evaluation enterprise edition of Microsoft's SQL Server 2000. An end user license agreement is contained in this licensed software.

About this title

Review

Structured Query Language (SQL), a standard language for working with databases, is so flexible and so concise, it's hard not to consider it perfectly evolved. It's even harder to justify not taking the time to learn SQL, considering that scores of technologies and hundreds of manufacturers support it and are likely to do so for some time. An investment in learning SQL is almost certain to pay off. Beginning SQL Programming drills critical SQL concepts and techniques (like simple data extractions and insertions) into its readers' brains, and backs up that got-to-memorise knowledge with easily accessible information on less commonly used techniques (like stored procedures and complicated joins).

The authors' emphasis falls on ANSI-standard SQL (mostly SQL-92) rather than on any particular publisher's implementation (and extension) of it, though they do use Microsoft SQL Server 2000 in their examples (and include a time-limited copy of it on the companion CD-ROM). Like most books in this series, this volume exposes its subject with a combination of lecture-like prose (for example: a discussion of NULLs, their meaning, and the design considerations associated with them) and type-this-get-that examples. It's a helpful approach which lends itself to careful study as well as pressurised hunts for quick answers. Readers may wish for information on specific database servers, or for information on integrating SQL queries into applications that don't involve Active Server Pages (ASP), but this book maintains its focus on SQL with overtones of Microsoft. --David Wall

Topics covered: Structured Query Language (SQL) for programmers, Web site developers and others who need a solid familiarity with the language as part of their duties, as well as aspiring database administrators who want a place to start their in-depth study of SQL and database design. Sections deal with all standard SQL statements, as well as database design in terms of data types, value constraints and joins. Calculations, stored functions, aggregate functions and schemas all are touched upon.

Edition details

• Publisher: WROX Press Ltd
• Publication date: 2001
• Language: English
• ISBN 10: 1861001800
• ISBN 13: 9781861001801
• Binding: Paperback
• Edition number: 1
• Number of pages: 738