Custom cover image
Microsoft SQL Server 2012 bible / by Adam Jorgensen ... [et al.]
Contributor(s): Resource type: Ressourcentyp: Buch (Online)Book (Online)Language: English Series: Bible Ser ; v.773Publisher: Indianapolis, IN : John Wiley & Sons, c2012Edition: Online-AusgDescription: Online-Ressource (1 online resource (1 v.))ISBN:- 9781283550130
- 128355013X
- 9781118286821
- 9781118106877
- SQL Server 2012 bible
- 005.75/85 23
- 005.756;005.7585
- 005.7585
- QA76.9.D3
- QA76.9.C55
Contents:
Summary: Harness the powerful new SQL Server 2012 Microsoft SQL Server 2012 is the most significant update to this product since 2005, and it may change how database administrators and developers perform many aspects of their jobs. If you're a database administrator or developer, Microsoft SQL Server 2012 Bible teaches you everything you need to take full advantage of this major release. This detailed guide not only covers all the new features of SQL Server 2012, it also shows you step by step how to develop top-notch SQL Server databases and new data connections and keep your databases performing at peak. The book is crammed with specific examples, sample code, and a host of tips, workarounds, and best practices. In addition, downloadable code is available from the book's companion web site, which you can use to jumpstart your own projects. Serves as an authoritative guide to Microsoft's SQL Server 2012 for database administrators and developers Covers all the software's new features and capabilities, including SQL Azure for cloud computing, enhancements to client connectivity, and new functionality that ensures high-availability of mission-critical applications Explains major new changes to the SQL Server Business Intelligence tools, such as Integration, Reporting, and Analysis Services Demonstrates tasks both graphically and in SQL code to enhance your learning Provides source code from the companion web site, which you can use as a basis for your own projects Explores tips, smart workarounds, and best practices to help you on the job Get thoroughly up to speed on SQL Server 2012 with Microsoft SQL Server 2012 Bible.Summary: Intro -- Microsoft® SQL Server® 2012 Bible -- Contents -- Part I: Laying the Foundations -- Chapter 1: The World of SQL Server -- SQL Server History -- SQL Server in the Database Market -- SQL Server Components -- Editions of SQL Server 2012 -- Notable SQL Server 2012 Enhancements -- Summary -- Chapter 2: Data Architecture -- Information Architecture Principle -- Database Objectives -- Smart Database Design -- Summary -- Chapter 3: Installing SQL Server -- Preparing the Server -- Selecting the Edition -- The Installation Process -- Summary -- Chapter 4: Client Connectivity -- Enabling Server Connectivity -- SQL Server Native Client Features -- Summary -- Chapter 5: SQL Server Management and Development Tools -- Organizing the Interface -- Registered Servers -- Object Explorer -- Using the Query Editor -- Using the Solution Explorer -- Getting a Jumpstart on Code with Templates and Code Snippets -- Summary -- Part II: Building Databases and Working with Data -- Chapter 6: Introducing Basic Query Flow -- Understanding Query Flow -- FROM Clause Data Sources -- WHERE Conditions -- (0 row(s) affected)Columns, Stars, Aliases, and Expressions -- Ordering the Result Set -- Select Distinct -- TOP () -- Summary -- Chapter 7: Relational Database Design and Creating the Physical Database Schema -- Database Basics -- Data Design Patterns -- Normal Forms -- Strategy Considerations -- Summary -- Chapter 8: Data Types, Expressions, and Scalar Functions -- Data Types -- Building Expressions -- Scalar Functions -- String Functions -- Soundex Functions -- Data-Type Conversion Functions -- Server Environment Information -- Summary -- Chapter 9: Merging Data with Joins, Subqueries, and CTEs -- Using Joins -- Set Difference Queries -- Using Unions -- Subqueries -- Summary -- Chapter 10: Aggregating, Windowing, and Ranking Data -- Aggregating Data.PPN: PPN: 80984785XPackage identifier: Produktsigel: ZDB-26-MYL | ZDB-30-PAD | ZDB-30-PQE | ZDB-38-EBR
Microsoft® SQL Server® 2012 Bible; Contents; Part I: Laying the Foundations; Chapter 1: The World of SQL Server; SQL Server History; SQL Server in the Database Market; SQL Server Components; Editions of SQL Server 2012; Notable SQL Server 2012 Enhancements; Summary; Chapter 2: Data Architecture; Information Architecture Principle; Database Objectives; Smart Database Design; Summary; Chapter 3: Installing SQL Server; Preparing the Server; Selecting the Edition; The Installation Process; Summary; Chapter 4: Client Connectivity; Enabling Server Connectivity; SQL Server Native Client Features
SummaryChapter 5: SQL Server Management and Development Tools; Organizing the Interface; Registered Servers; Object Explorer; Using the Query Editor; Using the Solution Explorer; Getting a Jumpstart on Code with Templates and Code Snippets; Summary; Part II: Building Databases and Working with Data; Chapter 6: Introducing Basic Query Flow; Understanding Query Flow; FROM Clause Data Sources; WHERE Conditions; (0 row(s) affected)Columns, Stars, Aliases, and Expressions; Ordering the Result Set; Select Distinct; TOP (); Summary
Chapter 7: Relational Database Design and Creating the Physical Database SchemaDatabase Basics; Data Design Patterns; Normal Forms; Strategy Considerations; Summary; Chapter 8: Data Types, Expressions, and Scalar Functions; Data Types; Building Expressions; Scalar Functions; String Functions; Soundex Functions; Data-Type Conversion Functions; Server Environment Information; Summary; Chapter 9: Merging Data with Joins, Subqueries, and CTEs; Using Joins; Set Difference Queries; Using Unions; Subqueries; Summary; Chapter 10: Aggregating, Windowing, and Ranking Data; Aggregating Data
Grouping Within a Result SetWindowing and Ranking; Ranking Functions; Summary; Chapter 11: Projecting Data Through Views; Why Use Views?; The Basic View; A Broader Point of View; Locking Down the View; Using SQL Synonyms; Summary; Chapter 12: Modifying Data In SQL Server; Inserting Data; Updating Data; Deleting Data; Merging Data; Returning Modified Data; Summary; Part III: Advanced T-SQL Data Types and Querying Techniques; Chapter 13: Working with Hierarchies; HierarchyID; HierarchyID Methods; Indexing Strategies; Hierarchical Data Alternatives; Summary; Chapter 14: Using XML Data
The XML Data TypeXML Data Type Methods; FOR XML; XQuery and FLWOR Operations; Summary; Chapter 15: Executing Distributed Queries; Distributed Query Overview; Developing Distributed Queries; Performance Consideration; Summary; Part IV: Programming with T-SQL; Chapter 16: Programming with T-SQL; Transact-SQL Fundamentals; Working with Variables; Procedural Flow; Examining SQL Server with Code; Temporary Tables and Table Variables; What's New in T-SQL for 2012; Error Handling; Bulk Operations; Summary; Chapter 17: Developing Stored Procedures; Managing Stored Procedures
Passing Data to Stored Procedures
No physical items for this record