Introduction to SQL

For Reports Designers

From Chase International

 

 

Course Description

This 2 day, instructor-led training course is designed to enable delegates to understand to basics of SQL – Structured Query Language and how they can use that knowledge in database report design to enhance and speed up the reports written.

 

Course Cost

Course cost includes courseware and any activity handouts.  If course is off-site it also includes lunch and refreshments.  Costs are dependant on location and number of delegates.

 

Product Editions and Versions

This course has no product edition or version requirements, during the course either Microsoft SQL Server 2000 or 2005 will be used.  Users of Crystal Reports will also benefit from this course.

 

Who Should Attend?

Any report designer, wishing to understand the theory and practical uses of the SQL language and use that skill in planning and preparing more efficient, faster reports with a reporting tool such as Crystal Reports.

 

Course Content

 

Introduction to SQL

Crystal Reports and SQL
  • What is SQL, background and theory
  • Using SQL within Crystal Reports
  • Types and execution of SQL statements
  • Interpreting & Amending the SQL Query
  • Schemas, security and syntax
  • SQL Expert or not

Retrieval of Data Using SQL

Enabling Server Side Processing

·         Creating a SELECT statement
  • Server Side Grouping

·         SELECT and FROM
  • Changes reflected in the SQL Query

·         Joins, keys and indexes

Reporting Against Stored Procedures

·         WHERE
  • Stored Procedures and Reporting

·         WHERE Conditions

Using SQL Expressions

Data Organisation
  • Using SQL Expression Editor
  • GROUP BY
  • SQL Expression Tips & Techniques
  • HAVING
  • Alternatives to Crystal functions
  • ORDER BY

Using SQL Commands
  • IN and BETWEEN, LIKE
  • SQL Commands in Crystal Reports
  • Aggregate Functions
  • Creating & Editing SQL Commands

Using Views and Stored Procedures
  • The Crystal Repository & SQL

·         Views
  • Parameter based SQL Commands

·         Creating a view
  • Clauses and SQL functions

·         Stored Procedures

Performance Tips & Techniques

·         Create and execute a stored procedure
  • Letting the server do the work

Using SQL and SQL Databases
  • Indexed fields in Table Joins
  • SQL databases

Crystal Reports and SQL
  • ODBC
  • Using SQL within Crystal Reports
  • Reporting tools (using Crystal Reports)
  • Interpreting & Amending the SQL Query
  • Client/Server Architecture (background)
  • SQL Expert or not

 

 

Pre-Requisite Knowledge

An understanding of relational databases or previous attendance on Introduction to

Relational Databases training course would be useful.  Any Crystal Reports training

also an advantage. 

 

Additional Training

This course may be followed by the Chase International Crystal Reports Advanced

training course.

 

For more information and specific costs:- www.chase-international.com – 01491 572987