Company Profile Newsletter IT Training Business Training Coaching Consulting Schedule Accreditations Contact Us
Popular Topics:
SharePoint Training Crystal Reports Training Photoshop Training Oracle Training Microsoft Excel Training
Project Management Training Finance Training Effective Management Training
Oracle Database 11g: SQL Fundamentals I 
Print PageOracle 9i SQL for Analysts
Description:
Oracle 9i SQL for Analysts is a hands-on course, which gives you a basic knowledge of relational databases and how to access them through SQL and SQL *Plus. this training covers topics that are necessary to query data for analsysis from an Oracle 9i database.
- Cost: Price on application
- Duration: 3 Days
- This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Prerequisites:
An understanding of relational database desing concepts.
Intro to Structure Query Language (SQL) for Analyst:
SQL the language
Data Manipulation Language (DML)
Data Definition Language (DDL)
SQL *Plus the Environment
Scripting using Oracleis Procedural
Language option (PL/SQL)
Overview of complete SQL SELECT syntax
Data Manipulation Language (DML)
Data Definition Language (DDL)
SQL *Plus the Environment
Scripting using Oracleis Procedural
Language option (PL/SQL)
Overview of complete SQL SELECT syntax
Intro to Oracle`s RDBMS objects:
Objects, Tables, Columns, Pseudo columns, Rows
Data domains, Duplicate values, Null values
Indexes, Views, Sequences, Synonyms
Declarative Constraints
Primary, Foreign, unique kays
Check, Not Null, Default
Data domains, Duplicate values, Null values
Indexes, Views, Sequences, Synonyms
Declarative Constraints
Primary, Foreign, unique kays
Check, Not Null, Default
Using SQL in different scenarios :
SQL using SQL *Plus
SQL using iSQL Plus (SQL *Plus via the WEB)
SQL using SQL *Plus Worksheet (DBA)
SQL using MS Query (Excel)
SQL using a "pass through query" from MS Access
SQL using SAS
SQL using Crystal
SQL using iSQL Plus (SQL *Plus via the WEB)
SQL using SQL *Plus Worksheet (DBA)
SQL using MS Query (Excel)
SQL using a "pass through query" from MS Access
SQL using SAS
SQL using Crystal
More SQL SELECT:
Arithmetic calculations
Character, Comparison, and Logical operators
WHERE clause, Pattern matching, Using SQL *Plus substitution variables &, &&, &1
ORDER BY clause
How NULLS are processed
Multiple Columns
ASC vs. DESC
DISTINCT vs. UNIQUE
Character, Comparison, and Logical operators
WHERE clause, Pattern matching, Using SQL *Plus substitution variables &, &&, &1
ORDER BY clause
How NULLS are processed
Multiple Columns
ASC vs. DESC
DISTINCT vs. UNIQUE
Single Row FUNCTIONS:
What are Functions?
1. Analytic
2. Character
3. Numeric
4. Date
5. Conversion
6. Miscellanous
1. Analytic
2. Character
3. Numeric
4. Date
5. Conversion
6. Miscellanous
GROUP BY Clause & Group FUNCTIONS:
What are GROUP Functions
Aggregate (Group)
Analytic functions
COUNT (*) vs.
COUNT (column_name)
SUM(), AVG(), MIN(), MAX()
VARIENCE(), STDDEV()
GROUP BY and HAVING clause
ROLLUP(), CUBE(), GROUPING()
Aggregate (Group)
Analytic functions
COUNT (*) vs.
COUNT (column_name)
SUM(), AVG(), MIN(), MAX()
VARIENCE(), STDDEV()
GROUP BY and HAVING clause
ROLLUP(), CUBE(), GROUPING()
Advanced topics:
Join, Subquery, Correlated Subquery
Join vs. Subquery
IF EXIST
Join vs. Subquery
IF EXIST
SQL *Plus Reporting:
Building a SQL script
COLUMN command
Titles, Control Breaks, Sorting
TTILE vs. REPHEADER
BTITLE vs. REPFOOTER
BREAK command
COMPUTE command (Aggregates)
Using variables in SQL *Plus
SQL *Plus substitution variables
&, &&, &1
ACCEPT and PROMPT commands
DEFINE and BIND variables
COLUMN command
Titles, Control Breaks, Sorting
TTILE vs. REPHEADER
BTITLE vs. REPFOOTER
BREAK command
COMPUTE command (Aggregates)
Using variables in SQL *Plus
SQL *Plus substitution variables
&, &&, &1
ACCEPT and PROMPT commands
DEFINE and BIND variables
Intro to PL/SQL scripting 3rd day:
What is this things called PL/SQL
Features and Benefits
Where do you fit?
Features and Benefits
Where do you fit?
PL/SQL Basics:
An Anonymous block structure
Lexical Units
Variable Declarations,
Expressions and operators Branching
IF and CASE statements
Looping, Simple and WHILE true LOOP
FOR x IN (a..b) LOOP
Lexical Units
Variable Declarations,
Expressions and operators Branching
IF and CASE statements
Looping, Simple and WHILE true LOOP
FOR x IN (a..b) LOOP
Working with database data:
SELECT statement (single row)
Other DML
Other DML
Intro to CURSORs:
Implicit and Declared CURSOR
SESLECT statement (multiple rows)
Using a LOOP to FETCH a CURSOR
SESLECT statement (multiple rows)
Using a LOOP to FETCH a CURSOR
Exception Handling:
What are EXCEPTIONS
Oracle Pre-defined, User defined, and Other Oracle exceptions
Oracle Pre-defined, User defined, and Other Oracle exceptions