55305A: Introduction to Data Modelling Courseware

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. 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 Details Module 1: Introduction to Data Modelling Module 2: Designing A Databa