Have you unlocked your potential?
Satisfaction Guaranteed.
Here at LearnLocker, we are committed to providing the best possible experience we can. If at any time you are not completely satisfied, we invite you to contact us with your comments and feedback. In addition, you have the right to cancel your membership at anytime. You can even cancel online through our website. Our cancellation policy and terms are covered in detail in the terms and conditions found in the LearnLocker Subscription Membership Agreement.

Oracle 11g Introduction to SQL Fundamentals

Course Outlines
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.8 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
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
Reset Password
Sign In:


You will be sent a link to the Reset Password page. Please note that the link may only be used today.