Crystal Reports Database Linking and Optimization

CrystalUser.com
Spring, Texas, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This course covers how Crystal Reports and databases interact in report production, with specific coverage of Oracle, SQL Server, and Access. The course provides an overview of key database and SQL concepts and how they impact the creation of Crystal reports. Driver issues, linking options, join types, views, stored procedures, and issues surrounding data types and values are additionally addressed.


Length - 2 Days
Class Time - 8:30 to 4:30


Prerequisites
Students should have attended Foundation Training Series or have equivalent experience. Detailed knowledge of databases is not required because database fundamentals are covered in the course. You must have some Crystal Reports experience prior to taking this course.


Price $995


COURSE OUTLINE
--------------------------------------------------------------------------------
How Crystal Reports Accesses Databases
Version differences
What is a driver
Native vs. ODBC drivers
Setting up different drivers

Database Fundamentals
What are tables, views, indexes, foreign keys, primary keys, rows, and columns
Frequently encountered relationship types- Parent/child, Associative, and Many to one
Crystal Reports and Indexes
What is a view
Benefits of using views
Limitations of using views
What is a stored procedure

SQL, Linking, and Joins in Crystal Reports
Understanding the Client/Server Environment
What is SQL
Basic SQL syntax
What is a Join
Joins; inner join, outer join, and Cartesian product
Modifying joins in Crystal Reports
When smart linking isn’t smart
How does Crystal Report utilize Client/Server Processing
Declarative vs. Procedural Languages

Access and Crystal Reports
Access data types
Access and nulls
Access and Indexes Viewing SQL statements in Crystal Reports

SQL Server and Crystal Reports
SQL Server data types
Indexes in SQL Server
Taking advantage of relational databases
SQL Server Views
Using Views from inside Crystal Reports
Understanding Stored Procedures
Creating a Stored Procedure in SQL Server

Oracle
The advantages of using Oracle databases
Oracle data types
Oracle and nulls
Oracle and indexes
Working with SQL Plus
Creating Oracle Views
PL/SQL and Packages
Using Oracle Stored Procedures
The Oracle Data Dictionary

...''

Phone:(800) 959-1451 X114

School Address:

CrystalUser.com
26303 Oak Ridge Drive
Spring, TX 77380 USA

Jobs & Resumes: Spring
Houses & Roommates: Spring

Crystal Reports XI Introduction
Crystal Reports XI Advanced
Crystal Reports Functions and Formulas
Crystal Reports Parameters and Subreports Workshop
Crystal Reports Executive Level Charting

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We provide free training course catalog service since 2003, in English and Chinese. Tens of thousands of visitors search our database from our portal and partners' websites each day.