Oracle 10g/11g: Introduction to 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: Introduction to SQL Today!

Your Price: $695

Video Title	Minutes
00: Course Introduction	7
01: Writing SQL SELECT Statements	19
02: Writing SQL SELECT Statements Demo	15
03: Restricting Data	18
04: Restricting Data Demo	15
05: Sorting Data	14
06: Sorting Data Demo	13
07: Displaying Data from Multiple Tables	22
08: Displaying Data from Multiple Tables Demo	20
09: Character Row Functions	13
10: Character Row Functions Demo	15
11: Numeric Row Functions	13
12: Numeric Row Functions Demos	9
13: Date/Time Row Functions	10
14: Date/Time Row Functions Demo	17
15: Miscellaneous Row Functions	18
16: Miscellaneous Row Functions Demo	18
17: Aggregating Data Using Group Functions	14
18: Aggregating Data Using Group Functions Demo	18
19: Extensions to the GROUP BY Clause	14
20: Extensions to the GROUP BY Clause Demo	11
21: Manipulating Data I	16
22: Manipulating Data I Demo	19
23: Manipulating Data II	13
24: Manipulating Data II Demo	15
Total:	6 hours 16 minutes

Start Learning Oracle 10g/11g: Introduction to 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: Introduction to SQL Today!

List Price: $995 Your Price: $695

Description

In this Oracle 10g/11g: Introduction to SQL online training course, students learn the basics of writing Oracle SQL statements. This course provides the SQL skills that allow developers, database administrators and end-users to write queries against single and multiple tables, manipulate data in tables and take advantage of Oracle supplied row functions.

Once you have completed Oracle 10g/11g: Introduction to SQL the next course in this series is Oracle 10g/11g: Advanced SQL.  The Oracle 10g/11g: Advanced SQL will further your knowledge by discussing advanced features of SQL in order to query and manipulate data within the database.  Click here to learn more about Oracle 10g/11g: Advanced SQL.

Objectives

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

• Access database data with a basic SELECT statement
• Access data from more than one table
• Manipulate database data
• Decide where best to use Oracle-supplied functions in place of user-written code

 

Related Training

• Course: Oracle 10g/11g: Advanced SQL
• 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
• Course: Oracle 11g PL/SQL Programming Part 1
• Course: Oracle 11g PL/SQL Programming Part 2
• Podcast: Why SQL Programming Standards are Important
• Podcast: Using the ANSI Standard SQL Join Operators
• Podcast: Reasons to use the SAVEPOINT statement when manipulating data
• Podcast: When to use TRUNCATE instead of DELETE and vice versa
• Podcast: Oracle 11g SQL New Features

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

Start Learning Oracle 10g/11g: Introduction to SQL Today!

List Price: $995 Your Price: $695

Oracle 10g/11g: Introduction to SQL Outline

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

Module 01: Writing SQL SELECT Statements

• Review the basic SQL SELECT statement syntax
• Select all columns using a wildcard notation from a table
• Valid SELECT statement expressions
• Write a query containing the arithmetic operators
• Use aliases to customize column headings
• Create a character expression with the concatenation operator
• Use the CASE Expression
• Lab Exercise

Module 02: Writing SQL SELECT Statements Demo

Module 03: Restricting Data

• Use the WHERE Clause
• WHERE clause operators
• =, <>, >, < operators
• BETWEEN, IN, LIKE, IS NULL operators
• Adding ANY or ALL to an operator
• List the Logical Conditions AND, OR, NOT
• Use Multiple Conditions in the WHERE clause
• Describe the Rules of Precedence
• Lab Exercise

Module 04: Restricting Data Demo

Module 05: Sorting Data

• Discuss default order of result sets
• Sort Rows with the ORDER BY Clause
• ORDER BY valid expressions
• DISTINCT and UNIQUE clauses
• Lab Exercise

Module 06: Sorting Data Demo

Module 07: Displaying Data from Multiple Tables

• Identify Types of Joins
• ANSI standard join operators vs. non-standard join methods
• Using the non-standard join methods
• Inner join vs. Outer join
• Generating a Cartesian Product
• ANSI standard join operators
• NATURAL JOIN, JOIN USING, JOIN ON, LEFT/RIGHT/FULL OUTER joins
• Lab Exercise

Module 08: Displaying Data from Multiple Tables Demo

Module 09: Character Row Functions

• Categories of row functions
• Statement behavior of row functions
• Useful / common character row functions
• Nest Functions to perform multiple tasks in one statement
• Lab Exercise

Module 10: Character Row Functions Demo

Module 11: Numeric Row Functions

• Where numeric row functions can and cannot be used
• Helpful numeric row functions in SQL statements
• Functionalities of common numeric row functions
• Explain Implicit and Explicit conversion
• Lab Exercise

Module 12: Numeric Row Functions Demos

Module 13: Date/Time Row Functions

• Where date/time row functions can and cannot be used
• Helpful date/time row functions in SQL statements
• Functionalities of common date/time row functions
• Lab Exercise

Module 14: Date/Time Row Functions Demo

Module 15: Miscellaneous Row Functions

• Using conversion functions
• Using conversion functions to format date/time data
• Environment and Data specific row functions
• The Decode function versus the Case Option
• Lab  Exercise

Module 16: Miscellaneous Row Functions Demo

Module 17: Aggregating Data Using Group Functions

• Categorize the Types of Group Functions
• Use the AVG, SUM, MAX, MIN, and COUNT Functions in a Query
• Utilize the DISTINCT Keyword with the Group Functions
• Describe how Nulls are handled with the Group Functions
• Create Groups of Data with the GROUP BY Clause
• Group Data by more than one column
• Exclude Groups of Data with the HAVING Clause
• Differences between the HAVING clause and the WHERE clause
• Lab Exercise

Module 18: Aggregating Data Using Group Functions Demo

Module 19: Extensions to the GROUP BY Clause

• Using the CUBE option
• Using the ROLLUP option
• CUBE vs. ROLLUP output
• The GROUPING BY option
• Lab Exercise

Module 20: Extensions to the GROUP BY Clause Demo

Module 21: Manipulating Data I

• Write INSERT statements to add rows to a table
• Insert Special Values
• Copy Rows from Another Table
• Update Rows in a Table
• Use DELETE statements to remove rows from a table
• Delete Rows Based on Another Table
• The COMMIT and ROLLBACK statements
• Using the SAVEPOINT statement
• Lab Exercise

Module 22: Manipulating Data I Demo

Module 23: Manipulating Data II

• Describe the TRUNCATE Statement
• TRUNCATE vs. DELETE
• Using the Multi-table INSERT statement
• Using the MERGE statement
• Show how Read Consistency works
• Lab Exercise

Module 24: Manipulating Data II Demo

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

Start Learning Oracle 10g/11g: Introduction to SQL Today!

List Price: $995 Your Price: $695

Prerequisites

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

Introduction to Programming for Non-Programmers

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

Start Learning Oracle 10g/11g: Introduction to 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: Introduction to 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.