کارشناسان و توسعه دهندگان هوش تجاری

آشنایی با مفاهیم، پیاده سازی، توسعه و پشتیبانی هوش تجاری در سازمان

Concepts of Business Intelligence and Data Warehouse

• Introduction to BI
• OLAP & OLTP
• Fact & Dimension
• Star schema & Snowflake Models

Installation

• Install Oracle Business Intelligence

Introduction to Oracle Business Intelligence Enterprise Edition

•  Introduction to Oracle BI EE
• Oracle BI 12c Highlights
•  Oracle BI 12c Architecture

Working with Oracle Business Intelligence Analyses

•  Adding basic formatting
•  Working with analyses in Oracle BI
•  Introduction to Oracle BI Analysis Editor
•  Setting analysis properties
•  Oracle BI column types
• Using advanced formatting

Filtering Data for Analyses

•  Adding prompts to analyses
•  Using saved analyses as filters
•  Dynamic filtering
•  Creating, editing, and grouping filters
•  Introduction to filters and selections

Selecting and Grouping Data for Analysis

• Creating calculated items
• Including advanced SQL clauses in your analysis
• Creating selection steps
•  Creating direct database analysis requests
• Creating groups

Advance Visualization in Analysis

•  Working with views in Compound Layouts
•  Performing common view tasks
•  Introduction to views, graphs, and editors
•  Creating and editing graphs

Showing Results with Pivot Tables

• Using hierarchical columns
•  Building calculations and displaying running sums
•  Showing an item's relative value
•  Creating, arranging, and formatting a pivot table
•  Setting aggregation and using totals
•  Sorting in pivot tables

Working with Additional Views in Analyses

•  Creating simple and advanced trellis views
•  Creating performance tile views
•  Linking master-detail views
•  Working other view types like Treemap and Heat Matrix

Visualizing Data on Maps

•  Oracle spatial components
•  Managing map data
•  Other applications and points of integration for map views
• Interacting with map views
•  Creating and editing Map views

Creating Oracle Business Intelligence Dashboards

•  Publishing dashboard pages
•  Using the Dashboard Builder
•  Exploring dashboard object properties and options
•  Creating and editing dashboards
•  Creating personal customizations and using other page options

Configuring Oracle Business Intelligence Dashboards

•  Embedding content in dashboards
•  Exploring types of dashboard content

Creating Dashboard Prompts and Variables

•  Adding variable prompts to a dashboard
•  Creating additional prompt page and setting page preferences
•  Adding a named dashboard prompt to a dashboard
•  Understanding variables
•  Adding a hidden named dashboard prompt to a dashboard

Scorecards and Key Performance Indicators

•  Editing scorecards and KPIs
•  Objects and components of Oracle Scorecard and Strategy Management
•  Creating scorecard documents
•  Scorecard document types
•  Creating scorecards and KPIs
•  Key Performance Indicator (KPI) overview

Working with BI Content in Smart View

•  Creating and publishing views using the View Designer
•  Inserting BI views in to Smart View clients
•  Working with Views in Smart View Clients
•  Customizing BI data in MS Office

Oracle Business Intelligence Mobile

•  Navigating the Oracle BI mobile application
•  Oracle BI Mobile Security Toolkit
•  Downloading and using the Oracle BI mobile application
•  Working with BI content
•  Working with favorites and local content

Administering the Presentation Catalog

•  Working with Oracle BI Briefing Books
•  Setting object permissions
•  Setting system privileges
•  Managing security using roles
• Oracle BI and catalog security overview
•  Understanding security inheritance
•  Archiving catalog items

Direct Database Analysis

•  Creating and Executing a Direct Database Analysis
•  Changing Direct Database Analysis Privileges
• Direct Database Analysis Overview

Repository Basics

•  Loading a repository into Oracle BI Server
•  Exploring a repository's structure, features, and functions
•  Exploring Oracle BI architecture components
•  Using the Oracle BI Administration Tool
•  Creating a repository
•  Installing the BI Client software

