We begin with the concepts of relational databases and the powerful SQL Programming Language, and continue with Business Objects Reporting ( Infoview, WEBI, Deski and Crystal Reports)


  • The program continues with Business Objects Reporting (Infoview, WEBI, and Deski, and Crystal Reports).

  • In the next level students will learn universe design and finally enterprise interface and architecture.

  • Reporting - Infoview, WEBI, and Deski.

  • Understand concepts of Web Intelligence.

  • Create Web Intelligence documents with queries.

  • Restrict data returned by a query.

  • Design a report.

  • Enhance the presentation of data in reports.

Week-1-2 -- Read Chapter 1-3

  • SQL 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 object in SQL Server databases

    • Obtaining information from database tables

    • SQL Server Security




Week 3-4 -- Read Chapter 4-6

  • Understanding Tables and Databases

    • Creating databases manually

    • Creating databases with database wizard

    • Defining maintenance plan wizard

    • Databases using T-SQL

    • Databases manipulation: Characteristics and deletions

    • Working with tables



  • Indexes and Views

    • The basics of index structure

    • Creating and working with indexes

    • Indexes and table architecture

    • Creating views (including using view manager)

    • Working with views

    • Indexed views




Complete all exercises of chapters 3 & 4

Week 5-6 -- Read Chapters 7 & 8

  • 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 Replications

    • Components of Store Procedures

    • Creating and working with stored procedures/system stored procedures

    • Components of triggers




Complete all exercises for chapter 6 & 7

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

  • Creating and working with triggers

  • Replication model and types of replication

  • Merge replication

  • 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