Oracle Database 11g: Introduction to SQL

Course details

This Oracle Database: 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.

Objectives

• Manage schema objects.
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax.
• Identify the major structural components of the Oracle Database 11g.
• Create reports of aggregated data.
• Write SELECT statements that include queries.
• Retrieve row and column data from tables.
• Run data manipulation statements (DML) in Oracle Database 11g.
• Create tables to store data.
• Utilize views to display data.
• Control database access to specific objects.
• Manage objects with data dictionary views.
• Write multiple-column sub-queries.
• Employ SQL functions to retrieve customized data.
• Use scalar and correlated sub-queries.
• Use the regular expression support in SQL.
• Create reports of sorted and restricted data.

Course Outline:

• Introduction to Oracle Database
• Retrieve Data using the SQL SELECT Statement
• Learn to Restrict and Sort Data
• Usage of Single-Row Functions to Customize Output
• Invoke Conversion Functions and Conditional Expressions
• Aggregate Data Using the Group Functions
• Display Data From Multiple Tables Using Joins
• Use Sub-queries to Solve Queries
• The SET Operators
• Data Manipulation Statements
• Use of DDL Statements to Create and Manage Tables
• Other Schema Objects
• Control User Access
• Management of Schema Objects
• Manage Objects with Data Dictionary Views
• Manipulate Large Data Sets
• Data Management in different Time Zones
• Retrieve Data Using Sub-queries
• Regular Expression Support