Introduction to SQL Databases
This three day course is for individuals who are looking to transition into a database professional role or whose job role is expanding to include database items. The course describes basic database concepts including database types, database languages, and database projects.
COD: MOC 10985
Categorie: Microsoft
Teaching methodology
The course includes educational laboratories in which each student will be able to work in order to complete training exercises that will provide practical experience in using the instrument, for each of the topics covered during the course.
Who should participate
The primary target audience for this course is individuals who are either moving into a database role or whose role has expanded to include database technologies.
Prerequisites
No special requirements required
Outgoing knowledge/skills
This three day course is for individuals who are looking to transition into a database professional role or whose job role is expanding to include database items. The course describes basic database concepts including database types, database languages, and database projects
Educational program
- Describe key database concepts in the context of SQL Server 2016
- Describe database languages used in SQL Server 2016
- Describe data modeling techniques
- Describe normalization and denormalization techniques
- Describe relationship types and effects in database design
- Describe the effects of database design on performance
- Describe commonly used database objects
Duration – 3 days
Delivery – in Classroom, On Site, Remote
PC and SW requirements:
- Internet connection
- Web browser, Google Chrome
- Zoom
Language
Instructor: English
Workshop: English
Slides: English
