top

  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.

  Info

  • Utilizzare questo link per rimuovere la selezione effettuata.
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
Opac: Controlla la disponibilità qui
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
Opac: Controlla la disponibilità qui
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
Opac: Controlla la disponibilità qui
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
Opac: Controlla la disponibilità qui
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
Opac: Controlla la disponibilità qui
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
Opac: Controlla la disponibilità qui
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
Opac: Controlla la disponibilità qui
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
Opac: Controlla la disponibilità qui
OCA [[electronic resource] ] : Oracle database 11g administrator certified associate study guide (1Z0-051 and 1Z0-052) / / Biju Thomas
OCA [[electronic resource] ] : Oracle database 11g administrator certified associate study guide (1Z0-051 and 1Z0-052) / / Biju Thomas
Autore Thomas Biju
Edizione [1st ed.]
Pubbl/distr/stampa Indianapolis, Ind., : Wiley Pub., 2009
Descrizione fisica 1 online resource (1158 p.)
Disciplina 005.75/75
Collana Serious skills
Soggetto topico Electronic data processing personnel - Certification
Database management - Examinations
Soggetto genere / forma Electronic books.
ISBN 1-118-05942-5
1-282-55025-X
9786612550256
0-470-48834-4
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto OCA Oracle® Database 11g Administrator Certified Associate Study Guide; Acknowledgments; About the Author; Contents at a Glance; Contents; Introduction; SQL Fundamentals I Assessment Test; Answers to SQL Fundamentals I Assessment Test; Administration I Assessment Test; Answers to Administration I Assessment Test; Part I: Oracle Database 11g: SQL Fundamentals I; Chapter 1: Introducing SQL; SQL Fundamentals; Writing Simple Queries; Accepting Values at Runtime; Summary; Exam Essentials; Untitled; Review Questions; Answers to Review Questions; Chapter 2: Using Single-Row Functions
Single-Row Function FundamentalsUsing Single-Row Character Functions; Using Single-Row Numeric Functions; Using Single-Row Date Functions; Using Single-Row Conversion Functions; Using Other Single-Row Functions; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 3: Using Group Functions; Group-Function Fundamentals; Utilizing Aggregate Functions; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 4: Using Joins and Subqueries; Writing Multiple-Table Queries; Using Set Operators; Subqueries; Summary; Exam Essentials; Review Questions
Answers to Review QuestionsChapter 5: Manipulating Data; Using DML Statements; Understanding Transaction Control; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 6: Creating Tables and Constraints; Database Objects Overview; Built-in Datatypes; Creating Tables; Modifying Tables; Managing Constraints; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 7: Creating Schema Objects; Creating and Modifying Views; Creating and Managing Sequences; Creating and Managing Synonyms; Creating and Managing Indexes; Summary; Exam Essentials
Review QuestionsAnswers to Review Questions; Part II: Oracle Database 11g: Administration I; Chapter 8: Introducing Oracle Database 11g Components and Architecture; Oracle Database Fundamentals; Oracle 11g Architecture; Installing Oracle 11g; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 9: Creating an Oracle 11g Database; Using DBCA to Create Oracle 11g Databases; Working with Oracle 11g Metadata; Managing Initialization-Parameter Files; Starting Up and Shutting Down an Oracle Instance; Monitoring the Database Alert Log; Summary; Exam Essentials
Review QuestionsAnswers to Review Questions; Chapter 10: Allocating Database Storage and Creating Schema Objects; Tablespaces and Data Files Overview; Managing Tablespaces; Managing Data Files; Working with Schema Objects; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 11: Understanding Network Architecture; Introducing Network Configurations; An Overview of Oracle Net Features; Configuring Oracle Net on the Server; Configuring Oracle Net for the Client; An Overview of Oracle Shared Server; Oracle Shared Server Infrastructure; Summary; Exam Essentials
Review Questions
Record Nr. UNINA-9910459480003321
Thomas Biju  
Indianapolis, Ind., : Wiley Pub., 2009
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
OCA [[electronic resource] ] : Oracle database 11g administrator certified associate study guide (1Z0-051 and 1Z0-052) / / Biju Thomas
OCA [[electronic resource] ] : Oracle database 11g administrator certified associate study guide (1Z0-051 and 1Z0-052) / / Biju Thomas
Autore Thomas Biju
Edizione [1st ed.]
Pubbl/distr/stampa Indianapolis, Ind., : Wiley Pub., 2009
Descrizione fisica 1 online resource (1158 p.)
Disciplina 005.75/75
Collana Serious skills
Soggetto topico Electronic data processing personnel - Certification
Database management - Examinations
ISBN 1-118-05942-5
1-282-55025-X
9786612550256
0-470-48834-4
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto OCA Oracle® Database 11g Administrator Certified Associate Study Guide; Acknowledgments; About the Author; Contents at a Glance; Contents; Introduction; SQL Fundamentals I Assessment Test; Answers to SQL Fundamentals I Assessment Test; Administration I Assessment Test; Answers to Administration I Assessment Test; Part I: Oracle Database 11g: SQL Fundamentals I; Chapter 1: Introducing SQL; SQL Fundamentals; Writing Simple Queries; Accepting Values at Runtime; Summary; Exam Essentials; Untitled; Review Questions; Answers to Review Questions; Chapter 2: Using Single-Row Functions
Single-Row Function FundamentalsUsing Single-Row Character Functions; Using Single-Row Numeric Functions; Using Single-Row Date Functions; Using Single-Row Conversion Functions; Using Other Single-Row Functions; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 3: Using Group Functions; Group-Function Fundamentals; Utilizing Aggregate Functions; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 4: Using Joins and Subqueries; Writing Multiple-Table Queries; Using Set Operators; Subqueries; Summary; Exam Essentials; Review Questions
Answers to Review QuestionsChapter 5: Manipulating Data; Using DML Statements; Understanding Transaction Control; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 6: Creating Tables and Constraints; Database Objects Overview; Built-in Datatypes; Creating Tables; Modifying Tables; Managing Constraints; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 7: Creating Schema Objects; Creating and Modifying Views; Creating and Managing Sequences; Creating and Managing Synonyms; Creating and Managing Indexes; Summary; Exam Essentials
Review QuestionsAnswers to Review Questions; Part II: Oracle Database 11g: Administration I; Chapter 8: Introducing Oracle Database 11g Components and Architecture; Oracle Database Fundamentals; Oracle 11g Architecture; Installing Oracle 11g; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 9: Creating an Oracle 11g Database; Using DBCA to Create Oracle 11g Databases; Working with Oracle 11g Metadata; Managing Initialization-Parameter Files; Starting Up and Shutting Down an Oracle Instance; Monitoring the Database Alert Log; Summary; Exam Essentials
Review QuestionsAnswers to Review Questions; Chapter 10: Allocating Database Storage and Creating Schema Objects; Tablespaces and Data Files Overview; Managing Tablespaces; Managing Data Files; Working with Schema Objects; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 11: Understanding Network Architecture; Introducing Network Configurations; An Overview of Oracle Net Features; Configuring Oracle Net on the Server; Configuring Oracle Net for the Client; An Overview of Oracle Shared Server; Oracle Shared Server Infrastructure; Summary; Exam Essentials
Review Questions
Record Nr. UNINA-9910792353103321
Thomas Biju  
Indianapolis, Ind., : Wiley Pub., 2009
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui