Sale!

Beginning Microsoft SQL Server 2012 Programming 1st Edition by Paul Atkinson, Robert Vieira ISBN 1118102282 9781118102282

Original price was: $70.00.Current price is: $24.99.

Instant download Beginning Microsoft(r) SQL Server(r) 2012 Programming Paul Atkinson & Robert Vieira after payment

SKU: EB_99282 Category:

Beginning Microsoft SQL Server 2012 Programming 1st Edition by Paul Atkinson, Robert Vieira – Ebook PDF Instant Download/Delivery: 1118102282, 978-1118102282
Full dowload Beginning Microsoft SQL Server 2012 Programming 1st after payment

 

Product details:

ISBN 10: 1118102282
ISBN 13: 978-1118102282
Author: Paul Atkinson, Robert Vieira
Beginning Microsoft SQL Server 2012 Programming 1st Edition: Get up to speed on the extensive changes to the newest release of Microsoft SQL Server
The 2012 release of Microsoft SQL Server changes how you develop applications for SQL Server. With this comprehensive resource, SQL Server authority Robert Vieira presents the fundamentals of database design and SQL concepts, and then shows you how to apply these concepts using the updated SQL Server. Publishing time and date with the 2012 release, Beginning Microsoft SQL Server 2012 Programming begins with a quick overview of database design basics and the SQL query language and then quickly proceeds to show you how to implement the fundamental concepts of Microsoft SQL Server 2012.

You’ll explore the key additions and changes to this newest version, including conditional action constructs, enhanced controls for results paging, application integration with SharePoint and Excel, and development of BI applications.

  • Covers new features such as SQL Azure for cloud computing, client-connectivity enhancements, security and compliance, data replication, and data warehouse performance improvements
  • Addresses essential topics including managing keys, writing scripts, and working with store procedures
  • Shares helpful techniques for creating and changing tables, programming with XML, and using SQL Server Reporting and Integration Services 

Beginning Microsoft SQL Server 2012 Programming demystifies even the most difficult challenges you may face with the new version of Microsoft SQL Server.

 

Beginning Microsoft SQL Server 2012 Programming 1st Table of contents:

1 RDBMS Basics: What Makes Up a SQL Server Database?

  • An Overview of Database Objects
  • SQL Server Data Types
  • SQL Server Identifiers for Objects
  • Summary

2 Learning the Tools of the Trade

  • Getting Help with Books Online
  • SQL Server Configuration Manager
  • SQL Server Management Studio
  • SQL Server Data Tools (formerly BIDS)
  • SQL Server Integration Services (SSIS)
  • SQL Server Reporting Services (SSRS)
  • SQL Server Analysis Services (SSAS)
  • Bulk Copy Program (BCP)
  • SQL Server Profiler
  • sqlcmd
  • PowerShell
  • Summary

3 The Foundation Statements of T-SQL

  • Getting Started with a Basic SELECT Statement
  • Adding Data with the INSERT Statement
  • Changing What You’ve Got with the UPDATE Statement
  • The DELETE Statement
  • Summary

4 Joins

  • Combining Table Data with JOINs
  • Selecting Matching Rows with INNER JOIN
  • Retrieving More Data with OUTER JOIN
  • Seeing Both Sides with FULL JOINs
  • Understanding CROSS JOINs
  • Exploring Alternative Syntax for Joins
  • Stacking Results with UNION
  • Summary

5 Creating and Altering Tables

  • Object Names in SQL Server
  • The CREATE Statement
  • The ALTER Statement
  • The DROP Statement
  • Using the GUI Tool
  • Summary

6 Keys and Constraints

  • Types of Constraints
  • Constraint Naming
  • Key Constraints
  • CHECK Constraints
  • DEFAULT Constraints
  • Disabling Constraints
  • Rules and Defaults — Cousins of Constraints
  • Triggers for Data Integrity
  • Choosing What to Use
  • Summary

7 Adding More to Your Queries

  • What Is a Subquery?
  • Building Correlated Subqueries
  • Derived Tables
  • Using Common Table Expressions (CTEs)
  • Using the EXISTS Operator
  • Mixing Data Types: CAST and CONVERT
  • Synchronizing Data with the MERGE Command
  • Gathering Affected Rows with the OUTPUT Clause
  • Through the Looking Glass: Windowing Functions
  • One Chunk at a Time: Ad Hoc Query Paging
  • Performance Considerations
  • Summary

