KeyStone Learn Oracle 8iR2 英文光碟正式版 (5片裝)





軟體簡介:



Keystone公司:Oracle8iR2資料庫實作教學,一次五片,不囉嗦,讓你一次學完
Keystone公司所推出的教育系列軟體一向是學習電腦所不可以或缺的重要教學光
碟,而這次所推出的教育光碟更是萬中選一的重要教材之一，內容完整，彙集資料
豐富，操作容易而所有的資料及習作更都是由講師親自操作的哦!!是你所不可以
放過的。市價:新台幣38000元(美金:749.95元)。

CourseDescription
Thisserieswillteachstudentsthefundamentalskillstheyneedtomanage
Oracle8iR2databases.Youwilllearndatabaseadministrationskillsby
designing,settingup,configuringandmanagingaOracleserver.Bytheendof
theseries,youwillhavegonethroughthemaintasksnecessarytomanage
Oracledatabases.

Level1(2hrs22min)
1.0Oracle8iArchitecture(1hr20min)
1.1DBAEnvironment
1.2ServerArchitecturalOverview
1.3DatabaseComps
1.4LogicalStorageStructure
1.5DataBlocks
1.6Tablespaces
1.7Oracle8iJVM
1.8MultithreadServer
1.9OptimalFlexibleArchitecture
1.10DBAProducts
1.11Summary
2.0OracleMemoryStructures&Processes(1hr2min)
2.1SettingupEnvironment
2.2DBBufferCache
2.3MultipleBufferCachePools
2.4StorageClause
2.5HitRatios
2.6CachingTables
2.7RedoLogBufferCache
2.8LargePool&JavaPool

Level2(2hrs9min)
1.0OracleMemoryStructures&Processes(47min)
1.1Sorting
1.2Checkpoints
1.3ServerProcesses
1.4BackgroundProcesses
1.5SQLStatementParsing
1.6Optimizers
1.7ParallelOperations
1.8Summary
2.0DataDictionary(39min)
2.1Metadata
2.2StaticViews
2.3DynamicViews
3.0DBAUtilities(43min)
3.1AdministrationUtilities
3.2InstallationFeatures

Level3(2hrs15min)
1.0CreatinganOracleInstance&Database(1hr25min)
1.1Starting&ShuttingdownaDatabase
1.2ShutdownOptions
1.3AlterDatabaseCommands
1.4PreparingtheSetup
1.5CreatingaDatabaseProcess
1.6CreateDatabaseCommand
1.7WhatCREATEDatabaseCreates
1.8DatabaseCreationWrapup
1.9Alert&TraceFiles
1.10DynamicViews
2.0ManagingTablespaces&DataFiles(50min)
2.1CreateTablespaceOverview
2.2CreateTablespaceCommand
2.3CreatingaTablespace
2.4TypesofTablespaces
2.5AlterTablespaceCommand
2.6TemporaryTablespaces
2.7Read-onlyTablespaces
2.8CoalescingTablespaces
2.9AlterTablespacesExamples
2.10TablespaceOfflineOptions
2.11RenamingaDataFile
2.12AddingSspacetoaDatabase
2.13DroppingTablespaces
2.14Dat

Level4(1hr53min)
1.0ManagingRollback&TemporarySegments(43min)
1.1DataBlocks
1.2DataDictionaryViews
1.3RollbackSegments
1.4LayingoutRollbackSegments
1.5TheOptionalParameter
1.6CreateRollbackSegmentCommand
1.7Alter&DropCommands
1.8SetTransactionCommand
1.9UsingDataDictionaryViews
1.10Recommendations
1.11TemporarySegments
2.0Control&RedoLogFiles(1hr10min)
2.1ControlFileContents
2.2DataDictionaryViews
2.3MultiplexingControlFiles
2.4ReviewofRedoLogFiles
2.5WritingtoRedoLogFiles
2.6LogSequenceNumbers&Checkpoints
2.7AddingRedoLogFiles
2.8ClearingRedoLogFiles
2.9DroppingRedoLogFiles
2.10RenamingRedoLogFiles
2.11ArchiveLogListCommand
2.12DataDictionaryViews

Level5(1hr49min)
1.0ManagingUsers&Profiles(48min)
1.1ManagingUsers
1.2CreatingUserAccount
1.3AlterUserCommand
1.4CreatingProfiles
1.5DatabaseResourceLimits
1.6CreateProfileCommand
1.7PasswordManaging
1.8PasswordComplexity
1.9PasswordResourceLimits
1.10Resource-LimitParameter
1.11DefiningPasswordManagement
1.12AssigningProfiles
1.13DataDictionaryViews
1.14DataEncryption
2.0ManagingPrivileges(61min)
2.1SystemPrivileges
2.2ObjectPrivileges
2.3WorkingwithRoles
2.4GrantCommand
2.5ViewingSystemPrivileges
2.6GrantingObjectsPrivileges
2.7ViewingPrivileges&Roles
2.8RevoteCommand
2.9DatabaseAuthentication&Access
2.10StandardPredefinedRoles
2.11SettingUpaRole
2.12WorkingwithRoles
2.13Enabling&DisablingRoles
2.14GuidelinesforRole
2.15Oracle8iEnhancedSecurity
Keystone.Laern.Oracle8i