Sale!

$2,999.00 $2,499.00

  • The program continues with Business Objects reporting (InfoView, WEBI, DESKI AND Crystal Reports)
  • In the next level students will learn universe design and enterprise interface and architecture.
  • Reporting – InfoView, WEBI and DESKI
  • Understand concepts of Web Intelligence.
  • Create Web Intellegence documents with queries
  • Restrict Data returned by a query
  • Design a report
  • Enhance the presentation of data in reports.

SKU: BizObjLive1000 Categories: ,

Product Description

Business Objects

Course Description

  • The program continues with Business Objects reporting (InfoView, WEBI, DESKI AND Crystal Reports)
  • In the next level students will learn universe design and enterprise interface and architecture.
  • Reporting – InfoView, WEBI and DESKI
  • Understand concepts of Web Intelligence.
  • Create Web Intellegence documents with queries
  • Restrict Data returned by a query
  • Design a report
  • Enhance the presentation of data in reports.

Course Outline

Week-1-2: Read chapter 1, 2, 3

QL Server Basics

  • Client-Server database architecture and SQL Server architecture
  • Installing MS SQL Server (2008, 2012 or earlier)
  • Tables, relational databases, SQL and database objects
  • Design and develop MS SQL Server databases and tables
  • Referencing objects in SQL Server databases
  • Obtaining information from database tables
  • SQL Server security

Week-3-4: Read chapter 4, 5, 6, Complete all exercise of chapter 3, 4

Understanding Tables and Databases

  • Creating databases manually
  • Creating databases with database wizard
  • Defining a maintenance plan wizard
  • Databases using Transact-SQL
  • Database manipulation: characteristics and deletions
  • Working with tables

Indexes and Views

  • The basics of index structures
  • Creating and working with indexes
  • Indexes and table architecture
  • Creating views (including using view manager)
  • Working with views
  • Indexed views

Week-5-6: Read Chapter 7, 8, Complete all exercise of chapter 6, 7

Database Diagrams, The Query Analyzer and SQL Basics

  • Working with diagrams
  • Diagramming for pubs database
  • Server connectivity and Screen management
  • Working with queries
  • SQL essentials (select, create table, insert, delete, update)

Stored Procedures, Triggers and Replication

  • Components of stored procedures
  • Creating and working with stored procedures/system stored procedures
  • Components of triggers

Week-7-8: Read Chapter 9

Data Transformation Services (DTS), Back Ups/Restores, Users, Roles, Logins and Analysis Manager

  • Creating, importing and exporting DTS
  • Creating, scheduling backups and restores
  • Authentication types, users, roles, security plans
  • Configuring DSN, loading analysis manager and working with cubes

Week-9-10: Read Chapter 10

  • Creating, scheduling backups and restores
  • Authentication types, users, roles, security plans
  • Configuring DSN, loading analysis manager and working with cubes

Week-11-12: Read Chapter 11

  • Merge replication
  • Replication model and types of replication
  • Creating and working with triggers
  • FORMAT A REPORT
  • CALCULATE DATA WITH FORMULAS AND VARIABLES
  • USE MULTIPLE DATA SOURCES UNIVERSE DESIGN
  • UNDERSTANDING BUSINESS OBJECTS UNIVERSES ·
  • CREATING THE COURSE UNIVERSE ·
  • BUILDING THE UNIVERSE STRUCTURE ·
  • CREATING DIMENSION OBJECTS ·
  • CREATING MEASURE OBJECTS ·
  • RESOLVING LOOPS IN A UNIVERSE ·
  • RESOLVING SQL TRAPS ENTERPRISE ADMINISTRATION ·
  • UNDERSTAND THE BUSINESS OBJECTS ·
  • ENTERPRISE INTERFACE AND ARCHITECTURE
  • MANAGE BUSINESS OBJECTS ENTERPRISE CONTENT
  • SECURE BUSINESS OBJECTS ENTERPRISE CONTENT ·
  • SECURE APPLICATION SECURITY

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.