Oracle Database 12c: Introduction to SQL

An Introduction to Oracle Database 12c

• The summary of Database
• Installation of SQL
•  Setup of SQL environment
• Features of Oracle Database 12c
• Difference between databases and relational databases
• Kinds of SQL Statements
• Oracle Database Architecture and Management Tools
• Managing the Database Objects
• Structuring the Oracle Network Environment
• Managing Space, Security and Storage
• Managing Undo Data and Data Concurrency

 Fetching Data using the SQL SELECT Statement

• Generating SQL SELECT statements
• Creating reports of data from results of a basic SELECT statement
• Arithmetic Operators
• Describe command and Column Heading Defaults
• Understanding Operator Precedence

Sorting and Retrieving Data

• Various clauses such as Where clause and Order By clause
• Comparison and logical operators
• Rules of precedence

Usage of Single-Row Functions to Customise Output

• Differentiate between single row and multiple row methods
• Feature strings with character operating in the Select and Where sections
• Function statistics with the Round, Trunk, and Mod methods
• Understand arithmetic with date data
• Operate dates with the Date functions

Invoke Conversion Methods and Conditional Expressions

• Describe implicit and explicit data type adjustment
• Using the TO_NUMBER, TO_CHAR, and TO_DATE conversion functions
• Using Nest multiple functions

Aggregated Data Using the Group Functions

• Aggregation methods for creating expressive reports
• Conquer the regained data into groups by using the Group By clause
• Remove groups of data by using the Having clause

Showing Data Using Joins from Multiple Tables

• Using Select statements to display data from more than one table
• An Overview of Joins and their types
• What is Self-join?

Use Subqueries to Solve Queries

• Define problem Types
• Describe sub-queries
• Identifying sub-queries types
• What are single-row and multiple-row subqueries?

The SET Operators

• Define the Set approaches
• Controlling the row order

Understanding Data Manipulation Statements (DML)

• Setting DML statement and functioning with schema objects
• Assessing and Inserting rows into a table
• Defining Delete and Update statement
• Understanding Commit and Rollback statements
• Establishing the main database objects
• Decide how constraints can be generated at table creation

 Other Schema Objects

• Formation of a simple and complex view
• Regaining data from views
• Making, upholding, and using sequences
• Generating and maintaining indexes
• Create private and public substitutes

An Overview of Control User Access

• Differentiating system rights from object rights
• Grant System Privileges
• Building and Grant Privileges to a Role
• How to change password and Grant Object Privileges?

Managing Schema Objects

• How to add, modify, and drop a Column?
• How to add and drop a Constraint?
• How to allow and restrict Constraint?
• Generating and Eliminating Indexes
• Performing Flashback Actions

Management of Objects with Data Dictionary Views

• An Overview of Data dictionary
• Understanding Dictionary Views, USER_OBJECTS and ALL_OBJECTS Views
• An Overview of Table and Column
• How to add comments to a table?

Manipulating Large Data Sets

• Use of subqueries to operate data
• Use of a subquery to retrieve data
• Use of Check Option Keyword on DML Statements
• Multi-table Insert Declarations kinds
• Using Multi-table Insert Statements
• Assimilating rows in a table
• Following changes in data over a period

Managing Data in various Time Zones

• An Introduction to Time Zones
• Understanding CURRENT_TIMESTAMP, CURRENT_DATE and LOCALTIMESTAMP
• Connecting Date and Time in a Session's Time Zone
• Accepting DBTimeZone and SessionTimeZone
• Alternating Date and Timestamp
• Interval Data Types
• Use of Extract, TZ_OFFSET and FROM_TZ
• Invoke TO_TIMESTAMP, TO_YMINTERVAL and TO_DSINTERVAL

Retrieve Data Using Subqueries

• Summary of Subqueries for multiple-column
• Recognising Non-pairwise and Pairwise Comparison

• Defining Scalar Subquery Languages
• Using Connected Subqueries
• The Exists and Not Exists methods
• Recursive and Invoke the With clause