ORACLE12C from beginner to Proficient (second edition) Shangong Kinsong Authoring

The cover of the book

Objective

1th Overview of Oracle Databases

1.1 Oracle Database product structure and composition

1.1.1 Standard Edition 1

1.1.2 Standard Edition

1.1.3 Enterprise Edition

1.2 Basic terminology of databases

1.2.1 Database
1.2.2 Database Management System
1, 2.3 Database system
1.2.4 Database Schema
1.2.5 Data Model
1.2.6 Data integrity constraints
1.2.7 online transaction processing and online analytical processing
1.2.8 Data Warehouse

1.3 Oracle Basic Terminology

1.3.1 Data Dictionary
1.3.2 Data files
1.3.3 Control files
1.3.4 Log files
1.3.5 Table Space
1.3.6 Segment
1.3.7 District
1.3.8 Data Block

New features of 1.4 oracle12c

1.4.1 Database Management Section
1.4.2 CDB and PDB sections
1.4.3 Cloud Connection

2nd installation and configuration of Oracle on WINDOWS8

2.1 Download version of oracle12cr1forwindowsx64

2.2 Oracle Universal Installer

2.3 Installation readiness for Oracle database software

2.4 Installation process

2.5 Configuring services

2.6 Post-installation verification

3rd. SQL Basics

3.1 SQL Overview

3.1.1 Features of SQL
Features of 3.1.2 SQL
3.1.3 Rules for writing SQL statements

3.2 Data definition

3.2.1 CREATE
3.2.2 DROP
3.2.3 ALTER

3.3 Data Query

3.3.1 Simple Query
3.3.2 WHERE clause
3.3.3 clause
3.3.4 groupby clause
3.3.5 HAVING clause
3.3.6 Multi-Table connection query
3.3.7 Collection Operations
3.3.8 Sub-query

3.4 Data manipulation

3.4.1 INSERT statement
3.4.2 UPDATE statement
3.4.3 DELETE statement
3.4.4 TRUNCATE statements

3.5 Data Control

3.5.1 GRANT Statement
3.5.2 REVOKE statements

3.6 Oracle Common functions

3.6.1 character class functions
3.6.2 Mathematical class functions
3.6.3 Date class functions
3.6.4 Conversion class functions
3.6.5 Aggregation class functions

4th Room Oraclepl/sql and programming

4.1 Pusql Introduction

Basic structure of 4.1.1 PL/SQL
4.1.2 PL/SQL annotations
4.1.3 PL/SQL Character set
4.1.4 PL/SQL data type
4.1.5 PL/SQL variables and constants
4.1.6 PL/SQL Statement control structure
4.1.7 PL/SQL expressions

Cursors for 4.2 pusql

4.2.1 Fundamentals
4.2.2 an explicit cursor
4.2.3 Implicit cursors
4.2.4 Cursor Properties
4.2.5 cursor Variable

4.3 process

4.3.1 creation Process
4.3.2 Call procedure
4.3.3 Removal process
parameter types and delivery of 4.3.4 process

4.4 Functions

4.4.1 Creating a function
4.4.2 Calling function
4.4.3 Delete a function

4.5 Packs

4.5.1 Fundamentals
4.5.2 Creating a Package
4.5.3 Calling Package
4.5.4 Deleting a package

4.6 Triggers

Fundamentals of 4.6.1 Triggers
4.6.2 Creating triggers
4.6.3 executing a Trigger
4.6.4 deleting triggers

The 5th chapter is familiar with Sql*plus environment

5.1 Entering and exiting the Sql*plus environment

5.1.1 Start Sql*plus
5.1.2 Creating Sql*plus Shortcuts
5.1.3 exiting the Sql*plus environment

5.2 Edit command for Sql*plus Editor

5.2.1 Editing commands
5.2.2 Save Command
5.2.3 Adding comments
5.2.4 Run command
5.2.5 Writing Interactive Commands
5.2.6 using bound variables
5.2.7 Trace Statements

5.3 Setting up the Sql*plus environment

5.3.1 Show Command
5.3.2 SET command

5.4 Sql*plus Environment Introduction

5.4.1 Storage Sql*plus Environment
5.4.2 Spool Output
5.4.3 Online Help

5.5 using Sql*plus to format the results of a query

5.5.1 Formatting columns
5.5.2 define the title and dimensions of the page and report
5.5.3 Storage and printing results

6th Basic operation of Oracle

6.1 Startup and shutdown of Oracle

