Foundation in Client / Server Database Systems, Thales Training Consultancy

FOUNDATION IN CLIENT / SERVER DATABASE SYSTEMS

Duration:

1 day (available on an in-company or customised basis only)

Price:

On Request

Locations Available:

Suitable For

This course is designed for new and existing database developers and IT decision makers. Delegates must be PC literate; database knowledge would be an advantage.

Objectives

By the end of the course participants will be able to:·

Explain the core concepts, benefits and drawbacks of common database architectures.·
Identify how the growth of an organisation links to the evolution of databases it needs to use.·
Explain the differences between file sharing and client/server database systems.·
Describe the role of a RDBMS (Relational Database Management System).·
Obtain hands-on experience of two leading database systems (Microsoft Access and Microsoft SQL Server).·
Select an appropriate database system for a particular application and environment.·
Obtain further relevant information and reading material from a number of resources.

Course Content

Introducing Client/Server Computing·

Mainframe computing·
File sharing computing·
Client/Server computing

Database Systems Within The Organisation·

The database pyramid and types of databases·
Common database growth and evolution patterns

File Sharing Computing - In-Depth·

Microsoft Access as a file sharing database·
Pros and cons of file sharing architecture

Client/Server computing - In-Depth ·

Microsoft SQL Server and Oracle as client/server databases·
Pros and cons of client/server architecture·
The Relational Database Management System (RDBMS), its role and function

Hands-on Demonstration·

Comparison of Microsoft Access and Microsoft SQL Server in a department / enterprise environment, covering performance and disaster recovery scenarios

Database Development And Support·

Development and support feature and technology comparisons for file sharing and client/server architectures

Selecting An Appropriate Database System·

Database challenges within the organisation·
Short listing database systems·
Feature comparison matrix for common database systems·
Licensing and pricing overview

Further Reading/Information·

Discussion of useful resources and further reading (website addresses, forums, books)·
Introduction to other Thales Training Consultancy ‘Advanced Database Systems’ courses