Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Provider Logo

Learning Oracle Database 12c

via LinkedIn Learning

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.

Syllabus

Introduction
  • Welcome
  • What you should know
  • Using the exercise files
1. Design Methodology and Tools
  • Database types and data modeling methodologies
  • Logical database modeling
  • Query and development tools
2. SQL Query Basics
  • SELECT statements: Capabilities and columns
  • Transformations done with SELECT statements
  • Be more SELECTive: WHERE do you use the WHERE clause?
3. Advanced Data Manipulation
  • Sort and group data
  • Single-row functions
  • Aggregate (group) functions
  • Using the set operators
  • Join tables
4. Modify and Create Database Object
  • Data manipulation language (DML): Explained
  • Data manipulation language (DML): In action
  • Data definition language (DDL)
5. Database Architecture
  • Memory
  • Storage
  • Processes
6. DBA Configuration Tools
  • Startup and shutdown
  • Dynamic Performance Views (V$)
  • Network naming methods
7. Manage Tablespaces and Disk Space
  • Manage tablespaces: Explained
  • Manage tablespaces: In action
  • Disk space management: Explained
  • Disk space management: In action
8. Table Compression
  • Table compression methodologies: Explained
  • Table compression methodologies: In action
9. Manage System-Related Tablespaces
  • Manage the UNDO tablespace
  • Manage REDO logs
  • Manage TEMP tablespaces
10. Database Monitoring
  • Alert log
  • ADDM, ASH, AWR
  • Monitor memory usage
Conclusion
  • Next steps

Taught by

Bob Bryla

Related Courses

Reviews

0.0 rating, based on 0 reviews

Start your review of Learning Oracle Database 12c

Never stop learning Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free