Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Enquire

Submit your enquiry for Oracle Database SQL Expert

Please enter valid question or comment

Please select a category

No matching category found.

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Prashanth

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

course photo

Oracle Database SQL Expert

Online Instructor led Course

Platform:

4,000

No Reviews Yet
0 Interested

About the Course


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.

Topics Covered

Retrieving Data Using the SQL SELECT Statement*

List the capabilities of SQL SELECT statements*
Execute a basic SELECT statement*
Describe how schema objects work*
Restricting and Sorting Data

Limit the rows that are retrieved by a query
Sort the rows that are retrieved by a query
Use the SQL row limiting clause**
Create queries using the PIVOT and UNPIVOT clause**
Use pattern matching to recognize patterns across multiple rows in a table**
Using Single-Row Functions to Customize Output

Describe various types of functions that are available in SQL
Use character, number, and date functions in SELECT statements (Updated to "Use character, number, and date and analytical (PERCENTILE_CONT, STDDEV, LAG, LEAD) functions in SELECT statements" September 15, 2014)**
Describe the use of conversion functions
Reporting Aggregated Data Using the Group Functions

Identify the available group functions
Describe the use of group functions
Group data by using the GROUP BY clause
Include or exclude grouped rows by using the HAVING clause
Displaying Data from Multiple Tables

Write SELECT statements to access data from more than one table using equijoins and nonequijoins
Join a table to itself by using a self-join
View data that generally does not meet a join condition by using outer joins
Generate a Cartesian product of all rows from two or more tables
Use the cross_outer_apply_clause**
Using Subqueries to Solve Queries

Define subqueries*
Describe the types of problems that subqueries can solve*
Use subqueries**
List the types of subqueries
Write single-row and multiple-row subqueries
Create a lateral inline view in a query**
Using the Set Operators

Describe set operators
Use a set operator to combine multiple queries into a single query
Control the order of rows returned
Manipulating Data

Describe each data manipulation language (DML) statement
Insert rows into a table
Update rows in a table
Delete rows from a table
Control transactions
Using DDL Statements to Create and Manage Tables

Categorize the main database objects
Review the table structure
List the data types that are available for columns
Create a simple table
Explain how constraints are created at the time of table creation
Truncate tables, and recursively truncate child tables**
Use 12c enhancements to the DEFAULT clause, invisible columns, virtual columns and identity columns in table creation/alteration**
Creating Other Schema Objects

Create simple and complex views (Updated to "Create simple and complex views with visible/invisible columns on September 15, 2014)**
Retrieve data from views
Create, maintain, and use sequences
Create and maintain indexes*
Create private and public synonyms
Managing Objects with Data Dictionary Views

Use the data dictionary views to research data on your objects*
Query various data dictionary views
Controlling User Access

Differentiate system privileges from object privileges
Grant privileges on tables (Updated to Grant privileges on tables and on a user on September 15, 2014)**
View privileges in the data dictionary
Grant roles
Distinguish between privileges and roles
Managing Schema Objects

Add constraints
Create indexes (Updated to "Create and maintain indexes including invisible indexes and multiple indexes on the same columns" on September 15, 2014)**
Create indexes using the CREATE TABLE statement
Creating function-based indexes
Drop columns and set column UNUSED
Perform FLASHBACK operations
Create and use external tables
Manipulating Large Data Sets

Manipulate data using subqueries
Describe the features of multitable INSERTs
Use the following types of multitable INSERTs (Unconditional, Conditional and Pivot)
Merge rows in a table
Track the changes to data over a period of time
Use explicit default values in INSERT and UPDATE statements**
Generating Reports by Grouping Related Data

Use the ROLLUP operation to produce subtotal values
Use the CUBE operation to produce crosstabulation values
Use the GROUPING function to identify the row values created by ROLLUP or CUBE
Use GROUPING SETS to produce a single result set
Managing Data in Different Time Zones

Use Various datetime functions
TZ_OFFSET
FROM_TZ
TO_TIMESTAMP
TO_TIMESTAMP_TZ
TO_YMINTERVAL
TO_DSINTERVAL
CURRENT_DATE
CURRENT_TIMESTAMP
LOCALTIMESTAMP
DBTIMEZONE
SESSIONTIMEZONE
EXTRACT
Retrieving Data Using Subqueries

Write a multiple-column subquery
Use scalar subqueries in SQL
Solve problems with correlated subqueries
Update and delete rows using correlated subqueries
Use the EXISTS and NOT EXISTS operators
Use the WITH clause
Hierarchical Retrieval

Interpret the concept of a hierarchical query
Create a tree-structured report
Format hierarchical data
Exclude branches from the tree structure
Regular Expression Support

Use Meta Characters
Regular Expression Functions
Use Replacing Patterns
Use Regular Expressions and Check Constraints

Who should attend

Data Warehouse Administrator
Developer
Application Developers
PL/SQL Developer
Forms Developer
System Analysts
Business Analysts

Pre-requisites

Nothing

What you need to bring

Nothing

Key Takeaways

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

This course will help you understand the advanced features of SQL. Learning these features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Some of the date-time functions available in the Oracle Database are also covered. This course also discusses how to use the regular expression support in SQL through expert instruction.
Content
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

cash back100% Money Back Guarentee

About the Trainer

Prashanth picture
Extensive knowledge of SQL and Oracle database administration
Highly technical and good understanding of Oracle products
Strong ability to communicate highly technical information in easy to understand language
Excellent written and verbal communication skills
Solid technical writing and documentation abilities for manuals
Seats Left-

Students Interested 0

Course Id: 25869