Introduction To Relational Databases
Aims
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 Content
Understanding relational databases
- What is a database?
- Types of databases and data
Introduction to Database Design
- Flat files and Normalisation
- Relational Database Management System
- Relational Databases explained
Planning and Building a Database
- Understanding user requirements
- Designing a database
- Three Schema Architecture
- Good database design
- Practical group design activity
- Records, fields and data types
Table Relationships
- Theory of table relationships
- Relational data
- Linking tables
Primary Keys
- Primary keys explained
- Importance of primary keys
- Using primary keys
|
Types
- Introduction to linking tables
- One to One
- One to Many
- Many to Many
Join Types
- Introduction to join types
- Inner Join
- Right Outer Join
- Full Outer Join
- Changing the join type
- Indexes
Forms and Queries
- Creating and using forms
- Creating and using queries
Using ODBC
- Theory of ODBC
- Understanding and creating ODBC connections
- Using ODBC to link reports and data
Relating Tables within Crystal Reports
- Introduction to Linking from a reporting tool (Crystal Reports used in session)
- Reporting Good Practice
|
No prior knowledge is required although knowledge of Windows conventions is useful. This course is ideal for 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.
Cost:
£195 (ex VAT) - inclusive of all materials, refreshments and a 2 course
lunch
