SQL for Dummies 5th Edition

Format : PDF
Author :  Allen G.Taylor
Publisher : Wiley
ISBN: 07645-4075-0
Size :  3 Mb

Indowebster Server:

Download Now!

Contents at a Glance

Introduction ................................................................1

Part I: Basic Concepts ..................................................5

Chapter 1: Relational Database Fundamentals ..............................................................7

Chapter 2: SQL Fundamentals .......................................................................................21

Chapter 3: The Components of SQL ..............................................................................45

Part II: Using SQL to Build Databases .........................71

Chapter 4: Building and Maintaining a Simple Database Structure ..........................73

Chapter 5: Building a Multitable Relational Database ................................................91

Part III: Retrieving Data ..........................................119

Chapter 6: Manipulating Database Data .....................................................................121

Chapter 7: Specifying Values ........................................................................................139

Chapter 8: Advanced SQL Value Expressions ............................................................161

Chapter 9: Zeroing In on the Data You Want ..............................................................173

Chapter 10: Relational Operators ................................................................................199

Chapter 11: Delving Deep with Nested Queries .........................................................223

Chapter 12: Recursive Queries ....................................................................................241

Chapter 13: Providing Database Security ...................................................................251

Part IV: Controlling Operations .................................265

Chapter 14: Protecting Data .........................................................................................267

Chapter 15: Using SQL Within Applications ...............................................................285

Part V: SQL in the Real World ..................................295

Chapter 16: ODBC and JDBC ........................................................................................297

Chapter 17: SQL:2003 and XML ....................................................................................307

Part VI: Advanced Topics .........................................321

Chapter 18: Cursors ......................................................................................................323

Chapter 19: Persistent Stored Modules ......................................................................333

Chapter 20: Error-Handling ..........................................................................................351

Part VII: The Part of Tens .........................................363

Chapter 21: Ten Common Mistakes ............................................................................365

Chapter 22: Ten Retrieval Tips ....................................................................................369

Part VIII: Appendixes ...............................................373

Appendix A: SQL:2003 Reserved Words .....................................................................375

Appendix B: Glossary ...................................................................................................379

Index .......................................................................387

Posted in: Database,SQL