SQL For Dummies, 6th Edition

SQL For Dummies, 6th Edition
PDF

Book Description
See how SQL interfaces with today's environments
Start building and using relational databases with SQL's newest features

The database may be the twenty-first century filing cabinet, but building one is a little more complex than sliding drawers into a metal box. With this book to guide you through all the newest features of SQL, you'll soon be whipping up relational databases, using SQL with XML to power data-driven Web sites, and more!

Discover how to
* Use SQL in a client/server system
* Build a multitable relational database
* Construct nested and recursive queries
* Set up database security
* Use SQL within applications
* Map SQL to XML

Content

Part I: Basic Concepts
Chapter 1: Relational Database Fundamentals
Chapter 2: SQL Fundamentals
Chapter 3: The Components of SQL

Part II: Using SQL to Build Databases
Chapter 4: Building and Maintaining a Simple Database Structure
Chapter 5: Building a Multitable Relational Database

Part III: Storing and Retrieving Data
Chapter 6: Manipulating Database Data
Chapter 7: Specifying Values
Chapter 8: Using Advanced SQL Value Expressions
Chapter 9: Zeroing In on the Data You Want
Chapter 10: Using Relational Operators
Chapter 11: Delving Deep with Nested Queries
Chapter 12: Recursive Queries

Part IV: Controlling Operations
Chapter 13: Providing Database Security
Chapter 14: Protecting Data
Chapter 15: Using SQL within Applications

Part V: Taking SQL to the Real World
Chapter 16: Accessing Data with ODBC and JDBC
Chapter 17: Operating on XML Data with SQL

Part VI: Advanced Topics
Chapter 18: Stepping through a Dataset with Cursors
Chapter 19: Adding Procedural Capabilities with Persistent Stored Modules
Chapter 20: Handling Errors

Part VII: The Part of Tens
Chapter 21: Ten Common Mistakes
Chapter 22: Ten Retrieval Tips

Download SQL For Dummies, 6th Edition PDF or ePUB format free


Free sample

Download in .PDF format



Add comments
Прокомментировать
Введите код с картинки:*
Кликните на изображение чтобы обновить код, если он неразборчив
Copyright © 2019