Follow Us :

SQL Fundamentals

Course_Reference: 
SA-OSF
Manufacturer: 
0
Training_Provider: 
18
Summary: 

This course is designed for anyone who needs to access and work with an Oracle Database. This course is suitable for delegates intending to sit the Introduction to Oracle9i: SQL Oracle Certified Professional examination (IZ0-007).

Objectives: 

By the end of this course, the delegate will be able to:

  • Describe the structure of a relational database
  • Use the command line features of SQLPlus and iSQLPlus
  • Create SQL statements to select data from an Oracle database
  • Use single row functions
  • Use enhanced grouping functions
  • Implement analytic functions
  • Generate hierarchical queries
  • Generate scripts and apply formatting to output
  • Use SQLPlus control and run time parameters
  • Create and alter tables, indexes and views
  • Use external tables
  • Create, update and delete records
  • Create users, profiles and roles
  • Grant and revoke access privileges
  • Access the data dictionary

  • The Structure of a Relational Database
  • Using SQLPlus and iSQLPLus
  • The Basic SQL Select Statement
  • Using Oracle and ANSI-Compliant Inner and Outer Joins
  • Sub-Queries and Sub-Query Operators
  • In-line views and Top-'N' Analysis
  • Hierarchical Queries
  • Grouping and Sorting Output
  • Advanced Grouping Expressions and Functions
  • Character, Date and Numeric Functions
  • Timestamp and Interval Datatypes and Functions
  • Analytic Functions
  • CASE Expressions
  • Regular Expression Notation and Related Functions
  • SQLPlus and iSQLPlus Parameters and Variables
  • Producing Reports with SQLPlus
  • Creating and Changing Tables and Views
  • Constraints and Indexes
  • Inserting, Updating and Deleting Data
  • Creating and Using External Tables
  • Basic Transaction Control
  • Controlling Access to Objects
  • Data Dictionary Tables and Views

Description: 

This course is designed for anyone who needs to access and work with an Oracle Database. This course is suitable for delegates intending to sit the Introduction to Oracle9i: SQL Oracle Certified Professional examination (IZ0-007).

Keywords: 
SQL,SQL Fundamentals,Oracle Database,relational database strucutre,SQLPlus,data dictionary

Software Vendor

IT Technical

Business Skills