skip to content
Beginning T-SQL 2012 Preview this item
ClosePreview this item
Checking...

Beginning T-SQL 2012

Author: Scott Shaw; Kathi Kellenberger
Publisher: [New York, N.Y.] : Apress : Distributed by Springer Science+Business Media, ©2012.
Series: Expert's voice in databases.
Edition/Format:   Print book : English : 2nd edView all editions and formats
Database:WorldCat
Summary:
Annotation
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

 

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Document Type: Book
All Authors / Contributors: Scott Shaw; Kathi Kellenberger
ISBN: 9781430237044 143023704X
OCLC Number: 748329575
Notes: Previously published as Beginning T-SQL 2008, by Kathi Kellenberger, ©2009.
"Quickly move beyond beginner status with this step-by-step approach to learning T-SQL"--Cover.
"Books for professionals by professionals"--Cover.
Includes index.
Description: xxi, 433 pages : illustrations ; 24 cm.
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?
Series Title: Expert's voice in databases.
Other Titles: T-SQL 2012
Responsibility: Scott Shaw, Kathi Kellenberger.
More information:

Abstract:

Annotation

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?

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/748329575> # Beginning T-SQL 2012
    a schema:CreativeWork, schema:Book ;
   library:oclcnum "748329575" ;
   library:placeOfPublication <http://id.loc.gov/vocabulary/countries/nyu> ;
   library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/1168396697#Place/new_york_n_y> ; # New York, N.Y.
   schema:about <http://id.worldcat.org/fast/1102869> ; # SQL (Computer program language)
   schema:about <http://id.worldcat.org/fast/864205> ; # Client/server computing
   schema:about <http://id.worldcat.org/fast/888037> ; # Database management
   schema:about <http://dewey.info/class/005.7585/> ;
   schema:about <http://id.worldcat.org/fast/1376937> ; # SQL server.
   schema:about <http://experiment.worldcat.org/entity/work/data/1168396697#CreativeWork/sql_server> ; # SQL server.
   schema:alternateName "T-SQL 2012" ;
   schema:bookEdition "2nd ed." ;
   schema:bookFormat bgn:PrintBook ;
   schema:contributor <http://experiment.worldcat.org/entity/work/data/1168396697#Person/kellenberger_kathi> ; # Kathi Kellenberger
   schema:copyrightYear "2012" ;
   schema:creator <http://experiment.worldcat.org/entity/work/data/1168396697#Person/shaw_scott> ; # Scott Shaw
   schema:datePublished "2012" ;
   schema:description "Annotation"@en ;
   schema:description "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?"@en ;
   schema:exampleOfWork <http://worldcat.org/entity/work/id/1168396697> ;
   schema:inLanguage "en" ;
   schema:isPartOf <http://experiment.worldcat.org/entity/work/data/1168396697#Series/expert_s_voice_in_databases> ; # Expert's voice in databases.
   schema:name "Beginning T-SQL 2012"@en ;
   schema:productID "748329575" ;
   schema:publication <http://www.worldcat.org/title/-/oclc/748329575#PublicationEvent/new_york_n_y_apress_distributed_by_springer_science+business_media_2012> ;
   schema:publisher <http://experiment.worldcat.org/entity/work/data/1168396697#Agent/apress> ; # Apress
   schema:publisher <http://experiment.worldcat.org/entity/work/data/1168396697#Agent/distributed_by_springer_science+business_media> ; # Distributed by Springer Science+Business Media
   schema:workExample <http://worldcat.org/isbn/9781430237044> ;
   wdrs:describedby <http://www.worldcat.org/title/-/oclc/748329575> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/1168396697#Agent/distributed_by_springer_science+business_media> # Distributed by Springer Science+Business Media
    a bgn:Agent ;
   schema:name "Distributed by Springer Science+Business Media" ;
    .

<http://experiment.worldcat.org/entity/work/data/1168396697#Person/kellenberger_kathi> # Kathi Kellenberger
    a schema:Person ;
   schema:familyName "Kellenberger" ;
   schema:givenName "Kathi" ;
   schema:name "Kathi Kellenberger" ;
    .

<http://experiment.worldcat.org/entity/work/data/1168396697#Series/expert_s_voice_in_databases> # Expert's voice in databases.
    a bgn:PublicationSeries ;
   schema:hasPart <http://www.worldcat.org/oclc/748329575> ; # Beginning T-SQL 2012
   schema:name "Expert's voice in databases." ;
   schema:name "Expert's voice in databases" ;
    .

<http://id.worldcat.org/fast/1102869> # SQL (Computer program language)
    a schema:Intangible ;
   schema:name "SQL (Computer program language)"@en ;
    .

<http://id.worldcat.org/fast/1376937> # SQL server.
    a schema:CreativeWork ;
   schema:name "SQL server." ;
    .

<http://id.worldcat.org/fast/864205> # Client/server computing
    a schema:Intangible ;
   schema:name "Client/server computing"@en ;
    .

<http://id.worldcat.org/fast/888037> # Database management
    a schema:Intangible ;
   schema:name "Database management"@en ;
    .

<http://worldcat.org/isbn/9781430237044>
    a schema:ProductModel ;
   schema:isbn "143023704X" ;
   schema:isbn "9781430237044" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.