55305A - Introduction to Data Modelling

The 55305A 1-day instructor-led course is an introductory class for anyone learning to design and create databases. The material will be helpful for new database administrators or any IT professionals who will have a part in designing and maintaining databases. Students will learn to create databases using SQL Server or Azure SQL databases and learn basic Transact-SQL skills for creating, altering and updating database objects.

What's included?

  • 2 Assessments
  • 3 Modules and Labs

Audience Profile

The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. IT personnel involved in database design and management will find the exercises useful.

At course completion

• Describe data modelling techniques
• Describe normalization and denormalization techniques
• Describe relationship types and effects in database design
• Describe commonly used methods for protecting data integrity

Course Lessons

Meet the instructor

Patrick Jones

Patrick Jones is a content marketing professional since 2002. He has a Masters Degree in Digital Marketing and a Bachelors in Education and has been teaching marketing strategies for over 15 years in Chicago. Patrick enjoys teaching all levels and all ages. He looks forward to sharing his love of building meaningful and effective content with all students to develop their marketing abilities.
Patrick Jones - Course author