Oracle 10g/11g: Advanced SQL

View Your Course Transcript

Videos

There are several great features that come with this course. The Course Transcript tracks your progress and allows you to pick up where you left off. You can view or email your transcript. The course comes with documentation found in Downloads Tab. You have access to the course and all videos for 1 year. Full screen viewing option available (see icon on bottom right corner of video).

Start Learning Oracle 10g/11g: Advanced SQL Today!

Your Price: $695

Video Title	Minutes
00: Course Introduction	8
01: Using the Set Operators	19
02: Using the Set Operators Demo	17
03: Flashback Query	19
04: Flashback Query Demo	18
05: Using Subqueries	18
06: Using Subqueries Demo	20
07: Hierarchical Retrieval	17
08: Hierarchical Retrieval Demo	16
09: Using the Data Dictionary Views	13
10: Using the Data Dictionary Views Demo	18
11: Creating Database Objects I (Views)	14
12: Creating Database Objects I (Views) Demos	15
13: Creating Database Objects II (Sequences)	18
14: Creating Database Objects II (Sequences) Demo	14
15: Creating Database Objects III (Synonyms)	16
16: Creating Database Objects III (Synonyms) Demo	14
17: Creating Database Objects IV (Tables)	24
18: Creating Database Objects IV (Tables) Demo	19
19: Creating Database Objects V (Indexes)	16
20: Creating Database Objects V (Indexes) Demo	14
21: Creating Database Objects VI (Constraints)	14
22: Creating Database Objects VI (Constraints) Demo	12
23: Regular Expression Support	12
24: Regular Expression Support Demo	10
Total:	6 hours 35 minutes

Start Learning Oracle 10g/11g: Advanced SQL Today!

Your Price: $695

Course Materials

Want to be able to access these helpful materials? Contact Us!

• Student Guide
• Lab Exercise Guide
• Data File
• Lab Set Up Instructions

Related Links

• Course Survey

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 10g/11g: Advanced SQL Today!

List Price: $995 Your Price: $695

Description

In this Oracle 10g/11g: Advanced SQL online training course, you will learn how to use the advanced features of SQL in order to query and manipulate data within the database. Advanced querying and reporting techniques including using SET operators, writing hierarchical queries and using the Flashback Query feature are explained. This Oracle training covers Schema objects such as Tables, Indexes and Constraints in detail.

In order to take this course you need to have taken Oracle 10g/11g: Introduction to SQL and have experience in writing Oracle SQL statements.

Objectives

As a result of taking this Oracle course, you will be to:

• Combine SQL result sets into a single result set using SET operators
• Access data from a previous point in time using the flashback query feature
• Combine multiple SQL statements into one statement
• Create various database objects

Related Training

• Course: Oracle 10g/11g: Introduction to SQL
• Course: Oracle 11g PL/SQL Programming Part 1
• Course: Oracle 11g PL/SQL Programming Part 2
• Course: Oracle 10g/11g Database Administration I - Part 1
• Course: Oracle 10g/11g Database Administration I - Part 2
• Course: Oracle 10g/11g Database Administration II Part 1
• Course: Oracle 10g/11g Database Administration II Part 2
• Podcast: Uses for the Flashback Query Feature
• Podcast: Useful Data Dictionary Views you have access to
• Podcast: Tips for using Subqueries
• Podcast: Benefits of the Invisible Index
• Podcast: When SET Operators are needed and how to use them

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 10g/11g: Advanced SQL Today!

List Price: $995 Your Price: $695

Oracle 10g/11g: Advanced SQL Outline

Module 00: Oracle 10g/11g: Advanced SQL Online Training - Course Introduction

Module 01: Using the Set Operators
•    Use the UNION operator to return all rows from multiple tables and eliminate any duplicate rows
•    Use the UNION ALL operator to return all rows from multiple tables (with duplicates)
•    Describe and use the INTERSECT operator
•    Explain and use the MINUS operator
•    List the SET operator guidelines
•    Order results when using the UNION operator
•    Using the ORDER BY clause with SET operators
•    Lab Exercise

Module 02: Using the Set Operators Demo

Module 03: Flashback Query
•    Prerequisites for using the Flashback Query feature
•    Uses for the Flashback Query feature
•    Limitations of the Flashback Query feature
•    Statement level vs. session level usage
•    Using statement level Flashback Query
•    The AS OF TIMESTAMP option
•    Using session level Flashback Query
•    The DBMS_FLASHBACK Oracle supplied package
•    Lab Exercise

