Microsoft SQL Server 2012 Administration: Real-World Skills for MCSA Certification and Beyond (Exams 70-461, 70-462, and 70-463)
Höfundur: Tom Carpenter
6.290 kr.
Lýsing:
Implement, maintain, and repair SQL Server 2012 databases As the most significant update since 2008, Microsoft SQL Server 2012 boasts updates and new features that are critical to understand. Whether you manage and administer SQL Server 2012 or are planning to get your MCSA: SQL Server 2012 certification, this book is the perfect supplement to your learning and preparation. From understanding SQL Server's roles to implementing business intelligence and reporting, this practical book explores tasks and scenarios that a working SQL Server DBA faces regularly and shows you step by step how to handle them.
Includes practice exams and coverage of exam objectives for those seeking MSCA: SQL Server 2012 certification Explores the skills you'll need on the job as a SQL Server 2012 DBA Discusses designing and implementing database solutions Walks you through administrating, maintaining, and securing SQL Server 2012 Addresses implementing high availability and data distribution Includes bonus videos where the author walks you through some of the more difficult tasks expected of a DBA Featuring hands-on exercises and real-world scenarios, this resource guides you through the essentials of implementing, maintaining, and repairing SQL Server 2012 databases.
Annað
- Höfundur: Tom Carpenter
- Útgáfa:1
- Útgáfudagur: 2013-06-03
- Hægt að prenta út 2 bls.
- Hægt að afrita 10 bls.
- Format:ePub
- ISBN 13: 9781118654903
- Print ISBN: 9781118487167
- ISBN 10: 1118654900
Efnisyfirlit
- Cover
- Contents
- Title page
- Copyright
- Dedication
- Acknowledgments
- About the Author
- Table of Exercises
- Introduction
- Who Should Read This Book
- What Is Covered in This Book
- How to Contact the Author
- Part I: Introducing SQL Server 2012
- Chapter 1: Understanding SQL Server’s Role
- What Is Information Technology?
- Introduction to Databases
- Database Servers and Applications
- SQL Server’s Role
- Summary
- Chapter Essentials
- Chapter 2: Installing SQL Server 2012
- Installation Planning
- Installing a Default Instance
- Installing Named Instances
- Installing to a Cluster
- Installing Extra Features
- Upgrading from Previous Versions
- Validating an Installation
- Removing an Installation
- Summary
- Chapter Essentials
- Chapter 3: Working with the Administration Tools
- SQL Server Configuration Manager
- SQL Server Management Studio
- SQL Server Data Tools
- SQL Server Profiler
- Books Online
- Windows Server Administration for the DBA
- Summary
- Chapter Essentials
- Chapter 4: SQL Server Command-Line Administration
- Introducing the Command Prompt
- General Commands
- Batch Files
- Mastering SQLCMD
- Introducing Windows PowerShell
- Using SQL Server PowerShell Extensions
- Summary
- Chapter Essentials
- Chapter 5: Querying SQL Server
- Understanding the SQL Language
- SQL Statement Types
- SQL Syntactical Elements
- Coding Recommendations
- Using SELECT Statements
- Advanced Query Techniques
- Using DDL Statements
- Using DCL Statements
- Modifying Data
- Tuning and Optimizing Queries
- Summary
- Chapter Essentials
- Chapter 1: Understanding SQL Server’s Role
- Chapter 6: Database Concepts and Terminology
- Relational Database Theory
- Database Design Processes
- Project Management for the DBA
- Summary
- Chapter Essentials
- Chapter 7: ERD and Capacity Planning
- Planning a Database
- Understanding Entity Relationship Diagramming
- Building an ERD
- Capacity Planning
- Summary
- Chapter Essentials
- Chapter 8: Normalization and Other Design Issues
- Designing for Normalization
- Designing for Performance
- Designing for Availability
- Designing for Security
- Summary
- Chapter Essentials
- Chapter 9: Creating SQL Server Databases
- SQL Server Databases
- Database Storage
- Database Options and Properties
- Creating Databases in the GUI
- Creating Databases with T-SQL
- Creating Databases with PowerShell
- Attaching and Detaching Databases
- Database Snapshots
- Summary
- Chapter Essentials
- Chapter 10: Creating Tables
- Data Types
- Collations
- Table Creation Process
- Data Partitioning
- Summary
- Chapter Essentials
- Chapter 11: Indexes and Views
- Understanding Indexes
- Creating Basic Indexes
- Creating Advanced Indexes
- Managing Indexes
- Understanding Views
- Creating Views
- Summary
- Chapter Essentials
- Chapter 12: Triggers and Stored Procedures
- Triggers Defined
- Using Triggers
- Creating Triggers
- Understanding Stored Procedures
- Creating Stored Procedures
- Summary
- Chapter Essentials
- Chapter 13: Implementing Advanced Features
- Understanding and Installing Analysis Services
- Understanding Integration Services
- Understanding and Installing Reporting Services
- Implementing Database Mail
- Configuring Full-Text Indexing
- Implementing Transparent Data Encryption
- Data Compression
- Summary
- Chapter Essentials
- Chapter 14: Creating Jobs, Operators, and Alerts
- Standardize, Automate, and Update
- Understanding SQL Server Jobs
- Creating T-SQL Jobs
- Creating SSIS Jobs
- Creating Windows Command Jobs
- Creating and Using Operators
- Creating and Using Alerts
- Using WSUS for SQL Server 2012
- Summary
- Chapter Essentials
- Chapter 15: Performance Monitoring and Tuning
- Performance Tuning Principles
- Performance and Troubleshooting Tools
- Blocks, Locks, and Deadlocks
- SQL Server Profiler
- Database Engine Tuning Advisor
- Performance Monitoring with System Monitor
- Using the Resource Governor
- Performance Studio
- Advanced Monitoring Tools
- Summary
- Chapter Essentials
- Chapter 16: Policy-Based Management
- Policy-Based Management
- Centralized Server Management
- Standardizing with PBM and CMS
- Summary
- Chapter Essentials
- Chapter 17: Backup and Restoration
- Backing Up a Database
- Backing Up System Databases
- Restoring a Database
- Backing Up the Environment
- Summary
- Chapter Essentials
- Chapter 18: Security Threats and Principles
- Security Defined
- Security Threats
- Security Principles
- Summary
- Chapter Essentials
- Chapter 19: Authentication and Encryption
- Understanding Authentication
- SQL Server Authentication Methods
- Logins, Users, and Roles
- Understanding Encryption
- Summary
- Chapter Essentials
- Chapter 20: Security Best Practices
- Establishing Baselines
- Implementing Least Privilege
- Auditing SQL Server Activity
- Configuring the Surface Area
- Understanding Common Criteria and C2
- Summary
- Chapter Essentials
- Chapter 21: AlwaysOn and High Availability
- Introducing AlwaysOn Technology
- Mirroring and AlwaysOn
- Failover Solutions
- Selecting Hardware for AlwaysOn
- Summary
- Chapter Essentials
- Chapter 22: SQL Server Failover Clustering
- Understanding Windows Failover Clustering Service
- Implementing a Windows Cluster
- Installing SQL Server 2012 to a Cluster
- Monitoring and Managing a SQL Server Cluster
- Summary
- Chapter Essentials
- Chapter 23: Database Mirroring and Snapshots
- RAID-based Data Redundancy
- Using Database Mirroring
- Understanding Log Shipping
- Implementing Database Snapshots
- Summary
- Chapter Essentials
- Chapter 24: Implementing Replication
- SQL Server Replication
- Importing and Exporting Data
- Summary
- Chapter Essentials
- Chapter 25: Data Warehousing
- Understanding Data Warehouses
- Implementing Fact Tables
- Implementing Dimensions
- Summary
- Chapter Essentials
- Chapter 26: SQL Server Integration Services
- Integration Issues
- Installing SSIS
- Configuring SSIS Security Settings
- Deploying Packages
- SSIS Auditing and Event Handling
- Extracting, Transforming, and Loading Data
- Summary
- Chapter Essentials
- Chapter 27: Data Quality Solutions
- Understanding Data Quality Concerns
- Installing Data Quality Services
- Using Master Data Services
- Cleaning Data
- Summary
- Chapter Essentials
- Appendix A: Microsoft’s Certification Program
- How Do You Become Certified on SQL Server 2012?
- Tips for Taking a Microsoft Exam
- Certification Objectives Map
- Appendix B: About the Additional Study Tools
- Additional Study Tools
- System Requirements
- Using the Study Tools
- Troubleshooting
UM RAFBÆKUR Á HEIMKAUP.IS
Bókahillan þín er þitt svæði og þar eru bækurnar þínar geymdar. Þú kemst í bókahilluna þína hvar og hvenær sem er í tölvu eða snjalltæki. Einfalt og þægilegt!Rafbók til eignar
Rafbók til eignar þarf að hlaða niður á þau tæki sem þú vilt nota innan eins árs frá því bókin er keypt.
Þú kemst í bækurnar hvar sem er
Þú getur nálgast allar raf(skóla)bækurnar þínar á einu augabragði, hvar og hvenær sem er í bókahillunni þinni. Engin taska, enginn kyndill og ekkert vesen (hvað þá yfirvigt).
Auðvelt að fletta og leita
Þú getur flakkað milli síðna og kafla eins og þér hentar best og farið beint í ákveðna kafla úr efnisyfirlitinu. Í leitinni finnur þú orð, kafla eða síður í einum smelli.
Glósur og yfirstrikanir
Þú getur auðkennt textabrot með mismunandi litum og skrifað glósur að vild í rafbókina. Þú getur jafnvel séð glósur og yfirstrikanir hjá bekkjarsystkinum og kennara ef þeir leyfa það. Allt á einum stað.
Hvað viltu sjá? / Þú ræður hvernig síðan lítur út
Þú lagar síðuna að þínum þörfum. Stækkaðu eða minnkaðu myndir og texta með multi-level zoom til að sjá síðuna eins og þér hentar best í þínu námi.
Fleiri góðir kostir
- Þú getur prentað síður úr bókinni (innan þeirra marka sem útgefandinn setur)
- Möguleiki á tengingu við annað stafrænt og gagnvirkt efni, svo sem myndbönd eða spurningar úr efninu
- Auðvelt að afrita og líma efni/texta fyrir t.d. heimaverkefni eða ritgerðir
- Styður tækni sem hjálpar nemendum með sjón- eða heyrnarskerðingu
- Gerð : 208
- Höfundur : 11849
- Útgáfuár : 2013
- Leyfi : 379
