New to DBA

[bih13]

Hi all,

Hope this is the right place to post this question. I recently joined a program that prepares students to become DBA's. Its a six month program, roughly. It's every weekend sat-sun, 4-7 P.M. I wanted to attach our course schedule and get some feedback from you guys to see if the topics covered in this course would prepare me for an actual job. Thanks!

Here is our course outline:

Oracle DBA Training - Schedule for Batch-29					
	Week	Day	Date	Topics	Notes
					
	UNIX Basics Training starts from here				
	1	Saturday	January 24, 2015	DBA training introduction	"Introduction, Wireless Key, Setup My_Documents, Set up VPN.
Other softwares --> Putty, XShell etc.
Internet architecture
Role of Database"
		Sunday	January 25, 2015	UNIX 01 -- Basics	Basic *NIX commands 01
	2	Saturday	January 31, 2015	"
UNIX 02 -- Basics"	Basic *NIX commands 02
		Sunday	February 1, 2015	UNIX 03 -- Basics 	Basics *NIX commands 03
	3	Saturday	February 7, 2015	UNIX 04 -- Basics 	Basics *NIX commands 03
		Sunday	February 8, 2015	UNIX 05 -- vi Editor 	vi editor
	SQL Training starts from here				
	4	Saturday	February 14, 2015		
		Sunday	February 15, 2015		
		Saturday	February 21, 2015	SQL  01 -- Oracle 11g/12c DB Installation on Windows	SQL  01 -- Oracle 11g/12c DB Installation on Windows
		Sunday	February 22, 2015	SQL  02 -- Intro to DataTypes / Create tables and other DML	SQL  02 -- Intro to DataTypes / Create tables and other DML
	5	Saturday	February 28, 2015	SQL  03 -- Sorting / Where Clause / Distinct / Expressions	
		Sunday	March 1, 2015	SQL 04 -- Group by / Order by / Having by / Update / Delete / Truncate	
	6	Saturday	March 7, 2015	SQL 05 -- Concatenation / View / And / Or / combining And Or / Like	To-char, round, Upper, Lower, Trunc / count / Sum / Min / Max, Index
		Sunday	March 8, 2015	SQL 06 -- Functions	Primary Key, Check , Unique, not null,
	7	Saturday	March 14, 2015	SQL 07 -- Constraints - I plus DCL, TCL	
		Sunday	March 15, 2015	SQL 08 -- Constraints - II plus DDL	Equijoins / Non-Equijoins / 
		Saturday	March 21, 2015	No Classes this weekend	
		Sunday	March 22, 2015		
	8	Saturday	March 28, 2015	SQL 09 -- SQL Joins 1	Simple Join / Inner Join / Outer Join / Self-Join / Cross-Join / Cartisian-Join
		Sunday	March 29, 2015	SQL 10 -- SQL Joins 2	
	DBA Training starts from here				
	9	Saturday	April 4, 2015	DBA 01 -- DB Networking 1	"Client - Server connectivity
ORACLE_BASE, ORACLE_HOME, Listener-- (Netca / Listener / tnsnames.ora)"
		Sunday	April 5, 2015	DBA 02 -- DB Networking 2	
	10	Saturday	April 11, 2015	DBA 03 -- Security - 1 	(create user, resource, connect, roles, profiles)
		Sunday	April 12, 2015	DBA 04 -- Security - 2 	(grants and privileges)
	11	Saturday	April 18, 2015	DBA 05 -- DB Shutdown stages 	normal, immediate, transactional, abort, (tail -f alertlog)
		Sunday	April 19, 2015	DBA 06 -- DB Startup stages 	nomount (pfile), mount (controlfiles), startup (open)
	12	Saturday	April 25, 2015	DBA 07 -- Oracle DB Installation on Linux 	need xwindow like exceed, cygwin, etc
		Sunday	April 26, 2015	DBA 08 -- Data Block Architecture 	"block, extent, segment, tablespace, database, server, cluster..
PCTFree, PCTUsed, Row Chaining, Row Migration"
		Saturday	May 2, 2015	No Classes this weekend	
		Sunday	May 3, 2015		
	13	Saturday	May 9, 2015	DBA 09 -- Instance Management 	SGA, PGA, UGA Management plus background processes
		Sunday	May 10, 2015	DBA 10 -- Parameter Management	Dynamic vs static parameters
	14	Saturday	May 16, 2015	DBA 11 -- Tablespace Management	Tablespace management
		Sunday	May 17, 2015	DBA 12 --  Database CPU Patches	Oracle Quarterly patches
		Saturday	May 23, 2015	No Classes this weekend (Memorial Day)	
		Sunday	May 24, 2015		
	15	Saturday	May 23, 2015	DBA 13 -- Introduction to Toad -1, SQL Loader	Load csv data using sqlldr utility
		Sunday	May 24, 2015	DBA 14 -- Export-Import 1	using exp/imp -1
	16	Saturday	May 30, 2015	DBA 15 --  Export-Import 2	 using exp/imp -2
		Sunday	May 31, 2015	DBA 16 --  Export-Import 3	 using datapump
		Saturday	June 6, 2015	DBA 17 -- Redo Log Management - 1	Online Redo Logs
		Sunday	June 7, 2015	DBA 18 -- Redo Log Management - 2	Offline Redo Logs (ArchiveLogs)
	17	Saturday	June 13, 2015	DBA 19 -- Backup and Recovery - 1 	User Manage Backup
		Sunday	June 14, 2015	DBA 20 -- Backup and Recovery - 2	Using RMAN
	18	Saturday	June 20, 2015	DBA 21 -- Backup and Recovery - 3 	Using RMAN
		Sunday	June 21, 2015	DBA 22 -- Backup and Recocery - 4	Using RMAN
	19	Saturday	June 27, 2015	DBA 23 -- TOAD	Manage DB from different TOAD
		Sunday	June 28, 2015	DBA 24 -- Cloud Clontrol	Manage DB from 12c cloud control
	20	Saturday	July 4, 2015	No Classes this weekend (Independance Day)	
		Sunday	July 5, 2015		
	21	Monday	July 11, 2015		
		Tuesday	July 12, 2015

[gandolf989]

The course seems interesting. After you finish if you want to get a job as a DBA you need to get experience.
You might be able to find work in a DBA outsourcing company. They usually have high turn over, but will give
you really good experience.

You can also try volunteering your new skills to a non profit. Good luck!

[bih13]

Do you think its enough information to be productive on the job?

[gandolf989]

That will probably be enough information, but it helps to find a mentor who can guide you through the harder
less defined issues. You should be able to install Oracle, patch Oracle both to a new full version and patch set
update, create a database, know how to allocate memory, online redo, backup clone and tune.

You just need the exposure to all of the issues that can happen and know what to do when an issue comes up.

[gandolf989]

That will probably be enough information, but it helps to find a mentor who can guide you through the harder
less defined issues. You should be able to install Oracle, patch Oracle both to a new full version and patch set
update, create a database, know how to allocate memory, online redo, backup clone and tune.

You just need the exposure to all of the issues that can happen and know what to do when an issue comes up.