Become a Seller

Cart

Home

Books

Higher Education and Professional Books

Applied Sciences and Other Technologies Books

Pearson Applied Sciences and Other Technologies Books

Effective SQL , 1e (English, Paperback, John L. Viescas, Douglas J. Steele, Ben G. Clothier)

Be the first to Review this product

₹500

₹550

9% off

Coupons for you

Special PriceGet extra 10% off on 1 item(s) (price inclusive of cashback/coupon)

T&C

Available offers

Bank Offer5% cashback on Flipkart Axis Bank Credit Card upto ₹4,000 per statement quarter

T&C

Bank Offer5% cashback on Axis Bank Flipkart Debit Card up to ₹750

T&C

Bank Offer10% offup to ₹1,500 on BOBCARD EMI Transactions of 6months and above tenures, Min Txn Value: ₹7,500

T&C

Bank Offer10% off upto ₹1500 on RBL Bank EMI Transactions of 6 months and above tenure. Min Txn Value: ₹10000

T&C

Delivery

Check

Enter pincode

Delivery by21 Aug, Thursday

View Details

Author

John L. Viescas, Douglas J. Steele, Ben G. Clothier

Highlights

Language: English
Binding: Paperback
Publisher: Pearson
Genre: Academic and Professional
ISBN: 9789352865086, 9352865081
Edition: 1, 2017
Pages: 352

Services

Cash on Delivery available
?

Seller

Vipsameerk

(Not Enough Ratings)

7 Days Replacement Policy
?

See other sellers

Description

Effective SQL brings together the hands-on solutions and practical insights students need to solve a wide range of complex problems with SQL, and to design databases that make it far easier to manage data in the future. Leveraging the proven format of the best-selling Effective series, it focuses on providing clear, practical explanations, expert tips, and plenty of realistic examples.

Specifications

Book Details

Publication Year

2017 11

Table of Contents

Foreword xiii Acknowledgments xv About the Authors xvii About the Technical Editors xix Introduction Chapter 1: Data Model Design Chapter 2: Programmability and Index Design Chapter 3: When You Can’t Change the Design Chapter 4: Filtering and Finding Data Chapter 5: Aggregation Chapter 6: Subqueries Chapter 7: Getting and Analyzing Metadata Chapter 8: Cartesian Products Chapter 9: Tally Tables Chapter 10: Modeling Hierarchical Data Appendix: Date and Time Types, Operations, and Functions

Contributors

Author Info

John L. Viescas is an independent database consultant with more than 45 years of experience. He began his career as a systems analyst, designing large database applications for IBM mainframe systems. He spent six years at Applied Data Research in Dallas, Texas, where he directed a staff of more than 30 people and was responsible for research, product development, and customer support of database products for IBM mainframe computers. While working at Applied Data Research, John completed a degree in business finance at the University of Texas at Dallas, graduating cum laude. Douglas J. Steele has been working with computers, both mainframe and PC, for almost 45 years. (Yes, he did use punch cards in the beginning!) He worked for a large international oil company for more than 31 years before retiring in 2012. Databases and data modeling were a focus for most of that time, although he finished his career by developing the SCCM task sequence to roll Windows 7 out to over 100,000 computers worldwide.

Frequently Bought Together

Effective SQL , 1e

₹450

₹550

18% off

SAP Abap - Hands - on Test Projects with Business Scenarios

4.3

(33)

₹764

Please add at least 1 add-on item to proceed

Be the first to ask about this product

Safe and Secure Payments.Easy returns.100% Authentic products.