- 272 pages
- English
- PDF
- Available on iOS & Android
About this book
SQL is a solid guide and reference to the key elements of SQL and how to use it effectively. Developed by authors who needed a good resource for students in their database class, this is an ideal supplement for database courses — no matter what main text you use or what flavor of SQL is required.It features a short and inexpensive introduction to SQL for students who have some programming experience and need to learn the main features of SQL; and suggested shortcuts for learning and practice, depending on the experience of the user.This book is recommended for novice developers, programmers, and database administrators as well as students in database courses, business courses, and IT-related courses.- Provides tutorial-based instruction for the main features of SQL for programmers and other technical professionals in need of a brief but really good introduction to SQL.- The approach is vendor-neutral—so very adaptable and flexible- The focus is on teaching concepts by walking through concrete examples and explanations, and self-review exercises are included at the end of each chapter.- Coverage is on the key features of the language that are required to understand SQL and begin using it effectively.- SQL 2003-compliant.
Frequently asked questions
- Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
- Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Information
Table of contents
- Cover
- SQL: Practical Guide for Developers
- Copyright
- Table of Contents
- Preface
- Chapter 1. Databasics
- Chapter 2. Retrieval: Basic SELECTion
- Chapter 3. Reshaping Results
- Chapter 4. Aggregating Results
- Chapter 5. Joins
- Chapter 6. Set Queries: UNION, INTERSECT, and EXCEPT
- Chapter 7. Subqueries
- Chapter 8. Modifying Data
- Chapter 9. Creating, Deleting, and Altering Tables
- Chapter 10. Views
- Chapter 11. Transactions
- Chapter 12. Database Privileges
- Chapter 13. Introduction to Cursors, Embedded SQL, Stored Procedures, and Triggers
- Index