Oracle Database Administration Workshop ( 12c and Higher)
Very helpful course for exam 1Z0-072 or 1Z0-082 ,more than 27 Hours that Prepare You to be a good DBA
- Descrição
- Currículo
- FAQ
- Revisões
Tempo de leitura less than a minute
This Course is one of the best courses ever in Oracle Administration (12c, 18c, 19c ).
Be ready to become very good Oracle DBA after finishing this course .
The course is more than 27 Hours of HD videos.
Very helpful course for exam 1Z0-072 or 1Z0-082.
All the presentations , PDFS and scripts are available for download.
my courses are the best seller and the highest rated in udemy, i do not create content that you find it easily in free websites and YouTube.
The course start from zero knowledge in Oracle Administration , but remember that SQL is a must.
simply this course is the best.
Download & installing + Basic Linux commands
-
1
Basic Introduction -
2
Brief History of Oracle Database
-
3
Oracle DB editions
-
4
Database VS Database Instance
-
5
sever processes and the PGA
-
6
System Global Area Part 1
-
7
System Global Area Part 2
-
8
Background Processes
-
9
Database Files
-
10
Logical Storage Structure
-
11
Default tablespaces
-
12
Multitenant Database 12c /18c
-
13
DBA Tasks and tools
-
14
Installation Methods and OS
Database Startup,shutdown and connections
-
15
Overview about installation steps
-
16
Downloading and installing Oracle Vbox
-
17
Downloading oracle Linux image
-
18
Creating our virtual machine for this course
-
19
Installing oracle Linux
-
20
Installing gust additions
-
21
Creating shared folder
-
22
Basic Linux commands part 1
-
23
Basic Linux commands part 2
-
24
Basic Linux commands part 3
-
25
Prerequisites for installing oracle DB 18c
-
26
Valuable information about the installation Prerequisites
-
27
OS configurations for oracle user
-
28
Downloading and installing oracle DB 18c
Helpful queries to explore Oracle DB architecture
-
29
Database Startup part 1
-
30
Database Startup part 2
-
31
Shutdown database part 1
-
32
Shutdown database part 2
-
33
Understanding oracle listener and Listener.ora
-
34
Understanding service name
-
35
Understanding tnsnames.ora
-
36
How client connections work
-
37
Installing Putty and so connections
-
38
Installing winSCP and so connections
-
39
Installing Oracle SQL developer (client side)
-
40
Connecting sys user in many methods
-
41
Moving from container to pluggable
-
42
Starting and stopping the listener
-
43
Easy connect method
-
44
connecting using tnsnames
-
45
unlock the hr schema in the pluggable database
-
46
saving and runing scripts
Managing Database Instance
-
47
oracle data dictionary concept
-
48
Common uses VS local users part 1
-
49
Common uses VS local users part 2
-
50
Understanding Dynamic Performance Views
-
51
cdb_ & dba_ when you are inside a pluggable
-
52
query the data files
-
53
query the temps files
-
54
V$DATABASE / v$version / v$instance
-
55
V$CONTAINERS / cdb_PDBS
-
56
V$DATAFILE
-
57
cdb_tablespaces / V$TABLESPACE
-
58
v$logfile / V$CONTROLFILE
-
59
Pluggable Database Save state
Creating PDBs
-
60
Initialization Parameters & Parameters Files
-
61
Search order for a parameter file
-
62
Uses of Initialization Parameters
-
63
Types of Initialization Parameters
-
64
About Modifying Initialization Parameters
-
65
Alter session example
-
66
v$parameter VS v$parameter2
-
67
v$system_parameter VS v$system_parameter2
-
68
example: Search order for a parameter file and creating pfile
-
69
Understanding the parameter spfile
-
70
creating non default name for pfile and startup
-
71
alter system example ( memory )
-
72
alter system example ( spfile )
-
73
alter system example ( both )
-
74
Default scope in alter statement part 1
-
75
Default scope in alter statement part 2
-
76
CONTAINER clause in alter system & Inheritance 1
-
77
CONTAINER clause in alter system & Inheritance 2
-
78
About Automatic Diagnostic Repository
-
79
The alert log Part 1
-
80
The alert log Part 2
-
81
View alert log using ADRCI
-
82
Trace files and Purging Part 1
-
83
Trace files and Purging Part 2
-
84
Enable DDL logging
-
85
V$SPPARAMETER
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
Estrelas 5
1479
Estrelas 4
896
Estrelas 3
233
Estrelas 2
27
Estrelas 1
23
Categoria:
Course details
Vídeo
27 hours
Sessões de Formação
2
Certificate of Completion
Popular courses
