001434227 000__ 05178cam\a2200601Mi\4500
001434227 001__ 1434227
001434227 003__ OCoLC
001434227 005__ 20230309003717.0
001434227 006__ m\\\\\o\\d\\\\\\\\
001434227 007__ cr\nn\nnnunnun
001434227 008__ 201226s2021\\\\cau\\\\\o\\\\\|||\0\eng\d
001434227 019__ $$a1228457431$$a1232276543$$a1235833647$$a1236267464$$a1237456417$$a1238201892$$a1238204366$$a1240163044$$a1242874947$$a1244558476$$a1246717547
001434227 020__ $$a1484266064
001434227 020__ $$a9781484266069
001434227 020__ $$z1484266056
001434227 020__ $$z9781484266052
001434227 020__ $$z9781484266076$$q(print)
001434227 020__ $$z1484266072
001434227 0247_ $$a10.1007/978-1-4842-6606-9.$$2doi
001434227 0248_ $$a9781484266052
001434227 0248_ $$a9781484266069
001434227 035__ $$aSP(OCoLC)1238204835
001434227 040__ $$aLDP$$beng$$cLDP$$dOCLCO$$dTOH$$dYDX$$dSFB$$dVT2$$dEBLCP$$dBNG$$dDCT$$dGW5XE$$dERF$$dOCLCF$$dUKAHL$$dUAB$$dTEFOD$$dCOM$$dOCLCO$$dOCLCQ
001434227 049__ $$aISEA
001434227 050_4 $$aQA76.76.M52
001434227 08204 $$a004.165$$223
001434227 1001_ $$aKellenberger, Kathi.,$$eauthor.$$4aut$$4http://id.loc.gov/vocabulary/relators/aut$$0(uri) http://viaf.org/viaf/sourceID/LC%7cno2019065573
001434227 24510 $$aBeginning T-SQL:$$bA Step-by-Step Approach /$$cby Kathi Kellenberger, Lee Everest.
001434227 250__ $$a4th ed. 2021.
001434227 264_1 $$aBerkeley, CA :$$bApress :$$bImprint: Apress,$$c2021.
001434227 300__ $$a1 online resource (XXIX, 706 p. 350 illus.)
001434227 336__ $$atext$$btxt$$2rdacontent
001434227 337__ $$acomputer$$bc$$2rdamedia
001434227 338__ $$aonline resource$$bcr$$2rdacarrier
001434227 347__ $$atext file
001434227 5050_ $$a1. Getting Started -- 2. Exploring Database Concepts -- 3. Writing Simple SELECT Queries -- 4. Using Built-In Functions and Expressions -- 5. Joining Tables -- 6. Building on Subqueries, Common Table Expressions, and Unions -- 7. Grouping and Summarizing Data -- 8. Discovering Windowing Functions -- 9. Advanced WHERE Clauses -- 10. Manipulating Data -- 11. Managing Transactions -- 12. Understanding T-SQL Programming Logic -- 13. Implementing Logic in the Database -- 14. Expanding on Data Type Concepts -- 15. Working with XML and JSON -- 16. Writing Advanced Queries -- 17.Where to Go Next? -- Appendix A: SQL Server for Linux and macOS -- Appendix B: Using SSMS -- Appendix C: SQL Notebooks.
001434227 506__ $$aAccess limited to authorized users.
001434227 520__ $$aGet a performance-oriented introduction to the T-SQL language underlying the Microsoft SQL Server and Azure SQL database engines. This fourth edition is updated to include SQL Notebooks as well as up-to-date syntax and features for T-SQL on-premises and in the Azure cloud. Exercises and examples now include the WideWorldImporters database, the newest sample database from Microsoft for SQL Server. Also new in this edition is coverage of JSON from T-SQL, news about performance enhancements called Intelligent Query Processing, and an appendix on running SQL Server in a container on macOS or Linux. Beginning T-SQL starts you on the path to mastering T-SQL with an emphasis on best practices. Using the sound coding techniques taught in this book will lead to excellent performance in the queries that you write in your daily work. Important techniques such as windowing functions are covered to help you write fast-executing queries that solve real business problems.The book begins with an introduction to databases, normalization, and to setting up your learning environment. You will learn about the tools you need to use such as SQL Server Management Studio, Azure Data Studio, and SQL Notebooks. Each subsequent chapter teaches an aspect of T-SQL, building on the skills learned in previous chapters. Exercises in most chapters provide an opportunity for the hands-on practice that leads to true learning and distinguishes the competent professional. A stand-out feature in this book is that most chapters end with a Thinking About Performance section. These sections cover aspects of query performance relative to the content just presented, including the new Intelligent Query Processing features that make queries faster without changing code. They will help you avoid beginner mistakes by knowing about and thinking about performance from day 1. You will: Install a sandboxed SQL Server instance for learning Understand how relational databases are designed Create objects such as tables and stored procedures Query a SQL Server table Filter and order the results of a query Query and work with specialized data types such as XML and JSON Apply modern features such as window functions Choose correct techniques so that your queries perform well.
001434227 542__ $$f© Copyright 2021 Kathi Kellenberger, Lee Everest.$$g2021
001434227 650_0 $$aMicrosoft software.
001434227 650_0 $$aMicrosoft .NET Framework.
001434227 650_0 $$aDatabase management.
001434227 650_6 $$aLogiciels Microsoft.
001434227 650_6 $$aBases de données$$xGestion.
001434227 655_0 $$aElectronic books.
001434227 7001_ $$aEverest, Lee.,$$eauthor.$$4aut$$4http://id.loc.gov/vocabulary/relators/aut
001434227 77608 $$iPrint version:$$z1484266056
001434227 852__ $$bebk
001434227 85640 $$3Springer Nature$$uhttps://univsouthin.idm.oclc.org/login?url=https://link.springer.com/10.1007/978-1-4842-6606-9$$zOnline Access$$91397441.1
001434227 909CO $$ooai:library.usi.edu:1434227$$pGLOBAL_SET
001434227 980__ $$aBIB
001434227 980__ $$aEBOOK
001434227 982__ $$aEbook
001434227 983__ $$aOnline
001434227 994__ $$a92$$bISE