Build and manage your Oracle Database 11g XE environment with this fast paced, practical guide with this book and ebook.
Install and configure Oracle Database XE on Windows and Linux
Develop database applications using Oracle Application Express
Back up, restore, and tune your database
Includes clear step-by-step instructions and examples
Install and uninstall Oracle Database XE on Windows and Linux environment
Set up local and remote database connections and resize Oracle SGA
Install SQL Developer, access table data, modify table data, understand transaction control statements and most commonly used SQL functions
Create and manage database objects like tables, indexes, constraints, views, sequences, and synonyms
Develop PL/SQL stored subprograms
Understand Oracle logical and physical components such as SGA, PGA, Tablespaces, and Flash Recovery Area
Move data between different Oracle Database XE versions
Upgrade Oracle Database Express Edition to other Oracle Database Editions
Protect and recover your database
Tune the database for optimal performance"