Beginning T-SQL: A Step-by-Step Approach
Get a performance-oriented introduction to the T-SQL language underlying the Microsoft SQL Server and Azure SQL database engines. This fourth edition is updated to include SQL Notebooks as well as up-to-date syntax and features for T-SQL on-premises and in the Azure cloud. Exercises and examples now...
Gespeichert in:
| Beteiligte Personen: | , |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | Englisch |
| Veröffentlicht: |
Berkeley, CA
Apress
2021
Berkeley, CA Imprint: Apress 2021 |
| Ausgabe: | 4th ed. 2021. |
| Schlagwörter: | |
| Links: | https://learning.oreilly.com/library/view/-/9781484266069/?ar |
| Zusammenfassung: | Get a performance-oriented introduction to the T-SQL language underlying the Microsoft SQL Server and Azure SQL database engines. This fourth edition is updated to include SQL Notebooks as well as up-to-date syntax and features for T-SQL on-premises and in the Azure cloud. Exercises and examples now include the WideWorldImporters database, the newest sample database from Microsoft for SQL Server. Also new in this edition is coverage of JSON from T-SQL, news about performance enhancements called Intelligent Query Processing, and an appendix on running SQL Server in a container on macOS or Linux. Beginning T-SQL starts you on the path to mastering T-SQL with an emphasis on best practices. Using the sound coding techniques taught in this book will lead to excellent performance in the queries that you write in your daily work. Important techniques such as windowing functions are covered to help you write fast-executing queries that solve real business problems.The book begins with an introduction to databases, normalization, and to setting up your learning environment. You will learn about the tools you need to use such as SQL Server Management Studio, Azure Data Studio, and SQL Notebooks. 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. 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, including the new Intelligent Query Processing features that make queries faster without changing code. They will help you avoid beginner mistakes by knowing about and thinking about performance from day 1. You will: Install a sandboxed SQL Server instance for learning Understand how relational databases are designed Create objects such as tables and stored procedures Query a SQL Server table Filter and order the results of a query Query and work with specialized data types such as XML and JSON Apply modern features such as window functions Choose correct techniques so that your queries perform well. |
| Umfang: | 1 Online-Ressource (XXIX, 706 Seiten 350 illus.) |
| ISBN: | 1484266064 9781484266069 |
Internformat
MARC
| LEADER | 00000cam a22000002 4500 | ||
|---|---|---|---|
| 001 | ZDB-30-ORH-061075809 | ||
| 003 | DE-627-1 | ||
| 005 | 20240228121319.0 | ||
| 007 | cr uuu---uuuuu | ||
| 008 | 210118s2021 xx |||||o 00| ||eng c | ||
| 020 | |a 1484266064 |9 1-4842-6606-4 | ||
| 020 | |a 9781484266069 |9 978-1-4842-6606-9 | ||
| 035 | |a (DE-627-1)061075809 | ||
| 035 | |a (DE-599)KEP061075809 | ||
| 035 | |a (ORHE)9781484266069 | ||
| 035 | |a (DE-627-1)061075809 | ||
| 040 | |a DE-627 |b ger |c DE-627 |e rda | ||
| 041 | |a eng | ||
| 072 | 7 | |a UMP. |2 bicssc | |
| 072 | 7 | |a COM051380. |2 bisacsh | |
| 082 | 0 | |a 004.165 |2 23 | |
| 100 | 1 | |a Kellenberger, Kathi. |e VerfasserIn |4 aut | |
| 245 | 1 | 0 | |a Beginning T-SQL |b A Step-by-Step Approach |c by Kathi Kellenberger, Lee Everest |
| 250 | |a 4th ed. 2021. | ||
| 264 | 1 | |a Berkeley, CA |b Apress |c 2021 | |
| 264 | 1 | |a Berkeley, CA |b Imprint: Apress |c 2021 | |
| 300 | |a 1 Online-Ressource (XXIX, 706 Seiten 350 illus.) | ||
| 336 | |a Text |b txt |2 rdacontent | ||
| 337 | |a Computermedien |b c |2 rdamedia | ||
| 338 | |a Online-Ressource |b cr |2 rdacarrier | ||
| 520 | |a Get a performance-oriented introduction to the T-SQL language underlying the Microsoft SQL Server and Azure SQL database engines. This fourth edition is updated to include SQL Notebooks as well as up-to-date syntax and features for T-SQL on-premises and in the Azure cloud. Exercises and examples now include the WideWorldImporters database, the newest sample database from Microsoft for SQL Server. Also new in this edition is coverage of JSON from T-SQL, news about performance enhancements called Intelligent Query Processing, and an appendix on running SQL Server in a container on macOS or Linux. Beginning T-SQL starts you on the path to mastering T-SQL with an emphasis on best practices. Using the sound coding techniques taught in this book will lead to excellent performance in the queries that you write in your daily work. Important techniques such as windowing functions are covered to help you write fast-executing queries that solve real business problems.The book begins with an introduction to databases, normalization, and to setting up your learning environment. You will learn about the tools you need to use such as SQL Server Management Studio, Azure Data Studio, and SQL Notebooks. 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. 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, including the new Intelligent Query Processing features that make queries faster without changing code. They will help you avoid beginner mistakes by knowing about and thinking about performance from day 1. You will: Install a sandboxed SQL Server instance for learning Understand how relational databases are designed Create objects such as tables and stored procedures Query a SQL Server table Filter and order the results of a query Query and work with specialized data types such as XML and JSON Apply modern features such as window functions Choose correct techniques so that your queries perform well. | ||
| 650 | 0 | |a Microsoft software | |
| 650 | 0 | |a Microsoft .NET Framework | |
| 650 | 0 | |a Database management | |
| 650 | 4 | |a Microsoft and .NET | |
| 650 | 4 | |a Database Management | |
| 650 | 4 | |a Logiciels Microsoft | |
| 650 | 4 | |a Bases de données ; Gestion | |
| 650 | 4 | |a Database management | |
| 650 | 4 | |a Microsoft software | |
| 700 | 1 | |a Everest, Lee. |e VerfasserIn |4 aut | |
| 776 | 1 | |z 1484266056 | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 1484266056 |
| 966 | 4 | 0 | |l DE-91 |p ZDB-30-ORH |q TUM_PDA_ORH |u https://learning.oreilly.com/library/view/-/9781484266069/?ar |m X:ORHE |x Aggregator |z lizenzpflichtig |3 Volltext |
| 912 | |a ZDB-30-ORH | ||
| 912 | |a ZDB-30-ORH | ||
| 951 | |a BO | ||
| 912 | |a ZDB-30-ORH | ||
| 049 | |a DE-91 | ||
Datensatz im Suchindex
| DE-BY-TUM_katkey | ZDB-30-ORH-061075809 |
|---|---|
| _version_ | 1821494834891849728 |
| adam_text | |
| any_adam_object | |
| author | Kellenberger, Kathi Everest, Lee |
| author_facet | Kellenberger, Kathi Everest, Lee |
| author_role | aut aut |
| author_sort | Kellenberger, Kathi |
| author_variant | k k kk l e le |
| building | Verbundindex |
| bvnumber | localTUM |
| collection | ZDB-30-ORH |
| ctrlnum | (DE-627-1)061075809 (DE-599)KEP061075809 (ORHE)9781484266069 |
| dewey-full | 004.165 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 004 - Computer science |
| dewey-raw | 004.165 |
| dewey-search | 004.165 |
| dewey-sort | 14.165 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | 4th ed. 2021. |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>03973cam a22005292 4500</leader><controlfield tag="001">ZDB-30-ORH-061075809</controlfield><controlfield tag="003">DE-627-1</controlfield><controlfield tag="005">20240228121319.0</controlfield><controlfield tag="007">cr uuu---uuuuu</controlfield><controlfield tag="008">210118s2021 xx |||||o 00| ||eng c</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1484266064</subfield><subfield code="9">1-4842-6606-4</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781484266069</subfield><subfield code="9">978-1-4842-6606-9</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)061075809</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)KEP061075809</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ORHE)9781484266069</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)061075809</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-627</subfield><subfield code="b">ger</subfield><subfield code="c">DE-627</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1=" " ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">UMP.</subfield><subfield code="2">bicssc</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM051380.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">004.165</subfield><subfield code="2">23</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Kellenberger, Kathi.</subfield><subfield code="e">VerfasserIn</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Beginning T-SQL</subfield><subfield code="b">A Step-by-Step Approach</subfield><subfield code="c">by Kathi Kellenberger, Lee Everest</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">4th ed. 2021.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Berkeley, CA</subfield><subfield code="b">Apress</subfield><subfield code="c">2021</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Berkeley, CA</subfield><subfield code="b">Imprint: Apress</subfield><subfield code="c">2021</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (XXIX, 706 Seiten 350 illus.)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">Text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">Computermedien</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">Online-Ressource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Get a performance-oriented introduction to the T-SQL language underlying the Microsoft SQL Server and Azure SQL database engines. This fourth edition is updated to include SQL Notebooks as well as up-to-date syntax and features for T-SQL on-premises and in the Azure cloud. Exercises and examples now include the WideWorldImporters database, the newest sample database from Microsoft for SQL Server. Also new in this edition is coverage of JSON from T-SQL, news about performance enhancements called Intelligent Query Processing, and an appendix on running SQL Server in a container on macOS or Linux. Beginning T-SQL starts you on the path to mastering T-SQL with an emphasis on best practices. Using the sound coding techniques taught in this book will lead to excellent performance in the queries that you write in your daily work. Important techniques such as windowing functions are covered to help you write fast-executing queries that solve real business problems.The book begins with an introduction to databases, normalization, and to setting up your learning environment. You will learn about the tools you need to use such as SQL Server Management Studio, Azure Data Studio, and SQL Notebooks. 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. 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, including the new Intelligent Query Processing features that make queries faster without changing code. They will help you avoid beginner mistakes by knowing about and thinking about performance from day 1. You will: Install a sandboxed SQL Server instance for learning Understand how relational databases are designed Create objects such as tables and stored procedures Query a SQL Server table Filter and order the results of a query Query and work with specialized data types such as XML and JSON Apply modern features such as window functions Choose correct techniques so that your queries perform well.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Microsoft software</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Microsoft .NET Framework</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database management</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Microsoft and .NET</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database Management</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Logiciels Microsoft</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Bases de données ; Gestion</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database management</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Microsoft software</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Everest, Lee.</subfield><subfield code="e">VerfasserIn</subfield><subfield code="4">aut</subfield></datafield><datafield tag="776" ind1="1" ind2=" "><subfield code="z">1484266056</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="z">1484266056</subfield></datafield><datafield tag="966" ind1="4" ind2="0"><subfield code="l">DE-91</subfield><subfield code="p">ZDB-30-ORH</subfield><subfield code="q">TUM_PDA_ORH</subfield><subfield code="u">https://learning.oreilly.com/library/view/-/9781484266069/?ar</subfield><subfield code="m">X:ORHE</subfield><subfield code="x">Aggregator</subfield><subfield code="z">lizenzpflichtig</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="951" ind1=" " ind2=" "><subfield code="a">BO</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-91</subfield></datafield></record></collection> |
| id | ZDB-30-ORH-061075809 |
| illustrated | Not Illustrated |
| indexdate | 2025-01-17T11:20:41Z |
| institution | BVB |
| isbn | 1484266064 9781484266069 |
| language | English |
| open_access_boolean | |
| owner | DE-91 DE-BY-TUM |
| owner_facet | DE-91 DE-BY-TUM |
| physical | 1 Online-Ressource (XXIX, 706 Seiten 350 illus.) |
| psigel | ZDB-30-ORH TUM_PDA_ORH ZDB-30-ORH |
| publishDate | 2021 |
| publishDateSearch | 2021 |
| publishDateSort | 2021 |
| publisher | Apress Imprint: Apress |
| record_format | marc |
| spelling | Kellenberger, Kathi. VerfasserIn aut Beginning T-SQL A Step-by-Step Approach by Kathi Kellenberger, Lee Everest 4th ed. 2021. Berkeley, CA Apress 2021 Berkeley, CA Imprint: Apress 2021 1 Online-Ressource (XXIX, 706 Seiten 350 illus.) Text txt rdacontent Computermedien c rdamedia Online-Ressource cr rdacarrier Get a performance-oriented introduction to the T-SQL language underlying the Microsoft SQL Server and Azure SQL database engines. This fourth edition is updated to include SQL Notebooks as well as up-to-date syntax and features for T-SQL on-premises and in the Azure cloud. Exercises and examples now include the WideWorldImporters database, the newest sample database from Microsoft for SQL Server. Also new in this edition is coverage of JSON from T-SQL, news about performance enhancements called Intelligent Query Processing, and an appendix on running SQL Server in a container on macOS or Linux. Beginning T-SQL starts you on the path to mastering T-SQL with an emphasis on best practices. Using the sound coding techniques taught in this book will lead to excellent performance in the queries that you write in your daily work. Important techniques such as windowing functions are covered to help you write fast-executing queries that solve real business problems.The book begins with an introduction to databases, normalization, and to setting up your learning environment. You will learn about the tools you need to use such as SQL Server Management Studio, Azure Data Studio, and SQL Notebooks. 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. 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, including the new Intelligent Query Processing features that make queries faster without changing code. They will help you avoid beginner mistakes by knowing about and thinking about performance from day 1. You will: Install a sandboxed SQL Server instance for learning Understand how relational databases are designed Create objects such as tables and stored procedures Query a SQL Server table Filter and order the results of a query Query and work with specialized data types such as XML and JSON Apply modern features such as window functions Choose correct techniques so that your queries perform well. Microsoft software Microsoft .NET Framework Database management Microsoft and .NET Database Management Logiciels Microsoft Bases de données ; Gestion Everest, Lee. VerfasserIn aut 1484266056 Erscheint auch als Druck-Ausgabe 1484266056 |
| spellingShingle | Kellenberger, Kathi Everest, Lee Beginning T-SQL A Step-by-Step Approach Microsoft software Microsoft .NET Framework Database management Microsoft and .NET Database Management Logiciels Microsoft Bases de données ; Gestion |
| title | Beginning T-SQL A Step-by-Step Approach |
| title_auth | Beginning T-SQL A Step-by-Step Approach |
| title_exact_search | Beginning T-SQL A Step-by-Step Approach |
| title_full | Beginning T-SQL A Step-by-Step Approach by Kathi Kellenberger, Lee Everest |
| title_fullStr | Beginning T-SQL A Step-by-Step Approach by Kathi Kellenberger, Lee Everest |
| title_full_unstemmed | Beginning T-SQL A Step-by-Step Approach by Kathi Kellenberger, Lee Everest |
| title_short | Beginning T-SQL |
| title_sort | beginning t sql a step by step approach |
| title_sub | A Step-by-Step Approach |
| topic | Microsoft software Microsoft .NET Framework Database management Microsoft and .NET Database Management Logiciels Microsoft Bases de données ; Gestion |
| topic_facet | Microsoft software Microsoft .NET Framework Database management Microsoft and .NET Database Management Logiciels Microsoft Bases de données ; Gestion |
| work_keys_str_mv | AT kellenbergerkathi beginningtsqlastepbystepapproach AT everestlee beginningtsqlastepbystepapproach |