Oracle 11g Training
This Oracle 11g training provides an introduction to using the SQL language within an Oracle database. Oracle Database is known for its industry leading performance, security, scalability and reliability. It is used world wide to manage some of todays most demanding transaction processing and business intelligence applications. In this course students will begin by learning about relational database concepts and terminology. Students are then introduced to the SQL language and will then shift into the areas of SQL statements, SQL clauses, SQL functions, creating and managing tables, performing queries, set operators, schema objects, and much more all within the Oracle 11g environment. The emphasis is on teaching someone how to utilize SQL within Oracle database.
Multimedia CD-ROM Based Training:
With CD based training, the lectures were video taped and then digitized and presented to you in Full Motion Video, Audio, & Graphics.
System Requirements: x86/400 mhz (minimum), CD-ROM Drive, 64 MB RAM, Sound Card. Available Hard Disk Space 200 MB. Windows 98, NT, ME, 2000, XP, Vista, Windows 7, or Apple Mac.
Course Outline - Oracle 11g Training:
Oracle 11g Level 1 - Introduction to SQL Fundamentals
1.0 Introduction to Oracle and SQL
1.1 Introduction
1.2 Objectives
1.3 Relational Database Concepts
1.4 Relational Terminology
1.5 The SQL Language
1.6 SQL Statements
1.7 Development Environments for SQL
1.8 The Human Resources Schema
1.9 Summary
2.0 SELECT Statement
2.1 Introduction
2.2 Objectives
2.3 Capabilities of SQL Select Statements
2.4 Writing SQL Statements
2.5 Column Heading Defaults
2.6 Operator Precedence
2.7 Defining a Null Value
2.8 Arithmetic Expressions and Concatentation
2.9 Literal Character Strings
2.10 Displaying the Table Structure
2.11 Summary
3.0 WHERE & ORDER BY Clauses
3.1 Introduction
3.2 Objectives
3.3 Limiting the Rows Selected
3.4 Comparison Operators
3.5 The NULL Conditions
3.6 Order By Clause
3.7 Summary
4.0 Single-Row Functions
4.1 Introduction
4.2 SQL Functions
4.3 Number Functions
4.4 Arithmetic with Dates
4.5 Summary
5.0 Conversion Functions
5.1 Introduction
5.2 Objectives
5.3 Explicit Data Type Conversion
5.4 The TO_CHAR Function with Dates
5.5 Elements of the Date Format Model
5.6 TO_NUMBER and TO_DATE Functions
5.7 General Functions
5.8 The NVL Function
5.9 The COALESCE Function
5.10 Conditional Expressions
6.0 Aggregated Dta/Group Functions
6.1 Introduction
6.2 Objectives
6.3 The AVG and SUM Functions
6.4 The DISTINCT Keyword
6.5 Group Functions and Null Values
6.6 The GROUP BY Clause
6.7 Illegal Queries Using Group Functions
6.7 Summary
7.0 Joining Tables
7.1 Introduction
7.2 SQL 1999 Joins
7.3 Retrieving Records with Natural Joins
7.4 Tables Aliases with the USING Clause
7.5 Creating Joins with the ON Clause
7.6 Joining a Table to Itself
7.7 Non-equijoins
7.8 INNER versus OUTER Joins
7.9 Summary
Oracle 11g Level 2 - Introduction to SQL Fundamentals
1.0 Using Subqueries
1.1 Introduction
1.2 Objectives
1.3 Using a Subquery to Solve a Problem
1.4 Guidelines for Using Subqueries
1.5 Using Group Functions in a Subquery
1.6 No Rows Returned by the Inner Query
1.7 Multiple Row Subqueries
1.8 Null Values in a Subquery
1.9 Summary
2.0 Set Operators
2.1 Introduction
2.2 Set Operator Guidelines
2.3 Tables Used for Examples
2.4 The UNION Operator
2.5 The UNION ALL Operator
2.6 The MINUS Operator
2.7 Matching the SELECT Statements
2.8 Summary
3.0 Data Manipulation Language
3.1 Introduction
3.2 Data Manipulation Language
3.3 INSERT Statement Syntax
3.4 Inserting Rows with Null Values
3.5 Inserting Specific Date and Time Values
3.6 UPDATE Statement Syntax
3.7 Deleting Rows from a Table
3.8 TRUNCATE Statement
3.9 Database Transactions
3.10 COMMIT and ROLLBACK Statements
3.11 State of the Data Before COMMIT or ROLLBACK
3.12 Read Consistency
3.13 FOR UPDATE Clause in a SELECT Statement
3.14 Summary
4.0 Create and Manage Tables
4.1 Introduction
4.2 Database Objects
4.3 Naming Rules for Oracle Objects
4.4 CREATE TABLE Statement
4.5 Referencing Another User's Tables
4.6 Data Types
4.7 Referential Integrity Constraints
4.8 Defining Constraints
4.9 Constraints
4.10 Creating a Table Using a Subquery
4.11 ALTER TABLE Statement
4.12 Read Only Tables
4.13 Dropping a Table
4.14 Summary
5.0 Other Schema Objects
5.1 Introduction
5.2 Database Objects
5.3 Advantages of Views
5.4 Creating a View
5.5 Creating a Complex View
5.6 Rules for Performing DML Operations on a View
5.7 Using the WITH CHECK OPTION Clause
5.8 Denying DML Operations
5.9 Removing a View
5.10 Sequences
5.11 NEXTVAL and CURRVAL Pseudocolumns
5.12 Caching Sequences
5.13 Indexes
5.14 Creating an Index
5.15 Index Creation Best Practices
5.16 Creating a Synonym for an Object
5.17 Summary
Expires July 31, 2010
Save 10% to 20%
most training titles
For corporate orders, call to get a special quote or click here to receive a price quote by email.
Computer Training
Videos/CD-ROMs
Product List
Programming
Other Categories
Autodesk
IT Certification
Microsoft Office
Soft skills
Computer Programming
Purchase Orders
Accepted from Corp., Gov., & Educational Institutions: Click here
