首頁(yè) > 計(jì)算機(jī)網(wǎng)絡(luò) >
編程語(yǔ)言與程序設(shè)計(jì)
> Oracle Database XE 11gR2 Jump Start Guide最新章節(jié)目錄
舉報(bào) 
會(huì)員
Oracle Database XE 11gR2 Jump Start Guide
最新章節(jié)：
Index
Thisbookdiscussesconceptsandtasksthroughreal-worldexamples.Theauthorusessimplelanguage,screenshots,andastep-by-stepapproachtogetyoustartedwithOracleDatabaseadministration.IfyouareastudentorbeginnerwhoislearningtoadministerOracleDatabase,thenthisbookisforyou.ThisbookisdesignedtocovertheproblemsthatnoviceDBAsparticularlystrugglewith,sonopriorknowledgeofOracledatabaseadministrationisexpected.
目錄(116章)
倒序
- coverpage
- Oracle Database XE 11gR2 Jump Start Guide
- Credits
- About the Author
- Acknowledgement
- About the Reviewers
- www.PacktPub.com
- Support files eBooks discount offers and more
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Chapter 1. Database Editions and Oracle Database XE
- About Oracle
- Oracle Database Express Edition (XE)
- Summary
- References
- Chapter 2. Installing and Uninstalling Oracle Database XE
- Downloading Oracle Database 11g XE
- Installing Oracle Database 11g XE on Windows XP (32-bit)
- Uninstalling Oracle Database 11g XE on Windows XP (32-bit)
- Installing Oracle Database 11g XE on Oracle Enterprise Linux (64-bit)
- Uninstalling Oracle Database 11g XE on Oracle Enterprise Linux (64-bit)
- Summary
- Chapter 3. Connecting and Configuring Oracle Database 11g XE
- Local database connections
- Remote database connections
- Changing SGA and PGA sizes
- Summary
- Chapter 4. Accessing Table Data DML Statements and Transactions
- Unlocking sample user accounts
- Installing SQL Developer
- Connecting SQL Developer to Oracle Database 11g XE
- About TAB and DUAL
- Writing simple queries
- Selecting data from multiple tables
- Exploring common functions
- What are Transaction Control Statements?
- Understanding DML statements
- Summary
- References
- Chapter 5. Creating and Managing Schema Objects
- Data Definition Language
- Creating and managing tables
- Creating and managing indexes
- Integrity constraints
- Creating and managing views
- Creating and managing synonyms
- Creating and managing sequences
- Gathering statistics
- Summary
- References
- Chapter 6. Developing Stored Subprograms and Triggers
- PL/SQL data types
- Stored subprograms
- Creating stored subprograms
- About packages
- Exception handling
- Wrapping up the PL/SQL stored programs
- PL/SQL triggers
- Summary
- References
- Chapter 7. Building a Sample Application with Oracle Application Express
- What is Oracle Application Express (APEX)?
- Creating application users
- Loading and unloading data to a text file
- Application Express Dashboard
- Summary
- References
- Chapter 8. Managing Database and Database Storage
- Memory structure
- Automatic Memory Management
- Important background processes
- Physical and logical database structures
- Managing the Flash Recovery Area
- Summary
- Chapter 9. Moving Data between Oracle Databases
- Exporting and importing data
- Moving data between Oracle Database 10g XE and Oracle Database 11g XE
- Exporting data using SQL Developer
- Summary
- Chapter 10. Upgrading Oracle Database 11g XE to Other Database Editions
- Upgrading Oracle Database 11g XE to Oracle Database 11g Enterprise Edition
- Summary
- Chapter 11. Backup and Recovery
- Introduction to backup and recovery
- Recovery Manager
- Connecting to Oracle Database XE using RMAN
- The ARCHIVELOG mode
- Backing up a database (the NOARCHIVELOG mode)
- Simulating a database failure (the NOARCHIVELOG mode)
- Restoring the NOARCHIVELOG database
- Configuring the RMAN environment
- Backing up the ARCHIVELOG database
- Simulating a database failure (the ARCHIVELOG mode)
- Restoring the ARCHIVELOG database
- Summary
- References
- Chapter 12. Tuning Oracle Database 11g XE
- Performance tuning
- Performance tuning approach
- Avoiding common pitfalls
- Autotrace utility
- Explain Plan
- Using indexes
- Dynamic performance views
- Statspack
- Summary
- References
- Appendix A. Features Available with Oracle Database 11g XE
- Features available
- Features not available
- Index 更新時(shí)間：2021-08-13 18:28:31
推薦閱讀
- Android應(yīng)用程序開(kāi)發(fā)與典型案例
- C++ Builder 6.0下OpenGL編程技術(shù)
- PyTorch Artificial Intelligence Fundamentals
- Learn Scala Programming
- 老“碼”識(shí)途
- Kotlin Standard Library Cookbook
- Mastering JavaScript High Performance
- Python全棧數(shù)據(jù)工程師養(yǎng)成攻略（視頻講解版）
- MINECRAFT編程：使用Python語(yǔ)言玩轉(zhuǎn)我的世界
- Python大學(xué)實(shí)用教程
- 一步一步跟我學(xué)Scratch3.0案例
- 石墨烯改性塑料
- TypeScript圖形渲染實(shí)戰(zhàn)：2D架構(gòu)設(shè)計(jì)與實(shí)現(xiàn)
- HTML5游戲開(kāi)發(fā)實(shí)戰(zhàn)
- Python Automation Cookbook
- Java Web應(yīng)用開(kāi)發(fā)
- Windows 10 for Enterprise Administrators
- Scratch 3.0少兒積木式編程（6~10歲）
- C++程序設(shè)計(jì)習(xí)題與實(shí)驗(yàn)指導(dǎo)
- Java Web程序員面試筆試寶典
- Instant AutoIt Scripting
- MATLAB/Simulink與過(guò)程控制系統(tǒng)仿真
- ServiceStack 4 Cookbook
- 軟件設(shè)計(jì)基礎(chǔ)理論
- C++ 黑客編程揭秘與防范
- 產(chǎn)品經(jīng)理實(shí)用手冊(cè)：Axure RP原型設(shè)計(jì)實(shí)踐（Web+App）
- Python機(jī)器學(xué)習(xí)與可視化分析實(shí)戰(zhàn)
- Swift 4 Programming Cookbook
- Instant Sikuli Test Automation
- Mastering Apache Cassandra
