Microsoft SQL server 2012 administration [[electronic resource] ] : real-world skills for mcsa certification and beyond / / Tom Carpenter

• Record Nr.: UNINA9910792297603321
• Autore: Carpenter Tom
• Pubbl/distr/stampa: Indianapolis, Ind., : Sybex, c2013
• ISBN: 1-118-65473-0
• Edizione: [1st edition]
• Descrizione fisica: 1 online resource (938 p.)
• Disciplina: 005.7585
• Soggetti: Database management - Examinations; Electronic data processing personnel - Certification
• Lingua di pubblicazione: Inglese
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Note generali: Includes index.
• Nota di contenuto: Cover; Copyright; Acknowledgments; About the Author; Contents at a Glance; Contents; Table of Exercises; Introduction; Who Should Read This Book; What You Will Learn; What You Need; Suggested Home Lab Setup; What Is Covered in This Book; Additional Study Tools; How to Contact the Author; Part I: Introducing SQL Server 2012; Chapter 1: Understanding SQL Server's Role; What Is Information Technology?; The Importance of IT; The Components of IT; Introduction to Databases; Types of Databases; Weighing the Benefits of Using a Local or Server-Based Database; Important Database Terms; Database Servers and Applications Database Application Types; SQL Server's Role; New Features Introduced in SQL Server 2012; Features Introduced in SQL Server 2008; Features Introduced in SQL Server 2005; Core Features of SQL Server; SQL Server Roles; Summary; Chapter Essentials; Chapter 2: Installing SQL Server 2012; Installation Planning; SQL Server 2012 Architecture; Installation Planning Process; Managing Permissions; Installing a Default Instance; SQL Server Installation Center Tasks; Installation; Installing Named Instances; Installing to a Cluster; Installing Extra Features; Upgrading from Previous Versions Handling Upgrades; Understanding Migrations; Validating an Installation; Removing an Installation; Summary; Chapter Essentials; Chapter 3: Working with the Administration Tools; SQL Server Configuration Manager; Overview of the SSCM; Performing Common SSCM Tasks; SQL Server Management ; Studio; Overview of the SSMS; Performing Common SSMS Tasks; SQL Server Data Tools; Overview of SSDT; Performing Common SSDT Tasks; SQL Server Profiler; Books Online; Windows Server Administration for the DBA; User Account Management; File System Management; Network Configuration Administration Summary; Chapter Essentials; Chapter 4: SQL Server Command-Line Administration; Introducing the Command Prompt; General Command-Prompt Options; Font Settings; Screen Layout; Color Choices; General Commands; Directory and Folder Navigation; Directory and Folder Listing; Screen Management; Displaying Information; Redirecting Output; Administrative Commands; Batch Files; Using Logic (IF and GOTO); Passing Data; Including Comments; Mastering SQLCMD; Introducing Windows PowerShell; Using SQL Server PowerShell Extensions; Summary; Chapter Essentials; Chapter 5: Querying SQL Server Understanding the SQL Language; Queries; Short Learning Curve; Varied Query Modes; Standardization; Added Logical Capabilities of T-SQL; SQL Statement Types; Data Manipulation Language; Data Definition Language; Data Control Language; SQL Syntactical Elements; Keywords; Comments; Batch Directives; SQL Statements; Clauses; Identifiers; Variables; Data Types; System Functions; Operators and Expressions; Statement Terminator; Coding Recommendations; Capitalize Keywords; Use Standard SQL; Do Not Use Keywords as Identifiers; Using SELECT Statements; Basic SELECT Statements
• Sommario/riassunto: 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 ste