SQL

Helps in learning and referring to the basics of SQL.

Autorentext
Michael J. Donahoo teaches networking to undergraduate and graduate students at Baylor University, where he is an assistant professor. He received his Ph.D. in computer science from the Georgia Institute of Technology. His research interests are in large-scale information dissemination and management. Gregory D. Speegle is an associate professor at Baylor University where he has taught graduate and undergraduate database courses for 10 years. He received a B.S. degree from Baylor in 1984, and a Ph.D. from the University of Texas in 1990. He has been the graduate director since 1994. Dr. Speegle believes students should be comfortable using databases as part of routine programming. His area of research interest is multimedia databases.

Klappentext
The value of SQL is indisputable, as it is the primary language of most modern database management systems. Many professionals now are also adding SQL to their technical repertoire. This practical guide is a short and focused introduction to the main features of using SQL. The book is useful as both a tutorial and a reference, and includes chapter questions and exercises to ground students and professionals in various topics. It does not focus on a particular vendor's SQL implementation and uses syntax that complies with the 1999 standard. Specific DBMS peculiarities are included on a companion web site, along with the code for the book.

Zusammenfassung
Presents tutorial-based instruction for the main features of SQL for programmers and other technical professionals. This book focuses on teaching concepts by walking through examples and explanations, and self-review exercises. It covers the key features of the language that are required to understand SQL and begin using it effectively.

Inhalt
Chapter 1: Databasics Chapter 2: Single Table Retrieval Chapter 3: Taming Tables Chapter 4: Aggregating Results Chapter 5: Multiple Table Queries using Simple Subqueries Chapter 6: Multiple Table Queries Using Joins Chapter 7: Set Based Queries Chapter 8: Advanced Subqueries Chapter 9: Creating a Database Chapter 10: Database Data Chapter 11: Transaction Management Chapter 12: Authorization Chapter 13: Advanced Topics Chapter 14: SQL Programming