AtHand Logo

 

COURSE LOGIN
Username:
Password:   
FEATURED CUSTOMERS
FEATURED SOLUTION
AtHand Learning System
Total E-Learning Solution


Built-In LMS
Learning Management
Testing Solutions that address the issues you face now.

Oracle 11g - Introduction to SQL Fundamentals

Print Version





 

Available Options

Oracle 11g - Set of 2 (Individual License)
Makau Course Cover - Box Shot  
CD-ROMs$159.00Add To Cart
Oracle 11g - Set of 2 (Library License)
Makau Course Cover - Box Shot  
CD-ROMs$318.00Add To Cart
Oracle 11g - Set of 2 (1 Year Access)
Makau Course Cover - Box Shot  
1 YR ONLINE$159.00Add To Cart

Course Instructor: AtHand's ExpertLine Instructors

AtHand's ExpertLine Instructors bring together AtHand's own teams of instructional designers, technical writers and expert technical presenters. The ExpertLine Instructors are best known for the hundreds of hours of courseware developed in AtHand's custom training division for Fortune 500 companies, academic partners and many other organizations. This team of experts have the real world knowledge to properly teach the basic and advanced topics for many of today's popular PC applications and practices.

Course Outline

Oracle 11g Introduction to SQL Fundamentals Level 1

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 Introduction to SQL Fundamentals Level 2

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