SQL a beginner's guide
This easy-to-follow guide enables readers to begin working with SQL - the core language for working with relational databases. Concepts are carefully explained and illustrative examples are provided to help clarify them. Exercises are also included to provide readers with practical experience
| Main Author: | |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
New York
McGraw-Hill Education
2016
|
| Edition: | Fourth edition, Andrew J. Oppel |
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
| Summary: | This easy-to-follow guide enables readers to begin working with SQL - the core language for working with relational databases. Concepts are carefully explained and illustrative examples are provided to help clarify them. Exercises are also included to provide readers with practical experience |
|---|---|
| Item Description: | Previous edition: 2009. - Includes index. - <B>Part I: SQL Databases</b><br>Chapter 1. Introduction to Relational Databases and SQL<br>Chapter 2. Working with the SQL Environment<br>Chapter 3. Creating and Altering Tables<br>Chapter 4. Enforcing Data Integrity<br>Chapter 5. Creating SQL Views<br>Chapter 6. Managing Database Security<br><b>Part II: Data Access and Modification</b><br>Chapter 7. Querying Data<br>Chapter 8. Modifying Data<br>Chapter 9. Using Predicates<br>Chapter 10. Working with Functions and Value Expressions<br>Chapter 11. Accessing Multiple Tables<br>Chapter 12. Using Subqueries to Access and Modify Data<br>Chapter 13. Working with Temporal Data<br><b>Part III: Creating SQL Invoked Routings</b><br>Chapter 14. Creating SQL Invoked Routines<br>Chapter 15. Creating SQL Triggers<br>Chapter 16. Using SQL Servers<br>Chapter 17. Managing SQL Transactions<br>Chapter 18. Accessing SQL Data from Your Host Program<br>Chapter 19. Working with XML Data<br><b>Part IV: Appendices</b><br>Appendix A. Answers to Self Tests<br>Appendix B. Keywords<br> |
| Physical Description: | xxvi, 533 pages illustrations (black and white) |
| ISBN: | 9780071842570 0071842578 9780071842594 |