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.
Read More
Specifications
Book Details
Title
Effective SQL , 1e
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
Product Form
Paperback
Publisher
Pearson
Genre
Academic and Professional
ISBN13
9789352865086
Book Category
Fiction Books
Book Subcategory
Science Fiction Books
Edition
1
ISBN10
9352865081
Language
English
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.
Be the first to ask about this product
Safe and Secure Payments.Easy returns.100% Authentic products.