Microsoft SQL Server 2012 Bible

If you're a database administrator or developer, this book is your complete, one-stop resource for SQL Server 2012. The authors provide in-depth coverage of core techniques, best practices, and smart workarounds, as well as plenty of examples and sample code. They also fully cover such new features as AlwwaysOn connectivity, new indexes, Power View, Master Data Services, Data Quality Services, PowerPivot for SQL Server 2012, and more. 

- Thoroughly explore all new features in SQL Server 2012 
- Understand advanced T-SQL data types and querying techniques 
- Ensure high availability for mission-critical applications 
- Start using SQL Azure for cloud computing 
- Master new security and compliance settings 
- Leverage your data with tools for BI, data warehousing, and Enterprise Information Management solutions 
- Get up to speed on the latest enhancements to the BI toolset

Disponibilidade: Disponível

155,28 US$
Microsoft

E-mail

telefonico

whatsapp

skype

viber

compras

Descrição do Produto

Detalhes

Adam Jorgesen, Jorge Segarra, Patrick Leblanc

Boek, paperback / 1384 blz.
Engelstalig
Wiley / 1e druk / 2012
ISBN-13: 9781118106877
 
 
Introduction 

Part 1: Laying the Foundations
1. The World of SQL Server 
2. Data Architecture 
3. Installing SQL Server 
4. Client Connectivity 
5. SQL Server Management and Development Tools 

Part 2: Building Databases and Working with Data 
6. Introducing Basic Query Flow 
7. Relational Database Design and Creating the Physical Database Schema 
8. Data Types, Expressions, and Scalar Functions 
9. Merging Data with Joins, Subqueries, and CTEs 
10. Aggregating, Windowing, and Ranking Data 
11. Projecting Data Through Views 
12. Modifying Data In SQL Server 

Part 3: Advanced T-SQL Data Types and Querying Techniques
13. Working with Hierarchies 
14. Using XML Data 
15. Executing Distributed Queries 

Part 4: Programming with T-SQL 
16. Programming with T-SQL 
17. Developing Stored Procedures 
18. Building User-Defined Functions 

Part 5: Enterprise Data Management
19. Configuring SQL Server 
20. Policy Based Management 
21. Backup and Recovery Planning 
22. Maintaining the Database 
23. Transferring Databases 
24. Database Snapshots 
25. Asynchronous Messaging with Service Broker 
26. Log Shipping 
27. Database Mirroring 
28. Replicating Data 
29. Clustering 
30. Configuring and Managing SQL Server with PowerShell 
31. Managing Data in Windows Azure SQL Database 

Part 6: Securing Your SQL Server 
32. Authentication Types in SQL Server 
33. Authorizing Securables 
34. Data Encryption 
35. Row-Level Security 

Part 7: Monitoring and Auditing
36. Creating Triggers 
37. Performance Monitor and PAL 
38. Using Profiler and SQL Trace 
39. Wait States 
40. Extended Events 
41. Data Change Tracking and Capture 
42. SQL Audit 
43. Management Data Warehouse 

Part 8: Performance Tuning and Optimization
44. Interpreting Query Execution Plans 
45. Indexing Strategies 
46. Maximizing Query Plan Reuse 
47. Managing Transactions, Locking, and Blocking 
48. Data Compression 
49. Partitioning 
50. Resource Governor 

Part 9: Business Intelligence 
51. Business Intelligence Database Design 
52. Building, Deploying, and Managing ETL Workflows in Integration Services 
53. Building Multidimensional Cubes in Analysis Services with MDX 
54. Configuring and Administering Analysis Services 
55. Authoring Reports in Reporting Services 
56. Configuring and Administering Reporting Services 
57. Data Mining with Analysis Services 
58. Creating and Deploying BI Semantic Models 
59. Creating and Deploying Power View Reports

Características do Produto

Características do Produto

Espeficações N/D
Fabricante Microsoft

Análises

Escreva a sua análise

A sua análise: Microsoft SQL Server 2012 Bible

Etiquetas de Produtos

Etiquetas de Produtos

Utilize um espaço para separar as etiquetas. Utilize aspas simples (') para frases.

Facebook