All Brands   >   IT Technical   >   Business Intelligence   >   Data Modelling and Database Design

CMDBID: 60116 | Course Code: | Duration: 3 Days
Overview >

The course includes industry standard techniques for data analysis and database design and places them in a modern day development environment. After an introductory session covering database design, sound theoretical concepts are linked to practical considerations. The course sequence moves from logical data analysis and data model development through to physical database design and optimisation. Environments such as the Internet and data warehouses are included as well as standard relational databases.

At all times the emphasis is on a pragmatic approach to the solution of everyday problems encountered in data analysis and design.

At the end of the course attendees will be able to:

  • Describe the reasons for producing data models.
  • Develop a logical data model, using a top-down approach, based on the analysis of a business scenario.
  • Validate a data model to ensure data integrity.
  • Develop a normalised data model using relational data analysis.
  • Normalise an existing data model.
  • Transform a logical to a physical data model based on a target database.
  • Create a database schema from a physical data model and optimise the schema.
  • Understand how to use data modelling techniques in a variety of situations including reverse engineering and the use of software packages.
Audience >
Prerequisites >
Outline >

Course Dates

Search by:

Show only GTR courses

Page 1, showing results 1-25 out of 36
Location
Start Date
Price
Bath, United Kingdom
13th Oct 2020
£1300
LVC, United Kingdom
19th Oct 2020
£1300
LVC, United States
19th Oct 2020
$2700
LVC, Australia
19th Oct 2020
$3900
LVC, France
19th Oct 2020
€2400
LVC, Germany
19th Oct 2020
€2400
LVC, Spain
19th Oct 2020
€2400
LVC, Italy
19th Oct 2020
€2400
LVC, Australia
19th Oct 2020
$3900
LVC, Australia
19th Oct 2020
$3900
LVC, United States
19th Oct 2020
$2700
LVC, United States
19th Oct 2020
$2700
New York, United States
9th Nov 2020
$2700
San Francisco, United States
9th Nov 2020
$2700
Canberra, Australia
9th Nov 2020
$3900
Paris, France
9th Nov 2020
€2400
Milan, Italy
9th Nov 2020
€2400
Chicago, United States
9th Nov 2020
$2700
London, United Kingdom
9th Nov 2020
£1300
Berlin, Germany
9th Nov 2020
€2400
Melbourne, Australia
9th Nov 2020
$3900
Sydney, Australia
9th Nov 2020
$3900
Madrid, Spain
9th Nov 2020
€2400
LVC, United States
23rd Nov 2020
$2700
LVC, United Kingdom
23rd Nov 2020
£1300

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. Its a cost effective option. One on one training can be delivered too, at reasonable rates.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

All $ prices are in USD unless it’s a NZ or AU date

SPVC = Self Paced Virtual Class

LVC = Live Virtual Class

Please Note: All courses are availaible as Live Virtual Classes