Coverart for item
The Resource Beginning T-SQL 2012, Scott Shaw, Kathi Kellenberger

Beginning T-SQL 2012, Scott Shaw, Kathi Kellenberger

Label
Beginning T-SQL 2012
Title
Beginning T-SQL 2012
Statement of responsibility
Scott Shaw, Kathi Kellenberger
Title variation
T-SQL 2012
Creator
Contributor
Subject
Language
eng
Summary
Annotation
Member of
Cataloging source
BTCTA
http://library.link/vocab/creatorName
Shaw, Scott
Illustrations
illustrations
Index
index present
LC call number
  • QA
  • QA76.73.S67
LC item number
S53 2012
Literary form
non fiction
http://library.link/vocab/relatedWorkOrContributorName
Kellenberger, Kathi
Series statement
Expert's voice in databases
http://library.link/vocab/subjectName
  • SQL (Computer program language)
  • Database management
  • Client/server computing
Summary expansion
Beginning T-SQL 2012is the first steptoward learning the T-SQL language that underlies Microsofts 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 2012starts you on the path to mastering T-SQL, with an emphasis on best practices and sound coding techniques.Beginning T-SQL 2012begins with an introduction to databases, normalization, and to SQL Server Management Studio. Each subsequent chapter teaches an aspect of T-SQL, building on the skills learned in previous chapters. Exercises in each chapter give readers an opportunity for the hands-on practice that leads to true learning and distinguishes the competent professional.Imparts best practices for writing T-SQLHelps you avoid common errorsShows how to write scalable code for good performanceWhat youll learnThe fundamentals of relational theory, upon which Transact-SQL is basedHow to write accurate queries that are scalable and perform wellHow to combine set-based and procedural processing, obtaining the best from both worldsHow to embed business logic in your database through stored procedures and functionsHow to simplify your work with new and advanced features, such as common table expressions and virtual tablesHow to enhance performance by knowing when to apply features such table value parameters, and when not toWho this book is forBeginning T-SQL 2012is for developers and database administrators who will be writing database applications against SQL Server databases.Table of ContentsGetting StartedWriting SimpleSELECT QueriesUsing Functions and ExpressionsQuerying Multiple TablesGrouping and Summarizing DataManipulating DataUnderstanding T-SQL Programming LogicWorking with XMLMoving Logic to the DatabaseWorking with Data TypesWriting Advanced QueriesWhere to Go Next?
Target audience
adult
Label
Beginning T-SQL 2012, Scott Shaw, Kathi Kellenberger
Instantiates
Publication
Note
  • Previously published as Beginning T-SQL 2008, by Kathi Kellenberger, c2009
  • "Quickly move beyond beginner status with this step-by-step approach to learning T-SQL"--Cover
  • "Books for professionals by professionals"--Cover
Bibliography note
Includes index
Contents
Getting started -- Writing simple SELECT queries -- Using functions and expressions -- Querying multiple tables -- Grouping and summarizing data -- Manipulating data -- Understanding T-SQL programming logic -- Working with XML -- Moving logic to the database -- Working with data types -- Writing advanced queries -- Where to go next?
Control code
ocn748329575
Dimensions
24 cm.
Edition
2nd ed.
Extent
xxi, 433 p.
Isbn
9781430237044
Isbn Type
(pbk.)
Other physical details
ill.
System control number
(OCoLC)748329575
Label
Beginning T-SQL 2012, Scott Shaw, Kathi Kellenberger
Publication
Note
  • Previously published as Beginning T-SQL 2008, by Kathi Kellenberger, c2009
  • "Quickly move beyond beginner status with this step-by-step approach to learning T-SQL"--Cover
  • "Books for professionals by professionals"--Cover
Bibliography note
Includes index
Contents
Getting started -- Writing simple SELECT queries -- Using functions and expressions -- Querying multiple tables -- Grouping and summarizing data -- Manipulating data -- Understanding T-SQL programming logic -- Working with XML -- Moving logic to the database -- Working with data types -- Writing advanced queries -- Where to go next?
Control code
ocn748329575
Dimensions
24 cm.
Edition
2nd ed.
Extent
xxi, 433 p.
Isbn
9781430237044
Isbn Type
(pbk.)
Other physical details
ill.
System control number
(OCoLC)748329575

Library Locations

    • CRPL-Downtown LibraryBorrow it
      450 5th Avenue SE, Cedar Rapids, IA, 52401, US
      41.976964 -91.6624043
Processing Feedback ...