8 Being Normal: Normalization and Other Basic Design Issues

  • Understanding Tables
  • Keeping Your Data “Normal”
  • Understanding Relationships
  • Diagramming Databases
  • Denormalization
  • Beyond Normalization
  • Drawing Up a Quick Example
  • Summary

9 SQL Server Storage and Index Structures

  • SQL Server Storage
  • Understanding Indexes
  • Creating, Altering, and Dropping Indexes
  • Choosing Wisely: Deciding Which Index Goes Where and When
  • Maintaining Your Indexes
  • Summary

10 Views

  • Creating Simple Views
  • Editing Views with T-SQL
  • Dropping Views
  • Creating and Editing Views in the Management Studio
  • Auditing: Displaying Existing Code
  • Protecting Code: Encrypting Views
  • About Schema Binding
  • Making Your View Look Like a Table with VIEW_METADATA
  • Indexed (Materialized) Views
  • Indexing an Aggregate View
  • Summary

11 Writing Scripts and Batches

  • Understanding Script Basics
  • Grouping Statements into Batches
  • Running from the Command Prompt: sqlcmd
  • Dynamic SQL: Using the EXEC Command
  • Using Control-of-Flow Statements
  • Summary

12 Stored Procedures

  • Creating the Sproc: Basic Syntax
  • Changing Stored Procedures with ALTER
  • Dropping Sprocs
  • Parameterizing Sprocs
  • More on Dealing with Errors
  • What a Sproc Offers
  • Extended Stored Procedures (XPs)
  • A Brief Look at Recursion
  • Debugging
  • Understanding .NET Assemblies
  • When to Use Stored Procedures
  • Summary

13 User-Defined Functions

  • What a UDF Is
  • UDFs Returning a Scalar Value
  • UDFs That Return a Table
  • Debugging User-Defined Functions
  • Using .NET in a Database World
  • Summary

14 Transactions and Locks

  • Understanding Transactions
  • How the SQL Server Log Works
  • Understanding Locks and Concurrency
  • Setting the Isolation Level
  • Dealing with Deadlocks (aka “a 1205”)
  • Summary

15 Triggers

  • What Is a Trigger?
  • Using Triggers for Data Integrity Rules
  • Other Common Uses for Triggers
  • Other Trigger Issues
  • Instead of Triggers
  • Performance Considerations
  • Dropping Triggers
  • Debugging Triggers
  • Summary

16 A Brief XML Primer

  • XML Basics
  • What SQL Server Brings to the Party
  • A Brief Word on XSLT
  • Summary

17 Business Intelligence Fundamentals

  • What Is Business Intelligence?
  • Those Who Forget History: The Data Warehouse
  • Dimensional Modeling: Why Be Normal?
  • ETLs
  • Making Your Data Actionable: BI Reporting Techniques
  • Summary

18 BI Storage and Reporting Resources

  • BI in T-SQL
  • SQL Server Analysis Services, or How I Learned to Stop Worrying and Love the Cube
  • Building Your First Cube
  • Self-Service BI: User Tools
  • Summary

19 Reporting for Duty, Sir! A Look at Reporting Services

  • Reporting Services 101
  • Understanding the SSRS Report Lifecycle
  • Understanding the Reporting Services Architecture
  • Building Simple Report Models
  • Report Server Projects
  • Summary

20 Getting Integrated with Integration Services

  • Understanding the Problem
  • Using the Import/Export Wizard to Generate Basic Packages
  • Examining Package Basics
  • Executing Packages
  • A Final Word on Packages
  • Summary

21 Playing Administrator

  • Scheduling Jobs
  • Logins and Users
  • Backup and Recovery
  • Index Maintenance
  • Policy Based Management
  • Automating Administration Tasks with PowerShell
  • Summary

People also search for Beginning Microsoft SQL Server 2012 Programming 1st:

microsoft sql server beginner’s guide
microsoft sql server 2012 analysis management objects
sql server 2012 setup
microsoft sql server 2012 business intelligence
microsoft sql server 2012 developer

Reviews

There are no reviews yet.

Be the first to review “Beginning Microsoft SQL Server 2012 Programming 1st Edition by Paul Atkinson, Robert Vieira ISBN 1118102282 9781118102282”