Module 04: Flashback Query Demo

Module 05: Using Subqueries
•    Use a subquery to solve a problem
•    Identify where subqueries can be placed in a SELECT statement
•    Describe the types of subqueries (single row, multiple row)
•    The single row subquery operators
•    The multiple row subquery operators
•    Using multi-column subqueries
•    Writing a correlated subquery
•    Lab Exercise

Module 06: Using Subqueries Demo

Module 07: Hierarchical Retrieval
•    Hierarchical Queries
•    Ranking Rows with LEVEL
•    Formatting Hierarchical Reports Using LEVEL and LPAD
•    Pruning Branches with the WHERE and CONNECT BY clauses
•    Lab Exercise

Module 08: Hierarchical Retrieval Demo

Module 09: Using the Data Dictionary Views
•    Types of Data Dictionary Views
•    Privileges needed to access the Data Dictionary Views
•    Using the Data Dictionary Views to view database metadata information
•    Helpful Data Dictionary Views
•    Lab Exercise

Module 10: Using the Data Dictionary Views Demo

Module 11: Creating Database Objects I (Views)
•    Creating a view syntax
•    View options
•    Privileges needed to create a view
•    Benefits of views
•    Limitations of views
•    Using views in SQL statements
•    Retrieving View definitions from the Data Dictionary
•    Lab Exercise

Module 12: Creating Database Objects I (Views) Demos

Module 13: Creating Database Objects II (Sequences)
•    Creating a sequence syntax
•    Privileges needed to create a sequence
•    Sequence usage
•    Sequence options
•    Using sequences in SQL statements
•    Retrieving Sequence definitions from the Data Dictionary
•    Lab Exercise

Module 14: Creating Database Objects II (Sequences) Demo

Module 15: Creating Database Objects III (Synonyms)
•    Types of synonyms
•    Private vs. Public synonyms
•    Creating a synonym syntax
•    Privileges needed to create a synonym
•    Synonym usage
•    Using synonyms in SQL statements
•    Retrieving Synonym definitions from the Data Dictionary
•    Lab Exercise

Module 16: Creating Database Objects III (Synonyms) Demo

Module 17: Creating Database Objects IV (Tables)
•    Types of Tables
•    The Basic Heap Table
•    Creating a table syntax
•    Valid column datatypes
•    Privileges needed to create a table
•    Retrieving Table definitions from the Data Dictionary
•    Lab Exercise

Module 18: Creating Database Objects IV (Tables) Demo

Module 19: Creating Database Objects V (Indexes)
•    Types of Indexes
•    Benefits of Indexes
•    The B-Tree Index
•    Creating an index syntax
•    Privileges needed to create a index
•    Retrieving Index definitions from the Data Dictionary
•    Lab Exercise


Module 20: Creating Database Objects V (Indexes) Demo

Module 21: Creating Database Objects VI (Constraints)
•    Types of Constraints
•    Primary Key, Foreign Key, Unique, NOT NULL, Check constraints
•    Review constraint purposes
•    Creating a constraint syntax
•    CREATE vs. ALTER syntax
•    Retrieving Constraint definitions from the Data Dictionary
•    Lab Exercise

Module 22: Creating Database Objects VI (Constraints) Demo

Module 23: Regular Expression Support
•    Regular Expression Support Overview
•    Describing simple patterns for searching and manipulating data
•    Describing complex patterns for searching and manipulating data
•    Lab Exercise

Module 24: Regular Expression Support Demo

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 10g/11g: Advanced SQL Today!

List Price: $995 Your Price: $695

Prerequisites

You need to have equivalent experience or have taken the following GogoTraining course:

• Introduction to Programming for Non-Programmers
• Oracle 10g/11g: Introduction to SQL

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 10g/11g: Advanced SQL Today!

List Price: $995 Your Price: $695

System Requirements

Hardware:

• Operating system supported by Oracle 10g R1 or higher - Windows XP, Solaris, HP/UX, AIX, Linux
• 1 GB RAM minimum, 2 GB RAM preferred
• 7-10 GB free disk space

Software:

• Oracle 11g Enterprise Edition (R1+) or Oracle 10g Enterprise Edition (R1+) or Oracle 10g Express Edition
• Oracle Database 11g Release 1 or Oracle 10g Express Edition

 

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 10g/11g: Advanced SQL Today!

List Price: $995 Your Price: $695

When you purchase a course from GogoTraining, you can submit comments or questions to our expert instructors.