This Oracle Database 12c: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.
Understand the basic concepts of relational databases ensure refined code by developers.
Create reports of sorted and restricted data. Run data manipulation statements (DML). Control database access to specific objects.
Manage schema objects.
Manage objects with data dictionary views. Retrieve row and column data from tables. Control privileges at the object and system level.
Create indexes and constraints; alter existing schema objects.
Create and query external tables.
Data Warehouse Administrator
Identify the major structural components of the Oracle Database 12c
Manage objects with data dictionary views
Manage schema objects
Retrieve row and column data from tables
Run data manipulation statements (DML) in Oracle Database 12c
Use scalar and correlated sub-queries
Utilize views to display data
Write SELECT statements that include queries
Write multiple-column sub-queries
Control database access to specific objects
Create reports of aggregated data
Create reports of sorted and restricted data
Create tables to store data
Display data from multiple tables using the ANSI SQL 99 JOIN syntax
Employ SQL functions to retrieve customized data
Working with Oracle Cloud Exadata Express Cloud Service
Retrieving Data using the SQL SELECT Statement
Restricting and Sorting Data
Using Single-Row Functions to Customize Output
Using Conversion Functions and Conditional Expressions
Reporting Aggregated Data Using the Group Functions
Displaying Data from Multiple Tables Using Joins
Using Subqueries to Solve Queries
Using the SET Operators
Managing Tables using DML statements
Introduction to Data Definition Language
Introduction to Data Dictionary Views
Creating Sequences, Synonyms, Indexes
Managing Schema Objects
Retrieving Data by Using Subqueries
Manipulating Data by Using Subqueries
Controlling User Access
Managing Data in Different Time Zones
課程二：Oracle Database 12c R2: Administration Workshop Ed 3
The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation in administration of an Oracle Database. In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner.
Manage an Oracle Database instance.
Configure the Oracle Network environment.
Create and manage storage structures.
Manage and move data.
Create and manage users.
Monitor the database and manage performance.
Create and manage Database as a Cloud Service database deployments.
Data Warehouse Administrator
Back up, restore, and patch DBCS database deployments
Describe the DBaaS and on-premises Oracle Database architectures
Manage database instances
Manage UNDO data
Move data between databases
Implement basic backup and recovery procedures
Monitor and tune database performance
Tune SQL to improve performance
Manage resources with Oracle Database Resource Manager
Create pluggable databases (PDBs)
Configure the Oracle network environment
Administer user security and implement auditing
Create and manage tablespaces
Manage storage space
Create and manage Database as a Cloud Service (DBCS) database deployments
Register databases and manage performance with Enterprise Manager Cloud Control
Exploring Oracle Database Architecture
Managing Database Instances
Configuring the Oracle Network Environment
Administering User Security
Creating and Managing Tablespaces
Managing Storage Space
Managing UNDO Data
Backup and Recovery Concepts
Monitoring and Tuning Database Performance
Oracle Database Resource Manager
Enterprise Manager Cloud Control
Introduction to Oracle Database Cloud Service
Creating DBCS Database Deployments
Managing DBCS Database Deployments
Backing Up and Restoring DBCS Database Deployments
Patching DBCS Database Deployments
Creating Master Encryption Keys for PDBs
Tablespace Encryption by Default