Introduction to Oracle 11g R2 SQL Programmingdf

Introduction to Oracle 11g R2 SQL Programming

Bascom Bridge’s Introduction to Oracle 11g R2 SQL Programming training teaches students how to create, retrieve, and manipulate objects in Oracle 11g R2 Structured Query Language (SQL). Students will also be introduced to Oracle® 11g R2 database features and tools.

 

ORACLE SQL TRAINING OBJECTIVES

  • Use SQL Developer and other available SQL interfaces.
  • Write simple SQL queries and format & sort the data as needed.
  • Write moderately complex SQL queries using various join techniques.
  • Supplement SQL code with references to pseudo columns and system functions.
  • Summarize, group, and combine data to obtain more meaningful query results.
  • Draw conclusions and make business decisions based upon the data processed.
  • Learn advanced query techniques such as set operations, sub-queries, and summary functions.
  • Create and maintain database tables using the SQL Data Definition Language (DDL).
  • Manage data within tables using the SQL Data Manipulation Language (DML).
  • Take advantage of regular expressions and support for international data and time zones.
  • Learn to use the SQL99 join syntax.
  • Perform advanced SQL queries using techniques e.g. CASE structures, rollup, and cube operations.
  • Use advanced table definitions and the creation of indexes, sequences, and views.
  • Use the powerful set of built-in SQL functions.
  • Handle DML errors without application interruption.
  • Obtain database object metadata from the data dictionary.
  • Understand basic database security and object privileges.
  • Protect database integrity and extend the conceptual data model using declarative constraints.
  • Use SQL Developer and other available SQL interfaces.

ORACLE SQL TRAINING PREREQUISITES

No prior Oracle SQL experience is presumed.

ORACLE SQL TRAINING MATERIALS

All students receive comprehensive courseware and a related textbook.

SOFTWARE NEEDED FOR EACH PC:

  • A complete installation of Oracle Express Edition 11g R2
  • Oracle SQL Developer
  • For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor’s screen simultaneously with working on their own.

ORACLE SQL TRAINING OUTLINE

  • Relational Databases & SQL
    • About Relational Databases
    • Elements Of SQL
  • Choosing A SQL & PL/SQL Interface
    • About Database Connections
    • About Bind Variables
    • Using SQL Developer
    • Using SQL*Plus
    • Using Application Express
  • Building A Select Statement
    • About the Select Statement
    • Using Alias Names
  • Restricting Data With the Where Clause
    • About Logical Operators
    • Equality Operator
    • Boolean Operators
    • Null & Between Operators
    • Is [Not] Null Operator
    • [Not] Between Operator
    • Finding Text Strings
    • [Not] Like Operator
    • Regexp_Like()
    • In Operator
  • Sorting Data With the Order By Clause
    • About the Order By Clause
    • Multiple Column Sorts
    • Specifying the Sort Sequence
    • About Null Values Within Sorts
    • Using Column Aliases
    • Pseudo Columns & Functions
    • Joining Tables
  • Using the Set Operators
    • About the Set Operators
    • Set Operator Examples
  • Summary Functions
    • About Summary Functions
    • Summary Functions With Distinct
  • Using Sub-Queries
    • About Sub-Queries
    • Standard Sub-Queries
    • Correlated Sub-Queries
  • Aggregating Data Within Groups
    • About Summary Groups
    • Finding Groups Within the Base Tables
    • Selecting Data From the Base Tables
    • Selecting Groups From the Result Table
  • Build Simple SQL*Plus Reports
    • Format Column Output With Column
    • Defining Report Breaks With Break
    • Produce Subtotals With Compute
  • Use Data Definition Language To Create & Manage Tables
    • Create Table Statement
    • Not Null
    • Default
    • Alter Table Statement
    • Drop Table Statement
    • Supportive Statements
    • Describe
    • Rename
  • Use Data Manipulation Language To Manipulate Data
    • About the Insert Statement
    • About the Delete Statement
    • About the Update Statement
    • About Transactions
    • Rollback
    • Commit
    • Savepoint
    • Set Transaction
    • Truncate Table
    • Complex Table References
  • SQL99 Join Techniques
    • Cross Joins
    • Natural Joins
    • Inner Joins
    • Outer Joins
    • Anti Joins
    • Using Named Subqueries
  • Enhancing Groups With Rollup & Cube
    • Using Rollup
    • Using Cube
  • Using the Case Expression SQL Functions
    • Character
    • String Formatting Functions
    • ASCII Codes Functions
    • Pad & Trim Functions
    • String Manipulation Functions
    • String Comparison Functions
    • Phonetic Search Functions
  • SQL Functions: Numeric
    • About the Numeric Functions
    • Null Value Functions
  • SQL Functions: Date
    • Date Format Functions
    • Date Arithmetic Functions
  • Database Objects: Relational Views
    • About Database Objects
    • About Relational Views
    • Updating View Data
    • Maintaining View Definitions
    • Alter View
    • Drop View
  • Database Objects: Data Dictionary Storage
    • About the Data Dictionary
    • Object-Specific Dictionary Views
    • User_Updatable_Columns
    • Understanding the Data Dictionary Structure
  • Database Objects: Indexes
    • About Indexes
    • Use B-Tree Indexes
  • Database Objects: Other Objects
    • More About Creating Tables
    • About Sequences
    • Alter Sequence & Drop Sequence
    • Alter Sequence
    • Drop Sequence
    • About Synonyms
    • Drop Synonym
    • Create Schema Authorization
  • Database Objects: Security
    • User Passwords
    • Object Security
  • Data Integrity Using Constraints
    • About Constraints
    • Not Null Constraint
    • Check Constraint
    • Unique Constraint
    • Primary Key Constraint
    • References Constraint
    • Defining Constraints On Existing Tables
  • Managing Constraint Definitions
    • Renaming & Dropping Constraints
    • Enabling & Disabling Constraints
    • Deferred Enforcement
    • Set Constraints
    • Handling Constraint Exceptions
    • Constraints With Views
    • Data Dictionary Storage
  • Advanced SQL*Plus Reports
    • Break
    • Compute
    • Column
    • Ttitle & Btitle
  • Building SQL*Plus Scripts
    • Using SQL*Plus Variables
    • Define & Undefine
    • Accept
    • Prompt
    • Pause
  • SQL*Plus Session Control
    • Controlling System Variables
    • Set
    • Show
  • Conclusion

Send a Comment

Your email address will not be published.

CONTACT US

+91 9376007676  

INQUIRY NOW


,

Introduction to Oracle 11g R2 SQL Programmingdf

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...
  • Course No : ORC-230
  •  Theory : 40%
  •  Lab : 60%
  • Duration : 30 hours
Scroll Up
Skip to toolbar