Microsoft SQL server 2012 administration real-world skills for mcsa certification and beyond
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 certific...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, Ind. :
Sybex
c2013.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628451706719 |
Tabla de Contenidos:
- 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
