标签:oracle教程,oracle数据库,
本站提供OracleExpressFoundation英文版免费下载,http://www.dxs89.com
TXT41Introduction
CourseObjectives
Aftercompletingthiscourse,youshouldbeableto
dothefollowing:
DescribeOracleExpressServerarchitectureandkeyfeatures
DescribeproceduresforconfiguringandmonitoringinstancesofExpressServer
DiscussthebasicfeaturesofmultidimensionalityandtheExpressdatabase
Create,populate,andmaintainanExpressdatabasebyusinggraphicaltoolsandcommandsyntax
CourseObjectives
SelectivelyaccessanddisplaysubsetsofdatastoredinanExpressdatabase
Define,compile,andexecuteExpressprograms
TransferdatabetweenExpressdatabases
CreatedynamicaccessfromExpresstorelationalwarehousedata
Applytechniquestomaintaindatabaseefficiency
CourseAgenda
Lesson1:Introduction
Lesson2:PrinciplesofExpressMultidimensionality
Lesson3:ElementsofanExpressSystem
Lesson4:ManaginganInstanceofExpressServer
Lesson5:ViewingExpressData
Lesson6:CreatinganExpressDatabase
Lesson7:SelectingData—theBasics
PrinciplesofExpressMultidimensionality
Objectives
Aftercompletingthislesson,youshouldbeableto
dothefollowing:
Distinguishbetweentraditionalrecordviewsandmultidimensionalviews
Compareandcontrastonlinetransactionprocessing(OLTP)withonlineanalyticalprocessing(OLAP)
IdentifykeyfeaturesofExpress
DescribethreefundamentalExpressdatabaseobjects:Variables,Dimensions,andRelations
TraditionalFlatFileView
MultidimensionalView
TransactionalVersusAnalyticalProcessingTools
FeaturesofExpress
FeaturesofExpress
ExpressDatabaseStructure
Variables
Objectsthatstoredata
Twotypes:
Data
Description
Dimensions
ExpressMultidimensionality
MultipleDimensions
SharingDimensions
ElementsofanExpressSystem
Objectives
Aftercompletingthislesson,youshouldbeableto
dothefollowing:
IdentifytheproductcategoriesoftheExpressproductline
DescribeExpressServersoftwarecomponentsandExpressServerarchitecturaloptions
DescribethegeneraltasksrequiredtocreateanExpresssolution
ExpressProductCategories
Serverproducts:
ExpressServer
ExpressInstanceManager
ExpressWebAgent
RelationalAccessManager
ExpressAdministrator
ExpressProductCategories
Clienttools:
ExpressAnalyzer
ExpressObjects
ExpressWebPublisher
ExpressSpreadsheetAdd-In
ExpressProductCategories
Analyticsolutions:
OracleFinancialAnalyzer
OracleSalesAnalyzer
ExpressServer:CalculationEngine
Robust,multicubedatamodel
Built-inanalyticalfunctionality:
Mathematical,financial,andstatisticalfunctions
Exception,comparative,andtrendanalysis
Forecasting
Modeling
What-ifscenarios
StoredProcedureLanguage(SPL)
ManaginganInstanceofExpressServer
Objectives
Aftercompletingthislesson,youshouldbeableto
dothefollowing:
OpenandnavigateinExpressInstanceManager
StartandstopaninstanceofExpressServer
ManageExpressServerconfigurationparametersandmodules
ManageExpressclientsessions
CreateclientconnectionstoaninstanceofExpressServer
ExpressInstanceManager
StartsandstopsExpressservices
Managesconfigurationparameters
ManagesoptionalmodulesforanExpressservice
ManagesExpressclientsessions
Displayssystemlogfiles
CreatesnewExpressservicesandremovesexistingservices
InstanceManager’sMainWindow
NavigatinginInstanceManager
FindinganUnregisteredService
StartinganExpressService
ManagingConfigurationParameters
ManagingExpressServerModules
......,大小:1.08 MB