Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Learning Oracle Database 12c

Video Introducing this tutorial

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

You Have Got Gift 25% OFF

Use this Coupon Code “J3JKN396