learning Oracle® 11g

learning Oracle® 11g

IntroductionIf you are reading this text, chances are you’re considering throwing yourself
into the wonderful world of Oracle database administration. The good
news is, you have come to right place. The bad news? Well, it’s not really bad
news . . . but you have quite an adventure ahead of you. Luckily, the authors
of this book, your guides in this adventure, can help smooth out any bumpy
roads. With over 35 years of combined Oracle experience, we hope to make
understanding the Oracle database a fun, enlightening experience.
Oracle is large company with a diverse portfolio of software. It’s constantly
growing too. It seems like every other week Oracle releases some slick new
product or acquires another company. Don’t let the overwhelming nature of
the big picture discourage you. This book imparts a fundamental knowledge
of the basics of database administration. An Oracle career is a constant learning
process. Establishing a solid understanding of the building blocks behind
the database engine will vault you into a successful Oracle career.
You might be interested to know that the rock behind all of Oracle’s products
is almost always the database. Take comfort in knowing that in the database
world, Oracle is the best. Learning the database is the first step to opening an
awful lot of doors for you. Starting at this level is key. After reading this book,
you will be well on your way to an interesting career filled with challenges
and plenty of opportunity.
There will always be a need for managing information. Every year we see
companies grow and accumulate data at a staggering rate. Databases are not
a passing fad like some other areas of information technology. The concept of
a relational database has been in circulation for almost 40 years and won’t be
going away anytime soon.

About This Book

Despite this book being titled Oracle 11g For Dummies, we focus on the
tenets of Oracle database administration. Not only do we cover many of the
features released with the 11g version of the database, but also cover the
fundamental building blocks. Many of these concepts and techniques apply
to past versions of the Oracle and almost certainly future releases

What’s in This Book

Oracle 11g has six different parts with six different major topics.

Part I: You Don’t Have to Go
to Delphi to Know Oracle

Part I helps prepare you for implementation by discussing why you’d
choose Oracle in the first place, what’s included in the architecture and

how the elements work together, and what you need to do before starting
Oracle database creation

Part II: Implementing Oracle on Your Own

Part II gets you into the nitty gritty of Oracle database creation by discussing
the tools and actual steps you’ll take. The Database Creation Assistant
(DBCA) is detailed here, as well as the SQL language. You can use either tool;
automatic or manual setup is your choice. Finally, you read what to populate
your Oracle database with.

Part III: Caring for an Oracle Database

You can’t just create and populate an Oracle database: You have to protect
it. Part III has the tools and tips you need to secure both the database and
the data within. The less glamorous but no less crucial maintenance chores
are detailed in this part, along with basic troubleshooting, should you need
to do some. Enterprise Manager makes a star appearance here as well; keeping
an eye on your database can keep you from having to troubleshoot in the
long run

Part IV: Inspecting Advanced Oracle Technologies

Part IV reveals some rare Oracle goods, including the flashback database,
flashback data archive, and database replay. Rolling back for data recovery
is detailed here, and high-availability options Real Application Clusters (RAC)
and Data Guard are explained as well.

Part V: The Part of Tens

Avoid installation mistakes by reading Part V. Ten simple things to avoid
(and another 10 to make sure you do) add up to 20 problem solvers. Head off
trouble before it starts
to download this course click here