SQL Clearly Explained
β Jan L. Harrington
π Library
π
2003
π Morgan Kaufmann
π English
β¦ LIBER β¦
π
SQL Clearly Explained
β Scribed by Harrington, Jan L
- Publisher
- Elsevier Science;Morgan Kaufmann
- Year
- 2010
- Tongue
- English
- Edition
- 3rd ed
- Category
- Library
β¬ Acquire This Volume
No coin nor oath required. For personal study only.
β¦ Synopsis
SQL Explained, Third Edition, provides an in-depth introduction to using SQL (Structured Query Language). Readers will learn not only SQL syntax, but also how SQL works. Understanding the how as well as the what will aid in creating SQL statements that execute as quickly as possible.
The book is organized into five parts. Part I presents the theoretical material underlying relational databases and SQL. Part II covers interactive SQL retrieval. Part III discusses the creation and management of database structure. It also covers non-data elements in the database environment, such as managing users/user accounts and transaction control. Part IV introduces several techniques for SQL programming: embedded SQL (using a high-level host language), dynamic SQL, and triggers/stored procedures. Part V discusses the non-relational extensions that have been added to the SQL standard: XML and object-relational capabilities. It covers object-oriented concepts, including the differences...
β¦ Table of Contents
- The relational data model 2. Manipulating relations with relational algebra 3. Introduction to SQL 4. Simple SQL retrieval 5. Retrieving data from more than one table 6. Advanced retrieval operations 7. Calculations and grouping queries 8. Data Modifications 9. Schemas and tables 10. Views, temporary tables, CTEs and indexes 11. Keeping the design up to date 12. Users and access rights 13. Users, sessions, and transaction manipulation 14. Triggers and stored procedures 15. Embedded SQL 16. Dynamic SQL 17. XML support 18. The object-relational data model 19. Object-relational support
β¦ Subjects
Llibres electrΓ²nics;SQL (Llenguatge de programacioΜ)
π SIMILAR VOLUMES
SQL Clearly Explained, Second Edition
β Jan L. Harrington
π Library
π
2003
π Morgan Kaufmann
π English
This is the second edition of the popular practitioner's guide to SQL, the industry-standard database query language. Like most computer languages, SQL can be overwhelming when you first see it, but for years readers have relied on this book to clear the confusion and explain how SQL works and how t
SQL Clearly Explained (Third Edition)
β Jan L. Harrington
π Library
π
2010
π Morgan Kaufmann
π English
A lucid guide to SQL which provides the tools to put practical instruction to work immediately!SQL Clearly Explained is one of those rare books that delivers 100 percent what its title promises. If you need to use SQL on the job, and who doesnt, then this book should be on your desk.This book functi
SQL Performance Explained
β Markus Winand
π Library
π
2012
π Markus Winand (2012)
π English
SQL Performance Explained helps developers to improve database performance. The focus is on SQL-it covers all major SQL databases without getting lost in the details of any one specific product. Starting with the basics of indexing and the WHERE clause, SQL Performance Explained guides developers th
SQL Clearly Explained, Second Edition (T
β Jan L. Harrington
π Library
π
2003
π Morgan Kaufmann
π English
This book explains SQL very clearly indeed, as the title implies. I knew a bit of SQL before I started reading this book, so the first 50-odd pages didn't teach me much, but they still made me understand a few things here and there more thoroughly. I got my copy yesterday, and I'm at around page 10
SQL Clearly Explained, Third Edition (Th
β Jan L. Harrington
π Library
π
2010
π Morgan Kaufmann
π English
This is a pretty good book for a beginner, someone who's seeing SQL (or any other database-related language) for the first time. It's good, but a bit to simplistic for anyone who's actively worked with databases. Good starting point, though.