First edition of this strong-selling book has sold over 14,000 copies since 2010. • Utilizes a language-based approach that allows the user to learn SQL as they would learn English • Updated examples work with the latest versions of Oracle, SQL Server, and MySQL

17.2

23.5

1

300

The Language of SQL

2018 02

The Language of SQL, 2nd Edition Introduction 1. Relational Databases and SQL 2. Basic Data Retrieval 3. Calculated Fields and Aliases 4. Using Functions 5. Sorting Data 6. Selection Criteria 7. Boolean Logic 8. Conditional Logic 9. Summarizing Data 10. Subtotals and Crosstabs 11. Inner Joins 12. Outer Joins 13. Self Joins and Views 14. Subqueries 15. Set Logic 16. Stored Procedures and Parameters 17. Modifying Data 18. Maintaining Tables 19. Principles of Database Design 20. Strategies for Displaying Data A. Getting Started with Microsoft SQL Server B. Getting Started with MySQL C. Getting Started with Oracle

Paperback

Pearson

Academic and Professional

9789332585928

Higher Education and Professional Books

Computing and Information Technology Books

2

933258592X

English

LARRY ROCKOFF has been involved with SQL and business intelligence development for many years. His primary area of interest is using reporting tools to explore and analyze data in complex databases. He holds an MBA from the University of Chicago, with a specialization in Management Science. He currently works with data warehouse and reporting applications for a major retail pharmacy. He also maintains a website that features book reviews on technology topics, focusing on analytics and business intelligence as well as broader societal issues at larryrockoff.com