`

The sequence of the learning ORACLE.

 
阅读更多

<!-- [if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:DrawingGridVerticalSpacing>7.8 磅</w:DrawingGridVerticalSpacing> <w:DisplayHorizontalDrawingGridEvery>0</w:DisplayHorizontalDrawingGridEvery> <w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:SpaceForUL/> <w:BalanceSingleByteDoubleByteWidth/> <w:DoNotLeaveBackslashAlone/> <w:ULTrailSpace/> <w:DoNotExpandShiftReturn/> <w:AdjustLineHeightInTable/> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:UseFELayout/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!-- [if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!-- [if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]-->

The sequence of the learning ORACLE is as below:

SQL->PLSQL->architect->backup and recovery->performance tuning->high availability.

I recommend you to learn ORACLE according to the sequence per my past experience.

Now matter whether you want to take the certification exam or start out your first steps of DBA.

The SQL is easier than you think because it is not procedural so you need not to tell it how to do it. What you need to tell is only what you want to do including get data from the database, put data into it and modify the data that is in the database.

The SQL is general language which can be used in any relational database.

The PL SQL is procedural language of the SQL it only can be used in the ORACLE related products.

Then you can learn the database architect.

The knowing architect will help you understand the ORACLE better and can make the ORACLE at your disposal.

Understanding the architect will help you troubleshoot every problem effectively.

The backup and recovery is important for a DBA.

Knowing the backup and recovery theory and testing out every possible scenario also will help you future understanding the architect.

Performance tuning is more profound field in ORACLE.

Different people has different view and different way to do it.

The high availability is not so hard as you think.

As long as you get the change to set it up for several times you will find it is not mysterious as its conception implying.

Per the sequence I suggest and stick to learn it for 1000 hours.

You will master ORALE well.

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics