X

يمكنك إضافة المزيد من الدورات التدريبية هنا.
سيتم حفظ القائمة.

الصفحة الرئيسية دورات الإمارات العربية المتحدة دورات معتمدة من أوراكل Oracle 11g SQL for Report Writers

تفاصيل الدورة

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.

Prerequisites:
  • PC Fundamentals
Who Should Attend:
  • Report Writers
  • Oracle Discoverer Users
  • Oracle Discoverer Administrators
Oracle Overview:
  • Introducing Oracle
  • The Elements of the Oracle System
  • Relational Concepts
  • What reporting tools do
SQL*Plus and SQL:
  • 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
SQL*Plus Reporting:
  • Introducing SQL*Plus for Reporting
  • Using SQL*Plus
SQL Functions:
  • The Concatenation Operator
  • Elements of the SQL Query: Arithmetic
  • Column Aliases
  • String Functions
  • Arithmetic Functions
  • Date Functions
  • Mixed Functions
Filtering Data Using Where:
  • Where Operators
  • Where with Keywords
  • Where and Logical Operators
Retrieving Data from Multiple Tables:
  • 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 By and Group Functions:
  • Group Function Examples
  • Group Function with Having
Data Warehousing and OLAP:
  • Materialised views
  • Dimensions
  • ROLLUP functions
  • The ROLLUP operator
  • The CUBE operator
  • Analytical Functions
  • Ranking
  • Banding
  • Windowing
  • Moving Averages
  • LAG and LEAD
Advanced SQL Functions:
  • Nesting Different Functions
  • Select with Minus, Union and Intersect
  • Connect By Prior
  • Hierarchies
تحديث بتاريخ 08 November, 2015

الموقع

عرض الخريطة الموقع Westland Square Pearse St Dublin 2 Ireland

نبذة عن معهد Professional Training Solutions Ltd

Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.
they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.
their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:
restructuring for competitiveness
productivity improvements through updating work processes to match new technology
managing outstheircing
strategic financial planning and engineering
their methodology is to:
Work closely with clients to understand and help them prioritise their needs
Design and deliver the best mix of training activities and consultancy to establish the competencies required
Provide ongoing coaching to sustain the improved practices and processes
they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.
their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.
عرض الجميع دورات Professional Training Solutions Ltd
اسأل ليمون
عرض جميع دورات دورات معتمدة من أوراكل
عرض جميع الوظائف المتاحة حالياً في مجال SQL Server and Oracle في الإمارات العربية المتحدة

SQL Server أسئلة ذات صلة

Are you from Professional Training Solutions Ltd ? Claim your course!
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على SQL Server ابتداءً من الآن. See all courses
عرض جميع دورات دورات معتمدة من أوراكل

هل هذه الدورة التدريبية الاختيار المناسب لك؟

لم تجد ما كنت تبحث عنه؟

جرب البحث عنه!
أو
تصفح المقررات دورات معتمدة من أوراكل

لست واثقًا أي الدورات التدريبية تحضر؟ دعنا نرشدك