LEADER 06698nam 22006975 450 001 9910300660203321 005 20200706083037.0 010 $a1-4842-0046-2 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(EXLCZ)993710000000224338 100 $a20140818d2014 u| 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aBeginning T-SQL$b[electronic resource] /$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 $a1-4842-0047-0 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