SQL For Dummies
Search in google:
Demystify database management systems with this fun and friendly guide to SQLThe secret is SQL, and once you get the hang of that, you can build relational databases and get valuable information into and out of them with ease. Here's how to structure a database management system with SQL, implement the design, protect your data, access and work with it, maintain your database, and much more, using the newest version of SQL. Down to data basics — learn what a relational database is and what goes into designing a good oneSQL secrets revealed — get an overview of SQL fundamentals and actually build a database Data in, data out — find out how to add, retrieve, display, delete, or change data in your databaseWhat's your query? — discover how to find what you need using different queriesGuarding your stuff — protect your data from theft, accidental or malicious corruption, and loss due to equipment failureGetting SQL to play nice — use Open DataBase Connectivity (ODBC) to solve the problems of combining SQL with other languages XML is your friend — communicate with other applications using XML with SQLEliminating errors — understand what SQL is trying to tell you when something goes wrongOpen the book and find:Essential database design considerationsHow a database management system differs from a database What SQL is and isn'tDifferent types of dataTen common database blunders How to use values, value expressions, and relational operatorsTips on using XML data with SQLCommon threats to your dataLearn to:Create relational databases with powerful data retrieval capacityUse SQL with XML and Access® 2010Structure a database management system and implement database designWork with all the core SQL features
Ch. 1Relational database fundamentals7Ch. 2SQL fundamentals21Ch. 3The components of SQL47Ch. 4Building and maintaining a simple database structure75Ch. 5Building a multitable relational database91Ch. 6Manipulating database data123Ch. 7Specifying values141Ch. 8Using advanced SQL value expressions163Ch. 9Zeroing in on the data you want175Ch. 10Using relational operators201Ch. 11Delving deep with nested queries225Ch. 12Recursive queries243Ch. 13Providing database security255Ch. 14Protecting data269Ch. 15Using SQL within applications287Ch. 16Accessing data with ODBC and JDBC303Ch. 17Operating on XML data with SQL313Ch. 18Stepping through a dataset with cursors335Ch. 19Adding procedural capabilities with persistent stored modules345Ch. 20Handling errors361Ch. 21Ten common mistakes375Ch. 22Ten retrieval tips379
![SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]](/application/data/covers/44/31/9780321444431.jpg "SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]")
