تفاصيل الدورة
This course gives a basic introduction to Oracle`s version of SQL, focusing on the select statement for use within reports. This will be relevant for all versions of the database, from 8i onwards Designed to introduce concepts and functionality in an accessible and friendly format, the course has been prepared to assist report writers understand what reporting tools will do behind the scenes and is aimed at those using any reporting tool that generates SQL. This is an ideal pre cursor for the Oracle Discoverer courses.
- PC Fundamentals
- Report Writers
- Oracle Discoverer Users
- Oracle Discoverer Administrators
- Introducing Oracle
- The Elements of the Oracle System
- Relational Concepts
- What reporting tools do
- Introduction
- Choosing and Describing Tables
- Elements of the SQL Query
- The SQL Buffer and Query Layout
- Editing SQL Statements
- The System Dummy Table
- Selecting Columns
- Duplicate Information (DISTINCT)
- Sorting Information
- Introducing SQL*Plus for Reporting
- Using SQL*Plus
- The Concatenation Operator
- Elements of the SQL Query: Arithmetic
- Column Aliases
- String Functions
- Arithmetic Functions
- Date Functions
- Mixed Functions
- Where Operators
- Where with Keywords
- Where and Logical Operators
- Joining Tables (Equi-Joins)
- Aliases for Table Names
- Thinking behind Creating Joins
- Joining Tables (Non-Equi-Joins)
- Joining Tables (Outer Joins)
- Joining Tables (Inner Joins)
- Group Function Examples
- Group Function with Having
- Materialised views
- Dimensions
- ROLLUP functions
- The ROLLUP operator
- The CUBE operator
- Analytical Functions
- Ranking
- Banding
- Windowing
- Moving Averages
- LAG and LEAD
- Nesting Different Functions
- Select with Minus, Union and Intersect
- Connect By Prior
- Hierarchies
نبذة عن معهد Professional Training Solutions Ltd
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoonدرهم 1,449مدة الدورة التدريبية: Upto 30 Hours
- Implementing an Advanced Server Infrastructure John Academy65 EUR
1,301 EURمدة الدورة التدريبية: Upto 14 Hours - Administering a SQL Database Infrastructure Global Edulink95 EUR
638 EURمدة الدورة التدريبية: Upto 22 Hours