Oracle​ ​DBA​ ​Training​ ​Course​ 2019 _ Junior Data Scientist |Taahseen Ali Abro

: left;" trbidi="on">

​Oracle​ ​DBA​ ​Training​ ​Course​ ​Content: 

Infrastructure​ ​setup 

●Installation​ ​of​ ​Virtual​ ​workstation 

●Installation​ ​of​ ​OEL​ ​Operating​ ​system 

●OEL​ ​Oracle​ ​Enterprise​ ​Linux 

●Disk​ ​Druid​ ​configuration 

●Manual​ ​partitions 

●Assigning​ ​​​ ​​static​ ​ip​ ​to​ ​Ethernet 

●Time​ ​zone​ ​selection 

●Root​ ​user​ ​password​ ​configuration 

●Packages​ ​selection 

●Post​ ​installation​ ​configuration 

●Login​ ​to​ ​the​ ​OS 

●Installing​ ​Virtual​ ​tools 

●Sharing​ ​of​ ​Folders​ ​from​ ​host​ ​OS​ ​to​ ​virtual​ ​OS 

●Cloning​ ​of​ ​OS​ ​in​ ​virtual​ ​workstation 

●Start​ ​and​ ​Shut​ ​of​ ​OS 

Basic​ ​Linux​ ​commands 

●Pre​ ​Installation​ ​Configuration 

●Creating​ ​group 

●Creating​ ​user 

●Password​ ​assigning 

●Crelist 

●creating​ ​file​ ​with​ ​cat 

●appending​ ​file​ ​with​ ​cat 

●view​ ​file​ ​contents​ ​with​ ​cat 

●moving​ ​and​ ​renaming​ ​a​ ​file 

●copy​ ​​​ ​​commands 

●remove​ ​commands 

●creation​ ​of​ ​Directory 

●touch 

●persistence 

●visual​ ​editor 

●time​ ​stamp 

●Groups 

●Users 

●password​ ​configuration 

●Normal​ ​user​ ​switching 

●Xhost​ ​+​ ​hostname​ ​configuration 

●netconfig 

●neat 

●service​ ​restarting 

●Basic​ ​file​ ​permission 

●Ownership 

●Change​ ​directory 

●change​ ​mod 

●Present​ ​working​ ​directory 

●Bash​ ​profile 

●executing​ ​bash​ ​profile 

●head 

●tail 

●ate​ ​directory​ ​path 

●Permissions 

●Ownership 

●Bash​ ​profile 

●Executing​ ​bash 

●XHOST​ ​+Switching​ ​user 

Installing​ ​ORACLE​ ​And​ ​Database​ ​creation 

●Basic​ ​Installation​ ​method 

●Advance​ ​Installation​ ​method 

●DBCA​ ​Method 

●Manual​ ​Database​ ​creation 

Connecting​ ​to​ ​Database 

●SQLPLUS​ ​​​ ​​tool 

●Verify​ ​​​ ​​database​ ​name 

●Verify​ ​database​ ​status 

●Verify​ ​​​ ​​control​ ​file​ ​location 

●Verify​ ​data​ ​files​ ​location 

●Verify​ ​redo​ ​log​ ​files​ ​location 

●Verify​ ​flash​ ​recovery​ ​area​ ​location 

●Verify​ ​Archive​ ​mode​ ​or​ ​No​ ​archive​ ​mode 

●Shut​ ​database 

●Startup​ ​database 

Parameter​ ​file​ ​management 

●Database​ ​startup​ ​process 

●Database​ ​No​ ​mount​ ​stage 

●SID​ ​and​ ​Parameter​ ​file 

●PFILE​ ​​​ ​​location 

●PFILE​ ​Name 

●PFILE​ ​Configuration 

●Verify​ ​PFILE​ ​OR​ ​SPFILE​ ​in​ ​DB 

●SPFILE​ ​Name 

●SPFILE​ ​Configuration 

●SPFILE​ ​​​ ​​Memory​ ​option 

●SPFILE​ ​Scope​ ​option 

●SPFILE​ ​​​ ​​SPFILE​ ​​​ ​​option 

