10985: Introduction to SQL Databases Training helps professionals gain comprehensive knowledge of fundamental database concepts, including database languages, data designs, and database types. This technical course is developed for people who plan to move into a professional database role or whose job involves expanding to encompass database components. 10985: Introduction to SQL Databases Training provides information regarding critical database concepts in the SQL Server 2016 context and also teaches about database language. From data modeling techniques to denormalization and normalization techniques, this training program covers all the essential concepts. By the end of this course, trainees will know how to demonstrate the different types of relationships and their effects in the database designs. They will also learn the commonly used database objects and the influence of database design on performance.
This training is designed based on the objectives of the course variant 10985C.
This module introduces key database concepts in the context of SQL Server 2016.
Lab: Exploring and querying SQL Server databases
After completing this module, you will be able to:
This module describes data modelling techniques.
Lab: Identify components in entity relationship modelling
After completing this module, you will be able to:
This module describes normalization and denormalization techniques.
Lab: Normalizing data
After completing this module, you will be able to:
This module describes relationship types and effects in database design.
Lab: Planning and implementing referential integrity
After completing this module, you will be able to:
This module introduces the effects of database design on performance.
Lab: Performance issues
After completing this module, you will be able to:
This module introduces commonly used database objects.
Lab: Using SQL server
After completing this module, you will be able to:
Share With Your Friends!
Twitter
LinkedIn