6.1.1 Starting the Oracle database
6.1.2 shutting down the Oracle database

6.2 Creation and modification of tables

Basic concepts of the 6.2.1 table
6.2.2 Table Structure Design
6.2.3 Creation of tables
6.2.4 Modifying table Structures

6.3 Index

The concept of 6.3.1 index
6.3.2 Creating an Index
6.3.3 Deleting an index

6.4 views

Concept of the 6.4.1 view
6.4.2 Creating a View
6.4.3 View Changes
6.4.4 Deleting a view

6.5 Data manipulation and data query

6.5.1 copying the original table insert record
6.5.2 Using views
6.5.3 using PL/SQL
6.5.4 data Query

7th Oracle Database Management operations

7.1 Learning to use views

7.1.1 Increased security
7.1.2 the complexity of hiding data
7.1.3 implementation of naming simplicity and legibility
7.1.4 Implementing change flexibility

7.2 Uniqueness of the implementation record

7.2.1 using key to implement
7.2.2 Creating a unique index
7.2.3 using sequences

7.3 Realizing the integrity of the data

7.3.1 Domain Integrity
7.3.2 Entity Integrity
7.3.3 Referential integrity
7.3.4 Stored Procedure Check
7.3.5 using triggers

7.4 Avoid a lot of changes caused by the change

7.4.1 Using views
7.4.2 using synonyms
7.4.3 using Cursors

8th Chapter Database User Management

8.1 Granting permissions

8.1.1 Direct Authorization
8.1.2 Authorization role
8.1.3 using the Alteruser statement to modify the user's default role
8.1.4 using Setrole to control role usage

8.2 Reclaim Permissions

8.2.1 Recycling
8.2.2 Deleting a role
8.2.3 Deleting a Database object
8.2.4 Deleting a user

8.3 Different user Rights management

8.4 Managing access to database objects

8.4.1 Using user passwords
8.4.2 Use Rights control
8.4.3 Using Database Links
8.4.4 Using configuration Files

Chapter 9th Data Space Management

9.1 Spatial design when establishing a database

9.1.1 specifying the initial value of the system table space
9.1.2 Setting the initial value of other table spaces

9.2 Management in the case of ample space

9.2.1 Dynamic monitoring Using data dictionary
9.2.2 Adding data files to table spaces

9.3 Ways to solve the lack of space

9.3.1 Increase data File size
9.3.2 Creating a new table space
9.3.3 Dynamically increasing table space
9.3. Differences and comparisons of 43 methods

9.4 Reasonable use of storage space

9.4.1 using the correct data type
9.4.2 storage parameters are set correctly
9.4.3 Regular recycling of useless table space
9.4.4 Archive History Table space

10th chapter Backup and recovery mechanism

10.1 Methods of Backup and recovery

10.2 Logical backup and recovery using a data pump

10.2.1 Exporting data using EXPDP
10.2.2 Importing data using IMPDP

10.3 Offline Backup and Recovery

10.3.1 Offline backup
10.3.2 Offline recovery
10.4 Online backup and recovery
10.4.1 Settings for archive logging mode
10.4.2 Creating a table space for recovering a directory
10.4.3 Create Rman users and authorize
10.4.4 Creating a Recovery Directory
10.4.5 Registering the target database
10.4.6 using the Rman program for backup
10.4.7 using the Rman program for recovery
10.5 Automatic backup and recovery
10.5.1 Flash Back Database
10.5.2 Flash Back Table
10.5.3 Flash back to Recycle Bin
10.5.4 Flash back Query
10.5.5 Flash back version query
10.5.6 Flash Back Transaction query
10.6 Comparison of several backup and recovery methods
Chapter 11th management of control files and log files
11.1 Control files
11.1.1 Control File Overview
11.1.2 multiplexed Control File
Creation of 11.1.3 control files
Backup and recovery of 11.1.4 control files
11.1.5 control file Query and delete
11.2 Log Files
11.2.1 log files and storage policies
11.2.2 adding log groups and log members
11.2.3 Setting the Log Auto-archive feature
11.2.4 Monitoring Log work
......
The 12th Chapter Database control
Chapter 13th Security Management of Oracle Database
The 14th Chapter Message Board System
The 15th chapter of the press release system
Appendix A ORACLE12C Vocabulary Collection
Appendix B oracle12c Options Overview

————————————————————————————————————————————————————————————————————————————————————————————————————————

ORACLE12C from beginner to Proficient (second edition) Shangong Kinsong Authoring