●Create​ ​SPFILE​ ​from​ ​SPFILE 

●Create​ ​PFILE​ ​from​ ​SPFILE 

●Backup​ ​and​ ​Restoration​ ​of​ ​Parameter​ ​file 

Control​ ​file​ ​management 

●ORACLE​ ​instance​ ​start​ ​up​ ​process 

●DATABASE​ ​​​ ​​Mount​ ​Stage 

●Control​ ​file​ ​characteristics 

●Control​ ​file​ ​multiplexing 

●Verify​ ​multiplexing 

Redo​ ​Log​ ​file​ ​management 

●ORACLE​ ​Instance 

●REDOLOG​ ​Algorithm 

●REDOLOG​ ​multiplexing 

●View​ ​Redo​ ​log​ ​Groups 

●View​ ​Redo​ ​log​ ​members 

●Redo​ ​log​ ​creation 

●Drop​ ​Redo​ ​log​ ​group​ ​,​ ​member 

●Adding​ ​member​ ​to​ ​Redo​ ​log​ ​group 

●View​ ​status 

●Manual​ ​Switching 

●Drop​ ​members​ ​from​ ​group 

​ ​​Archive​ ​Log​ ​And​ ​Flash​ ​Recovery​ ​Area 

●Configuring​ ​Database​ ​in​ ​Archive​ ​log​ ​mode 

●Configuring​ ​database​ ​in​ ​no​ ​archive​ ​log​ ​mode 

●Configure​ ​FRA 

●Manual​ ​switching 

●Verify 

Table​ ​space​ ​Management 

●Permanent​ ​table​ ​space 

●Temporary​ ​table​ ​space 

●Undo​ ​table​ ​space 

●SYSTEM​ ​.dbf 

●SYSAUX.dbf 

●Users.dbf 

●Temp.dbf 

●Unodtbs.dbf 

●Roll​ ​back 

●Creating​ ​permanent​ ​table​ ​space​ ​with​ ​limited​ ​size 

●Creating​ ​permanent​ ​table​ ​space​ ​with​ ​unlimited​ ​size 

●Creating​ ​permanent​ ​table​ ​space​ ​with​ ​fixed​ ​size 

●Adding​ ​data​ ​file​ ​to​ ​existing​ ​table​ ​space 

●Resizing​ ​data​ ​file 

●Table​ ​space​ ​online 

●Table​ ​space​ ​offline 

●Drop​ ​table​ ​space 

●Auto​ ​extend​ ​feature 

●View​ ​user​ ​table​ ​space 

●Determine​ ​Database​ ​size 

●Determine​ ​used​ ​database​ ​size 

●Determine​ ​allocate​ ​data​ ​size 

●Determine​ ​table​ ​space​ ​size 

●Determine​ ​table​ ​size 

●User​ ​Management​ ​And​ ​Security 

●Database​ ​user​ ​creation 

●User​ ​connects​ ​to​ ​database 

●Creating​ ​role 

●Assigning​ ​privilege​ ​to​ ​role 

●Assigning​ ​role​ ​to​ ​a​ ​user 

●Revoking​ ​privilege​ ​from​ ​role 

●View​ ​user​ ​roles 

●View​ ​user​ ​privileges 

●Password​ ​set​ ​for​ ​user 

●User​ ​account​ ​lock 

●User​ ​account​ ​unlock 

●Drop​ ​a​ ​user 

●User​ ​creation​ ​with​ ​Permanent​ ​table​ ​space 

●User​ ​creation​ ​with​ ​Temporary​ ​table​ ​space 

●Quota​ ​configuration 

●Quota​ ​increase 

●Quota​ ​decrease 

●Quota​ ​revoke 

●Quota​ ​unlimited 

●Security​ ​Profile  

●Security​ ​Password 

●Security​ ​Kernel 

Oracle​ ​Network​ ​Services 

●TCP​ ​IP​ ​Configuration 

●Ping 

●Listener 

●Tns​ ​names 

●Netca​ ​tool 

●Port​ ​Range 

●Location 

●Listener​ ​services 

