001480760 000__ 06610cam\\22006257i\4500
001480760 001__ 1480760
001480760 003__ OCoLC
001480760 005__ 20231031003307.0
001480760 006__ m\\\\\o\\d\\\\\\\\
001480760 007__ cr\cn\nnnunnun
001480760 008__ 230916s2023\\\\nyu\\\\\o\\\\\000\0\eng\d
001480760 019__ $$a1396181365
001480760 020__ $$a9781484296851$$qelectronic book
001480760 020__ $$a1484296850$$qelectronic book
001480760 020__ $$z9781484296844
001480760 020__ $$z1484296842
001480760 0247_ $$a10.1007/978-1-4842-9685-1$$2doi
001480760 035__ $$aSP(OCoLC)1396696419
001480760 040__ $$aEBLCP$$beng$$erda$$cEBLCP$$dORMDA$$dGW5XE$$dOCLCO$$dYDX
001480760 049__ $$aISEA
001480760 050_4 $$aQA76.9.D3$$bS56 2023
001480760 08204 $$a005.75/65$$223/eng/20230919
001480760 1001_ $$aSimon, Mark,$$eauthor.
001480760 24510 $$aLeveling up with SQL :$$badvanced techniques for transforming data into insights /$$cMark Simon.
001480760 264_1 $$a[New York] :$$bApress,$$c[2023]
001480760 300__ $$a1 online resource
001480760 336__ $$atext$$btxt$$2rdacontent
001480760 337__ $$acomputer$$bc$$2rdamedia
001480760 338__ $$aonline resource$$bcr$$2rdacarrier
001480760 500__ $$aPlace of publication from publisher's website.
001480760 500__ $$aMore Details on Calculations
001480760 5050_ $$aIntro -- Table of Contents -- About the Author -- About the Technical Reviewer -- Acknowledgments -- Introduction -- Chapter 1: Getting Ready -- About the Sample Database -- Setting Up -- Database Management Software -- Database Client -- The Sample Database -- What You Probably Know Already -- Some Philosophical Concepts -- Data vs. Information vs. Values -- Database Tables -- Writing SQL -- Basic SQL -- Data Types -- SQL Clauses -- Filtering Data with the WHERE Clause -- Multiple Assertions -- Wildcard Matches -- Sorting with the ORDER BY Clause -- Limiting Results -- Sorting Strings
001480760 5058_ $$aCalculating Columns -- Calculating with NULLs -- Aliases -- Subqueries -- The CASE Expression -- Casting a Value -- Views -- Joins -- The ON Clause -- Join Types -- Aggregates -- Working with Tables -- Data Types -- Constraints -- Foreign Keys -- Indexes -- Manipulating Data -- Set Operations -- Coming Up -- Chapter 2: Working with Table Design -- Understanding Normalized Tables -- Columns Should Be Independent -- Adding the Towns Table -- Adding a Foreign Key to the Town -- Update the Customers Table -- Remove the Old Address Columns -- Create a customerdetails View -- Drop the Address Columns
001480760 5058_ $$aChanging the Town -- Adding the Country -- Additional Comments -- Improving Database Integrity -- Fixing Issues with a Nullable Column -- Replacing NULL Quantities -- Setting the NOT NULL Constraint for Quantity -- Setting a DEFAULT for Quantity -- Adding a Positive CHECK Constraint for Quantity -- Combining the Changes -- Making the Changes in SQLite -- Other Adjustments -- Ensuring the Prices Are Not Negative -- Ensuring That an Author Is Born Before Dying -- Adding Indexes -- Adding an Index to the Books and Authors Tables -- Creating a Unique Index -- Review -- Normal Form -- Multiple Values
001480760 5058_ $$aAltering Tables -- Views -- Indexes -- The Final Product -- Summary -- Coming Up -- Chapter 3: Table Relationships and Joins -- An Overview of Relationships -- One-to-Many Relationship -- Counting One-to-Many Joins -- The NOT IN Quirk -- Creating a Books and Authors View -- One-to-One Relationships -- One-to-Maybe Relationships -- Multiple Values -- Many-to-Many Relationships -- Joining Many-to-Many Tables -- Summarizing Multiple Values -- Combining the Joins -- Many-to-Many Relationships Happen All the Time -- Another Many-to-Many Example -- Inserting into Related Tables
001480760 5058_ $$aAdding a Book and an Author -- Adding an Author -- Adding a Book -- Adding a New Sale -- Adding a New Sale in the Sales Table -- Adding the Sale Items and Getting the Prices -- Completing the Sale -- Review -- Types of Relationships -- Joining Tables -- Views -- Inserting into Related Tables -- Summary -- Coming Up -- Chapter 4: Working with Calculated Data -- Calculation Basics -- Using Aliases -- Alias Names -- AS Is Optional -- Aliases Are Not Available in the Rest of the Query -- Dealing with NULLs -- Coalesce -- Fixing the Author Names -- Using Calculations in Other Clauses
001480760 506__ $$aAccess limited to authorized users.
001480760 520__ $$aLearn to write SQL queries to select and analyze data, and improve your ability to manipulate data. This book will help you take your existing skills to the next level. Author Mark Simon kicks things off with a quick review of basic SQL knowledge, followed by a demonstration of how efficient SQL databases are designed and how to extract just the right data from them. You'll then learn about each individual table's structure and how to work with the relationships between tables. As you progress through the book, you will learn more sophisticated techniques such as using common table expressions and subqueries, analyzing your data using aggregate and windowing functions, and how to save queries in the form of views and other methods. This book employs an accessible approach to work through a realistic sample, enabling you to learn concepts as they arise to improve parts of the database or to work with the data itself. After completing this book, you will have a more thorough understanding of database structure and how to use advanced techniques to extract, manage, and analyze data. What Will You Learn Gain a stronger understanding of database design principles, especially individual tables Understand the relationships between tables Utilize techniques such as views, subqueries, common table expressions, and windowing functions Who Is This Book For: SQL Databases users who want to improve their knowledge and techniques.
001480760 588__ $$aDescription based on online resource; title from digital title page (viewed on October 06, 2023).
001480760 650_6 $$aSQL (Langage de programmation)
001480760 650_6 $$aBases de données relationnelles.
001480760 650_6 $$aBases de données$$xGestion.
001480760 650_0 $$aSQL (Computer program language)$$0(DLC)sh 96008008
001480760 650_0 $$aRelational databases.
001480760 650_0 $$aDatabase management.$$vCongresses$$0(DLC)sh2008102037
001480760 655_0 $$aElectronic books.
001480760 77608 $$iPrint version:$$aSimon, Mark$$tLeveling up with SQL$$dBerkeley, CA : Apress L. P.,c2023$$z9781484296844
001480760 852__ $$bebk
001480760 85640 $$3Springer Nature$$uhttps://univsouthin.idm.oclc.org/login?url=https://link.springer.com/10.1007/978-1-4842-9685-1$$zOnline Access$$91397441.1
001480760 909CO $$ooai:library.usi.edu:1480760$$pGLOBAL_SET
001480760 980__ $$aBIB
001480760 980__ $$aEBOOK
001480760 982__ $$aEbook
001480760 983__ $$aOnline
001480760 994__ $$a92$$bISE