Introduction to SQL for Report Designers

Chase International
Henley-on-Thames, Chesterfield, Scotland, Dublin, United Kingdom, Ireland

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

Course Description:

'' A one-day course that covers the basics of SQL and how that SQL knowledge can be utilised in Database Report Design, with practical examples and activities using SQL Server 2000 and Crystal Reports.

Prerequisites
Pre-requirements for this course would be an understanding of relational databases or attending Introduction to Relational Databases, Level 1 of Crystal Reports Report Design or equivalent Crystal Reports experience.

Course Agenda
• Introduction to SQL
• Working with the SQL Environment
• Creating SQL Views of your Data
• Querying and Modifying SQL
• Using Functions and Value Expressions
• Accessing Multiple Tables
• Using Subqueries
• Using SQL and Crystal Reports
• Optimising Reports Using SQL
• Replacing Formulas with SQL Functions and Expressions
...''

Phone:+44 (0) 1491 572987

School Address:

71A Bell Street
Henley-on-Thames
Oxfordshire
RG9 2BD
Tel: +44 (0) 1491 572987
Fax: +44 (0) 1491 572132
Email: courses@chase-international.com

Chesterfield Office
Tapton Park Innovation Centre
Brimmington Road
Tapton
Chesterfield
S41 0TZ
Tel: +44 (0) 1246 541901
Email: chesterfield@chase-international.com

Scotland Office
Dunfermline Business, Learning & Conference Centre
Dunfermline
Halbeath
Fife
KY11 8DY
Tel: +44 (0) 1383 559050
Fax: +44 (0) 1383 559052
Email: dunfermline@chase-international.com

Ireland Office
4 Upper Cranford Centre
Stillorgan Road
Dublin 4
Ireland
Tel: +353 (0) 1 283 9222
Fax: +353 (0) 1 260 7072
Email: dublin@chase-international.com


Jobs & Resumes: Henley-on-Thames, Chesterfield, Scotland, Dublin
Houses & Roommates: Henley-on-Thames, Chesterfield, Scotland, Dublin

Introduction to Relational Databases for Report Designers
Introduction to OLAP for Analytics Designers
Crystal Report Design Level 1, v10
Crystal Report Design Level 2, v10
Crystal Report Design Level 3, v10
Applying Report Design Methodology and Expertise, v10
Crystal Report Integration for VB Developers
Crystal Report Integration for Web Developers
Crystal Report Design Level 1, v9
Crystal Report Design Level 2, v9

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.
 

Tips: In most cases you will get a unique submit code along with your each posting on this website. Please provide it as well as the message title if you want any assistance for editing/removal.