ABCDE
1
Oracle DBA Training - Batch 33 schedule | Class timings 4 to 7 PM on Saturday & Sunday
2
WeekDateTopicsNotes
3
4
UNIX Basics Training starts from here
5
1Saturday, May 14, 2016DBA training introductionIntroduction, Wireless Key, Setup My_Documents, Set up VPN.
Other softwares --> Putty, XShell etc.
Internet architecture
Role of Database
6
Sunday, May 15, 2016UNIX 01 -- BasicsBasic *NIX commands 01
7
2Saturday, May 21, 2016
UNIX 02 -- Basics		Basic *NIX commands 02
8
Sunday, May 22, 2016UNIX 03 -- Basics Basics *NIX commands 03
9
Saturday, May 28, 2016UNIX 04 -- BasicsBasics *NIX commands 04
10
Sunday, May 29, 2016UNIX 05 -- Basics Basics *NIX commands 05
11
3Saturday, June 4, 2016UNIX 06 -- Basics Basics *NIX commands 06
12
Sunday, June 5, 2016UNIX 07 -- vi Editor vi editor
13
Saturday, June 11, 2016No classes this weekend (Ramadan Begins)
14
Sunday, June 12, 2016
15
SQL Training starts from here
16
4Saturday, June 18, 2016SQL 01 -- Oracle 11g/12c DB Installation on WindowsSQL 01 -- Oracle 11g/12c DB Installation on Windows
17
Sunday, June 19, 2016SQL 02 -- Intro to DataTypes / Create tables and other DMLSQL 02 -- Intro to DataTypes / Create tables and other DML
18
Saturday, June 25, 2016No classes this weekend (3rd week of Ramadan)
19
Sunday, June 26, 2016
20
Saturday, July 2, 2016No classes this weekend (Last week of Ramadan)
21
Sunday, July 3, 2016
22
5Saturday, July 9, 2016SQL 03 -- Sorting / Where Clause / Distinct / Expressions
23
Sunday, July 10, 2016SQL 04 -- Group by / Order by / Having by / Update / Delete / Truncate
24
6Saturday, July 16, 2016SQL 07 -- Constraints - I plus DCL, TCL
25
Sunday, July 17, 2016SQL 08 -- Constraints - II plus DDLEquijoins / Non-Equijoins /
26
7Saturday, July 23, 2016SQL 09 -- SQL Joins 1Simple Join / Inner Join / Outer Join / Self-Join / Cross-Join / Cartisian-Join
27
Sunday, July 24, 2016SQL 10 -- SQL Joins 2
28
Oracle DBA Training starts from here
29
8Saturday, July 30, 2016DBA 01 -- DB Networking 1Client - Server connectivity
ORACLE_BASE, ORACLE_HOME, Listener-- (Netca / Listener / tnsnames.ora)
30
Sunday, July 31, 2016DBA 02 -- DB Networking 2
31
9Saturday, August 6, 2016DBA 03 -- Security - 1 (create user, resource, connect, roles, profiles)
32
Sunday, August 7, 2016DBA 04 -- Security - 2 (grants and privileges)
33
10Saturday, August 13, 2016DBA 05 -- DB Shutdown stages normal, immediate, transactional, abort, (tail -f alertlog)
34
Sunday, August 14, 2016DBA 06 -- DB Startup stages nomount (pfile), mount (controlfiles), startup (open)
35
11Saturday, August 20, 2016DBA 07 -- Oracle DB Installation on Linux need xwindow like exceed, cygwin, etc
36
Sunday, August 21, 2016DBA 08 -- Data Block Architecture block, extent, segment, tablespace, database, server, cluster..
PCTFree, PCTUsed, Row Chaining, Row Migration
37
12Saturday, August 27, 2016DBA 09 -- Instance Management SGA, PGA, UGA Management plus background processes
38
Sunday, August 28, 2016DBA 10 -- Parameter ManagementDynamic vs static parameters
39
Saturday, September 3, 2016No Classes
40
Sunday, September 4, 2016
41
13Saturday, September 10, 2016DBA 11 -- Tablespace ManagementTablespace management
42
Sunday, September 11, 2016DBA 12 -- Database CPU PatchesOracle Quarterly patches
43
14Saturday, September 17, 2016DBA 13 -- Introduction to Toad -1, SQL LoaderLoad csv data using sqlldr utility
44
Sunday, September 18, 2016DBA 14 -- Export-Import 1using exp/imp -1
45
Saturday, September 24, 2016DBA 15 -- Export-Import 2 using exp/imp -2
46
Sunday, September 25, 2016DBA 16 -- Export-Import 3 using datapump
47
15Saturday, October 1, 2016DBA 17 -- Redo Log Management - 1Online Redo Logs
48
Sunday, October 2, 2016DBA 18 -- Redo Log Management - 2Offline Redo Logs (ArchiveLogs)
49
16Saturday, October 8, 2016DBA 19 -- Backup and Recovery - 1 User Manage Backup
50
Sunday, October 9, 2016DBA 20 -- Backup and Recovery - 2Using RMAN
51
17Saturday, October 15, 2016DBA 21 -- Backup and Recovery - 3 Using RMAN
52
Sunday, October 16, 2016DBA 22 -- Backup and Recovery - 4Using RMAN
53
18Saturday, October 22, 2016DBA 23 -- TOAD (optional)Manage DB from different TOAD
54
Sunday, October 23, 2016DBA 24 -- Cloud Clontrol (optional)Manage DB from 12c cloud control
55
19Saturday, October 29, 2016Extra Weekend 1
56
Sunday, October 30, 2016
57
20Saturday, November 5, 2016Extra Weekend 2
58
Sunday, November 6, 2016
59
60