SQL for dummies
"SQL For Dummies, 7th Edition, shows programmers and web developers how to use SQL to build relational databases and get valuable information from them. This book covers the core features of the SQL language. Topics covered include how to use SQL to structure a DBMS and implement a database des...
| Main Author: | |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
Hoboken, N.J.
Wiley
2010
|
| Edition: | 7th ed |
| Series: | For dummies
|
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- Relational database fundamentals
- SQL fundamentals
- Components of SQL
- Building and maintaining a simple database structure
- Building a multitable relational database
- Manipulating database data
- Specifying values
- Using advanced SQL value expressions
- Zeroing in on the data you want
- Using relational operators
- Delving deep with nested queries
- Recursive queries
- Providing database security
- Protecting data
- Using SQL within applications
- Accessing data with ODBC and JDBC
- Operating on XML data with SQL
- Stepping through a dataset with cursors
- Adding procedural capabilities with persistent stored modules
- Handling errors
- Triggers
- Ten common mistakes
- Ten retrieval tips
- Appendix: SQL:2008 reserved words