Learning Oracle Database 12c
2h 57mBeginner2017-03-30
Authors
Bob Bryla
30 years of experience in the database business
Course details
In this course, Oracle expert and author Bob Bryla goes beyond the fundamentals of administering an Oracle database, and dives deep into the skills an Oracle power user needs to know. Bob reviews the database architecture and shows how a database administrator (DBA) can more effectively manage and configure an Oracle database. At the same time, he explains the database's features that enable a business intelligence (BI) developer to effectively write applications using Oracle Database 12c.
Learning objectives
Design methodology and tools
SQL query basics
Advanced data manipulation
Modifying and creating a database object
Database architecture
DBA configuration tools
Managing tablespaces and disk space
Table compression
Manage system-related tablespaces
Database monitoring
Learning objectives
Design methodology and tools
SQL query basics
Advanced data manipulation
Modifying and creating a database object
Database architecture
DBA configuration tools
Managing tablespaces and disk space
Table compression
Manage system-related tablespaces
Database monitoring
Skills covered
Oracle DatabaseDatabase AdministrationOracleDatabase Management
Concepts
0. Introduction
- 01 - Welcome
- 02 - What you should know
- 03 - Using the exercise files
1. Design Methodology and Tools
- 04 - Database types and data modeling methodologies
- 05 - Logical database modeling
- 06 - Query and development tools
2. SQL Query Basics
- 07 - SELECT statements - Capabilities and columns
- 08 - Transformations done with SELECT statements
- 09 - Be more SELECTive - WHERE do you use the WHERE clause
3. Advanced Data Manipulation
- 10 - Sort and group data
- 11 - Single-row functions
- 12 - Aggregate (group) functions
- 13 - Using the set operators
- 14 - Join tables
4. Modify and Create Database Object
- 15 - Data manipulation language (DML) - Explained
- 16 - Data manipulation language (DML) - In action
- 17 - Data definition language (DDL)
5. Database Architecture
- 18 - Memory
- 19 - Storage
- 20 - Processes
6. DBA Configuration Tools
- 21 - Startup and shutdown
- 22 - Dynamic Performance Views (V$)
- 23 - Network naming methods
7. Manage Tablespaces and Disk Space
- 24 - Manage tablespaces - Explained
- 25 - Manage tablespaces - In action
- 26 - Disk space management - Explained
- 27 - Disk space management - In action
8. Table Compression
- 28 - Table compression methodologies - Explained
- 29 - Table compression methodologies - In action
9. Manage System-Related Tablespaces
- 30 - Manage the UNDO tablespace
- 31 - Manage REDO logs
- 32 - Manage TEMP tablespaces
10. Database Monitoring
- 33 - Alert log
- 34 - ADDM, ASH, AWR
- 35 - Monitor memory usage
Conclusion
- 36 - Next steps