|
||||
|
||||
|
||||
| Overview 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
|
||||
| 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
$1095 |
||||
| 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 |
