Author
Released
11/9/2016After completing this course, you'll have fundamentals required for installation, configuration, and administration of an Oracle 12c database.
- Database instance and storage
- Instance memory pools
- Instance background processes
- Client connections
- Database storage file types
- Control files and backup files
- Multitenant databases
- Starting and stopping the database
- Installing Oracle 12c software
- Using the developer tools
- Database management
Skill Level Beginner
Duration
Views
- Hi, I'm David Yahalom, and welcome to Oracle 12c Database Fundamentals. In this course, you will learn the fundamentals required to become an Oracle 12c Database expert. We will take a deep dive into the Oracle 12c architecture, learn how to install the Oracle 12c Database software, configure and start the Oracle 12c Instance, and basically learn everything required from a theoretical as well as a hands-on perspective to start your career as an Oracle expert.
I'll start by explaining the Oracle 12c Database architecture, and how the different individual components act together to enable one of the world's most powerful databases. We will continue with a deep dive into the Oracle Instance, explaining the purpose of the Oracle Shared Pool, Buffer Cache, and outer components, as well as review the different background processes Oracle utilizes for database processing. We will continue by exploring the different Oracle storage structures, both physical as well as logical, and learn the functions of tablespaces, data files, Redo Logs, and more.
After we've got the conceptual basics explained, and got a good handle on the Oracle 12c architecture, we will review how to install and configure the Oracle Database as well as the various tools used to manage and work with Oracle. So grab some coffee, get ready, as the fun's about to start.
Related Courses
-
Database Foundations: Core Concepts
with Adam Wilbert2h 14m Beginner -
Database Foundations: Administration
with Adam Wilbert1h 14m Beginner -
Oracle 12c: New Features
with David Yahalom4h 22m Intermediate
-
Introduction
-
Welcome1m 34s
-
Target audience1m 13s
-
Exercise files19s
-
-
1. Architecture
-
Database instance3m 26s
-
Database storage4m 14s
-
Server processes5m 56s
-
-
2. Instance Memory Pools
-
System global area2m 19s
-
Shared pool5m 37s
-
Buffer cache3m 37s
-
Redo log buffer4m 46s
-
Other SGA pools and the PGA3m 51s
-
SGA and PGA sizing4m 24s
-
-
3. Instance Background Processes
-
Database writer4m 58s
-
Log writer6m 2s
-
Checkpoint process2m 30s
-
SMON process44s
-
PMON process38s
-
RECO process1m 35s
-
LREG process2m 27s
-
Archiver process2m 15s
-
-
4. Client Connections
-
Oracle listener5m 22s
-
TNSNAMES.ORA config files5m 30s
-
How client connections work2m 55s
-
-
5. Physical Database Structures
-
Database storage file types2m 26s
-
Datafiles and tablespaces8m 39s
-
Redo log files4m 5s
-
Control files2m 4s
-
Backup files4m 49s
-
Additional storage files3m 19s
-
-
6. Multitenant Database
-
New vs. old2m 22s
-
Backward compatibility1m 19s
-
7. Start and Stop the Database
-
8. Install Oracle 12c software
-
Prerequisites for installation14m 10s
-
O/S configuration6m 43s
-
Download the software4m 3s
-
Install software6m 36s
-
-
9. Create a Database Instance
-
Use DBCA to create a database14m 55s
-
10. Tools for Developers and DBAs
-
SQL *Plus for administration4m 16s
-
SQL Developer for development13m 57s
-
Oracle Enterprise Manager8m 14s
-
-
11. Management
-
Start and stop the instance3m 20s
-
View and set parameters5m 27s
-
Data dictionary8m 20s
-
-
Conclusion
-
Next steps1m 17s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Welcome