Beginning T-SQL [[electronic resource] /] / by Kathi Kellenberger, Scott Shaw |
Autore | Kellenberger Kathi |
Edizione | [3rd ed. 2014.] |
Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2014 |
Descrizione fisica | 1 online resource (480 p.) |
Disciplina |
004
005.74 |
Collana | The expert's voice in SQL server |
Soggetto topico |
Database management
Data structures (Computer science) Database Management Data Structures and Information Theory |
ISBN | 1-4842-0046-2 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Contents at a Glance; Chapter 1: Getting Started; Installing SQL Server Express Edition; Installing Books Online; Using Books Online; Using SQL Server Management Studio; Launching SQL Server Management Studio; Installing the Sample Databases; Get Started with SSMS; Summary; Chapter 2: Exploring Database Concepts; What Is SQL Server?; Databases in the Cloud; Service vs. Application; Database as Container; Data Is Stored in Tables; Data Types; Normalization; Understanding Indexes; Database Schemas; Summary; Chapter 3: Writing Simple SELECT Queries; Using the SELECT Statement
Selecting a Literal ValueRetrieving from a Table; Generating a Select-List; Mixing Literals and Column Names; Filtering Data; Adding a WHERE Clause; Using WHERE Clauses with Alternate Operators; Using BETWEEN; Using BETWEEN with NOT; Filtering on Date and Time; Using WHERE Clauses with Two Predicates; Using the IN Operator; Working with NULL; Sorting Data; Thinking About Performance; Taking Advantage of Indexes; Viewing Execution Plans; Summary; Answers to the Exercises; Solutions to Exercise 3-1: Using the SELECT Statement; Solutions to Exercise 3-2: Filtering Data Solutions to Exercise 3-3: Using WHERE Clauses with Two PredicatesSolutions to Exercise 3-4: Working with NULL; Solutions to Exercise 3-5: Sorting Data; Chapter 4: Using Built-In 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; Using String Functions; RTRIM and LTRIM; LEFT and RIGHT; LEN and DATALENGTH; CHARINDEX; SUBSTRING; CHOOSE; REVERSE; UPPER and LOWER; REPLACE; Nesting Functions; Using Date and Time Functions GETDATE and SYSDATETIMEDATEADD; DATEDIFF; DATENAME and DATEPART; DAY, MONTH, and YEAR; CONVERT; FORMAT; DATEFROMPARTS; EOMONTH; Using Mathematical Functions; ABS; POWER; SQUARE and SQRT; ROUND; RAND; Logical Functions and Expressions; The CASE Expression; Simple CASE; Searched CASE; Listing a Column as the Return Value; IIF; COALESCE; Administrative Function s; Using Functions in the WHERE and ORDER BY Clauses; The TOP Keyword; Thinking About Performance; Summary; Answers to the Exercises; Solutions to Exercise 4-1: Expressions Using Operators Solutions to Exercise 4-2: Using Mathematical OperatorsSolution to Exercise 4-3: Using Functions; Solution to Exercise 4-4: Using Date and Time Functions; Solution to Exercise 4-5: Using Mathematical Functions; Solution to Exercise 4-6: Using Logical and System Functions; Solution to Exercise 4-7: Using Functions in the WHERE and ORDER BY Clauses; Chapter 5: Joining Tables; Using INNER JOIN; 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; Using OUTER JOIN; Using LEFT OUTER JOIN Using RIGHT OUTER JOIN |
Record Nr. | UNINA-9910300660203321 |
Kellenberger Kathi | ||
Berkeley, CA : , : Apress : , : Imprint : Apress, , 2014 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Pro T-SQL Programmer's Guide [[electronic resource] /] / by Jay Natarajan, Rudi Bruchez, Michael Coles, Scott Shaw, Miguel Cebollero |
Autore | Natarajan Jay |
Edizione | [4th ed. 2015.] |
Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2015 |
Descrizione fisica | 1 online resource (727 p.) |
Disciplina |
005.75
005.75/6 |
Collana | The expert's voice in SQL server Pro T-SQL programmer's guide |
Soggetto topico |
Database management
Database Management |
ISBN | 1-4842-0145-0 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
""Contents at a Glance""; ""Contents""; ""About the Authors""; ""About the Technical Reviewer""; ""Acknowledgments""; ""Introduction""; ""Chapter 1: Foundations of T-SQL""; ""A Short History of T-SQL""; ""Imperative vs. Declarative Languages""; ""SQL Basics""; ""Statements""; ""Databases""; ""Transaction Logs""; ""Schemas""; ""Tables""; ""Views""; ""Indexes""; ""Stored Procedures""; ""User-Defined Functions""; ""SQL CLR Assemblies""; ""Elements of Style""; ""Whitespace""; ""Naming Conventions""; ""One Entry, One Exit""; ""Defensive Coding""; ""The SELECT * Statement""
""Variable Initialization""""Summary""; ""Chapter 2: Tools of the Trade""; ""SQL Server Management Studio""; ""IntelliSense""; ""Code Snippets""; ""Keyboard Shortcut Schemes""; ""T-SQL Debugging""; ""SSMS Editing Options""; ""Context-Sensitive Help""; ""Graphical Query Execution Plans""; ""Project-Management Features""; ""The Object Explorer""; ""The SQLCMD Utility""; ""SQL Server Data Tools""; ""SQL Profiler""; ""Extended Events""; ""SQL Server Integration Services""; ""The Bulk Copy Program""; ""SQL Server 2014 Books Online""; ""The AdventureWorks Sample Database""; ""Summary"" ""Chapter 3: Procedural Code""""Three-Valued Logic""; ""Control-of-Flow Statements""; ""The BEGIN and END Keywords""; ""The IF...ELSE Statement""; ""The WHILE, BREAK, and CONTINUE Statements""; ""The GOTO Statement""; ""The WAITFOR Statement""; ""The RETURN Statement""; ""The CASE Expression""; ""The Simple CASE Expression""; ""The Searched CASE Expression""; ""CASE and Pivot Tables""; ""The IIF Statement""; ""CHOOSE""; ""COALESCE and NULLIF""; ""Cursors""; ""Summary""; ""Chapter 4: User-Defined Functions""; ""Scalar Functions""; ""Recursion in Scalar User-Defined Functions"" ""Procedural Code in User-Defined Functions""""Multistatement Table-Valued Functions""; ""Inline Table-Valued Functions""; ""Restrictions on User-Defined Functions""; ""Nondeterministic Functions""; ""State of the Database""; ""Summary""; ""Chapter 5: Stored Procedures""; ""Introducing Stored Procedures""; ""Metadata Discovery""; ""Natively Compiled Stored Procedures""; ""Managing Stored Procedures""; ""Stored Procedures Best Practices""; ""Stored Procedure Example""; ""Recursion in Stored Procedures""; ""Table-Valued Parameters""; ""Temporary Stored Procedures"" ""Recompilation and Caching""""Stored Procedure Statistics""; ""Parameter Sniffing""; ""Recompilation""; ""Summary""; ""Chapter 6: In-Memory Programming""; ""The Drivers for In-Memory Technology""; ""Hardware Trends""; ""Getting Started with In-Memory Objects""; ""Step 1: Add a New Memory-Optimized Data FILEGROUP""; ""Step 2: Add a New Memory-Optimized Container""; ""Step 3: Create Your New Memory-Optimized Table""; ""Limitations on Memory-Optimized Tables""; ""In-Memory OLTP Table Indexes""; ""Hash Indexes""; ""Range Indexes""; ""Natively Compiled Stored Procedures""; ""Chapter 7: Triggers"" ""DML Triggers"" |
Record Nr. | UNINA-9910300637903321 |
Natarajan Jay | ||
Berkeley, CA : , : Apress : , : Imprint : Apress, , 2015 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|