●Bouncing​ ​services 

●Stop​ ​service 

●Start​ ​service 

●status​ ​service 

●Testing​ ​connection 

●Client​ ​side​ ​tns​ ​configuration 

●Linux​ ​to​ ​Linux​ ​setup 

Backup​ ​​​ ​​And​ ​Restoration 

●Logical​ ​backup 

●Physical​ ​backup 

●Online​ ​backup 

●Offline​ ​backup 

●Import​ ​statement 

●Export​ ​Statement 

●Data​ ​pump​ ​technology 

●Full​ ​database​ ​level​ ​backup 

●Incremental​ ​level​ ​backup 

●Cumulative​ ​level​ ​backup 

●User​ ​level​ ​backup 

●Table​ ​level​ ​backup 

​ ​​Patch​ ​Management 

●What​ ​is​ ​a​ ​patch 

●Understand​ ​Oracle​ ​version 

●Installing​ ​Oracle​ ​software 

●Creating​ ​database​ ​10g 

●Patch​ ​set​ ​procedure 

●Unzip​ ​the​ ​patch​ ​set 

●Apply​ ​patch 

●scripts 

●Verify​ ​invalid​ ​objects 

●Recompile 

●Verify​ ​Oracle​ ​version 

Up​ ​gradation​ ​from​ ​10g​ ​to​ ​11g 

●Understanding​ ​Pre​ ​requisite​ ​for​ ​upgrade 

●Verify​ ​existing​ ​Oracle​ ​home​ ​location 

●Verify​ ​existing​ ​Oracle​ ​Base​ ​location 

●Installing​ ​11g 

●Verify​ ​pre​ ​upgrade​ ​script 

●Modification​ ​of​ ​Parameter​ ​file​ ​values 

●Upgrading​ ​database​ ​with​ ​11g 

●Verify​ ​invalid​ ​objects 

●Recompile 

●Verify​ ​Oracle​ ​version 

Cloning 

●Cloning​ ​concept 

●Online​ ​Cloning 

●Pre​ ​requisite​ ​for​ ​online​ ​cloning 

●online​ ​backup 

●Generate​ ​control​ ​trace​ ​file 

●Conversion​ ​of​ ​trace​ ​file 

●Preparing​ ​client​ ​machine 

●Cloning​ ​on​ ​client​ ​machine 

●Recover​ ​data​ ​from​ ​archive​ ​log 

●Verify​ ​cloning​ ​on​ ​client​ ​machine 

Automatic​ ​Storage​ ​Management 

●ASM​ ​Concept 

●Pre​ ​requisite​ ​ASM 

●Disk​ ​group​ ​creation 

●ASM​ ​Instance​ ​configuration 

●Local​ ​configuration​ ​add 

●ASM​ ​disk 

●Installing​ ​Oracle​ ​binaries 

●RDBMS​ ​instance​ ​configuration 

●Manual​ ​database​ ​creation​ ​on​ ​storage 

●verify​ ​database​ ​creation 

Data​ ​Guard​ ​-​ ​Disaster​ ​Recovery​ ​solution 

●Data​ ​Guard​ ​concept 

●Feature​ ​of​ ​DG 

●Implementing​ ​DG 

●Pre​ ​requisite​ ​of​ ​DG 

●DG​ ​configuration​ ​on​ ​Primary​ ​server 

●DG​ ​configuration​ ​on​ ​secondary​ ​server 

●Verify​ ​replication​ ​through​ ​manual​ ​switch​ ​log​ ​files 

Recovery​ ​Manager​ ​Infrastructure​ ​setup 

●Pre​ ​requisite​ ​of​ ​RMAN 

●RMAN​ ​configuration​ ​on​ ​server​ ​side 

●RMAN​ ​configuration​ ​on​ ​client​ ​side 

●connecting​ ​to​ ​idle​ ​catalog​ ​database 

●create​ ​catalog​ ​database 

●RMAN​ ​database​ ​register 

●verify​ ​target​ ​server​ ​information 

●RMAN​ ​statements 

●Using​ ​RMAN​ ​backup 

tahseenaliabro