Effective SQL

61 Specific Ways to Write Better SQL

Nonfiction, Computers, Programming, Programming Languages, SQL, Database Management
Cover of the book Effective SQL by John L. Viescas, Douglas J. Steele, Ben G. Clothier, Pearson Education
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: John L. Viescas, Douglas J. Steele, Ben G. Clothier ISBN: 9780134579061
Publisher: Pearson Education Publication: January 9, 2017
Imprint: Addison-Wesley Professional Language: English
Author: John L. Viescas, Douglas J. Steele, Ben G. Clothier
ISBN: 9780134579061
Publisher: Pearson Education
Publication: January 9, 2017
Imprint: Addison-Wesley Professional
Language: English

Effective SQL brings together the hands-on solutions and practical insights you 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 -- all in full color.

 

Drawing on their immense experience as consultants and instructors, three world-class database experts identify specific challenges, and distill each solution into five pages or less. Throughout, they provide well-annotated SQL code designed for all leading platforms, as well as code for specific implementations ranging from SQL Server to Oracle and MySQL, wherever these vary or permit you to achieve your goal more efficiently.

 

Going beyond mere syntax, the authors also show how to avoid poor database design that makes it difficult to write effective SQL, how to improve suboptimal designs, and how to work around designs you can't change. You'll also find detailed sections on filtering and finding data, aggregation, subqueries, and metadata, as well as specific solutions for everything from listing products to scheduling events and defining data hierarchies. Simply put, if you already know the basics of SQL, Effective SQL will help you become a world-class SQL problem-solver.

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

Effective SQL brings together the hands-on solutions and practical insights you 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 -- all in full color.

 

Drawing on their immense experience as consultants and instructors, three world-class database experts identify specific challenges, and distill each solution into five pages or less. Throughout, they provide well-annotated SQL code designed for all leading platforms, as well as code for specific implementations ranging from SQL Server to Oracle and MySQL, wherever these vary or permit you to achieve your goal more efficiently.

 

Going beyond mere syntax, the authors also show how to avoid poor database design that makes it difficult to write effective SQL, how to improve suboptimal designs, and how to work around designs you can't change. You'll also find detailed sections on filtering and finding data, aggregation, subqueries, and metadata, as well as specific solutions for everything from listing products to scheduling events and defining data hierarchies. Simply put, if you already know the basics of SQL, Effective SQL will help you become a world-class SQL problem-solver.

More books from Pearson Education

Cover of the book Geekonomics by John L. Viescas, Douglas J. Steele, Ben G. Clothier
Cover of the book Final Cut Pro X 10.3 - Apple Pro Training Series by John L. Viescas, Douglas J. Steele, Ben G. Clothier
Cover of the book CCNA Routing and Switching 200-125 Official Cert Guide Library by John L. Viescas, Douglas J. Steele, Ben G. Clothier
Cover of the book Computer Structure and Logic by John L. Viescas, Douglas J. Steele, Ben G. Clothier
Cover of the book Agile Java™ by John L. Viescas, Douglas J. Steele, Ben G. Clothier
Cover of the book How Do Traders and Investors Use Charts with Technical Analysis? by John L. Viescas, Douglas J. Steele, Ben G. Clothier
Cover of the book York Notes Companions: Romantic Literature by John L. Viescas, Douglas J. Steele, Ben G. Clothier
Cover of the book Following Effective Trends in Sector Investing by John L. Viescas, Douglas J. Steele, Ben G. Clothier
Cover of the book Digital Exhaust by John L. Viescas, Douglas J. Steele, Ben G. Clothier
Cover of the book Stunning CSS3 by John L. Viescas, Douglas J. Steele, Ben G. Clothier
Cover of the book The Truth About Taxes and Your Employment by John L. Viescas, Douglas J. Steele, Ben G. Clothier
Cover of the book Strategic Management by John L. Viescas, Douglas J. Steele, Ben G. Clothier
Cover of the book MCTS 70-680 Cert Guide by John L. Viescas, Douglas J. Steele, Ben G. Clothier
Cover of the book Genetic Breakthroughs— Their Implications for You and Your Health (Collection) by John L. Viescas, Douglas J. Steele, Ben G. Clothier
Cover of the book Walking the Walk by John L. Viescas, Douglas J. Steele, Ben G. Clothier
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy