Beginning T-SQL 2012
Beginning T-SQL 2012 is the first step toward learning the T-SQL language that underlies Microsoft’s 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 sto...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
[New York] :
Apress
c2012.
|
| Edición: | 2nd ed. 2012. |
| Colección: | The expert's voice in databases
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629443206719 |
Tabla de Contenidos:
- Title Page; Copyright Page; Dedication Page; Contents at a Glance; Table of Contents; Foreword; About the Authors; About the Technical Reviewer; Acknowledgments; Introduction; CHAPTER 1 Getting Started; Installing SQl Server Express Edition; Installing the Sample Databases; Installing Books Online; Using Books Online; Using SQl Server Management Studio; Launching SQLServer Management Studio; Running Queries; Exploring Database Concepts; What Is SQL Server?; Editions; Service vs. Application; Database As Container; Data Is Stored in Tables; Data Types; Normalization; Understanding Indexes
- Database SchemasSummary; CHAPTER 2 Writing Simple SELECT Queries; Using the SELECT Statement; Selecting a Literal Value; Retrieving from a Table; Generating a Select-List; Mixing Literals and Column Names; Filtering Data; Adding a WHERE Clause; Using WHEREClauses with Alternate Operators; Using BETWEEN; Using NOT BETWEEN; Filtering On Date and Time; Pattern Matching with LIKE; Restricting the Characters in Pattern Matches; Combining Wildcards; Using WHERE Clauses with Two Predicates; Using WHERE Clauses with Three or More Predicates; Using NOT with Parentheses; Using the IN Operator
- Working with NothingPerforming a Full-Text Search; Using CONTAINS; Using Multiple Terms with CONTAINS; Searching Multiple Columns; Using FREETEXT; Sorting Data; Thinking About Performance; Taking Advantage of Indexes; Viewing Execution Plans; Summary; CHAPTER 3 Using 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; Data Type Precedence; Using Functions; Using String Functions; RTRIM and LTRIM; LEFT and RIGHT; LEN and DATALENGTH
- CHARINDEXSUBSTRING; CHOOSE; REVERSE; UPPER and LOWER; REPLACE; Nesting Functions; Using Date Functions; GETDATE and SYSDATETIME; DATEADD; DATEDIFF; DATENAME and DATEPART; DAY, MONTH, and YEAR; CONVERT; FORMAT; Using Mathematical Functions; ABS; POWER; SQUARE and SQRT; ROUND; RAND; System Functions; The CASE Function; Simple CASE; Searched CASE; Listing a Column as the Return Value; IIF; COALESCE; Admin Functions; Using Functions in the WHERE and ORDERBY Clauses; The TOP Keyword; Ranking Functions; Using ROW_NUMBER; Using RANK and DENSE_RANK; Using NTILE; Thinking About Performance
- Using Functions in the WHERE ClauseSummary; CHAPTER 4 Querying Multiple Tables; Writing INNER JOINS; 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; Writing Outer Joins; Using LEFT OUTER JOIN; Using RIGHT OUTER JOIN; Using OUTER JOIN to Find Rows with No Match; Adding a Table to the Right Side of a Left Join; Adding a Table to the Left Side of a Left Join; FULL OUTER JOIN; CROSS JOIN; Self-Joins; Writing Subqueries; Using a Sub query in an IN List; Using a Subquery and NOT IN
- Using a Subquery Containing NULLwith NOT IN
