A quick, clearly written introduction to the use of SQL to store and retrieve information
Read More
Specifications
Book Details
Publication Year
2018 02
Table of Contents
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
Contributors
Author Info
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
Dimensions
Width
17.2
Height
23.5
Depth
1
Weight
300
Ratings & Reviews
4.7
★
3 Ratings &
0 Reviews
5★
4★
3★
2★
1★
2
1
0
0
0
Have you used this product? Be the first to review!
Be the first to ask about this product
Safe and Secure Payments.Easy returns.100% Authentic products.