rdf-syntax-grammar
mods:
  schema location: http://www.loc.gov/mods/v3 http://www.loc.gov/standards/mods/v3/mods-3-2.xsd
  title info:
    title: SQL antipatterns
    sub title: avoiding the pitfalls of database programming
    part number: Volume 1
  name:
    name part: Karwin, Bill
    role:
      role term: creator
    role:
      role term: author.
  name:
    name part: Carter, Jacquelyn
    role:
      role term: editor
  type of resource: text
  genre: bibliography
  origin info:
    place:
      place term: ncu
    date issued: 2022
    issuance: monographic
  language:
    language term: eng
  physical description:
    form: remote
    extent: 1 online resource (xvii, 354 pages)
  abstract: SQL is the ubiquitous language for software developers working with structured data. Most developers who rely on SQL are experts in their favorite language (such as Java, Python, or Go), but they're not experts in SQL. They often depend on antipatterns - solutions that look right but become increasingly painful to work with as you uncover their hidden costs. Learn to identify and avoid many of these common blunders. Refactor an inherited nightmare into a data model that really works. Updated for the current versions of MySQL and Python, this new edition adds a dozen brand new mini-antipatterns for quick wins. No matter which platform, framework, or language you use, the database is the foundation of your application, and the SQL database language is the standard for working with it. Antipatterns are solutions that look simple at the surface, but soon mire you down with needless work. Learn to identify these traps, and craft better solutions for the often-asked questions in this book. Avoid the mistakes that lead to poor performance and quality, and master the principles that make SQL a powerful and flexible tool for handling data and logic. Dive deep into SQL and database design, and learn to recognize the most common missteps made by software developers in database modeling, SQL query logic, and code design of data-driven applications. See practical examples of misconceptions about SQL that can lure software projects astray. Find the greatest value in each group of data. Understand why an intersection table may be your new best friend. Store passwords securely and don't reinvent the wheel. Handle NULL values like a pro. Defend your web applications against the security weakness of SQL injection.
  note: by Bill Karwin ; edited by Jacquelyn Carter.
  note: Includes bibliographical references.
  subject:
    topic: SQL (Computer program language)
  subject:
    topic: Relational databases
  subject:
    topic: Relational databases
  subject:
    topic: SQL (Computer program language)
  classification: QA76.73.S67
  classification: 005.75/65
  related item:
    title info:
      title: SQL antipatterns : Volume 1
    name:
      name part: Karwin, Bill.
    origin info:
      publisher: Raleigh : The Pragmatic Bookshelf, 2022
    identifier: (OCoLC)1346308057
  related item:
    title info:
      title: Pragmatic programmers
  identifier: 9798888650035
  identifier: 9781680508987
  identifier: 1680508989
  identifier: 9798888650011 O'Reilly Media
  identifier: https://proxy.library.tamu.edu/login
  record info:
    record content source: ORMDA
    record creation date: 221213
    record change date: 20260129163151.9
    record identifier: in00004673300
    language of cataloging:
      language term: eng