Effective SQL : 61 specific ways to write better SQL
Description
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 Details
Notes
Also in this Series
Reviews from GoodReads
Citations
Viescas, J. L., Steele, D. J., & Clothier, B. (2017). Effective SQL: 61 specific ways to write better SQL . Addison-Wesley.
Chicago / Turabian - Author Date Citation, 17th Edition (style guide)Viescas, John L., 1947-, Douglas J., Steele and Ben, Clothier. 2017. Effective SQL: 61 Specific Ways to Write Better SQL. Boston: Addison-Wesley.
Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)Viescas, John L., 1947-, Douglas J., Steele and Ben, Clothier. Effective SQL: 61 Specific Ways to Write Better SQL Boston: Addison-Wesley, 2017.
Harvard Citation (style guide)Viescas, J. L., Steele, D. J. and Clothier, B. (2017). Effective SQL: 61 specific ways to write better SQL. Boston: Addison-Wesley.
MLA Citation, 9th Edition (style guide)Viescas, John L., Douglas J. Steele, and Ben Clothier. Effective SQL: 61 Specific Ways to Write Better SQL Addison-Wesley, 2017.
Staff View
Grouping Information
| Grouped Work ID | bf59f750-9b08-719e-2c80-62d89325f890-eng |
|---|---|
| Full title | effective sql 61 specific ways to write better sql |
| Author | viescas john l |
| Grouping Category | book |
| Last Update | 2025-01-24 12:33:29PM |
| Last Indexed | 2025-05-03 03:31:24AM |
Book Cover Information
| Image Source | syndetics |
|---|---|
| First Loaded | Apr 15, 2023 |
| Last Used | Apr 24, 2025 |
Marc Record
| First Detected | Mar 14, 2023 08:04:11 AM |
|---|---|
| Last File Modification Time | Mar 14, 2023 08:04:11 AM |
| Suppressed | Record had no items |
MARC Record
| LEADER | 02685cam a2200517Ii 4500 | ||
|---|---|---|---|
| 001 | ocn969170596 | ||
| 003 | OCoLC | ||
| 005 | 20230314080334.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 170119s2017 maua o 001 0 eng d | ||
| 019 | |a 1006312078 | ||
| 020 | |a 9780134579061|q (electronic bk.) | ||
| 020 | |a 0134579062|q (electronic bk.) | ||
| 035 | |a (OCoLC)969170596|z (OCoLC)1006312078 | ||
| 037 | |a CL0500000819|b Safari Books Online | ||
| 040 | |a UMI|b eng|e rda|e pn|c UMI|d OCLCF|d STF|d N$T|d YDX|d N$T|d CEF|d KSU|d OCLCQ|d DEBBG|d OCLCO|d OCLCQ | ||
| 049 | |a MAIN | ||
| 050 | 4 | |a QA76.73.S67 | |
| 072 | 7 | |a COM|x 051170|2 bisacsh | |
| 082 | 0 | 4 | |a 005.75/6|2 23 |
| 100 | 1 | |a Viescas, John L.,|d 1947-|e author.|9 179515 | |
| 245 | 1 | 0 | |a Effective SQL :|b 61 specific ways to write better SQL /|c John L. Viescas, Dougtlas J. Steele, Ben G. Clothier. |
| 264 | 1 | |a Boston :|b Addison-Wesley,|c [2017] | |
| 264 | 4 | |c ©2017 | |
| 300 | |a 1 online resource (1 volume) :|b illustrations. | ||
| 336 | |a text|b txt|2 rdacontent | ||
| 337 | |a computer|b c|2 rdamedia | ||
| 338 | |a online resource|b cr|2 rdacarrier | ||
| 490 | 1 | |a Effective software development series | |
| 500 | |a Includes index. | ||
| 505 | 0 | |a Data model design -- Programmability and index design -- When you can't change the design -- Filtering and finding data -- Aggregation -- Subqueries -- Getting and analyzing metadata -- Cartesian products -- Tally tables -- Modeling hierarchical data -- Appendix: Date and time types, operations, and functions. | |
| 520 | |a Presents practical solutions and insights for solving complex problems with SQL and designing databases that simplify data management in the future. Brings together advanced best practices and realistic example code for all of these versions of SQL: IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle Database, and PostgreSQL. | ||
| 588 | 0 | |a Online resource; title from title page (viewed January 17, 2017). | |
| 590 | |a O'Reilly|b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 650 | 0 | |a SQL (Computer program language)|9 62322 | |
| 650 | 0 | |a Databases. | |
| 700 | 1 | |a Steele, Douglas J.,|e author.|9 362050 | |
| 700 | 1 | |a Clothier, Ben,|e author.|9 349844 | |
| 776 | 0 | 8 | |i Print version:|a Viescas, John L., 1947-|t Effective SQL.|d ©2017|z 0134578899|z 9780134578897|w (OCoLC)944156879 |
| 830 | 0 | |a Effective software development series. | |
| 856 | 4 | 0 | |u https://library.access.arlingtonva.us/login?url=https://learning.oreilly.com/library/view/~/9780134579078/?ar|x O'Reilly|z eBook |
| 938 | |a EBSCOhost|b EBSC|n 1602129 | ||
| 938 | |a YBP Library Services|b YANK|n 14858320 | ||
| 994 | |a 92|b VIA | ||
| 999 | |c 281455|d 281455 | ||