Course OD20762C: Developing SQL Databases (90 Day)

Choose how you want to learn: online or in a classroom
Compare learning environments

On-demand training

Learn more

Classroom training

Learn more

Find a Microsoft Learning PartnerFind an on-demand training partnerFind a classroom training partner
Anytime accessYesNo
Anywhere access to recorded instructorYesNo
Microsoft official training contentYesYes
In-depth trainingYesYes
Hands-on labs Yes Yes
SATV redemption Yes Yes
Ask instructor questions in personNoYes
Attend live class in personNoYes
Attend live class remotelyNoYes
Time commitment Self-paced
(3 month access)
5 days
À propos de ce cours
Public(s) :IT Professionals
Technologie :SQL Server
Niveau :Advanced
Cette révision :C
Durée :2 days
Langue(s) :English

Première publication :

19 April 2018
Présentation
À propos de ce cours

This course provides students with the knowledge and skills to develop a Microsoft SQL Server database. The course focuses on teaching individuals how to use SQL Server product features and tools related to developing a database.

Profil du participant

The primary audience for this course is IT Professionals who want to become skilled on SQL Server product features and technologies for implementing a database.

The secondary audiences for this course are individuals who are developers from other product platforms looking to become skilled in the implementation of a SQL Server database.

À la fin du cours

After completing this course, students will be able to:

  • Design and Implement Tables.
  • Describe advanced table designs
  • Ensure Data Integrity through Constraints.
  • Describe indexes, including Optimized and Columnstore indexes
  • Design and Implement Views.
  • Design and Implement Stored Procedures.
  • Design and Implement User Defined Functions.
  • Respond to data manipulation using triggers.
  • Design and Implement In-Memory Tables.
  • Implement Managed Code in SQL Server.
  • Store and Query XML Data.
  • Work with Spatial Data.
  • Store and Query Blobs and Text Documents.
Communauté

Vous recherchez des ressources de formation, des événements et des conseils d'homologues ? Rejoignez la communauté de formation et de certification Microsoft.

Vous vous préparez à un examen ? Trouvez votre groupe d'étude de certification Microsoft.