SQL For Dummies - Uncover the secrets of SQL and start building better relational databases today (8th Edition)

SQL For Dummies - Uncover the secrets of SQL and start building better relational databases today (8th Edition)



Details:


SQL For Dummies, 8th Edition
For Dummies; 8th Edition (September 2013) | ISBN: 1118607961 | PDF + EPUB | 480 pages | 13.6 MB

Uncover the secrets of SQL and start building better relational databases today!

This fun and friendly guide will help you demystify database management systems so you can create more powerful databases and access information with ease. Updated for the latest SQL functionality, SQL For Dummies, 8th Edition covers the core SQL language and shows you how to use SQL to structure a DBMS, implement a database design, secure your data, and retrieve information when you need it.


Includes new enhancements of SQL:2011, including temporal data functionality which allows you to set valid times for transactions to occur and helps prevent database corruption
Covers creating, accessing, manipulating, maintaining, and storing information in relational database management systems like Access, Oracle, SQL Server, and MySQL
Provides tips for keeping your data safe from theft, accidental or malicious corruption, or loss due to equipment failures and advice on eliminating errors in your work

Table of Contents

Part I: Getting Started with SQL
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. Handling Temporal Data
Chapter 8. Specifying Values
Chapter 9. Using Advanced SQL Value Expressions
Chapter 10. Zeroing In on the Data You Want
Chapter 11. Using Relational Operators
Chapter 12. Delving Deep with Nested Queries
Chapter 13. Recursive Queries

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

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

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

Part VII: The Part of Tens
Chapter 23. Ten Common Mistakes
Chapter 24. Ten Retrieval Tips



PS : If You got an error while extracting while others are working try diferent directory path in your PC. Somtimes if you got a long directory path while extracting it will giv you an error. To solve this issue , as an example just paste the tgz file in C drive and extract (just inside the C drive not with in any other folder). Hope your Understand

Update Torrent Stats to see Current Seeders and Leechers

Visit my account to download more apps and ebooks + magazines

If This Torrent Helpful Please Support the Authors by Purchasing It!.. Thanx