000 03136nam a22004335i 4500
001 vtls000541310
003 RU-ToGU
005 20210922082058.0
007 cr nn 008mamaa
008 160915s2014 xxu| s |||| 0|eng d
020 _a9781484200469
_9978-1-4842-0046-9
024 7 _a10.1007/978-1-4842-0046-9
_2doi
035 _ato000541310
040 _aSpringer
_cSpringer
_dRU-ToGU
050 4 _aQA75.5-76.95
072 7 _aUY
_2bicssc
072 7 _aCOM014000
_2bisacsh
082 0 4 _a004
_223
100 1 _aKellenberger, Kathi.
_eauthor.
_9446769
245 1 0 _aBeginning T-SQL
_helectronic resource
_bThird Edition /
_cby Kathi Kellenberger, Scott Shaw.
260 _aBerkeley, CA :
_bApress :
_bImprint: Apress,
_c2014.
300 _aXXIV, 496 p. 289 illus.
_bonline resource.
336 _atext
_btxt
_2rdacontent
337 _acomputer
_bc
_2rdamedia
338 _aonline resource
_bcr
_2rdacarrier
520 _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.
650 0 _aComputer Science.
_9155490
650 0 _aDatabase management.
_9566224
650 1 4 _aComputer Science.
_9155490
650 2 4 _aComputer Science, general.
_9155491
650 2 4 _aDatabase Management.
_9566226
700 1 _aShaw, Scott.
_eauthor.
_9446770
710 2 _aSpringerLink (Online service)
_9143950
773 0 _tSpringer eBooks
856 4 0 _uhttp://dx.doi.org/10.1007/978-1-4842-0046-9
912 _aZDB-2-CWD
999 _c399245