LEADER 00822cam0-2200289---450- 001 990005066890403321 005 20110525115532.0 035 $a000506689 035 $aFED01000506689 035 $a(Aleph)000506689FED01 035 $a000506689 100 $a19990604d1961----km-y0itay50------ba 101 0 $aeng 105 $ay-------001yy 200 1 $a<>practical guide to colloquial idiom$fby W. J. Ball 210 $aLondon$cLongmans$d1961 215 $aXI, 258 p.$d18 cm 610 0 $aLingua inglese$aConversazione$aManuali 676 $a428 700 1$aBall,$bWilson James$0202895 801 0$aIT$bUNINA$gRICA$2UNIMARC 901 $aBK 912 $a990005066890403321 952 $a428 BAL 1$bFil.Mod. 8751$fFLFBC 959 $aFLFBC 996 $aPractical guide to colloquial idiom$9531667 997 $aUNINA LEADER 06794nam 22007455 450 001 9910300660203321 005 20200706083037.0 010 $a9781484200469 010 $a1484200462 024 7 $a10.1007/978-1-4842-0046-9 035 $a(CKB)3710000000224338 035 $a(EBL)1964858 035 $a(SSID)ssj0001338640 035 $a(PQKBManifestationID)11735570 035 $a(PQKBTitleCode)TC0001338640 035 $a(PQKBWorkID)11344387 035 $a(PQKB)10141957 035 $a(MiAaPQ)EBC1964858 035 $a(DE-He213)978-1-4842-0046-9 035 $a(iGPub)SPNA0031391 035 $a(CaSebORM)9781484200469 035 $a(PPN)180622366 035 $a(OCoLC)889970326 035 $a(OCoLC)ocn889970326 035 $a(EXLCZ)993710000000224338 100 $a20140818d2014 u| 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aBeginning T-SQL /$fby Kathi Kellenberger, Scott Shaw 205 $a3rd ed. 2014. 210 1$aBerkeley, CA :$cApress :$cImprint: Apress,$d2014. 215 $a1 online resource (480 p.) 225 1 $aThe expert's voice in SQL server 300 $aIncludes index. 311 08$a9781484200476 311 08$a1484200470 327 $aContents at a Glance; Chapter 1: Getting Started; Installing SQL Server Express Edition; Installing Books Online; Using Books Online; Using SQL Server Management Studio; Launching SQL Server Management Studio; Installing the Sample Databases; Get Started with SSMS; Summary; Chapter 2: Exploring Database Concepts; What Is SQL Server?; Databases in the Cloud; Service vs. Application; Database as Container; Data Is Stored in Tables; Data Types; Normalization; Understanding Indexes; Database Schemas; Summary; Chapter 3: Writing Simple SELECT Queries; Using the SELECT Statement 327 $aSelecting a Literal ValueRetrieving from a Table; Generating a Select-List; Mixing Literals and Column Names; Filtering Data; Adding a WHERE Clause; Using WHERE Clauses with Alternate Operators; Using BETWEEN; Using BETWEEN with NOT; Filtering on Date and Time; Using WHERE Clauses with Two Predicates; Using the IN Operator; Working with NULL; Sorting Data; Thinking About Performance; Taking Advantage of Indexes; Viewing Execution Plans; Summary; Answers to the Exercises; Solutions to Exercise 3-1: Using the SELECT Statement; Solutions to Exercise 3-2: Filtering Data 327 $aSolutions to Exercise 3-3: Using WHERE Clauses with Two PredicatesSolutions to Exercise 3-4: Working with NULL; Solutions to Exercise 3-5: Sorting Data; Chapter 4: Using Built-In Functions and Expressions; Expressions Using Operators; Concatenating Strings; Concatenating Strings and NULL; CONCAT; ISNULL and COALESCE; Concatenating Other Data Types to Strings; Using Mathematical Operators; Using String Functions; RTRIM and LTRIM; LEFT and RIGHT; LEN and DATALENGTH; CHARINDEX; SUBSTRING; CHOOSE; REVERSE; UPPER and LOWER; REPLACE; Nesting Functions; Using Date and Time Functions 327 $aGETDATE and SYSDATETIMEDATEADD; DATEDIFF; DATENAME and DATEPART; DAY, MONTH, and YEAR; CONVERT; FORMAT; DATEFROMPARTS; EOMONTH; Using Mathematical Functions; ABS; POWER; SQUARE and SQRT; ROUND; RAND; Logical Functions and Expressions; The CASE Expression; Simple CASE; Searched CASE; Listing a Column as the Return Value; IIF; COALESCE; Administrative Function s; Using Functions in the WHERE and ORDER BY Clauses; The TOP Keyword; Thinking About Performance; Summary; Answers to the Exercises; Solutions to Exercise 4-1: Expressions Using Operators 327 $aSolutions to Exercise 4-2: Using Mathematical OperatorsSolution to Exercise 4-3: Using Functions; Solution to Exercise 4-4: Using Date and Time Functions; Solution to Exercise 4-5: Using Mathematical Functions; Solution to Exercise 4-6: Using Logical and System Functions; Solution to Exercise 4-7: Using Functions in the WHERE and ORDER BY Clauses; Chapter 5: Joining Tables; Using INNER JOIN; Joining Two Tables; Avoiding an Incorrect Join Condition; Joining on a Different Column Name; Joining on More Than One Column; Joining Three or More Tables; Using OUTER JOIN; Using LEFT OUTER JOIN 327 $aUsing RIGHT OUTER JOIN 330 $aBeginning T-SQL is a performance-oriented introduction to the T-SQL language underlying the Microsoft SQL Server database engine. T-SQL is essential in writing SQL statements to get data into and out of a database. T-SQL is the foundation for business logic embedded in the database in the form of stored procedures and functions. Beginning T-SQL starts you on the path to mastering T-SQL, with an emphasis on best-practices and sound coding techniques leading to excellent performance. This new edition is updated to cover the essential features of T-SQL found in SQL Server 2014, 2012, and 2008. Beginning T-SQL begins with an introduction to databases, normalization, and to SQL Server Management Studio. Attention is given to Azure SQL Database and how to connect to remote databases in the cloud. 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. Important techniques such as windowing functions are covered to help write fast executing queries that solve real business problems. 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. They'll help you avoid beginner mistakes by knowing about and thinking about performance from Day 1. Imparts best practices for writing T-SQL Helps you avoid common errors Shows how to write scalable code for good performance. 410 0$aExpert's voice in SQL server. 606 $aDatabase management 606 $aData structures (Computer science) 606 $aDatabase Management$3https://scigraph.springernature.com/ontologies/product-market-codes/I18024 606 $aData Structures and Information Theory$3https://scigraph.springernature.com/ontologies/product-market-codes/I15009 615 0$aDatabase management. 615 0$aData structures (Computer science) 615 14$aDatabase Management. 615 24$aData Structures and Information Theory. 676 $a004 676 $a005.74 700 $aKellenberger$b Kathi$4aut$4http://id.loc.gov/vocabulary/relators/aut$0879538 702 $aShaw$b Scott$4aut$4http://id.loc.gov/vocabulary/relators/aut 801 0$bUMI 801 1$bUMI 906 $aBOOK 912 $a9910300660203321 996 $aBeginning T-SQL$92012829 997 $aUNINA