Building the Physical Layer of a Repository

•  Examining physical layer object properties
•  Importing data sources
• Setting up Connection Pool properties
•  Defining keys and joins

Building the Business Model and Mapping Layer of a Repository

•  Building logical tables, columns, and sources
•  Building a business model
•  Building measures
•  Examining business model object properties
•  Defining logical joins

Building the Presentation Layer of a Repository

•  Exploring presentation layer objects
•  Modifying presentation layer objects
•  Examining presentation layer object properties
•  Creating presentation layer objects

Testing and Validating a Repository

•  Executing analyses to test the repository
• Uploading the repository through Enterprise Manager
•  Checking repository consistency

Adding Calculations to a Fact

•  Creating new calculation measures based on physical columns
•  Creating measures using functions
• Creating new calculation measures using the Calculation Wizard

Working with Logical Dimensions

•  Creating logical dimension hierarchies

Security

•  Setting up object permissions
•  Creating users and groups
•  Exploring Oracle BI default security settings
• Creating application roles

افرادی که به یادگیری پایگاه داده اوراکل نیاز دارند، دانشجویان، برنامه نویسان، مدیران و مشاوران آی تی کسب و کارها

• نصب، پیاده سازی و مدیریت اوراکل

Understanding Oracle Database Architecture - Oracle Database: Administration Workshop

• Understanding Oracle Database Instance Configurations
• Understanding Oracle Database Memory and Process Structures
• Understanding Logical and Physical Database Structures
• Understanding Oracle Database Server Architecture

Managing Users, Roles and Privileges - Oracle Database: Administration Workshop

• Assigning Quotas to Users
• Applying the Principal of Least Privilege
• Creating and Assigning Profiles
• Administering User Authentication Methods
• Managing Oracle Database Users, Privileges, and Roles

Moving Data - Oracle Database: Administration Workshop

• Using External Tables
• Using Oracle Data Pump
• Using SQL*Loader

Configuring Oracle Net Services - Oracle Database: Administration Workshop

• Using Oracle Net Services Administration Tools
• Configuring Communication Between Database Instances
• Configuring the Oracle Net Listener
• Connecting to an Oracle Database Instance
• Comparing Dedicated and Shared Server Configurations
• Administering Naming Methods

Managing Undo - Oracle Database: Administration Workshop

• Understanding Transactions and Undo Data
• Storing Undo Information
• Configuring Undo Rentention
• Comparing Undo Data and Redo Data
• Understanding Temporary Undo

Using Conversion Functions and Conditional Expressions - Oracle Database: Introduction to SQL

• Applying the NVL, NULLIF, and COALESCE functions to data
• Understanding implicit and explicit data type conversion
• Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
• Nesting multiple functions

Using SET Operators - Oracle Database: Introduction to SQL

• Matching the SELECT statements
• Using the ORDER BY clause in set operations
• Using The INTERSECT operator
• Using The MINUS operator
• Using The UNION and UNION ALL operators

Managing Views - Oracle Database: Introduction to SQL

• Managing Views

Retrieving Data using the SQL SELECT Statement - Oracle Database: Introduction to SQL

• Using Column aliases
• Using The DESCRIBE command
• Using The SQL SELECT statement
• Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
• Using Arithmetic expressions and NULL values in the SELECT statement

Reporting Aggregated Data Using Group Functions - Oracle Database: Introduction to SQL

• Restricting Group Results
• Creating Groups of Data
• Using Group Functions

Managing Tables using DML statements - Oracle Database: Introduction to SQL

• Managing Database Transactions
• Using Data Manipulation Language
• Controlling transactions

Managing Schema Objects - Oracle Database: Introduction to SQL

• Creating and using temporary tables
• Managing constraints

Managing Database Instances - Oracle Database: Administration Workshop

• Starting Up Oracle Database Instances
• Using Data Dictionary Views
• Shutting Down Oracle Database Instances
• Using Dynamic Performance Views
• Using the Automatic Diagnostic Repository (ADR)
• Using the Alert Log and Trace Files
• Managing Initialization Parameter Files

