Learning Oracle Database 12c
Overview
In this course, database administrators can learn how to configure Oracle Database 12c, and business intelligence developers can learn how to effectively write applications using it.
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.
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.
Syllabus
Introduction
- Welcome
- What you should know
- Using the exercise files
- Database types and data modeling methodologies
- Logical database modeling
- Query and development tools
- SELECT statements: Capabilities and columns
- Transformations done with SELECT statements
- Be more SELECTive: WHERE do you use the WHERE clause?
- Sort and group data
- Single-row functions
- Aggregate (group) functions
- Using the set operators
- Join tables
- Data manipulation language (DML): Explained
- Data manipulation language (DML): In action
- Data definition language (DDL)
- Memory
- Storage
- Processes
- Startup and shutdown
- Dynamic Performance Views (V$)
- Network naming methods
- Manage tablespaces: Explained
- Manage tablespaces: In action
- Disk space management: Explained
- Disk space management: In action
- Table compression methodologies: Explained
- Table compression methodologies: In action
- Manage the UNDO tablespace
- Manage REDO logs
- Manage TEMP tablespaces
- Alert log
- ADDM, ASH, AWR
- Monitor memory usage
- Next steps
Taught by
Bob Bryla
Related Courses
Reviews
0.0 rating, based on 0 reviews