Introduction to Relational Databases

for Report Designers

From Chase International

 

 

Course Description

This 1 day, instructor-led training course covers the theory of relational databases and includes group workshop and practical examples to create a database using Microsoft Access, allowing you to gain insight into your own Corporate database.  You will understand how a database works and how to retrieve data from it using table relationships and other database concepts.

 

Course Cost

Course cost includes courseware and any activity.  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.  Users of any database may attend.

 

Who Should Attend?

Any report designer who would like to have valuable insight into the way a relational database is built and works in order to then understand how best to report on that data.

 

Course Content

 

Understanding relational databases

Link Types
  • What is a database?
  • Introduction to linking tables
  • Types of databases and data
  • One to One

Introduction to Database Design
  • One to Many
  • Flat files and Normalisation
  • Many to Many
  • Relational Database Management System

Join Types
  • Relational Databases explained
  • Introduction to join types

Planning and Building a Database
  • Inner Join

·         Understanding user requirements
  • Right Outer Join

·         Designing a database
  • Full Outer Join

·         Three Schema Architecture
  • Changing the join type

·         Good database design
  • Indexes

·         Practical group design activity

Forms and Queries

·         Records, fields and data types
  • Creating and using forms

Table Relationships
  • Creating and using queries
  • Theory of table relationships

Using ODBC
  • Relational data
  • Theory of ODBC
  • Linking tables
  • Understanding and creating ODBC connections

Primary Keys
  • Using ODBC to link reports and data

·         Primary keys explained

Relating Tables within Crystal Reports

·         Importance of primary keys
  • Introduction to Linking from a reporting tool (Crystal Reports used in session)

·         Using primary keys
  • Reporting Good Practice

 

Pre-Requisite Knowledge
No prior knowledge is required, knowledge of Windows conventions is useful.
Use of a reporting tool, such as Crystal Reports, is an advantage.

Additional Training
This course may be followed, for report designers, by the Chase International Crystal Reports Introduction

à Intermediate or Advanced training courses.

 

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