The M55315 instructor-led course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on a SQL Server instance. The material updates and replaces course 10985C previously published under the same title.
Virtual Learning
This interactive training can be taken from any location, your office or home and is delivered by a trainer. This training does not have any delegates in the class with the instructor, since all delegates are virtually connected. Virtual delegates do not travel to this course, Global Knowledge will send you all the information needed before the start of the course and you can test the logins.
Module 1: Introduction to databases
This module introduces key database concepts in the context of SQL Server.
Lab of Module 1:
After completing this module 1, students will be able to:
Module 2: Data Modeling
This module describes data modelling techniques.
Lab of Module 2:
After completing this module 2, students will be able to:
Module 3: Normalization
This module describes normalization and denormalization techniques.
Lab of Module 3:
After completing this module 3, students will be able to:
Module 4: Relationships
This module describes relationship types and effects in database design.
Lab of Module 4:
After completing this module 4, students will be able to:
Module 5: Performance
This module introduces the effects of database design on performance.
Lab of Module 5:
After completing this module 5, students will be able to:
Module 6: Database Objects
This module introduces commonly used database objects.
Lab of Module 6:
After completing this module 6, students will be able to:
This is a foundation level course and therefore only requires general computer literacy.
The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material.
