Microsoft SQL server 2012 administration [[electronic resource] ] : real-world skills for mcsa certification and beyond / / Tom Carpenter |
Autore | Carpenter Tom |
Edizione | [1st edition] |
Pubbl/distr/stampa | Indianapolis, Ind., : Sybex, c2013 |
Descrizione fisica | 1 online resource (938 p.) |
Disciplina | 005.7585 |
Soggetto topico |
Database management - Examinations
Electronic data processing personnel - Certification |
Soggetto genere / forma | Electronic books. |
ISBN | 1-118-65473-0 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
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 |
Record Nr. | UNINA-9910465708503321 |
Carpenter Tom
![]() |
||
Indianapolis, Ind., : Sybex, c2013 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Microsoft SQL server 2012 administration [[electronic resource] ] : real-world skills for mcsa certification and beyond / / Tom Carpenter |
Autore | Carpenter Tom |
Edizione | [1st edition] |
Pubbl/distr/stampa | Indianapolis, Ind., : Sybex, c2013 |
Descrizione fisica | 1 online resource (938 p.) |
Disciplina | 005.7585 |
Soggetto topico |
Database management - Examinations
Electronic data processing personnel - Certification |
ISBN | 1-118-65473-0 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
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 |
Record Nr. | UNINA-9910792297603321 |
Carpenter Tom
![]() |
||
Indianapolis, Ind., : Sybex, c2013 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Microsoft Windows Operating System essentials [[electronic resource] /] / Tom Carpenter |
Autore | Carpenter Tom |
Edizione | [1st edition] |
Pubbl/distr/stampa | Indianapolis, : John Wiley & Sons, c2012 |
Descrizione fisica | 1 recurso en linea (402 p.) |
Disciplina | 005.446 |
Collana | Sybex serious skills Microsoft Windows operating system |
Soggetto topico | Microsoft software |
Soggetto genere / forma | Electronic books. |
ISBN |
1-283-92769-1
1-118-22768-9 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Microsoft Windows Operating Essentials; Acknowledgments; About the Author; Contents; Introduction; Chapter 1: Windows Operating Systems Overview; Discovering the History of Windows; Understanding the OS Architecture; Identifying Windows Interfaces; The Essentials and Beyond; Chapter 2: Installing Windows; Exploring OS Editions; Planning Clean Installs vs. Upgrades; Understanding Installation Types; Using Virtualized Installations; The Essentials and Beyond; Chapter 3: Managing the Desktop; Understanding Desktop Features; Working with Gadgets; Changing Display Settings; Creating Shortcuts
Configuring the Aero InterfaceThe Essentials and Beyond; Chapter 4: Using Native Applications; Using the Traditional Tools; Working with Internet Explorer; Creating Screenshots; Using Media Applications; Viewing Configuration Settings; The Essentials and Beyond; Chapter 5: Managing with the Control Panel; Understanding Applets; Configuring Administrative Tools; Configuring Accessibility; Using Important Applets; The Essentials and Beyond; Chapter 6: Mobility and Remote Management; Understanding Mobility; Using Remote Desktop; Using Remote Assistance; Understanding the MMC Working with Windows PowerShellThe Essentials and Beyond; Chapter 7: Managing Applications; Planning for Local and Network Applications; Installing, Configuring, and Removing Applications; Using Group Policy for Application Control; Understanding Application Virtualization; The Difference between Services and Standard Applications; The Essentials and Beyond; Chapter 8: Controlling Malware; Understanding Malware Types; Planning for Malware Protection; Understanding Microsoft Protection Methods; The Essentials and Beyond; Chapter 9: File Management; Understanding Filesystems Working with EncryptionUsing Libraries; The Essentials and Beyond; Chapter 10: Network Shares; Planning for File Sharing; Creating File Shares; Understanding NTFS and Share Permissions; Sharing Printers; The Essentials and Beyond; Chapter 11: Device Management; Understanding Device Drivers; Exploring Plug-and-Play Operations; Connecting and Managing Devices; Printers; System Devices; The Essentials and Beyond; Chapter 12: Storage Management; Data Storage Concepts; Understanding RAID; Identifying Storage Technologies; Understanding Disk Types; Using Online Storage; The Essentials and Beyond Chapter 13: Windows TroubleshootingTroubleshooting Processes; Using Disk Defragmenter; Performing a Disk Cleanup; Scheduling Tasks; Accessing Additional Troubleshooting Tools; The Essentials and Beyond; Chapter 14: Backup and Recovery; Planning for Backups; Testing Recovery Processes; Working with System Restore; Selecting Third-Party Backup Software; Using Recovery Boot Options; The Essentials and Beyond; Chapter 15: Windows Update; Understanding Hotfixes and Service Packs; Planning for Windows Update and Microsoft Update; The Essentials and Beyond; Appendix A: Answers to Review Questions Chapter 1 |
Record Nr. | UNINA-9910461440503321 |
Carpenter Tom
![]() |
||
Indianapolis, : John Wiley & Sons, c2012 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Microsoft Windows Operating System essentials [[electronic resource] /] / Tom Carpenter |
Autore | Carpenter Tom |
Edizione | [1st edition] |
Pubbl/distr/stampa | Indianapolis, : John Wiley & Sons, c2012 |
Descrizione fisica | 1 recurso en linea (402 p.) |
Disciplina | 005.446 |
Collana | Sybex serious skills Microsoft Windows operating system |
Soggetto topico | Microsoft software |
ISBN |
1-283-92769-1
1-118-22768-9 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Microsoft Windows Operating Essentials; Acknowledgments; About the Author; Contents; Introduction; Chapter 1: Windows Operating Systems Overview; Discovering the History of Windows; Understanding the OS Architecture; Identifying Windows Interfaces; The Essentials and Beyond; Chapter 2: Installing Windows; Exploring OS Editions; Planning Clean Installs vs. Upgrades; Understanding Installation Types; Using Virtualized Installations; The Essentials and Beyond; Chapter 3: Managing the Desktop; Understanding Desktop Features; Working with Gadgets; Changing Display Settings; Creating Shortcuts
Configuring the Aero InterfaceThe Essentials and Beyond; Chapter 4: Using Native Applications; Using the Traditional Tools; Working with Internet Explorer; Creating Screenshots; Using Media Applications; Viewing Configuration Settings; The Essentials and Beyond; Chapter 5: Managing with the Control Panel; Understanding Applets; Configuring Administrative Tools; Configuring Accessibility; Using Important Applets; The Essentials and Beyond; Chapter 6: Mobility and Remote Management; Understanding Mobility; Using Remote Desktop; Using Remote Assistance; Understanding the MMC Working with Windows PowerShellThe Essentials and Beyond; Chapter 7: Managing Applications; Planning for Local and Network Applications; Installing, Configuring, and Removing Applications; Using Group Policy for Application Control; Understanding Application Virtualization; The Difference between Services and Standard Applications; The Essentials and Beyond; Chapter 8: Controlling Malware; Understanding Malware Types; Planning for Malware Protection; Understanding Microsoft Protection Methods; The Essentials and Beyond; Chapter 9: File Management; Understanding Filesystems Working with EncryptionUsing Libraries; The Essentials and Beyond; Chapter 10: Network Shares; Planning for File Sharing; Creating File Shares; Understanding NTFS and Share Permissions; Sharing Printers; The Essentials and Beyond; Chapter 11: Device Management; Understanding Device Drivers; Exploring Plug-and-Play Operations; Connecting and Managing Devices; Printers; System Devices; The Essentials and Beyond; Chapter 12: Storage Management; Data Storage Concepts; Understanding RAID; Identifying Storage Technologies; Understanding Disk Types; Using Online Storage; The Essentials and Beyond Chapter 13: Windows TroubleshootingTroubleshooting Processes; Using Disk Defragmenter; Performing a Disk Cleanup; Scheduling Tasks; Accessing Additional Troubleshooting Tools; The Essentials and Beyond; Chapter 14: Backup and Recovery; Planning for Backups; Testing Recovery Processes; Working with System Restore; Selecting Third-Party Backup Software; Using Recovery Boot Options; The Essentials and Beyond; Chapter 15: Windows Update; Understanding Hotfixes and Service Packs; Planning for Windows Update and Microsoft Update; The Essentials and Beyond; Appendix A: Answers to Review Questions Chapter 1 |
Record Nr. | UNINA-9910789885703321 |
Carpenter Tom
![]() |
||
Indianapolis, : John Wiley & Sons, c2012 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|