05528nam 2200709 a 450 991097040440332120200520144314.097811186547361118654730(CKB)2560000000103655(EBL)1212541(SSID)ssj0000971703(PQKBManifestationID)11520403(PQKBTitleCode)TC0000971703(PQKBWorkID)10940354(PQKB)11703823(OCoLC)874812232(Au-PeEL)EBL1212541(CaPaEBR)ebr10719140(CaONFJC)MIL576329(OCoLC)851098885(CaSebORM)9781118654903(MiAaPQ)EBC1212541(OCoLC)862412018(OCoLC)ocn862412018(Perlego)1002798(EXLCZ)99256000000010365520150303d2013 uy 0engurunu|||||txtccrMicrosoft SQL server 2012 administration real-world skills for mcsa certification and beyond /Tom Carpenter1st editionIndianapolis, Ind. Sybexc20131 online resource (938 p.)Includes index.9781118654903 1118654900 9781118487167 1118487168 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 TermsDatabase 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 FeaturesUpgrading 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 ManagementNetwork 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 EssentialsChapter 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 StatementsBasic SELECT StatementsImplement, 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 steDatabase managementExaminationsStudy guidesElectronic data processing personnelCertificationStudy guidesDatabase managementExaminationsElectronic data processing personnelCertification005.7585Carpenter Tom1626080MiAaPQMiAaPQMiAaPQBOOK9910970404403321Microsoft SQL server 2012 administration4358353UNINA