Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
Administering Microsoft Azure SQL Solutions : Hands-on Preparation and Practice for Exam DP-300 / / by Geoff Hiten
| Administering Microsoft Azure SQL Solutions : Hands-on Preparation and Practice for Exam DP-300 / / by Geoff Hiten |
| Autore | Hiten Geoff |
| Edizione | [1st ed. 2025.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2025 |
| Descrizione fisica | 1 online resource (317 pages) |
| Disciplina | 005.75/85 |
| Collana | Certification Study Companion Series |
| Soggetto topico |
Database management - Examinations
Microsoft Azure (Computing platform) - Examinations SQL (Computer program language) - Examinations |
| ISBN | 979-88-6881-585-0 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | 1. About the DP-300 Exam, this book, and Azure -- Part 1: Plan and Implement Azure SQL Data Platform Resources -- 2. Plan and Implement Azure SQL Database Solutions -- 3. Configure Resources for Scale and Performance -- 4. Plan and Implement a Migration Strategy -- Part 2: Implement a Secure Environment -- 5. Configure Database Authentication and Authorization -- 6. Implement Security for Data at Rest and Data in Transit -- 7. Implement Compliance Controls for Sensitive Data -- Part 3: Monitor, Configure, and Optimize Database Resources -- 8. Monitor Resource Activity and Performance -- 9. Monitor and Optimize Query Performance -- 10. Configure Database Solutions for Optimal Performance -- Part 4: Configure and Manage Automation -- 11. Create and Manage SQL Agent Jobs -- 12. Automate Deployment of Database Resources -- 13. Create and Manage Database Tasks in Azure -- Part 5: Plan and Configure a High Availability and Disaster Recovery (HA/DR) Environment -- 14. Recommend a HA/DR Strategy for Database Solutions -- 15. Plan and Perform Backup and Restore of a Database -- 16. Configure HA/DR for Database Solutions. |
| Record Nr. | UNINA-9911031578603321 |
Hiten Geoff
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2025 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
DB2 10.1/10.5 for Linux, UNIX, and Windows database administration : certification study guide / / Mohankumar (Mohan) Saraswatipura and Robert (Kent) Collins
| DB2 10.1/10.5 for Linux, UNIX, and Windows database administration : certification study guide / / Mohankumar (Mohan) Saraswatipura and Robert (Kent) Collins |
| Autore | Saraswatipura Mohankumar |
| Edizione | [First edition.] |
| Pubbl/distr/stampa | Boise, ID : , : MC Press Online, LLC, , [2015] |
| Descrizione fisica | 1 online resource (1248 p.) |
| Disciplina | 005.7565 |
| Soggetto topico | Database management - Examinations |
| Soggetto genere / forma | Electronic books. |
| ISBN | 1-58347-716-0 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Front Cover; Title Page; Copyright; About the Authors; Acknowledgments; Contents; Foreword; 1: IBM DB2 10.1 Certification; DB2 10.1 Certification Roles; DB2 10.1 Certification Tracks; The Certification Process; Taking an IBM Certification Exam; 2: DB2 Server Management; Exam Objectives; Working with Instances; Configuring the DB2 System Environment; Configuring DB2 Instances and Databases; DB2 Autonomic Computing Features; Automatic Storage; Data Compression; Automatic Database Maintenance; The Configuration Advisor; Adaptive Utility Throttling; Taking Control of a DB2 Server
Working with IBM Data StudioConnecting to Instances and Databases; Generating Data Definition Language Scripts; Performing Database Administration Tasks; Performing Database Development Tasks; Scheduling Database Jobs; Analyzing SQL Queries; Chapter Summary; Practice Questions; Answers; 3: Physical Design; Exam Objectives; Servers, Instances, and Databases; DB2 Database Objects; Creating a DB2 Database; A Complete CREATE DATABASE Command; Design Aspects of Databases; Buffer Pools; Table Spaces; Reclaimable Storage; Storage Groups; Schemas; Range Clustering and Range Partitioning Tables Range Clustered TablesRange Partitioned Tables; Multi-temperature Storage; Time Travel Query Using Temporal Tables; Utilities, Tools, and File Type Modifiers; Restrictions for System-Period Temporal Tables; Application-Period Temporal Tables; Bitemporal Period Tables; Working with XML Data; Data Compression; DB2 9.7-Increasing the Compression Landscape; Chapter Summary; Practice Questions; Answers; 4: Business Rules Implementation; Exam Objectives; Business Rules; Not Null Constraints; Default Constraints; Check Constraints; Unique Constraints; Referential Integrity Constraints Informational ConstraintsThe Set Integrity Command; Creating Tables and Constraints; Creating Views with the Check Option; Creating and Using Triggers; Chapter Summary; Practice Questions; Answers; 5: Monitoring DB2 Activity; Exam Objectives; The Database System Monitor; The Snapshot Monitor; Table Functions for Monitoring; Functions Quick Reference; Administrative Views for Monitoring; Buffer Pool Hit Ratio and I/O Response Time; Currently Running Expensive SQL Statement; Current Lock-wait Chains in the Database; Understanding Your Table Spaces; Getting to Know Your Database Server Event MonitorsEvent Types and Examples; Reading Unformatted Event Data; Unformatted Event Data Format Table Functions; Analyzing SQL with the Explain Facility; The Explain Tables; Collecting Explain Data; Evaluating Explain Data; DB2 Troubleshooting Tools; Obtaining Information About an Error Code; Reason Codes; The db2diag Utility; First Occurrence Data Capture (FODC); The DB2 Diagnostic Log File; The Administration Notification Log; Controlling How Much Information Is Collected; Interpreting the Notification and Diagnostic Log Entries; The db2pdcfg Command; The db2bfd Command The db2val Command |
| Record Nr. | UNINA-9910460827703321 |
|
Saraswatipura Mohankumar
|
||
| Boise, ID : , : MC Press Online, LLC, , [2015] | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
DB2 10.1/10.5 for Linux, UNIX, and Windows database administration : certification study guide / / Mohankumar (Mohan) Saraswatipura and Robert (Kent) Collins
| DB2 10.1/10.5 for Linux, UNIX, and Windows database administration : certification study guide / / Mohankumar (Mohan) Saraswatipura and Robert (Kent) Collins |
| Autore | Saraswatipura Mohankumar |
| Edizione | [First edition.] |
| Pubbl/distr/stampa | Boise, ID : , : MC Press Online, LLC, , [2015] |
| Descrizione fisica | 1 online resource (1248 p.) |
| Disciplina | 005.7565 |
| Soggetto topico | Database management - Examinations |
| ISBN | 1-58347-716-0 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Front Cover; Title Page; Copyright; About the Authors; Acknowledgments; Contents; Foreword; 1: IBM DB2 10.1 Certification; DB2 10.1 Certification Roles; DB2 10.1 Certification Tracks; The Certification Process; Taking an IBM Certification Exam; 2: DB2 Server Management; Exam Objectives; Working with Instances; Configuring the DB2 System Environment; Configuring DB2 Instances and Databases; DB2 Autonomic Computing Features; Automatic Storage; Data Compression; Automatic Database Maintenance; The Configuration Advisor; Adaptive Utility Throttling; Taking Control of a DB2 Server
Working with IBM Data StudioConnecting to Instances and Databases; Generating Data Definition Language Scripts; Performing Database Administration Tasks; Performing Database Development Tasks; Scheduling Database Jobs; Analyzing SQL Queries; Chapter Summary; Practice Questions; Answers; 3: Physical Design; Exam Objectives; Servers, Instances, and Databases; DB2 Database Objects; Creating a DB2 Database; A Complete CREATE DATABASE Command; Design Aspects of Databases; Buffer Pools; Table Spaces; Reclaimable Storage; Storage Groups; Schemas; Range Clustering and Range Partitioning Tables Range Clustered TablesRange Partitioned Tables; Multi-temperature Storage; Time Travel Query Using Temporal Tables; Utilities, Tools, and File Type Modifiers; Restrictions for System-Period Temporal Tables; Application-Period Temporal Tables; Bitemporal Period Tables; Working with XML Data; Data Compression; DB2 9.7-Increasing the Compression Landscape; Chapter Summary; Practice Questions; Answers; 4: Business Rules Implementation; Exam Objectives; Business Rules; Not Null Constraints; Default Constraints; Check Constraints; Unique Constraints; Referential Integrity Constraints Informational ConstraintsThe Set Integrity Command; Creating Tables and Constraints; Creating Views with the Check Option; Creating and Using Triggers; Chapter Summary; Practice Questions; Answers; 5: Monitoring DB2 Activity; Exam Objectives; The Database System Monitor; The Snapshot Monitor; Table Functions for Monitoring; Functions Quick Reference; Administrative Views for Monitoring; Buffer Pool Hit Ratio and I/O Response Time; Currently Running Expensive SQL Statement; Current Lock-wait Chains in the Database; Understanding Your Table Spaces; Getting to Know Your Database Server Event MonitorsEvent Types and Examples; Reading Unformatted Event Data; Unformatted Event Data Format Table Functions; Analyzing SQL with the Explain Facility; The Explain Tables; Collecting Explain Data; Evaluating Explain Data; DB2 Troubleshooting Tools; Obtaining Information About an Error Code; Reason Codes; The db2diag Utility; First Occurrence Data Capture (FODC); The DB2 Diagnostic Log File; The Administration Notification Log; Controlling How Much Information Is Collected; Interpreting the Notification and Diagnostic Log Entries; The db2pdcfg Command; The db2bfd Command The db2val Command |
| Record Nr. | UNINA-9910797930103321 |
|
Saraswatipura Mohankumar
|
||
| Boise, ID : , : MC Press Online, LLC, , [2015] | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
DB2 10.1/10.5 for Linux, UNIX, and Windows database administration : certification study guide / / Mohankumar (Mohan) Saraswatipura and Robert (Kent) Collins
| DB2 10.1/10.5 for Linux, UNIX, and Windows database administration : certification study guide / / Mohankumar (Mohan) Saraswatipura and Robert (Kent) Collins |
| Autore | Saraswatipura Mohankumar |
| Edizione | [First edition.] |
| Pubbl/distr/stampa | Boise, ID : , : MC Press Online, LLC, , [2015] |
| Descrizione fisica | 1 online resource (1248 p.) |
| Disciplina | 005.7565 |
| Soggetto topico | Database management - Examinations |
| ISBN | 1-58347-716-0 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Front Cover; Title Page; Copyright; About the Authors; Acknowledgments; Contents; Foreword; 1: IBM DB2 10.1 Certification; DB2 10.1 Certification Roles; DB2 10.1 Certification Tracks; The Certification Process; Taking an IBM Certification Exam; 2: DB2 Server Management; Exam Objectives; Working with Instances; Configuring the DB2 System Environment; Configuring DB2 Instances and Databases; DB2 Autonomic Computing Features; Automatic Storage; Data Compression; Automatic Database Maintenance; The Configuration Advisor; Adaptive Utility Throttling; Taking Control of a DB2 Server
Working with IBM Data StudioConnecting to Instances and Databases; Generating Data Definition Language Scripts; Performing Database Administration Tasks; Performing Database Development Tasks; Scheduling Database Jobs; Analyzing SQL Queries; Chapter Summary; Practice Questions; Answers; 3: Physical Design; Exam Objectives; Servers, Instances, and Databases; DB2 Database Objects; Creating a DB2 Database; A Complete CREATE DATABASE Command; Design Aspects of Databases; Buffer Pools; Table Spaces; Reclaimable Storage; Storage Groups; Schemas; Range Clustering and Range Partitioning Tables Range Clustered TablesRange Partitioned Tables; Multi-temperature Storage; Time Travel Query Using Temporal Tables; Utilities, Tools, and File Type Modifiers; Restrictions for System-Period Temporal Tables; Application-Period Temporal Tables; Bitemporal Period Tables; Working with XML Data; Data Compression; DB2 9.7-Increasing the Compression Landscape; Chapter Summary; Practice Questions; Answers; 4: Business Rules Implementation; Exam Objectives; Business Rules; Not Null Constraints; Default Constraints; Check Constraints; Unique Constraints; Referential Integrity Constraints Informational ConstraintsThe Set Integrity Command; Creating Tables and Constraints; Creating Views with the Check Option; Creating and Using Triggers; Chapter Summary; Practice Questions; Answers; 5: Monitoring DB2 Activity; Exam Objectives; The Database System Monitor; The Snapshot Monitor; Table Functions for Monitoring; Functions Quick Reference; Administrative Views for Monitoring; Buffer Pool Hit Ratio and I/O Response Time; Currently Running Expensive SQL Statement; Current Lock-wait Chains in the Database; Understanding Your Table Spaces; Getting to Know Your Database Server Event MonitorsEvent Types and Examples; Reading Unformatted Event Data; Unformatted Event Data Format Table Functions; Analyzing SQL with the Explain Facility; The Explain Tables; Collecting Explain Data; Evaluating Explain Data; DB2 Troubleshooting Tools; Obtaining Information About an Error Code; Reason Codes; The db2diag Utility; First Occurrence Data Capture (FODC); The DB2 Diagnostic Log File; The Administration Notification Log; Controlling How Much Information Is Collected; Interpreting the Notification and Diagnostic Log Entries; The db2pdcfg Command; The db2bfd Command The db2val Command |
| Record Nr. | UNINA-9910822041103321 |
|
Saraswatipura Mohankumar
|
||
| Boise, ID : , : MC Press Online, LLC, , [2015] | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
DB2 11 system administrator for Z/Os certification study guide : exam 317 / / Judy H. Nall
| DB2 11 system administrator for Z/Os certification study guide : exam 317 / / Judy H. Nall |
| Autore | Nall Judy H. |
| Edizione | [First edition.] |
| Pubbl/distr/stampa | Boise, Idaho : , : MC Press Online, LLC, , 2016 |
| Descrizione fisica | 1 online resource (305 pages) |
| Disciplina | 005.44769 |
| Soggetto topico |
Electronic data processing personnel - Certification
Database management - Examinations |
| ISBN |
1-58347-859-0
1-58347-857-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910150332903321 |
|
Nall Judy H.
|
||
| Boise, Idaho : , : MC Press Online, LLC, , 2016 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Documentum content management foundations [[electronic resource] ] : EMC proven professional certification exam E20-120 study guide : learn the technical fundamentals of the EMC documentum platform while effectively preparing for the E20-120 exam / / Pawan Kumar
| Documentum content management foundations [[electronic resource] ] : EMC proven professional certification exam E20-120 study guide : learn the technical fundamentals of the EMC documentum platform while effectively preparing for the E20-120 exam / / Pawan Kumar |
| Autore | Kumar Pawan |
| Pubbl/distr/stampa | Birmingham, U.K., : Packt Pub., 2007 |
| Descrizione fisica | 1 online resource (285 p.) |
| Disciplina | 005.74 |
| Collana | From technologies to solutions |
| Soggetto topico |
Web sites - Management - Examinations
Database management - Examinations |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-281-25259-X
1-84719-241-6 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | pt. 1. Fundamentals -- pt. 2. Security -- pt. 3. User interface -- pt. 4. Application development -- pt. 5. Advanced concepts. |
| Record Nr. | UNINA-9910455030003321 |
|
Kumar Pawan
|
||
| Birmingham, U.K., : Packt Pub., 2007 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Documentum content management foundations [[electronic resource] ] : EMC proven professional certification exam E20-120 study guide : learn the technical fundamentals of the EMC documentum platform while effectively preparing for the E20-120 exam / / Pawan Kumar
| Documentum content management foundations [[electronic resource] ] : EMC proven professional certification exam E20-120 study guide : learn the technical fundamentals of the EMC documentum platform while effectively preparing for the E20-120 exam / / Pawan Kumar |
| Autore | Kumar Pawan |
| Pubbl/distr/stampa | Birmingham, U.K., : Packt Pub., 2007 |
| Descrizione fisica | 1 online resource (285 p.) |
| Disciplina | 005.74 |
| Collana | From technologies to solutions |
| Soggetto topico |
Web sites - Management - Examinations
Database management - Examinations |
| ISBN |
1-281-25259-X
1-84719-241-6 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | pt. 1. Fundamentals -- pt. 2. Security -- pt. 3. User interface -- pt. 4. Application development -- pt. 5. Advanced concepts. |
| Record Nr. | UNINA-9910778065903321 |
|
Kumar Pawan
|
||
| Birmingham, U.K., : Packt Pub., 2007 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Documentum content management foundations : EMC proven professional certification exam E20-120 study guide : learn the technical fundamentals of the EMC documentum platform while effectively preparing for the E20-120 exam / / Pawan Kumar
| Documentum content management foundations : EMC proven professional certification exam E20-120 study guide : learn the technical fundamentals of the EMC documentum platform while effectively preparing for the E20-120 exam / / Pawan Kumar |
| Autore | Kumar Pawan |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | Birmingham, U.K., : Packt Pub., 2007 |
| Descrizione fisica | 1 online resource (285 p.) |
| Disciplina | 005.74 |
| Collana | From technologies to solutions |
| Soggetto topico |
Web sites - Management - Examinations
Database management - Examinations |
| ISBN |
9781281252593
128125259X 9781847192417 1847192416 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | pt. 1. Fundamentals -- pt. 2. Security -- pt. 3. User interface -- pt. 4. Application development -- pt. 5. Advanced concepts. |
| Record Nr. | UNINA-9910954895203321 |
|
Kumar Pawan
|
||
| Birmingham, U.K., : Packt Pub., 2007 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Microsoft SQL server 2012 administration [[electronic resource] ] : real-world skills for mcsa certification and beyond / / Tom Carpenter
| 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 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Microsoft SQL server 2012 administration [[electronic resource] ] : real-world skills for mcsa certification and beyond / / Tom Carpenter
| 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 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
