Users Online
· Guests Online: 8
· Members Online: 0
· Total Members: 188
· Newest Member: meenachowdary055
· Members Online: 0
· Total Members: 188
· Newest Member: meenachowdary055
Forum Threads
Newest Threads
No Threads created
Hottest Threads
No Threads created
Latest Articles
DEMO - Oracle 12c Database Administration Fundamentals
DEMO - Oracle 12c Database Administration FundamentalsOracle Technologies |
| Categories | Most Recent | Top Rated | Popular Courses |
 | Uploader | Date Added | Views | Rating |
| Superadmin | 01.01.70 | 444 | No Rating | |
| Description | ||||
| Oracle Database 12c is the world's leading relational database management system. In this course, Oracle certified instructor and consultant David Yahalom provides an overview of this powerful database, focusing on those brand new to the software. David covers the Oracle database architecture in detail, including the shared pool, buffer cache, and physical and logical storage structures. He also discusses concepts such as tablespaces, data files, and redo logs. He then moves onto installation and configuration of the database itself, reviewing the Oracle CLI and GUI administration and development tools and typical administration tasks, including backup and recovery. After completing this course, you'll have fundamentals required for installation, configuration, and administration of an Oracle 12c database. Topics include: 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 Introduction Welcome 1m 34s Target audience 1m 13s Exercise files 19s Learning supports 25s 1. Architecture Database instance 3m 26s Database storage 4m 14s Server processes 5m 56s 2. Instance Memory Pools System global area 2m 19s Shared pool 5m 37s Buffer cache 3m 37s Redo log buffer 4m 46s Other SGA pools and the PGA 3m 52s SGA and PGA sizing 4m 24s 3. Instance Background Processes Database writer 4m 58s Log writer 6m 2s Checkpoint process 2m 30s SMON process 44s PMON process 38s RECO process 1m 35s LREG process 2m 27s Archiver process 2m 15s 4. Client Connections Oralce listener 5m 22s TNSNAMES.ORA config files 5m 30s How client connections work 2m 55s 5. Physical Database Structures Database storage file types 2m 26s Datafiles and tablespaces 8m 39s Special Oracle tablespaces 3m 2s Redo log files 4m 5s Control files 2m 5s Backup files 4m 49s Additional storage files 3m 19s 6. Mulitenant Database Benefits of the 12c architecture 2m 47s New vs. Old 2m 22s Backward compatabiltiy 1m 19s 7. Start and Stop the Database Startup 3m 35s Shutdown 3m 46s 8. Install Oracle 12c software Prerequisites for installation 14m 19s O/S configuration 6m 43s Download the software 4m 3s Install software 6m 36s 9. Create a Database Instance Use NETCA to create a listener 3m 36s Use DBCA to create a database 14m 58s 10. Tools for Developers and DBAs SQL *Plus for administration 4m 16s SQL Developer for development 13m 57s Oracle Enterprise Manager 8m 3s 11. Management Start and stop the instance 3m 24s Start and stop the listener 3m 4s View and set parameters 5m 27s Create users and assign permissions 9m Data dictionary 8m 20s Troubleshoot using the Alert Log 5m 13s Storage: Tablespaces and datafiles 7m 24s Conclusion Next steps 1m 17s | ||||
Ratings
Comments
No Comments have been Posted.
Post Comment
Please Login to Post a Comment.