New Training Series: Oracle Database 11g DBA II

Trainer Timothy Warner is filmed in the Nugget Green Room.

Hey everyone. I wanted to take a moment to announce my new CBT Nuggets training series on the Oracle Database 11g Database Administration II certification.

The DBA II (1Z0-053) exam qualifies you in part for the second-tier Oracle Certified Professional (OCP) credential; this is a particularly valuable certification in the DBA world.

The subject matter in the Oracle 11g DBA II skill set focuses primarily on two areas:

• Performance tuning

• Troubleshooting

Thus, if you are fairly new to Oracle Database, then I would suggest that you begin your learning path by studying my other Oracle training series for CBT Nuggets:

• Oracle Database 11g SQL Fundamentals I 1Z0-051

• Oracle Database 11g DBA 1 1Z0-052

On the other hand, if you are already an experienced DBA who has recently "inherited" one or more Oracle 11g databases and need some quick training on disaster recovery and performance tuning and optimization, then you definitely came to the right place with this course.

One common question I receive from existing Oracle DBAs is, "Do you use Linux or Windows in your demonstrations?" For this title I've decided to stay with Windows, although I've switched back and forth between *NIX and Windows platforms for the other Oracle series. The bottom line is that for the purposes of the DBA II skill set, the biggest difference between the Windows and Linux implementations of Oracle deals with file path construction; viz., Linux uses forward slash separators and Windows uses backslashes.

Another common question is, "How much of your demos deal with command-line versus GUI administration?" The answer to that is: 50/50. The reasons for showing you how to accomplish Oracle DBA tasks by using both the Oracle Enterprise Manager (OEM) GUI console as well as the SQL*Plus command-line client is two-fold:

• The exam will test your capabilities with both methods of administration

• Some users are more comfortable with the command line, and other users prefer GUI tools

I hope you enjoy the training, and I look forward to receiving your feedback on it. Happy studying!