Managing Storage - Oracle Database: Administration Workshop

• Managing Resumable Space Allocation
• Shrinking Segments
• Deferring Segment Creation
• Using Space-Saving Features
• Deploying Oracle Database Space Management Features
• Managing Different Types of Segments
• Using Table and Row Compression
• Understanding Block Space Management

Accessing an Oracle Database with Oracle supplied Tools - Oracle Database: Administration Workshop

• Using the Database Configuration Assistant (DBCA)
• Using Oracle Enterprise Manager Cloud Control
• Using racle enterprise Manager Database Express
• Using SQL Developer
• Using SQL Plus

Managing Tablespaces and Datafiles - Oracle Database: Administration Workshop

• Viewing Tablespace Information
• Creating, Altering and Dropping Tablespaces
• Managing Table Data Storage
• Implementing Oracle Managed Files
• Moving and Renaming Online Data Files

Restricting and Sorting Data - Oracle Database: Introduction to SQL

• Applying Rules of precedence for operators in an expression
• Limiting Rows Returned in a SQL Statement
• Using Substitution Variables
• Using the DEFINE and VERIFY commands

Displaying Data from Multiple Tables Using Joins - Oracle Database: Introduction to SQL

• Using Self-joins
• Using Various Types of Joins
• Using Non equijoins
• Using OUTER joins

Understanding Data Definition Language - Oracle Database: Introduction to SQL

• Using Data Definition Language

Managing Data in Different Time Zones - Oracle Database: Introduction to SQL

• Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
• Working with INTERVAL data types

Using Single-Row Functions to Customize Output - Oracle Database: Introduction to SQL

• Manipulating strings with character functions in SQL SELECT and WHERE clauses
• Performing arithmetic with date data
• Manipulating numbers with the ROUND, TRUNC and MOD functions
• Manipulating dates with the date function

Using Subqueries to Solve Queries - Oracle Database: Introduction to SQL

• Using Single Row Subqueries
• Using Multiple Row Subqueries

Managing Sequences, Synonyms, Indexes - Oracle Database: Introduction to SQL

• Managing Indexes
• Managing Synonyms
• Managing Sequences

این دوره برای مدیران و توسعه دهندگان پایگاه داده و هوش کسب و کار حرفه ای در نظر گرفته شده است. البته به احتمال بسیار زیاد این دوره مورد توجه کسانی که الزاما وظیفه آنها در پایگاه داده متمرکز نشده و یا طرح و برنامه ای برای شرکت در آزمون  ۴۶۱-۷۰ ندارند یعنی، ایجاد کنندگان گزارش، تحلیلگران کسب و کار و توسعه دهندگان نرم افزار نیز، مفید خواهد بود.

طراحان پایگاه داده، توسعه دهندگان و مدیران پایگاه داده SQL Server در سازمان ها و نهادهای دولتی و غیردولتی نیز از مخاطبان این دوره خواهند بود.

شرکت کنندگان در این دوره، پس از پایان دوره قادر خواهند بود تا:

• کوئریهای مختلفی را ایجاد کنند.
• تغییرات در کوئری ها داشته باشند
• با پایگاه داده SQL Server به راحتی کار کنند.

• نوشتن انواع کوئری انتخاب  SELECT queries
• نوشتن کوئری بر روی چندین جدول
• استفاده از توابع سیستمی  Functions
• استفاده ازSubQuery ها
• اجرای رویه های ذخیره شده  Stored Procedures
• استفاده از عملگرهای مجموعه ای  set operators
• پیاده سازی رفع خطا  implement error handling
• پیاده سازی تراکنش ها
• استفاده از عبارات جدول  table expression
• مرتب کردن و فیلتر کردن داده ها
• استفاده از رتبه بندی پنجره، افست و توابع جمع: window ranking, offset and aggregate functions
• پرس و جو SQL سرور ابرداده  (metadata)
• برنامه با  T-SQL
• بهبود عملکرد کوئری ها