SQL for Report Designers

Chase International
Dunfermline, Henley-on-Thames, London, Dublin, United Kingdom

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

Henley Management College
Greenlands,
Henley-on-Thames,
Oxfordshire,
RG9 3AU

Lafone House
The Leathermarket
Weston Street
London
SE1 3HN

Dunfermline Business, Learning & Conference Centre
Dunfermline
Halbeath
Fife
KY11 8DY
Tel: +44 (0) 1383 559050

Ireland Office and Training Centre
GDK E2, Nutgrove Office Park
Nutgrove Avenue
Rathfarnham
Dublin 14
Tel: +353 (0) 1 283 9222

Jersey Training Location
Sir Walter Raleigh House
48-50 The Esplanade
St. Helier
Jersey
Channel Islands
JE1 3UN


Jobs & Resumes: Dunfermline, Henley-on-Thames, London, Dublin
Houses & Roommates: Dunfermline, Henley-on-Thames, London, Dublin

Relational Databases for Report Designers
OLAP
Crystal Xcelsius 4
Crystal Reports 6
Crystal Report Integration for Web Developers
Crystal Report Integration for VB Developers
Enterprise XI - Administering Servers
Enterprise XI - Administering Users and Content
Enterprise XI - Designing and Deploying a Solution
Crystal Analysis - Creating a Guided Analytical Report, v10

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: ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges.